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	2861881	2422	-	2436	=	-14	*	(34	/	184)	=	-2.58695651
4	2861882	2485	-	2485	=	0	*	(21	/	184)	=	0.0
5	2861885	2484	-	2528	=	-44	*	(33	/	184)	=	-7.89130434
6	2861886	2488	-	2552	=	-64	*	(31	/	184)	=	-10.78260864
7	2861889	2526	-	2567	=	-41	*	(32	/	184)	=	-7.13043476
8	2861890	2560	-	2586	=	-26	*	(33	/	184)	=	-4.66304348
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Guerneville Elementary											-33

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	87520	2399	-	2436	=	-37	*	(35	/	191)	=	-6.7801047
4	87523	2479	-	2485	=	-6	*	(35	/	191)	=	-1.09947644
5	87524	2509	-	2528	=	-19	*	(25	/	191)	=	-2.48691099
6	87526	2494	-	2552	=	-58	*	(34	/	191)	=	-10.32460732
7	87529	2522	-	2567	=	-45	*	(33	/	191)	=	-7.77486911
8	87531	2536	-	2586	=	-50	*	(29	/	191)	=	-7.591623
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Guerneville Elementary											-36

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	90022	2402	-	2436	=	-34	*	(23	/	186)	=	-4.20430104
4	90023	2451	-	2485	=	-34	*	(33	/	186)	=	-6.03225804
5	90026	2489	-	2528	=	-39	*	(36	/	186)	=	-7.54838709
6	90027	2524	-	2552	=	-28	*	(23	/	186)	=	-3.46236556
7	90029	2512	-	2567	=	-55	*	(38	/	186)	=	-11.23655913
8	90032	2526	-	2586	=	-60	*	(33	/	186)	=	-10.64516124
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Guerneville Elementary											-43

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	90225	2413	-	2436	=	-23	*	(27	/	185)	=	-3.35675674
4	90226	2476	-	2485	=	-9	*	(23	/	185)	=	-1.11891892
5	90229	2473	-	2528	=	-55	*	(35	/	185)	=	-10.4054054
6	90230	2543	-	2552	=	-9	*	(40	/	185)	=	-1.94594594
7	90233	2572	-	2567	=	5	*	(25	/	185)	=	0.67567568
8	90234	2540	-	2586	=	-46	*	(35	/	185)	=	-8.70270269
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Guerneville Elementary											-25

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	90841	2414	-	2436	=	-22	*	(31	/	185)	=	-3.68648647
4	90842	2460	-	2485	=	-25	*	(30	/	185)	=	-4.05405405
5	90843	2497	-	2528	=	-31	*	(25	/	185)	=	-4.18918919
6	90844	2500	-	2552	=	-52	*	(34	/	185)	=	-9.55675672
7	90845	2560	-	2567	=	-7	*	(38	/	185)	=	-1.43783784
8	90846	2559	-	2586	=	-27	*	(27	/	185)	=	-3.94054052
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Guerneville Elementary											-27

2015	2016	2017	2018	2019	Sum	Average
-33	-36	-43	-25	-27	-164.0	-32.8

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

Simply compute the standard deviation and multiply by 3 and subtract from the average: -53.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.

Guerneville Elementary math proficiency

Zero+ meets standard.

Guerneville Primary

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Guerneville Elementary School District	269	281	286	278	1,340	457	458	396
Elementary School (Public)
Guerneville Elementary (Charter)	269	281	286	262	242	255	220	201
Guerneville Primary					24	24	22	22
K-12 Schools (Public)
California Pacific Charter - Sonoma						178	216	173
California STEAM Sonoma II				16	1,074