SCHOOLIO: Districts

San Francisco Unified school district (Data source)

County of San Francisco

2015

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	2352828	2441	-	2436	=	5	*	(4325	/	26277)	=	0.82296305
4	2352831	2476	-	2485	=	-9	*	(4306	/	26277)	=	-1.47482589
5	2352832	2511	-	2528	=	-17	*	(4117	/	26277)	=	-2.663508
6	2352835	2525	-	2552	=	-27	*	(3383	/	26277)	=	-3.47608174
7	2352836	2548	-	2567	=	-19	*	(3357	/	26277)	=	-2.42733187
8	2352839	2564	-	2586	=	-22	*	(3378	/	26277)	=	-2.82817671
11	2352840	2611	-	2628	=	-17	*	(3411	/	26277)	=	-2.20675875
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for San Francisco Unified											-14

2016

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	71898	2441	-	2436	=	5	*	(4335	/	26466)	=	0.81897529
4	71900	2478	-	2485	=	-7	*	(4246	/	26466)	=	-1.12302576
5	71901	2507	-	2528	=	-21	*	(4076	/	26466)	=	-3.23418726
6	71903	2525	-	2552	=	-27	*	(3620	/	26466)	=	-3.6930401
7	71906	2556	-	2567	=	-11	*	(3430	/	26466)	=	-1.42560265
8	71907	2571	-	2586	=	-15	*	(3359	/	26466)	=	-1.90376331
11	71910	2617	-	2628	=	-11	*	(3400	/	26466)	=	-1.41313383
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for San Francisco Unified											-12

2017

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	73857	2452	-	2436	=	16	*	(4093	/	26384)	=	2.48211037
4	73860	2479	-	2485	=	-6	*	(4171	/	26384)	=	-0.94852941
5	73862	2506	-	2528	=	-22	*	(4052	/	26384)	=	-3.37871437
6	73863	2519	-	2552	=	-33	*	(3594	/	26384)	=	-4.49522436
7	73866	2557	-	2567	=	-10	*	(3604	/	26384)	=	-1.36597938
8	73867	2577	-	2586	=	-9	*	(3416	/	26384)	=	-1.16525166
11	73870	2623	-	2628	=	-5	*	(3454	/	26384)	=	-0.65456337
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for San Francisco Unified											-10

2018

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	74028	2446	-	2436	=	10	*	(4009	/	26141)	=	1.53360621
4	74029	2485	-	2485	=	0	*	(4070	/	26141)	=	0.0
5	74032	2507	-	2528	=	-21	*	(4040	/	26141)	=	-3.24547644
6	74033	2524	-	2552	=	-28	*	(3443	/	26141)	=	-3.68784665
7	74036	2552	-	2567	=	-15	*	(3559	/	26141)	=	-2.04219425
8	74037	2578	-	2586	=	-8	*	(3582	/	26141)	=	-1.09620902
11	74040	2611	-	2628	=	-17	*	(3438	/	26141)	=	-2.23579816
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for San Francisco Unified											-11

2019

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	74553	2449	-	2436	=	13	*	(4068	/	25913)	=	2.04082892
4	74554	2482	-	2485	=	-3	*	(4014	/	25913)	=	-0.46470883
5	74555	2516	-	2528	=	-12	*	(3950	/	25913)	=	-1.82919769
6	74556	2517	-	2552	=	-35	*	(3472	/	25913)	=	-4.68953804
7	74557	2559	-	2567	=	-8	*	(3465	/	25913)	=	-1.06973334
8	74558	2572	-	2586	=	-14	*	(3545	/	25913)	=	-1.91525488
11	74559	2610	-	2628	=	-18	*	(3399	/	25913)	=	-2.36105429
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for San Francisco Unified											-10

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-14	-12	-10	-11	-10	-57.0	-11.4

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

For the lines, you have the data necessary to plot the chart.

THIS chart shows what the school system "wants"

NOT what school board members want.

NOT what superintendents want.

More about this chart.

Students would perform better the more years in school IF the follow-the-schedule method wanted that.

But that's not what it "wants"...and it's not a coincidence this pattern repeats (repeatedly).

The system (the follow-the-schedule method) "wants" schools to perform poorer, relative to grade level, the more years students spend in public school.

• Any result above zero is proficient; below is not proficient.

San Francisco Unified math proficiency

Zero+ meets standard.

Schools in San Francisco Unified

Elementary School (Public) (72)

Alamo Elementary	Alvarado Elementary	Argonne Elementary
Bryant Elementary	Buena Vista/ Horace Mann K-8	Carmichael (Bessie)/FEC
Carver (George Washington) Elementary	Chavez (Cesar) Elementary	Chin (John Yehall) Elementary
Chinese Immersion School at DeAvila	Clarendon Alternative Elementary	Cleveland Elementary
Cobb (William L.) Elementary	Drew (Charles) College Preparatory Academy	El Dorado Elementary
Feinstein (Dianne) Elementary	Flynn (Leonard R.) Elementary	Garfield Elementary
Glen Park Elementary	Grattan Elementary	Guadalupe Elementary
Harte (Bret) Elementary	Hillcrest Elementary	Huerta (Dolores) Elementary
Jefferson Elementary	Key (Francis Scott) Elementary	King (Thomas Starr) Elementary
Lafayette Elementary	Lakeshore Alternative Elementary	Lau (Gordon J.) Elementary
Lawton Alternative Elementary	Lee (Edwin and Anita) Newcomer	Lilienthal (Claire) Elementary
Longfellow Elementary	Malcolm X Academy	Marshall Elementary
McCoppin (Frank) Elementary	McKinley Elementary	Milk (Harvey) Civil Rights Elementary
Miraloma Elementary	Mission Education Center	Monroe Elementary
Moscone (George R.) Elementary	Muir (John) Elementary	New Traditions Elementary
Ortega (Jose) Elementary	Parker (Jean) Elementary	Parks (Rosa) Elementary
Peabody (George) Elementary	Redding Elementary	Revere (Paul) Elementary
Rooftop Elementary	San Francisco Community Alternative	San Francisco Public Montessori
Sanchez Elementary	Serra (Junipero) Elementary	Sheridan Elementary
Sherman Elementary	Sloat (Commodore) Elementary	Spring Valley Elementary
Stevenson (Robert Louis) Elementary	Sunnyside Elementary	Sunset Elementary
Sutro Elementary	Taylor (Edward R.) Elementary	Tenderloin Community
Ulloa Elementary	Visitacion Valley Elementary	Webster (Daniel) Elementary
West Portal Elementary	Yick Wo Elementary	Yu (Alice Fong) Elementary

High Schools (Public) (10)

Balboa High	Burton (Phillip and Sala) Academic High	Galileo High
Lincoln (Abraham) High	Lowell High	Marshall (Thurgood) High
Mission High	O'Connell (John) High	Wallenberg (Raoul) Traditional High
Washington (George) High

Intermediate/Middle Schools (Public) (13)

Aptos Middle	Brown Jr. (Willie L) Middle	Denman (James) Middle
Everett Middle	Francisco Middle	Giannini (A.P.) Middle
Hoover (Herbert) Middle	King Jr. (Martin Luther) Academic Middle	Lick (James) Middle
Marina Middle	Presidio Middle	Roosevelt Middle
Visitacion Valley Middle

Continuation High Schools (2)

Downtown High

Wells (Ida B.) High

Alternative Schools of Choice (5)

Academy (The)- SF @McAteer	Asawa (Ruth) SF Sch of the Arts, A Public School	Independence High
Jordan (June) School for Equity	S.F. International High

Preschool (11)

Cooper (Sarah B.) Children Center	Havard (Leola M.) Early Education	Las Americas Children Center
Mahler (Theresa S.) Children Center	McLaren (John) Children Centers	Noriega Children Center
Presidio Early Ed.	San Miguel Children Center	Stockton (Commodore) Children Center
Tule Elk Park Children Center	Weill (Raphael) Children Center