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	15483	2454	-	2436	=	18	*	(723	/	4660)	=	2.79270385
4	15486	2496	-	2485	=	11	*	(665	/	4660)	=	1.56974248
5	15487	2533	-	2528	=	5	*	(700	/	4660)	=	0.75107296
6	15490	2543	-	2552	=	-9	*	(697	/	4660)	=	-1.34613734
7	15491	2556	-	2567	=	-11	*	(649	/	4660)	=	-1.53197425
8	15494	2590	-	2586	=	4	*	(613	/	4660)	=	0.52618026
11	15495	2597	-	2628	=	-31	*	(613	/	4660)	=	-4.07789698
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Berkeley Unified											-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	422	2470	-	2436	=	34	*	(698	/	4661)	=	5.09161121
4	424	2496	-	2485	=	11	*	(711	/	4661)	=	1.67796609
5	425	2535	-	2528	=	7	*	(677	/	4661)	=	1.0167346
6	428	2569	-	2552	=	17	*	(656	/	4661)	=	2.39261959
7	429	2568	-	2567	=	1	*	(672	/	4661)	=	0.14417507
8	431	2579	-	2586	=	-7	*	(607	/	4661)	=	-0.91160695
11	433	2615	-	2628	=	-13	*	(640	/	4661)	=	-1.78502467
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Berkeley Unified											8

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	440	2464	-	2436	=	28	*	(736	/	4693)	=	4.39122096
4	442	2498	-	2485	=	13	*	(696	/	4693)	=	1.92797783
5	443	2525	-	2528	=	-3	*	(715	/	4693)	=	-0.45706371
6	445	2558	-	2552	=	6	*	(672	/	4693)	=	0.85915193
7	447	2579	-	2567	=	12	*	(646	/	4693)	=	1.65182185
8	450	2598	-	2586	=	12	*	(684	/	4693)	=	1.74898784
11	451	2589	-	2628	=	-39	*	(544	/	4693)	=	-4.5207756
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Berkeley Unified											6

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	463	2474	-	2436	=	38	*	(700	/	4777)	=	5.56834832
4	465	2495	-	2485	=	10	*	(746	/	4777)	=	1.56164957
5	467	2533	-	2528	=	5	*	(704	/	4777)	=	0.73686414
6	469	2562	-	2552	=	10	*	(716	/	4777)	=	1.49884864
7	471	2583	-	2567	=	16	*	(677	/	4777)	=	2.26753192
8	473	2611	-	2586	=	25	*	(661	/	4777)	=	3.45928405
11	475	2621	-	2628	=	-7	*	(573	/	4777)	=	-0.83964831
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Berkeley Unified											14

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	497	2469	-	2436	=	33	*	(689	/	4532)	=	5.01699026
4	498	2513	-	2485	=	28	*	(693	/	4532)	=	4.28155339
5	499	2534	-	2528	=	6	*	(725	/	4532)	=	0.95984113
6	500	2561	-	2552	=	9	*	(687	/	4532)	=	1.36429832
7	501	2597	-	2567	=	30	*	(698	/	4532)	=	4.62047661
8	502	2612	-	2586	=	26	*	(659	/	4532)	=	3.78067076
11	503	2627	-	2628	=	-1	*	(381	/	4532)	=	-0.08406884
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Berkeley Unified											20

2015	2016	2017	2018	2019	Sum	Average
-1	8	6	14	20	47.0	9.4

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

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

Berkeley Unified math proficiency

Zero+ meets standard.

Berkeley Arts Magnet at Whittier	Cragmont Elementary	Emerson Elementary
Jefferson Elementary	John Muir Elementary	Malcolm X Elementary
Oxford Elementary	Rosa Parks Environmental Science	Sylvia Mendez Elementary
Thousand Oaks Elementary	Washington Elementary

Berkeley High

Longfellow Arts and Technology Middle

Martin Luther King Middle

Willard Middle

Berkeley Technology Academy

Berkeley Adult

Berkeley Special Education Preschool