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	102711	2508	-	2436	=	72	*	(194	/	1428)	=	9.78151255
4	102712	2539	-	2485	=	54	*	(205	/	1428)	=	7.75210079
5	102715	2602	-	2528	=	74	*	(233	/	1428)	=	12.07422968
6	102716	2625	-	2552	=	73	*	(225	/	1428)	=	11.50210083
7	102719	2630	-	2567	=	63	*	(192	/	1428)	=	8.4705882
8	102720	2663	-	2586	=	77	*	(208	/	1428)	=	11.21568625
11	102723	2695	-	2628	=	67	*	(171	/	1428)	=	8.02310923
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Piedmont City Unified											69

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	2889	2527	-	2436	=	91	*	(217	/	1505)	=	13.12093019
4	2892	2563	-	2485	=	78	*	(197	/	1505)	=	10.2099667
5	2893	2595	-	2528	=	67	*	(214	/	1505)	=	9.5269103
6	2895	2631	-	2552	=	79	*	(244	/	1505)	=	12.80797336
7	2898	2658	-	2567	=	91	*	(228	/	1505)	=	13.78604646
8	2900	2656	-	2586	=	70	*	(193	/	1505)	=	8.97674414
11	2901	2700	-	2628	=	72	*	(212	/	1505)	=	10.14219266
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Piedmont City Unified											79

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	2963	2523	-	2436	=	87	*	(181	/	1484)	=	10.6111859
4	2965	2565	-	2485	=	80	*	(222	/	1484)	=	11.96765496
5	2967	2598	-	2528	=	70	*	(204	/	1484)	=	9.62264149
6	2969	2617	-	2552	=	65	*	(202	/	1484)	=	8.84770887
7	2971	2664	-	2567	=	97	*	(245	/	1484)	=	16.01415088
8	2974	2670	-	2586	=	84	*	(237	/	1484)	=	13.41509434
11	2975	2679	-	2628	=	51	*	(193	/	1484)	=	6.63274931
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Piedmont City Unified											77

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	2965	2524	-	2436	=	88	*	(159	/	1437)	=	9.73695193
4	2967	2574	-	2485	=	89	*	(184	/	1437)	=	11.39596379
5	2969	2605	-	2528	=	77	*	(222	/	1437)	=	11.89561581
6	2971	2624	-	2552	=	72	*	(208	/	1437)	=	10.42171186
7	2973	2652	-	2567	=	85	*	(212	/	1437)	=	12.54001388
8	2975	2683	-	2586	=	97	*	(242	/	1437)	=	16.33542099
11	2977	2683	-	2628	=	55	*	(210	/	1437)	=	8.03757829
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Piedmont City Unified											80

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	2993	2530	-	2436	=	94	*	(157	/	1348)	=	10.94807115
4	2994	2564	-	2485	=	79	*	(163	/	1348)	=	9.5526706
5	2995	2607	-	2528	=	79	*	(187	/	1348)	=	10.95919877
6	2996	2633	-	2552	=	81	*	(230	/	1348)	=	13.82047475
7	2997	2651	-	2567	=	84	*	(209	/	1348)	=	13.02373884
8	2998	2676	-	2586	=	90	*	(208	/	1348)	=	13.8872403
11	2999	2701	-	2628	=	73	*	(194	/	1348)	=	10.50593465
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Piedmont City Unified											83

2015	2016	2017	2018	2019	Sum	Average
69	79	77	80	83	388.0	77.6

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

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

Piedmont City Unified math proficiency

Zero+ meets standard.

Beach Elementary

Havens Elementary

Wildwood Elementary

Piedmont High

Piedmont Middle

Millennium High Alternative

Piedmont Adult Education

Piedmont Preschool

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Piedmont City Unified School District	2,699	2,695	2,685	2,614	2,582	2,559	2,454	2,340
Elementary School (Public)
Beach Elementary	362	335	313	298	276	266	264	264
Havens Elementary	533	497	493	476	439	466	444	432
Wildwood Elementary	298	312	302	302	296	281	264	261
High Schools (Public)
Piedmont High	784	800	811	813	855	831	839	814
Intermediate/Middle Schools (Public)
Piedmont Middle	645	681	698	665	651	649	586	512
Continuation High Schools
Millennium High Alternative	77	70	68	60	65	66	57	57