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	1294097	2410	-	2436	=	-26	*	(471	/	3097)	=	-3.95414916
4	1294098	2434	-	2485	=	-51	*	(543	/	3097)	=	-8.94187922
5	1294101	2460	-	2528	=	-68	*	(497	/	3097)	=	-10.91249591
6	1294102	2488	-	2552	=	-64	*	(534	/	3097)	=	-11.03519533
7	1294105	2495	-	2567	=	-72	*	(518	/	3097)	=	-12.04262186
8	1294106	2504	-	2586	=	-82	*	(534	/	3097)	=	-14.13884401
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Atwater Elementary											-61

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	40583	2424	-	2436	=	-12	*	(541	/	3149)	=	-2.06160685
4	40584	2450	-	2485	=	-35	*	(506	/	3149)	=	-5.62400762
5	40587	2470	-	2528	=	-58	*	(555	/	3149)	=	-10.22229277
6	40588	2506	-	2552	=	-46	*	(517	/	3149)	=	-7.55223878
7	40590	2505	-	2567	=	-62	*	(522	/	3149)	=	-10.27754842
8	40593	2507	-	2586	=	-79	*	(508	/	3149)	=	-12.74436327
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Atwater Elementary											-48

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	41585	2423	-	2436	=	-13	*	(548	/	3224)	=	-2.20967742
4	41587	2450	-	2485	=	-35	*	(548	/	3224)	=	-5.94913151
5	41590	2474	-	2528	=	-54	*	(516	/	3224)	=	-8.64267986
6	41591	2507	-	2552	=	-45	*	(574	/	3224)	=	-8.01178659
7	41594	2514	-	2567	=	-53	*	(514	/	3224)	=	-8.44975184
8	41596	2516	-	2586	=	-70	*	(524	/	3224)	=	-11.37717119
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Atwater 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	41620	2425	-	2436	=	-11	*	(530	/	3264)	=	-1.78615195
4	41623	2454	-	2485	=	-31	*	(558	/	3264)	=	-5.29963234
5	41624	2483	-	2528	=	-45	*	(552	/	3264)	=	-7.61029412
6	41627	2511	-	2552	=	-41	*	(531	/	3264)	=	-6.67003674
7	41628	2517	-	2567	=	-50	*	(580	/	3264)	=	-8.8848039
8	41631	2511	-	2586	=	-75	*	(513	/	3264)	=	-11.78768378
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Atwater Elementary											-42

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	41765	2431	-	2436	=	-5	*	(563	/	3326)	=	-0.846362
4	41766	2456	-	2485	=	-29	*	(522	/	3326)	=	-4.55141309
5	41767	2485	-	2528	=	-43	*	(559	/	3326)	=	-7.22699938
6	41768	2505	-	2552	=	-47	*	(565	/	3326)	=	-7.98406493
7	41769	2512	-	2567	=	-55	*	(541	/	3326)	=	-8.94618159
8	41770	2513	-	2586	=	-73	*	(576	/	3326)	=	-12.64221285
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Atwater Elementary											-42

2015	2016	2017	2018	2019	Sum	Average
-61	-48	-45	-42	-42	-238.0	-47.6

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

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

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.

Atwater Elementary math proficiency

Zero+ meets standard.

Bellevue Senior Elementary

Mitchell Intermediate

Atwater Senior Academy

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Atwater Elementary School District	4,855	4,899	4,964	5,073	5,125	4,978	4,815	4,854
Elementary School (Public)
Aileen Colburn Elementary	458	415	411	425	417	404	395	416
Bellevue Elementary	641	648	626	656	691	638	661	697
Elmer Wood Elementary	516	522	537	543	560	562	527	548
Mitchell Elementary	556	574	591	577	591	553	523	543
Peggy Heller Elementary	543	577	575	573	665	748	738	728
Shaffer Elementary	528	553	557	564	548	550	509	503
Thomas Olaeta Elementary	545	548	600	617	601	576	536	519
Intermediate/Middle Schools (Public)
Bellevue Senior Elementary	197	203	193	185	211	198	174	166
Mitchell Intermediate	865	854	864	925	837	741	751	730
District Community Day Schools
Atwater Senior Academy	6	5	10	8	4	8	1	4