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	2859632	0	-	2436	=		*	(7	/	21)	=
4	2859635	0	-	2485	=		*	(2	/	21)	=
5	2859636	0	-	2528	=		*	(1	/	21)	=
6	2859639	0	-	2552	=		*	(3	/	21)	=
7	2859640	0	-	2567	=		*	(1	/	21)	=
8	2859643	0	-	2586	=		*	(7	/	21)	=
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Fort Ross Elementary

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	87429	0	-	2436	=		*	(2	/	13)	=
4	87431	0	-	2485	=		*	(6	/	13)	=
5	87433	0	-	2528	=		*	(1	/	13)	=
6	87435	0	-	2552	=		*	(1	/	13)	=
7	87437	0	-	2567	=		*	(3	/	13)	=
8	87438	0	-	2586	=		*	(0	/	13)	=
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Fort Ross Elementary

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	89926	0	-	2436	=		*	(0	/	13)	=
4	89928	0	-	2485	=		*	(0	/	13)	=
5	89929	0	-	2528	=		*	(0	/	13)	=
6	89931	0	-	2552	=		*	(0	/	13)	=
7	89934	0	-	2567	=		*	(0	/	13)	=
8	89935	0	-	2586	=		*	(0	/	13)	=
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Fort Ross Elementary

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	90127	0	-	2436	=		*	(0	/	15)	=
4	90128	0	-	2485	=		*	(0	/	15)	=
5	90131	0	-	2528	=		*	(0	/	15)	=
6	90132	0	-	2552	=		*	(0	/	15)	=
7	90135	0	-	2567	=		*	(0	/	15)	=
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Fort Ross Elementary

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
4	90741	0	-	2485	=		*	(0	/	9)	=
5	90742	0	-	2528	=		*	(0	/	9)	=
7	90743	0	-	2567	=		*	(5	/	9)	=
8	90744	0	-	2586	=		*	(0	/	9)	=
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Fort Ross Elementary

2015	2016	2017	2018	2019	Sum	Average
					0.0	0.0

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

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

NOT what school board members want.

NOT what superintendents want.

Forestville Union Elementary Geyserville Unified

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

Fort Ross Elementary