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	1381255	2415	-	2436	=	-21	*	(1415	/	9566)	=	-3.10631402
4	1381256	2452	-	2485	=	-33	*	(1348	/	9566)	=	-4.65021952
5	1381259	2483	-	2528	=	-45	*	(1317	/	9566)	=	-6.19537946
6	1381260	2493	-	2552	=	-59	*	(1362	/	9566)	=	-8.40037628
7	1381263	2507	-	2567	=	-60	*	(1340	/	9566)	=	-8.40476688
8	1381264	2535	-	2586	=	-51	*	(1352	/	9566)	=	-7.20802839
11	1381267	2553	-	2628	=	-75	*	(1432	/	9566)	=	-11.22726315
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Napa Valley Unified											-49

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	43516	2425	-	2436	=	-11	*	(1245	/	9391)	=	-1.45831114
4	43518	2460	-	2485	=	-25	*	(1407	/	9391)	=	-3.74560748
5	43520	2481	-	2528	=	-47	*	(1351	/	9391)	=	-6.76147372
6	43523	2498	-	2552	=	-54	*	(1335	/	9391)	=	-7.67649874
7	43525	2502	-	2567	=	-65	*	(1356	/	9391)	=	-9.38558192
8	43527	2530	-	2586	=	-56	*	(1323	/	9391)	=	-7.88925564
11	43528	2563	-	2628	=	-65	*	(1374	/	9391)	=	-9.51016931
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Napa Valley Unified											-46

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	44586	2427	-	2436	=	-9	*	(1213	/	9362)	=	-1.16609698
4	44587	2461	-	2485	=	-24	*	(1255	/	9362)	=	-3.21726125
5	44589	2486	-	2528	=	-42	*	(1416	/	9362)	=	-6.35248874
6	44592	2487	-	2552	=	-65	*	(1366	/	9362)	=	-9.48408455
7	44593	2499	-	2567	=	-68	*	(1343	/	9362)	=	-9.7547532
8	44595	2520	-	2586	=	-66	*	(1365	/	9362)	=	-9.62294381
11	44597	2554	-	2628	=	-74	*	(1404	/	9362)	=	-11.09762867
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Napa Valley Unified											-51

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	44601	2427	-	2436	=	-9	*	(1256	/	9253)	=	-1.22165784
4	44602	2466	-	2485	=	-19	*	(1226	/	9253)	=	-2.51745379
5	44605	2487	-	2528	=	-41	*	(1246	/	9253)	=	-5.52102019
6	44606	2493	-	2552	=	-59	*	(1418	/	9253)	=	-9.04160811
7	44609	2496	-	2567	=	-71	*	(1349	/	9253)	=	-10.35112933
8	44610	2521	-	2586	=	-65	*	(1339	/	9253)	=	-9.4061385
11	44613	2549	-	2628	=	-79	*	(1419	/	9253)	=	-12.11509777
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Napa Valley Unified											-50

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	44743	2432	-	2436	=	-4	*	(1182	/	9069)	=	-0.52133642
4	44744	2467	-	2485	=	-18	*	(1256	/	9069)	=	-2.49288784
5	44745	2494	-	2528	=	-34	*	(1210	/	9069)	=	-4.53633253
6	44746	2496	-	2552	=	-56	*	(1263	/	9069)	=	-7.79887528
7	44747	2510	-	2567	=	-57	*	(1399	/	9069)	=	-8.79292089
8	44748	2515	-	2586	=	-71	*	(1332	/	9069)	=	-10.42805159
11	44749	2546	-	2628	=	-82	*	(1427	/	9069)	=	-12.9026353
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Napa Valley Unified											-47

2015	2016	2017	2018	2019	Sum	Average
-49	-46	-51	-50	-47	-243.0	-48.6

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

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

Napa Valley Unified math proficiency

Zero+ meets standard.

American Canyon High

Napa High

Vintage High

American Canyon Middle	Harvest Middle	Redwood Middle
River Middle	Silverado Middle

Valley Oak High

Napa Valley Adult

Napa Valley Independent Studies

New Technology High