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	2432078	2400	-	2436	=	-36	*	(16	/	253)	=	-2.27667982
4	2432081	2397	-	2485	=	-88	*	(17	/	253)	=	-5.9130434
5	2432082	2440	-	2528	=	-88	*	(21	/	253)	=	-7.30434778
6	2432085	2463	-	2552	=	-89	*	(34	/	253)	=	-11.96047424
7	2432086	2449	-	2567	=	-118	*	(45	/	253)	=	-20.98814222
8	2432089	2493	-	2586	=	-93	*	(51	/	253)	=	-18.74703551
11	2432090	2454	-	2628	=	-174	*	(69	/	253)	=	-47.45454533
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for New Jerusalem Elementary											-115

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	74204	2363	-	2436	=	-73	*	(76	/	697)	=	-7.9598278
4	74206	2392	-	2485	=	-93	*	(85	/	697)	=	-11.34146337
5	74208	2446	-	2528	=	-82	*	(83	/	697)	=	-9.76470588
6	74209	2465	-	2552	=	-87	*	(71	/	697)	=	-8.86226683
7	74211	2484	-	2567	=	-83	*	(96	/	697)	=	-11.43185079
8	74214	2497	-	2586	=	-89	*	(92	/	697)	=	-11.74748923
11	74216	2495	-	2628	=	-133	*	(194	/	697)	=	-37.01865129
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for New Jerusalem Elementary											-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	76190	2359	-	2436	=	-77	*	(58	/	640)	=	-6.978125
4	76193	2407	-	2485	=	-78	*	(82	/	640)	=	-9.99375
5	76194	2432	-	2528	=	-96	*	(92	/	640)	=	-13.8
6	76196	2459	-	2552	=	-93	*	(85	/	640)	=	-12.3515625
7	76198	2497	-	2567	=	-70	*	(92	/	640)	=	-10.0625
8	76200	2487	-	2586	=	-99	*	(93	/	640)	=	-14.3859375
11	76202	2493	-	2628	=	-135	*	(138	/	640)	=	-29.109375
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for New Jerusalem Elementary											-97

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	76382	2370	-	2436	=	-66	*	(107	/	910)	=	-7.76043952
4	76384	2407	-	2485	=	-78	*	(96	/	910)	=	-8.22857139
5	76386	2418	-	2528	=	-110	*	(121	/	910)	=	-14.62637352
6	76388	2443	-	2552	=	-109	*	(134	/	910)	=	-16.05054942
7	76390	2494	-	2567	=	-73	*	(130	/	910)	=	-10.42857137
8	76392	2487	-	2586	=	-99	*	(144	/	910)	=	-15.66593404
11	76394	2484	-	2628	=	-144	*	(178	/	910)	=	-28.16703288
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for New Jerusalem Elementary											-101

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	76907	2395	-	2436	=	-41	*	(102	/	921)	=	-4.54071659
4	76908	2418	-	2485	=	-67	*	(102	/	921)	=	-7.4201954
5	76909	2441	-	2528	=	-87	*	(95	/	921)	=	-8.97394134
6	76910	2452	-	2552	=	-100	*	(139	/	921)	=	-15.0922909
7	76911	2494	-	2567	=	-73	*	(150	/	921)	=	-11.88925078
8	76912	2513	-	2586	=	-73	*	(140	/	921)	=	-11.09663408
11	76913	2478	-	2628	=	-150	*	(193	/	921)	=	-31.43322465
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for New Jerusalem Elementary											-90

2015	2016	2017	2018	2019	Sum	Average
-115	-98	-97	-101	-90	-501.0	-100.2

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

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

New Jerusalem Elementary math proficiency

Zero+ meets standard.

New Jerusalem Elementary

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
New Jerusalem Elementary School District	3,783	4,242	4,588	4,522	4,831	5,446	6,502	6,670
Elementary School (Public)
Acacia Elementary Charter	276	421	329
Delta Bridges Charter		131	166	244	248	254	242	248
New Jerusalem	222	218	209	218	248	234	237	219
New Jerusalem Elementary	25	28	29	22	22	26	19	24
Intermediate/Middle Schools (Public)
Acacia Middle Charter	74	127	148
K-12 Schools (Public)
California Virtual Academy @ San Joaquin	1,559	1,428	1,375	1,340	1,433	1,595	2,559	2,814
Delta Charter	512	516	533	649	696	739	828	862
Delta Charter Online				116	113	148	216	215
Delta Home Charter	194	111	89	115	207	234	267	297
Delta Keys Charter	100	159	157	105	63	201	228	191	164
Delta Launch Charter			13	11
Humphreys College Academy of Business, Law and Education	239	375	669	768	814	1,039	1,033	1,016
Insight @ San Joaquin		34	156	230	257	327	305	202
New Jerusalem Online	283	334	300	153	33
Renew Virtual Academy K12 #1	88
Valley View Charter Prep	211	360	415	488	559	622	605	609