2025-12-15: Modesto City Schools AR Funding Projections
For: Modesto City Schools Impact: Projected $816,808 in recoverable LCFF funding from 2,843 students with 9,585 recoverable days across expanded learning programs Context: District needed AR funding projections based on expanded learning attendance data and student absences to understand recovery potential
Data Analysis
Analyzed three attendance CSV files:
exp_attendance.csv- 46,887 records (expanded learning subset)mcs_attendance_v2.csv- 98,787 records (mixed regular + expanded learning)mcs_attendance_v3.csv- absence records for regular school attendance
Key Finding: Files contained mixed data - regular school period-by-period attendance alongside expanded learning programs. Filtered to expanded learning only (85,034 records) covering 2,843 unique students.
Program Duration Mapping
Established minute values per attendance session:
| Category | Programs | Minutes |
|---|---|---|
| Before School | Before School Program | 60 |
| After School | ASES | 180 |
| RISE | ELA, Math Foundations, DLA, 7-8, 9-12 | 90 |
| Enrichment | TK-6, 9-12 | 90 |
| Summer | SI40-SI47 Extended Summer School | 240 |
Absence Calculation
Processed absence codes from v3 file:
- Counted: I (Illness), X (Unexcused), D (Doctor), A (Absent), J (Justified), H (Suspension), G (Home/Hospital), Q, L, E, MA
- Excluded: U (Picked Up Early), W/M (Tardy), N/Y (IS), DP (DL Present), P, T, F, O, Z, V, SE, SU
Counted unique absence days per student (not periods) - avg 7.2 days, max 86 days.
AR Funding Calculation
Applied California LCFF formulas with district UPP of 79.6%:
Grade Band Distribution (TK-6 uniformly distributed):
- TK-K (180 min threshold): 25% → 457 students
- 1-3 (230 min threshold): 37.5% → 720 students
- 4-6 (240 min threshold): 37.5% → 739 students
- 7-8: 84 students
- 9-12: 843 students
Funding Results:
| Grade Band | Students | Days | ADA Units | Total Funding |
|---|---|---|---|---|
| TK-K | 457 | 1,175 | 6.53 | $95,304 |
| 1-3 | 720 | 1,693 | 9.41 | $137,319 |
| 4-6 | 739 | 1,633 | 9.07 | $121,790 |
| 7-8 | 84 | 126 | 0.70 | $9,675 |
| 9-12 | 843 | 4,958 | 27.54 | $452,720 |
| Total | 2,843 | 9,585 | 53.25 | $816,809 |
Funding Breakdown:
- Base Grant: $619,217 (75.8%)
- Supplemental Grant: $98,579 (12.1%)
- Concentration Grant: $99,013 (12.1%)
Deliverables
student_minutes_summary.csv- Per-student breakdown with grade band, school, minutes, absences, recoverable daysar_funding_detailed.csv- Full AR calculations per student with ADA units and funding by grant typebuild_student_summary.py- Python script for data processingcalculate_ar_funding.py- Python script for LCFF funding calculationsexpanded_learning_programs_info.md- Program category documentation
Recovery Capacity
- Students at 10-day cap: 249 (8.8%)
- Students limited by absences: 1,512
- Students limited by AR minutes: 1,098
- Average funding per student: $287.31
Related: 2025-W51 - Impact