SCHOOLIO: Districts

Trona Joint Unified school district (Data source)

County of San Bernardino

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	2063786	2405	-	2436	=	-31	*	(22	/	128)	=	-5.328125
4	2063789	2473	-	2485	=	-12	*	(21	/	128)	=	-1.96875
5	2063790	2444	-	2528	=	-84	*	(17	/	128)	=	-11.15625
6	2063793	2484	-	2552	=	-68	*	(14	/	128)	=	-7.4375
7	2063794	2510	-	2567	=	-57	*	(24	/	128)	=	-10.6875
8	2063797	2460	-	2586	=	-126	*	(14	/	128)	=	-13.78125
11	2063798	2525	-	2628	=	-103	*	(16	/	128)	=	-12.875
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Trona Joint Unified											-63

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	63412	2390	-	2436	=	-46	*	(22	/	146)	=	-6.93150683
4	63414	2471	-	2485	=	-14	*	(24	/	146)	=	-2.30136985
5	63417	2500	-	2528	=	-28	*	(23	/	146)	=	-4.41095889
6	63418	2479	-	2552	=	-73	*	(19	/	146)	=	-9.49999998
7	63420	2473	-	2567	=	-94	*	(18	/	146)	=	-11.58904107
8	63423	2490	-	2586	=	-96	*	(21	/	146)	=	-13.80821914
11	63424	2527	-	2628	=	-101	*	(19	/	146)	=	-13.14383559
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Trona Joint Unified											-62

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	65190	2389	-	2436	=	-47	*	(20	/	142)	=	-6.61971829
4	65193	2436	-	2485	=	-49	*	(23	/	142)	=	-7.93661967
5	65194	2487	-	2528	=	-41	*	(21	/	142)	=	-6.06338024
6	65196	2516	-	2552	=	-36	*	(25	/	142)	=	-6.33802817
7	65199	2446	-	2567	=	-121	*	(20	/	142)	=	-17.04225347
8	65201	2486	-	2586	=	-100	*	(17	/	142)	=	-11.9718309
11	65202	2512	-	2628	=	-116	*	(16	/	142)	=	-13.0704225
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Trona Joint Unified											-69

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	65277	2421	-	2436	=	-15	*	(15	/	131)	=	-1.71755724
4	65279	2430	-	2485	=	-55	*	(20	/	131)	=	-8.39694653
5	65281	2458	-	2528	=	-70	*	(22	/	131)	=	-11.75572517
6	65283	2525	-	2552	=	-27	*	(21	/	131)	=	-4.32824426
7	65285	2511	-	2567	=	-56	*	(23	/	131)	=	-9.83206106
8	65287	2453	-	2586	=	-133	*	(18	/	131)	=	-18.27480914
11	65289	2487	-	2628	=	-141	*	(12	/	131)	=	-12.91603047
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Trona Joint Unified											-67

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	65649	2402	-	2436	=	-34	*	(23	/	133)	=	-5.87969922
4	65650	2465	-	2485	=	-20	*	(15	/	133)	=	-2.25563908
5	65651	2502	-	2528	=	-26	*	(19	/	133)	=	-3.71428569
6	65652	2521	-	2552	=	-31	*	(15	/	133)	=	-3.49624057
7	65653	2519	-	2567	=	-48	*	(25	/	133)	=	-9.02255635
8	65654	2508	-	2586	=	-78	*	(20	/	133)	=	-11.72932324
11	65655	2523	-	2628	=	-105	*	(16	/	133)	=	-12.63157886
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Trona Joint Unified											-49

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-63	-62	-69	-67	-49	-310.0	-62.0

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

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.

Trona Joint Unified math proficiency

Zero+ meets standard.

Schools in Trona Joint Unified

Elementary School (Public) (1)

Trona Elementary

High Schools (Public) (1)

Trona High

Schools in Trona Joint Unified

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Trona Joint Unified School District	250	255	949	1,206	2,746	264	259	273
Elementary School (Public)
Trona Elementary	140	150	153	140	157	136	132	145
High Schools (Public)
Trona High	110	105	117	121	133	128	127	128
K-12 Schools (Public)
California STEAM San Bernardino			679	945	2,412
University Prep - San Bernardino					44

Trona Joint Unified school district (Data source)

County of San Bernardino

THIS chart shows what the school system "wants"

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

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

Schools in Trona Joint Unified

Elementary School (Public) (1)

High Schools (Public) (1)

Schools in Trona Joint Unified

Enrollment by school type, school and year

Elementary School (Public)

High Schools (Public)

K-12 Schools (Public)