SCHOOLIO: Districts

Step 1				Step 2				Step 3
Get Mean Scale Score from line numbers in this data file.				Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard				Multiply Distance From Standard by proportion of students in grade.
Grade	Line number	Mean Scale Score	-	Scale Score: met min	=	Distance from standard	*	(Students tested in grade	/	Students) tested in school	=	Weighted Distance From Standard
3	591391	2389	-	2436	=	-47	*	(24	/	133)	=	-8.48120297
4	591394	2454	-	2485	=	-31	*	(21	/	133)	=	-4.89473682
5	591395	2494	-	2528	=	-34	*	(23	/	133)	=	-5.87969922
6	591398	2468	-	2552	=	-84	*	(16	/	133)	=	-10.10526308
7	591399	2516	-	2567	=	-51	*	(25	/	133)	=	-9.58646612
8	591402	2550	-	2586	=	-36	*	(24	/	133)	=	-6.49624057
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Shaffer Union Elementary											-45

Step 1				Step 2				Step 3
Get Mean Scale Score from line numbers in this data file.				Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard				Multiply Distance From Standard by proportion of students in grade.
Grade	Line number	Mean Scale Score	-	Scale Score: met min	=	Distance from standard	*	(Students tested in grade	/	Students) tested in school	=	Weighted Distance From Standard
3	18915	2399	-	2436	=	-37	*	(20	/	126)	=	-5.87301585
4	18917	2464	-	2485	=	-21	*	(27	/	126)	=	-4.49999999
5	18918	2458	-	2528	=	-70	*	(20	/	126)	=	-11.11111106
6	18921	2518	-	2552	=	-34	*	(22	/	126)	=	-5.93650792
7	18922	2525	-	2567	=	-42	*	(12	/	126)	=	-3.99999999
8	18924	2544	-	2586	=	-42	*	(25	/	126)	=	-8.33333332
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Shaffer Union Elementary											-40

Step 1				Step 2				Step 3
Get Mean Scale Score from line numbers in this data file.				Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard				Multiply Distance From Standard by proportion of students in grade.
Grade	Line number	Mean Scale Score	-	Scale Score: met min	=	Distance from standard	*	(Students tested in grade	/	Students) tested in school	=	Weighted Distance From Standard
3	19246	2383	-	2436	=	-53	*	(19	/	116)	=	-8.68103446
4	19247	2463	-	2485	=	-22	*	(19	/	116)	=	-3.60344827
5	19250	2450	-	2528	=	-78	*	(25	/	116)	=	-16.8103448
6	19251	2479	-	2552	=	-73	*	(22	/	116)	=	-13.84482756
7	19254	2540	-	2567	=	-27	*	(18	/	116)	=	-4.18965515
8	19255	2553	-	2586	=	-33	*	(13	/	116)	=	-3.69827585
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Shaffer Union Elementary											-51

Step 1				Step 2				Step 3
Get Mean Scale Score from line numbers in this data file.				Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard				Multiply Distance From Standard by proportion of students in grade.
Grade	Line number	Mean Scale Score	-	Scale Score: met min	=	Distance from standard	*	(Students tested in grade	/	Students) tested in school	=	Weighted Distance From Standard
3	19247	2418	-	2436	=	-18	*	(21	/	117)	=	-3.23076922
4	19250	2484	-	2485	=	-1	*	(19	/	117)	=	-0.16239316
5	19251	2453	-	2528	=	-75	*	(19	/	117)	=	-12.17948715
6	19254	2514	-	2552	=	-38	*	(22	/	117)	=	-7.14529914
7	19255	2536	-	2567	=	-31	*	(20	/	117)	=	-5.29914527
8	19257	2575	-	2586	=	-11	*	(16	/	117)	=	-1.5042735
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Shaffer Union Elementary											-30

Step 1				Step 2				Step 3
Get Mean Scale Score from line numbers in this data file.				Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard				Multiply Distance From Standard by proportion of students in grade.
Grade	Line number	Mean Scale Score	-	Scale Score: met min	=	Distance from standard	*	(Students tested in grade	/	Students) tested in school	=	Weighted Distance From Standard
3	19395	2385	-	2436	=	-51	*	(23	/	138)	=	-8.49999997
4	19396	2469	-	2485	=	-16	*	(23	/	138)	=	-2.66666666
5	19397	2475	-	2528	=	-53	*	(21	/	138)	=	-8.06521739
6	19398	2496	-	2552	=	-56	*	(23	/	138)	=	-9.3333333
7	19399	2561	-	2567	=	-6	*	(25	/	138)	=	-1.08695652
8	19400	2565	-	2586	=	-21	*	(23	/	138)	=	-3.49999999
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Shaffer Union Elementary											-33

2015	2016	2017	2018	2019	Sum	Average
-45	-40	-51	-30	-33	-199.0	-39.8

Simply compute the standard deviation and multiply by 3 and add to the average: -15.8

Simply compute the standard deviation and multiply by 3 and subtract from the average: -63.8

NOT what school board members want.

NOT what superintendents want.

But that's not what it "wants"...and it's not a coincidence this pattern repeats (repeatedly).

• Any result above zero is proficient; below is not proficient.

Shaffer Union Elementary math proficiency

Zero+ meets standard.

Shaffer Elementary

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Shaffer Union Elementary School District	209	184	180	166	192	193	187	192
Elementary School in 1 School District (Public)
Shaffer Elementary	209	184	180	166	192	193	187	192