How can I more effectively review a child’s health screenings?
Centro de la Familia (Centro) found that the ChildPlus system makes it difficult to efficiently and comprehensively review health screenings through the standard Missing Health Event module. They wanted to be able to see all missing health screenings at once, instead of needing to navigate in-and-out from one event to the next individually in order to get a comprehensive picture.
To address this, Centro developed a PowerBI dashboard that provides a comprehensive view of health events. It provides efficient, actionable analysis for all children’s health screening events in real-time, with the capability to drill down through case notes, reducing time-consuming navigation into the isolated health screenings events module in ChildPlus.
ANALYSIS
Centro created a dashboard the pulls all health screening data into one place. The dashboard provides the missing health screening information for every single child in the program and allows users to filter the information by program, enrollment week, enrollment status, and by family advocate. Missing screenings are identified by the number “one” (1) indicating that the screening in that column is missing; the background color in the missing event (number) changes and it is sensitive to the child’s enrollment, respective to the program’s mandated completion dates.
The colored background also informs the users about the level of performance of the assigned family advocate. For 45-day screenings, the background will be yellow if the child was enrolled and screened within 15-30 days; it will be blue if the child was screened within 31-45 days; and it will be red if the screening is overdue. (For 90-day screenings, the colors align with 61-80 days and 81-90 days respectively.)
The dashboard only shows children with missing screenings and allows the user to filter by location and family advocate as well. A child’s enrollment information (including number of days enrolled and if the child was disenrolled) is available by clicking on a child’s name.
Centro monitors health screenings on a weekly basis using this dashboard. Filtered by enrollment week in the season, it ensures that only children enrolled the week within the compliance timeframe are listed and viewed for missing health screenings. This dashboard is particularly useful in Migrant and Seasonal Head Start programs where enrollment is on a cumulative basis, not full-funded enrolled during the service period.
RESULT
These data, in a single comprehensive visual, trigger timely support to parents and guardians and more effective access to children’s medical services
Managers are now able to view that status of children’s health screenings in one central location and are able to drill-down into an individual child’s case notes without needing to go to a separate data source or to navigate through a variety of different screens. From this information, managers get actionable information that allows them to monitor easily and effectively.
Leadership is also now able to analyze trends within and between sites, between programs and regions by child, and by family. The performance of individual family service advocates can also be assessed for professional development, if needed.
ADDITIONAL DETAILS
AUDIENCE: Direct Staff, Management, Leadership
LEVEL OF ANALYSIS: Child, Caseload, Center, Grantee
DIFFICULTY: Advanced
CONTENT AREA: Health
DATA SOURCES: ChildPlus, Microsoft PowerBI
CONSIDERATIONS AND CAVEATS: As the creators of the data, family advocates need to be trained on the importance of and relevant skills required to enter the relevant data in a timely and accurate manner.
ALTERNATE AUDIENCE GUIDANCE: Health Services Advisory Committee (HSAC)
TECHNICAL APPENDIX
Content area user-assisted data architect/coder. Health Manger identifies source data sets, reports and repositories for use in the coding and mapping –and in the final “feel and look” –of data from ChildPlus for PowerBI visualization.
CONTACT
Content Area Health Manager – Julieta Adobatto - j.adobatto@cdlf.org
Technical appendix - Michael Fairchild - m.fairchild@cdlf.org
Program Director - Gonzalo Palza - g.palza@cldf.org