Find What Works: Schools
← All source documentsDownload current version (93ea735c8bb9)
Source document

docs/qa_reports/miami/__enrollment_full_qa.md

Served verbatim from the project repository. Internal working document conventions apply: documents may reference file paths, branch names, and findings-ledger anchors from the repo.

QA — Miami-Dade enrollment and capacity: served cells vs sources

Generated: 2026-09-16T22:52:05.856338+00:00

Verdict: PASS

SectionResult
A. Base case (served DB vs re-read of each ingested file, 13 components)PASS
B. Completeness (every source cell served; every served cell in source)PASS
C. Cross-publisher (FLDOE membership vs NCES CCD)PASS
D. Computed values (derived metrics recomputed)PASS
E. Served-value invariants (ranges, identities, ownership gate; shift alarms reported)REVIEW (16 unexplained shift alarms)

A. Base case

metricyearscommonmatchesmismatchessuppressed
enrollment_oct2016-17, 2017-18, 2018-19, 2019-20, 2020-21, 2021-22, 2022-23, 2023-24, 2024-25, 2025-2650995048051
enrollment_oct_gKG2018-19, 2022-23, 2023-24, 2025-2620652012053
enrollment_oct_g52018-19, 2022-23, 2023-24, 2025-2620652011054
enrollment_oct_g32016-17, 2017-18, 2022-2315081464044
fish_capacity_school2022-23, 2023-24, 2024-251005100500
fish_capacity_permanent2022-23, 2023-24, 2024-251005100500
cofte2022-23, 2023-24, 2024-251005100500
utilization_school_capacity_pct2022-23, 2023-24, 2024-251005100500
per_pupil_expenditure_school2021-22, 2022-23, 2023-24, 2024-251969196900
per_pupil_expenditure_total2021-22, 2022-23, 2023-24, 2024-251969196900
enrollment_abc2025-26292900
fish_capacity_permanent_abc2025-26292900
enrollment_oct_ccd2018-19, 2023-241045104500