Staff-to-child ratios are the line between an operating license and a citation. State rules set a maximum number of children per teacher — tighter for infants (often 1:4), looser for pre-K (often 1:12) — and the rule applies at every moment of the day, not on average. The dangerous moments are open and close, when children trickle in and out and a single teacher can briefly be over ratio. This dashboard checks compliance timeblock by timeblock so gaps are caught before an inspector finds them.
What this dashboard answers
What share of our classroom timeblocks met the required ratio, and which centers fall out of compliance? Where do the out-of-ratio blocks cluster — which age groups, and crucially, which times of day? The compliance page shows the compliance rate, out-of-ratio block count, and required-vs-present staff by age group, ranked by site. The detail page concentrates on time of day (Open / Midday / Close), matrixes compliant and out-of-ratio blocks by site and age group, and heat-maps where the gaps live.
The metrics that matter
Ratio compliance rate is the headline, but it can hide a serious problem if violations cluster: 95% compliant overall still means real exposure if every gap is at one center's close. Out-of-ratio blocks is the count that matters for licensing — each one is a moment a teacher was responsible for too many children. Staffing coverage rate shows how close present staffing runs to the minimum; a center hovering right at 1.0 has no slack for a teacher calling out. Reading by time of day is essential because open and close are where the shortfalls concentrate.
Why the data is trapped
Attendance check-in/out (children) and staff clock data live in Brightwheel, Procare, or HiMama/Lillio, but the systems track them separately and per-center. Computing the required ratio for each room at each point of the day from children present, comparing it to staff present, and rolling the violations up across sites by time of day is a calculation no built-in report performs. So compliance gets verified by walking the floor and hoping — the cross-tab that would catch the open-and-close gaps stays buried.
How to read it
Don't stop at the overall compliance rate — go straight to the time-of-day view, because clustered close-time gaps are both the most common and the most citable. Use the site-by-age-group matrix to find which rooms drive the violations, then read coverage rate to see whether a center is chronically thin or just occasionally short. An infant room out of ratio is the highest-priority fix given the tight 1:4 standard. The sample uses fully synthetic, anonymized timeblock data — no real staff or child records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Required Staff | Staff required by ratio given the children present in each classroom timeblock. |
| Staff Present | Staff actually present in each classroom timeblock. |
| Ratio Compliance Rate | Compliant timeblocks ÷ total timeblocks — the share of the day in ratio. |
| Out-of-Ratio Blocks | Timeblocks where staff present fell below required — each a licensing exposure. |
| Staffing Coverage Rate | Staff present ÷ staff required — coverage relative to the mandated minimum. |
| Children Present | Children present across classroom timeblocks — the ratio denominator. |
Used by: Center directors and multi-site operators managing licensing risk
Frequently asked questions
What are typical childcare staff-to-child ratios?
Ratios are set by each state and tighten for younger children — commonly around 1:4 for infants, 1:6 for toddlers, 1:10 for preschool, and 1:12 for pre-K. The exact numbers vary by state, but the principle is constant: the younger the room, the fewer children per teacher, and the rule applies at every moment of the day.
Why do out-of-ratio gaps cluster at open and close?
At open and close, children arrive and leave gradually while staff shifts are starting or ending, so a single teacher can briefly be responsible for more children than the ratio allows. Those are the moments inspectors and parents notice, which is why the report breaks compliance out by time of day rather than reporting a daily average.
Can I build this on my own attendance and staffing data?
Yes. Export child check-in/out and staff clock data from Brightwheel, Procare, or HiMama/Lillio and use this as a template — we model it into a Power BI report. The sample uses synthetic data, so there's no real staff or child information here.
Build this report on your own data
Clone this Childcare centers template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →