SCHOOLIO: Schools

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	877319	2425	-	2436	=	-11	*	(172	/	644)	=	-2.9378882
4	877322	2456	-	2485	=	-29	*	(220	/	644)	=	-9.90683227
5	877323	2478	-	2528	=	-50	*	(252	/	644)	=	-19.56521735
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Brentwood Science											-32

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	27755	2408	-	2436	=	-28	*	(176	/	576)	=	-8.55555554
4	27756	2463	-	2485	=	-22	*	(183	/	576)	=	-6.98958333
5	27758	2497	-	2528	=	-31	*	(217	/	576)	=	-11.67881944
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Brentwood Science											-27

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	28326	2419	-	2436	=	-17	*	(153	/	514)	=	-5.06031127
4	28327	2440	-	2485	=	-45	*	(173	/	514)	=	-15.14591438
5	28329	2488	-	2528	=	-40	*	(188	/	514)	=	-14.63035016
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Brentwood Science											-35

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	28377	2397	-	2436	=	-39	*	(127	/	438)	=	-11.30821914
4	28379	2450	-	2485	=	-35	*	(145	/	438)	=	-11.58675798
5	28381	2458	-	2528	=	-70	*	(166	/	438)	=	-26.52968031
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Brentwood Science											-49

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	28556	2413	-	2436	=	-23	*	(80	/	321)	=	-5.73208721
4	28557	2466	-	2485	=	-19	*	(114	/	321)	=	-6.74766353
5	28558	2487	-	2528	=	-41	*	(127	/	321)	=	-16.22118379
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Brentwood Science											-29

2015	2016	2017	2018	2019	Sum	Average
-32	-27	-35	-49	-29	-172.0	-34.4

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

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

	2015	2016	2017	2018	2019
Percent	73%	80%	84%	80%	84%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file

NOT what teachers want.

NOT what principals want.

NOT what parents want.

Arroyo Seco Museum Science	Balboa Gifted/High Ability Magnet Elementary	Brentwood Science
City of Angels	Crescent Heights Boulevard Elementary	Downtown Business High
Francisco Bravo Medical Magnet High	King/Drew Medical Magnet High	Lake Balboa College Preparatory Magnet K-12
Lomita Math/Science/Technology Magnet	Los Angeles Center for Enriched Studies	Mid-City's Prescott School of Enriched Sciences
Orthopaedic Hospital	Paseo del Rey Fundamental	Sherman Oaks Center for Enriched Studies
South Shores/CSUDH Visual and Performing Arts	Thirty-Second Street USC Performing Arts	Thomas Riley High
Tom Bradley Global Awareness Magnet	Vintage Math/Science/Technology Magnet	Westside Global Awareness Magnet
Windsor Hills Math Science	Youth Opportunities Unlimited