Short Avenue Elementary: english

The shaded band is this school's normal range. If nothing about how it works changes, nearly every future year should land inside it. Zero means the typical student just meets the state standard. The small numbers under the years are how many students were tested.

Step 1 · Each year's result

For each grade tested, take the average (mean) scale score from the California Department of Education's results file, and subtract the lowest score that counts as "Standard Met" for that grade. That is the grade's distance from standard. Weight each grade by its share of the students tested, then add the grades up. Grades where the state hides the average because ten or fewer students tested are left out entirely.

2015 from sb_ca2015_1_csv_v3.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	32,056	2393.4	− 2432	−38.6	× 50 / 185	−10.4
4	32,057	2492.7	− 2473	19.7	× 54 / 185	5.8
5	32,060	2463.5	− 2502	−38.5	× 37 / 185	−7.7
6	32,061	2506.1	− 2531	−24.9	× 44 / 185	−5.9
Sum, rounded to a whole point						−18

2016 from sb_ca2016_1_csv_v3.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	30,270	2399.1	− 2432	−32.9	× 34 / 147	−7.6
4	30,271	2455.7	− 2473	−17.3	× 38 / 147	−4.5
5	30,274	2527.7	− 2502	25.7	× 48 / 147	8.4
6	30,275	2509.8	− 2531	−21.2	× 27 / 147	−3.9
Sum, rounded to a whole point						−8

2017 from sb_ca2017_1_csv_v2.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	30,834	2454.4	− 2432	22.4	× 47 / 142	7.4
4	30,837	2462.8	− 2473	−10.2	× 35 / 142	−2.5
5	30,839	2489.5	− 2502	−12.5	× 37 / 142	−3.3
6	30,841	2506.1	− 2531	−24.9	× 23 / 142	−4
Sum, rounded to a whole point						−2

2018 from sb_ca2018_1_csv_v3.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	30,882	2411.6	− 2432	−20.4	× 36 / 155	−4.7
4	30,884	2482.0	− 2473	9	× 51 / 155	3
5	30,886	2468.2	− 2502	−33.8	× 38 / 155	−8.3
6	30,888	2526.9	− 2531	−4.1	× 30 / 155	−0.8
Sum, rounded to a whole point						−11

2019 from sb_ca2019_1_csv_v4.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	31,053	2468.1	− 2432	36.1	× 36 / 156	8.3
4	31,054	2443.2	− 2473	−29.8	× 40 / 156	−7.6
5	31,055	2541.5	− 2502	39.5	× 54 / 156	13.7
6	31,056	2551.8	− 2531	20.8	× 26 / 156	3.5
Sum, rounded to a whole point						18

2022 from sb_ca2022_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	31,072	2451.4	− 2432	19.4	× 46 / 124	7.2
4	31,073	2480.6	− 2473	7.6	× 43 / 124	2.6
5	31,074	2540.2	− 2502	38.2	× 35 / 124	10.8
Sum, rounded to a whole point						21

2023 from sb_ca2023_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	31,129	2459.0	− 2432	27	× 43 / 126	9.2
4	31,130	2495.0	− 2473	22	× 40 / 126	7
5	31,131	2529.2	− 2502	27.2	× 43 / 126	9.3
Sum, rounded to a whole point						25

2024 from sb_ca2024_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	30,995	2467.3	− 2432	35.3	× 49 / 132	13.1
4	30,996	2528.7	− 2473	55.7	× 43 / 132	18.1
5	30,997	2524.8	− 2502	22.8	× 40 / 132	6.9
Sum, rounded to a whole point						38

2025 from sb_ca2025_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	30,854	2465.9	− 2432	33.9	× 57 / 148	13.1
4	30,855	2560.3	− 2473	87.3	× 51 / 148	30.1
5	30,856	2555.4	− 2502	53.4	× 40 / 148	14.4
Sum, rounded to a whole point						58

Step 2 · The average and the normal range

Average: add the yearly results and divide by how many there are. −18, −8, −2, −11, 18, 21, 25, 38, 58 → 13.4
Typical year-to-year change: how far the result moved from each year to the next, ignoring up or down. 2015→2016: 10 · 2016→2017: 6 · 2017→2018: 9 · 2018→2019: 29 · 2019→2022: 3 · 2022→2023: 4 · 2023→2024: 13 · 2024→2025: 20 → average 11.8
Normal range: multiply the typical change by 2.66, then add it to the average and subtract it. 11.8 × 2.66 = 31.4. Upper limit 44.8, lower limit −18.

Why 2.66? It is the standard factor from quality control, the work of Walter Shewhart and W. Edwards Deming. It turns "how much the result typically changes in a year" into "how far it can wander by chance alone".

Years with no result (no state tests were given in spring 2020) are skipped: the year-to-year change runs from the last year with a result to the next one.

Step 3 · Free or reduced-price meals

The share of enrolled students eligible for free or reduced-price meals. From 2014–15, 2015–16, 2016–17, 2017–18, 2018–19, 2020–21, 2021–22, 2022–23, 2023–24, 2024–25, 2025–26.