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	18986	2402	-	2436	=	-34	*	(58	/	409)	=	-4.82151586
4	18987	2450	-	2485	=	-35	*	(68	/	409)	=	-5.81907088
5	18989	2417	-	2528	=	-111	*	(45	/	409)	=	-12.21271384
6	18992	2455	-	2552	=	-97	*	(69	/	409)	=	-16.36430313
7	18993	2447	-	2567	=	-120	*	(48	/	409)	=	-14.08312956
8	18996	2445	-	2586	=	-141	*	(46	/	409)	=	-15.85819062
11	18998	2490	-	2628	=	-138	*	(75	/	409)	=	-25.30562345
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Upper Lake Unified											-94

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	18996	2435	-	2436	=	-1	*	(61	/	433)	=	-0.1408776
4	18997	2470	-	2485	=	-15	*	(59	/	433)	=	-2.0438799
5	19000	2447	-	2528	=	-81	*	(66	/	433)	=	-12.3464203
6	19001	2439	-	2552	=	-113	*	(54	/	433)	=	-14.09237871
7	19004	2462	-	2567	=	-105	*	(65	/	433)	=	-15.76212467
8	19005	2475	-	2586	=	-111	*	(47	/	433)	=	-12.04849877
11	19008	2464	-	2628	=	-164	*	(81	/	433)	=	-30.67898374
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Upper Lake Unified											-87

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	19154	2442	-	2436	=	6	*	(42	/	407)	=	0.61916462
4	19155	2470	-	2485	=	-15	*	(63	/	407)	=	-2.32186731
5	19156	2474	-	2528	=	-54	*	(56	/	407)	=	-7.4299754
6	19157	2463	-	2552	=	-89	*	(66	/	407)	=	-14.43243242
7	19158	2454	-	2567	=	-113	*	(49	/	407)	=	-13.60442256
8	19159	2453	-	2586	=	-133	*	(67	/	407)	=	-21.89434881
11	19160	2453	-	2628	=	-175	*	(64	/	407)	=	-27.51842748
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Upper Lake Unified											-87

2017	2018	2019	Sum	Average
-94	-87	-87	-268.0	-89.3

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

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

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.

Upper Lake Unified math proficiency

Zero+ meets standard.

Upper Lake Elementary

Upper Lake High

Upper Lake Middle

Clover Valley High (Continuation)

Upper Lake Community Day

Upper Lake Adult Education