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	1752212	2366	-	2436	=	-70	*	(1610	/	10242)	=	-11.0037102
4	1752215	2403	-	2485	=	-82	*	(1599	/	10242)	=	-12.80199178
5	1752216	2424	-	2528	=	-104	*	(1506	/	10242)	=	-15.29232567
6	1752219	2448	-	2552	=	-104	*	(1540	/	10242)	=	-15.63757073
7	1752220	2441	-	2567	=	-126	*	(1458	/	10242)	=	-17.93673101
8	1752223	2465	-	2586	=	-121	*	(1377	/	10242)	=	-16.26801404
11	1752224	2498	-	2628	=	-130	*	(1152	/	10242)	=	-14.62214403
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Coachella Valley Unified											-104

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	54434	2384	-	2436	=	-52	*	(1499	/	10276)	=	-7.58544176
4	54437	2409	-	2485	=	-76	*	(1617	/	10276)	=	-11.95912805
5	54438	2424	-	2528	=	-104	*	(1615	/	10276)	=	-16.34488118
6	54441	2458	-	2552	=	-94	*	(1489	/	10276)	=	-13.62066947
7	54442	2442	-	2567	=	-125	*	(1484	/	10276)	=	-18.051771
8	54444	2468	-	2586	=	-118	*	(1447	/	10276)	=	-16.61599843
11	54446	2503	-	2628	=	-125	*	(1125	/	10276)	=	-13.6847995
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Coachella Valley Unified											-98

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	56029	2395	-	2436	=	-41	*	(1381	/	10247)	=	-5.52561723
4	56032	2419	-	2485	=	-66	*	(1511	/	10247)	=	-9.73221427
5	56033	2434	-	2528	=	-94	*	(1608	/	10247)	=	-14.75085384
6	56036	2451	-	2552	=	-101	*	(1584	/	10247)	=	-15.61276463
7	56038	2454	-	2567	=	-113	*	(1436	/	10247)	=	-15.8356592
8	56040	2451	-	2586	=	-135	*	(1459	/	10247)	=	-19.22172336
11	56041	2505	-	2628	=	-123	*	(1268	/	10247)	=	-15.22045468
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Coachella Valley Unified											-96

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	56129	2397	-	2436	=	-39	*	(1352	/	9872)	=	-5.34116692
4	56131	2426	-	2485	=	-59	*	(1392	/	9872)	=	-8.31928686
5	56133	2440	-	2528	=	-88	*	(1494	/	9872)	=	-13.31766612
6	56135	2463	-	2552	=	-89	*	(1574	/	9872)	=	-14.19023494
7	56137	2453	-	2567	=	-114	*	(1474	/	9872)	=	-17.02147486
8	56138	2468	-	2586	=	-118	*	(1409	/	9872)	=	-16.84177467
11	56141	2507	-	2628	=	-121	*	(1177	/	9872)	=	-14.42635737
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Coachella Valley Unified											-89

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	56391	2405	-	2436	=	-31	*	(1390	/	9760)	=	-4.41495899
4	56392	2426	-	2485	=	-59	*	(1342	/	9760)	=	-8.1125
5	56393	2444	-	2528	=	-84	*	(1383	/	9760)	=	-11.9028688
6	56394	2465	-	2552	=	-87	*	(1472	/	9760)	=	-13.12131146
7	56395	2453	-	2567	=	-114	*	(1484	/	9760)	=	-17.33360652
8	56396	2468	-	2586	=	-118	*	(1448	/	9760)	=	-17.50655729
11	56397	2503	-	2628	=	-125	*	(1241	/	9760)	=	-15.89395488
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Coachella Valley Unified											-88

2015	2016	2017	2018	2019	Sum	Average
-104	-98	-96	-89	-88	-475.0	-95.0

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

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

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.

Coachella Valley Unified math proficiency

Zero+ meets standard.

Coachella Valley High

Desert Mirage High

West Shores High

Bobby Duke Middle

Cahuilla Desert Academy Junior High

Toro Canyon Middle

La Familia Continuation High

Coachella Valley Adult

Coachella Valley USD Special Ed PreK