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	1101009	2433	-	2436	=	-3	*	(264	/	1785)	=	-0.44369748
4	1101012	2476	-	2485	=	-9	*	(275	/	1785)	=	-1.38655462
5	1101013	2498	-	2528	=	-30	*	(322	/	1785)	=	-5.41176468
6	1101016	2534	-	2552	=	-18	*	(335	/	1785)	=	-3.37815126
7	1101017	2568	-	2567	=	1	*	(307	/	1785)	=	0.1719888
8	1101020	2593	-	2586	=	7	*	(282	/	1785)	=	1.10588235
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Rosemead Elementary											-9

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	34443	2438	-	2436	=	2	*	(270	/	1800)	=	0.3
4	34446	2483	-	2485	=	-2	*	(275	/	1800)	=	-0.30555555
5	34448	2524	-	2528	=	-4	*	(277	/	1800)	=	-0.61555555
6	34449	2541	-	2552	=	-11	*	(327	/	1800)	=	-1.99833333
7	34452	2573	-	2567	=	6	*	(333	/	1800)	=	1.11
8	34454	2598	-	2586	=	12	*	(318	/	1800)	=	2.11999999
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Rosemead Elementary											1

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	35056	2454	-	2436	=	18	*	(255	/	1751)	=	2.62135921
4	35058	2496	-	2485	=	11	*	(274	/	1751)	=	1.72130211
5	35059	2509	-	2528	=	-19	*	(278	/	1751)	=	-3.01656196
6	35062	2565	-	2552	=	13	*	(288	/	1751)	=	2.13820673
7	35063	2559	-	2567	=	-8	*	(327	/	1751)	=	-1.49400342
8	35066	2599	-	2586	=	13	*	(329	/	1751)	=	2.44260422
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Rosemead Elementary											4

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	35066	2446	-	2436	=	10	*	(250	/	1658)	=	1.50784077
4	35068	2508	-	2485	=	23	*	(262	/	1658)	=	3.63449938
5	35070	2531	-	2528	=	3	*	(269	/	1658)	=	0.486731
6	35072	2557	-	2552	=	5	*	(271	/	1658)	=	0.8172497
7	35073	2590	-	2567	=	23	*	(280	/	1658)	=	3.88419782
8	35076	2589	-	2586	=	3	*	(326	/	1658)	=	0.58986731
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Rosemead Elementary											11

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	35243	2458	-	2436	=	22	*	(249	/	1619)	=	3.3835701
4	35244	2500	-	2485	=	15	*	(259	/	1619)	=	2.3996294
5	35245	2544	-	2528	=	16	*	(275	/	1619)	=	2.71772698
6	35246	2563	-	2552	=	11	*	(270	/	1619)	=	1.83446571
7	35247	2585	-	2567	=	18	*	(285	/	1619)	=	3.1686226
8	35248	2608	-	2586	=	22	*	(281	/	1619)	=	3.81840642
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Rosemead Elementary											17

2015	2016	2017	2018	2019	Sum	Average
-9	1	4	11	17	24.0	4.8

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

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

Rosemead Elementary math proficiency

Zero+ meets standard.

Emma W. Shuey Elementary	Encinita Elementary	Mildred B. Janson Elementary
Savannah Elementary

Muscatel Middle

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Rosemead Elementary School District	2,668	2,611	2,511	2,438	2,418	2,394	2,341	2,302
Elementary School (Public)
Emma W. Shuey Elementary	532	516	498	477	491	486	460	514
Encinita Elementary	403	388	350	347	345	336	327	338
Mildred B. Janson Elementary	616	601	567	580	593	603	580	514
Savannah Elementary	522	452	436	413	419	413	405	381
Intermediate/Middle Schools (Public)
Muscatel Middle	595	654	660	621	570	556	569	555