Public Sector and Human Services
This sample program review package for one fictional county child welfare office includes a 25-item case review instrument in Excel that scores 60 reviewed cases and a 10-page review report written the way a state quality assurance unit would write it.
Sample data. All names, organizations, and figures are fictional.
Open larger imageThe workbook holds the review instrument, an item guide, the ratings for 60 sample cases with drop-down rating codes, and a summary sheet that calculates item results, outcome ratings, and results by case type and unit, with charts. The performance standard is an input cell, so a reviewer can see how the results change under a different threshold.
The report covers purpose and scope, sampling and review method, a county profile tied to the companion child welfare dashboard, findings by outcome area with charts and short case pattern examples, strengths, areas needing improvement, and a program improvement plan with goals, action steps, measures, owners, and target dates. It is written in plain public administration language for county and state program leadership.
Select an image to see it larger.
This is the secondary data profile from a community health needs assessment for ten Upstate South Carolina counties, and it is built from the 2024 County Health Rankings release. It compares 35 county indicators with state and national values and turns them into a dashboard, a 14-page report and an Excel workbook.
Public data
This sample analyzes a fictional county community health survey with 1,412 respondents, which is the kind of survey hospitals run as part of a community health needs assessment. It includes a filterable dashboard, an 8-page results brief and an Excel workbook with crosstabs, a codebook and weighting.
Sample data