How byronxlix/massachusetts-high-school-enrollment-projections works
This repository is a Massachusetts county-level enrollment projection pipeline: ACS grade-enrollment estimates are transformed into historical cohorts, survival ratios, weighted ratios, and recursive 2025–2029 projections, then checked and presented for planning. The README documents the dashboard’s county, grade, and QA views. The main script excerpt shows input preparation, interpolation, ratio calculations, projection logic, output writes, and QA; links among stages also rely on the README’s stated workflow because the script excerpt is incomplete.
Main entry points: enrollment_projection.py Quality Assurance · weighted_cohort_survival_rates.csv Weighted Ratios · high_school_enrollment_projections_2025_2029.csv High School Projections · dashboard Power BI Dashboard
Components 13
ACS Inputs
- Raw ACS Tables
data/raw
Projection Analysis
- Clean Enrollment
enrollment_projection.py - Historical Cohorts
data/processed/historical_enrollment_2019_2024.csv - 2020 Interpolation
enrollment_projection.py - Cohort Ratios
data/processed/cohort_survival_rates.csv - Weighted Ratios
data/processed/weighted_cohort_survival_rates.csv - Recursive Projections
enrollment_projection.py
Results and QA
- High School Projections
output/high_school_enrollment_projections_2025_2029.csv - Quality Assurance
enrollment_projection.py - WACSR QA Flags
data/processed/wacsr_qa_flags.csv
Planning Views
- Power BI Dashboard
dashboard
Other components
- ACS Census
- Enrollment Planning
Connections 14
- ACS Census → Raw ACS Tables: provides tables
README.md - Raw ACS Tables → Clean Enrollment: loads and cleans
enrollment_projection.py - Clean Enrollment → 2020 Interpolation: reshapes data
README.md - 2020 Interpolation → Historical Cohorts: creates history
README.md - Historical Cohorts → Cohort Ratios: calculates ratios
README.md - Cohort Ratios → Weighted Ratios: weights ratios
README.md - Weighted Ratios → Recursive Projections: applies recursively
README.md - Recursive Projections → High School Projections: saves projections
enrollment_projection.py - High School Projections → Quality Assurance: checks results
README.md - Weighted Ratios → Quality Assurance: flags outliers
README.md - Quality Assurance → WACSR QA Flags: records flags
README.md - High School Projections → Power BI Dashboard: communicates trends
README.md - Quality Assurance → Power BI Dashboard: summarizes QA
README.md - Power BI Dashboard → Enrollment Planning: informs analysis
README.md