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
6	1378906	0	-	2552	=		*	(0	/	20)	=
7	1378907	0	-	2567	=		*	(2	/	20)	=
8	1378910	0	-	2586	=		*	(5	/	20)	=
11	1378911	2401	-	2628	=	-227	*	(13	/	20)	=	-147.55
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Napa County Office of Education											-148

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
7	43429	2352	-	2567	=	-215	*	(11	/	53)	=	-44.62264134
8	43431	2413	-	2586	=	-173	*	(14	/	53)	=	-45.69811314
11	43432	2425	-	2628	=	-203	*	(28	/	53)	=	-107.24528286
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Napa County Office of Education											-198

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
7	44494	0	-	2567	=		*	(0	/	59)	=
8	44495	2370	-	2586	=	-216	*	(16	/	59)	=	-58.57627104
11	44497	2427	-	2628	=	-201	*	(38	/	59)	=	-129.457627
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Napa County Office of Education											-188

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
6	44504	0	-	2552	=		*	(0	/	44)	=
7	44507	0	-	2567	=		*	(0	/	44)	=
8	44508	2371	-	2586	=	-215	*	(13	/	44)	=	-63.52272718
11	44511	2387	-	2628	=	-241	*	(26	/	44)	=	-142.40909069
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Napa County Office of Education											-206

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
6	44646	0	-	2552	=		*	(0	/	52)	=
7	44647	0	-	2567	=		*	(7	/	52)	=
8	44648	2392	-	2586	=	-194	*	(16	/	52)	=	-59.69230756
11	44649	2403	-	2628	=	-225	*	(28	/	52)	=	-121.15384605
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Napa County Office of Education											-181

2015	2016	2017	2018	2019	Sum	Average
-148	-198	-188	-206	-181	-921.0	-184.2

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

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

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 County Office of Education math proficiency

Zero+ meets standard.

Napa County Community

Napa Preschool Program

Napa County Juvenile Hall/Court

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Napa County Office of Education School District	140	111	136	112	103	108	104	81
County Community
Napa County Community	125	105	123	103	98	99	94	79
Preschool
Napa Preschool Program	0
Juvenile Court Schools
Napa County Juvenile Hall/Court	15	6	13	9	5	9	10	2