Harmony Union Elementary: english

The shaded band is this district'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	94,302	2423.1	− 2432	−8.9	× 15 / 120	−1.1
4	94,305	2467.8	− 2473	−5.2	× 24 / 120	−1
5	94,306	2502.1	− 2502	0.1	× 20 / 120	0
6	94,309	2609.7	− 2531	78.7	× 17 / 120	11.1
7	94,310	2534.1	− 2552	−17.9	× 27 / 120	−4
8	94,313	2590.4	− 2567	23.4	× 17 / 120	3.3
Sum, rounded to a whole point						8

2016 from sb_ca2016_1_csv_v3.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	87,550	2447.9	− 2432	15.9	× 23 / 138	2.7
4	87,551	2467.7	− 2473	−5.3	× 20 / 138	−0.8
5	87,554	2492.0	− 2502	−10	× 26 / 138	−1.9
6	87,556	2541.8	− 2531	10.8	× 23 / 138	1.8
7	87,558	2633.2	− 2552	81.2	× 20 / 138	11.8
8	87,560	2574.2	− 2567	7.2	× 26 / 138	1.4
Sum, rounded to a whole point						15

2017 from sb_ca2017_1_csv_v2.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	90,051	2433.5	− 2432	1.5	× 26 / 154	0.3
4	90,053	2519.5	− 2473	46.5	× 25 / 154	7.5
5	90,055	2485.4	− 2502	−16.6	× 22 / 154	−2.4
6	90,056	2515.6	− 2531	−15.4	× 30 / 154	−3
7	90,058	2555.7	− 2552	3.7	× 27 / 154	0.6
8	90,060	2669.8	− 2567	102.8	× 24 / 154	16
Sum, rounded to a whole point						19

2018 from sb_ca2018_1_csv_v3.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	90,273	2450.1	− 2432	18.1	× 22 / 151	2.6
4	90,276	2484.0	− 2473	11	× 27 / 151	2
5	90,277	2563.8	− 2502	61.8	× 25 / 151	10.2
6	90,280	2528.3	− 2531	−2.7	× 23 / 151	−0.4
7	90,281	2531.4	− 2552	−20.6	× 29 / 151	−4
8	90,284	2591.4	− 2567	24.4	× 25 / 151	4
Sum, rounded to a whole point						15

2019 from sb_ca2019_1_csv_v4.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	90,885	2489.1	− 2432	57.1	× 32 / 152	12
4	90,886	2499.8	− 2473	26.8	× 25 / 152	4.4
5	90,887	2561.9	− 2502	59.9	× 23 / 152	9.1
6	90,888	2584.8	− 2531	53.8	× 23 / 152	8.1
7	90,889	2573.0	− 2552	21	× 21 / 152	2.9
8	90,890	2583.6	− 2567	16.6	× 28 / 152	3.1
Sum, rounded to a whole point						40

2021 from sb_ca2021_1_csv_v2.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
4	88,984	2519.4	− 2473	46.4	× 21 / 92	10.6
5	88,985	2553.1	− 2502	51.1	× 20 / 92	11.1
6	88,986	2528.9	− 2531	−2.1	× 17 / 92	−0.4
7	88,987	2583.8	− 2552	31.8	× 20 / 92	6.9
8	88,988	2578.8	− 2567	11.8	× 14 / 92	1.8
Sum, rounded to a whole point						30

2022 from sb_ca2022_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	91,119	2467.6	− 2432	35.6	× 27 / 100	9.6
4	91,120	2461.1	− 2473	−11.9	× 14 / 100	−1.7
5	91,121	2570.3	− 2502	68.3	× 22 / 100	15
6	91,122	2553.5	− 2531	22.5	× 20 / 100	4.5
8	91,124	2626.8	− 2567	59.8	× 17 / 100	10.2
Sum, rounded to a whole point						38

2023 from sb_ca2023_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	91,009	2437.3	− 2432	5.3	× 21 / 107	1
4	91,010	2482.6	− 2473	9.6	× 28 / 107	2.5
5	91,011	2521.9	− 2502	19.9	× 17 / 107	3.2
6	91,012	2593.3	− 2531	62.3	× 22 / 107	12.8
7	91,013	2584.2	− 2552	32.2	× 19 / 107	5.7
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	90,962	2403.7	− 2432	−28.3	× 22 / 145	−4.3
4	90,963	2472.7	− 2473	−0.3	× 23 / 145	0
5	90,964	2533.5	− 2502	31.5	× 33 / 145	7.2
6	90,965	2514.7	− 2531	−16.3	× 25 / 145	−2.8
7	90,966	2621.7	− 2552	69.7	× 21 / 145	10.1
8	90,967	2571.5	− 2567	4.5	× 21 / 145	0.7
Sum, rounded to a whole point						11

2025 from sb_ca2025_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	90,656	2442.1	− 2432	10.1	× 18 / 124	1.5
4	90,657	2508.3	− 2473	35.3	× 22 / 124	6.3
5	90,658	2508.5	− 2502	6.5	× 13 / 124	0.7
6	90,659	2555.3	− 2531	24.3	× 29 / 124	5.7
7	90,660	2550.6	− 2552	−1.4	× 22 / 124	−0.2
8	90,661	2628.9	− 2567	61.9	× 20 / 124	10
Sum, rounded to a whole point						24

2026 from sb_ca2026_1_csv_v1.zip

Grade	Line in file	Average score	Standard Met	Distance	Students	Weighted
3	90,315	2510.3	− 2432	78.3	× 18 / 120	11.7
4	90,316	2483.1	− 2473	10.1	× 22 / 120	1.9
5	90,317	2501.8	− 2502	−0.2	× 25 / 120	0
6	90,318	2518.2	− 2531	−12.8	× 11 / 120	−1.2
7	90,319	2573.7	− 2552	21.7	× 25 / 120	4.5
8	90,320	2573.3	− 2567	6.3	× 19 / 120	1
Sum, rounded to a whole point						18

Step 2 · The average and the normal range

Average: add the yearly results and divide by how many there are. 8, 15, 19, 15, 40, 30, 38, 25, 11, 24, 18 → 22.1
Typical year-to-year change: how far the result moved from each year to the next, ignoring up or down. 2015→2016: 7 · 2016→2017: 4 · 2017→2018: 4 · 2018→2019: 25 · 2019→2021: 10 · 2021→2022: 8 · 2022→2023: 13 · 2023→2024: 14 · 2024→2025: 13 · 2025→2026: 6 → average 10.4
Normal range: multiply the typical change by 2.66, then add it to the average and subtract it. 10.4 × 2.66 = 27.7. Upper limit 49.8, lower limit −5.6.

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 — for a district, the total across its schools. From 2014–15, 2015–16, 2016–17, 2017–18, 2018–19, 2020–21, 2021–22, 2022–23, 2023–24, 2024–25, 2025–26.

Harmony Union Elementary