| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Administrative Staff Ratios | |||||||||||
2 | ||||||||||||
3 | This workbook calculates student-per-administrator ratios, by state, by year (with and without including staff) | |||||||||||
4 | It presents data (esp. from NCES CCD via ELSI) to compare states by their level of staff resources per student | |||||||||||
5 | ||||||||||||
6 | ||||||||||||
7 | School years are presented as fiscal years. For example 2013-14 is abbreviated as 2014 (e.g. fall 2022 = 2023) | |||||||||||
8 | The term "district" is used in place of the more formal term LEA | |||||||||||
9 | The data include both district administrators and school administrators | |||||||||||
10 | County and state administrators and their staff are NOT included in this data | |||||||||||
11 | ||||||||||||
12 | The "jumpiness" of data suggest poor data quality or inconsistent definitions in many states | |||||||||||
13 | ||||||||||||
14 | ||||||||||||
15 | IMPORTANT NOTE! | |||||||||||
16 | ||||||||||||
17 | Counts of students and teachers that appear in this sheet are NOT guaranteed to match our "book of record" figures. For those, refer instead here: | |||||||||||
18 | https://docs.google.com/spreadsheets/d/1J8gItWA9SaCPjUR2HSB-M2a885C4qUhu5wHryKodCpk/edit#gid=2090577871 | |||||||||||
19 | ||||||||||||
20 | Freshness check as of July 2024 | |||||||||||
21 | Students | |||||||||||
22 | Counselors | |||||||||||
23 | Stdt per counselor | |||||||||||
24 | School administrators | |||||||||||
25 | District administrators | |||||||||||
26 | Admin_All | |||||||||||
27 | Ratio calculations | |||||||||||
28 | Student per counselor | |||||||||||
29 | Student per administrator | This is the one used in the chart "California's education system is administratively lean" | ||||||||||
30 | Students per admin all | |||||||||||
31 | ||||||||||||
32 | ||||||||||||
33 | ||||||||||||
34 | ||||||||||||
35 | ||||||||||||
36 | ||||||||||||
37 | ||||||||||||
38 | ||||||||||||
39 | ||||||||||||
40 |