As the world grappled with the uncertainty of the COVID-19 pandemic, schools were forced to adopt new ways of monitoring and maintaining the health and safety of their communities. Educational institutions faced the challenge of tracking student and staff health conditions, managing COVID-19 cases, and communicating vital information to parents and stakeholders.
For one school district, the solution was clear: develop an application that could provide real-time health data, facilitate communication, and help guide decision-making on whether students should continue learning in person or switch to remote education.
This case study explores the journey of developing a health integrity application for a school district during the height of the pandemic and highlights how this tool can be adapted to other health scenarios in the future.
The Challenge
The client, a public charter school system, requested the development of an application to track health conditions within their district. The immediate need was to monitor the occurrence of COVID-19 cases among students and staff, as well as to support decisions on whether the school should transition to remote learning or continue with in-person instruction.
The application needed to serve several functions:
- Real-Time Data: Track the number of current cases, recoveries, and overall statistics related to the pandemic across the district.
- Email Alerts: Send notifications to parents, teachers, and administrators whenever new health data was entered, ensuring that all stakeholders were informed and could respond appropriately.
- Charts and Dashboards: Provide visual representations of the health data to make the information easily digestible and actionable.
- User Accessibility: Ensure that the application was accessible via mobile devices, allowing all stakeholders (parents, teachers, administrators) to stay updated in real-time.
- Security and Permissions: Limit health data inputting and updating to only authorized school staff.
In addition to these core requirements, the district also wanted the application to include information on COVID-19 vaccines, testing locations, and frequently asked questions (FAQs) about the pandemic to keep the community well-informed.
The Solution
To meet the district's needs, a robust, scalable, and secure solution was developed using Salesforce and Lightning Web Components. Here's how the application came to life:
- Data Integration: The first step involved extracting student, staff, and school personnel data from CSV files and uploading it into Salesforce using its data import tools. This provided the foundation for tracking health conditions and assurance that the right people were being contacted with relevant information.
- Custom Dashboards: To make the data actionable and easy to understand, a set of interactive dashboards were created in Salesforce Lightning. These dashboards visualized key health data, including the number of COVID-19 cases, recoveries, and cases by demographic categories such as gender, race, ethnicity, and age. This granular view helped administrators identify trends and make informed decisions based on the evolving health situation.
- Communication Tools: The application was designed to automatically send notifications to stakeholders whenever new health data was entered. This feature was crucial for ensuring that teachers, parents, and school administrators were always informed and could respond to health developments promptly.
- Public Health Information: Additional tabs were included in the application to provide up-to-date information on vaccines, testing sites, and COVID-related FAQs. This helped ease the stress and confusion that many parents and staff experienced during the pandemic.
- Mobile and Desktop Compatibility: Understanding that stakeholders might need to access the application from various devices, the team made sure that it was compatible with both desktops and mobile phones. This flexibility allowed everyone from parents to teachers to stay connected on-the-go.
- Secure Access and Permissions: Only authorized school staff were granted permission to update health data, enhancing the security and accuracy of the information. This safeguard prevented unauthorized modifications and kept the data reliable.
The Outcome
The dynamic application provided immediate benefits to the district and its stakeholders. As COVID-19 cases continued to fluctuate, the ability to track health data in real time allowed administrators to make timely decisions regarding onsite versus remote learning. The application helped reinforce the safety of approximately 40,000 students across 50 schools, while also giving parents, teachers, and school staff the information they needed to stay informed.
Key outcomes included:
- Effective Communication: With automatic email notifications and an easy-to-navigate dashboard, parents, teachers, and administrators received timely updates on the district’s health status, empowering them to make informed decisions.
- User Satisfaction: School administrators praised the application for its ease of use, high performance, and low cost. Teachers and parents appreciated the convenience of being able to access health information at any time, ensuring that they were always aware of any changes in the school’s health status.
- Flexibility and Adaptability: Beyond COVID-19, the application was built with the future in mind. Its architecture allowed it to be easily adapted for tracking other health conditions or public health crises. For example, in the event of a flu outbreak or an influenza-like illness, the same application could be used to monitor cases and inform the school community.
- Language Options: The application also included language options, to allow all stakeholders to understand and engage with the health data, regardless of their primary language.
Extending Beyond Covid-19
Although the initial focus of the application was on managing the COVID-19 pandemic, its structure makes it a highly adaptable tool for future health scenarios. Some examples of how the application could be applied to other health challenges include:
- Flu Season Tracking: The same tool could track flu cases across schools, sending alerts and providing real-time data on the number of cases to help decide whether to keep schools open or shift to remote learning.
- Mental Health Monitoring: In the wake of the pandemic, mental health has become a growing concern. The application could be adapted to track and monitor students' mental health, sending alerts to school counselors or parents if any issues are detected.
- Vaccination Tracking: For future pandemics or vaccine rollouts, the application could track vaccination rates within the school community, sending reminders to parents or guardians about upcoming vaccine opportunities.
- Public Health Crises: In the event of any other communicable disease outbreak, the application could be quickly reconfigured to track and communicate information about the new health threat.
Past and Future
The development of this school health integrity application provided a powerful, user-friendly tool for managing COVID-19 health data and facilitating communication between school administrators, teachers, parents, and staff. By integrating real-time updates, interactive dashboards, and secure data entry, the application helped the school district navigate the complexities of the pandemic while providing safety for its students and staff.
More importantly, this solution is not limited to just the COVID-19 pandemic. The application’s adaptable architecture and user-centric design make it a valuable tool for future public health scenarios, strengthening school preparedness in responding to any health crisis that may arise.
Ready to streamline your processes and give your team more time to focus on what truly matters? At Cayuse, we specialize in building custom applications that drive efficiency and unlock the full potential of your business. Let’s work together to transform your operations and boost productivity. Contact us today to get started!