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	1396421	2444	-	2436	=	8	*	(19	/	93)	=	1.6344086
4	1396422	2502	-	2485	=	17	*	(13	/	93)	=	2.37634408
5	1396425	2535	-	2528	=	7	*	(18	/	93)	=	1.35483871
6	1396426	2535	-	2552	=	-17	*	(11	/	93)	=	-2.01075267
7	1396429	2620	-	2567	=	53	*	(13	/	93)	=	7.40860214
8	1396430	2600	-	2586	=	14	*	(19	/	93)	=	2.86021505
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Clear Creek Elementary											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	44024	2455	-	2436	=	19	*	(18	/	98)	=	3.48979591
4	44027	2506	-	2485	=	21	*	(22	/	98)	=	4.7142857
5	44029	2578	-	2528	=	50	*	(15	/	98)	=	7.6530612
6	44030	2584	-	2552	=	32	*	(18	/	98)	=	5.87755101
7	44033	2615	-	2567	=	48	*	(12	/	98)	=	5.87755099
8	44034	2654	-	2586	=	68	*	(13	/	98)	=	9.02040815
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Clear Creek Elementary											37

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	45094	2464	-	2436	=	28	*	(17	/	102)	=	4.66666665
4	45096	2536	-	2485	=	51	*	(21	/	102)	=	10.49999995
5	45097	2553	-	2528	=	25	*	(22	/	102)	=	5.39215685
6	45099	2615	-	2552	=	63	*	(14	/	102)	=	8.64705876
7	45102	2617	-	2567	=	50	*	(18	/	102)	=	8.8235294
8	45104	0	-	2586	=		*	(0	/	102)	=
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Clear Creek Elementary											38

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	45109	2471	-	2436	=	35	*	(16	/	118)	=	4.7457627
4	45110	2462	-	2485	=	-23	*	(20	/	118)	=	-3.89830508
5	45113	2561	-	2528	=	33	*	(26	/	118)	=	7.27118644
6	45114	2555	-	2552	=	3	*	(25	/	118)	=	0.63559322
7	45117	2558	-	2567	=	-9	*	(13	/	118)	=	-0.99152542
8	45118	2606	-	2586	=	20	*	(18	/	118)	=	3.05084744
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Clear Creek Elementary											11

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	45241	2473	-	2436	=	37	*	(14	/	116)	=	4.46551724
4	45242	2476	-	2485	=	-9	*	(18	/	116)	=	-1.39655172
5	45243	2503	-	2528	=	-25	*	(20	/	116)	=	-4.31034483
6	45244	2572	-	2552	=	20	*	(27	/	116)	=	4.6551724
7	45245	2561	-	2567	=	-6	*	(22	/	116)	=	-1.13793103
8	45246	2585	-	2586	=	-1	*	(15	/	116)	=	-0.12931034
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Clear Creek Elementary											2

2015	2016	2017	2018	2019	Sum	Average
14	37	38	11	2	102.0	20.4

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

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

Clear Creek Elementary math proficiency

Zero+ meets standard.

Clear Creek Elementary

Enrollment by school type, school and year

	2015	2016	2017	2018	2019	2020	2021	2022
Clear Creek Elementary School District	149	144	144	161	157	181	162	149
Elementary School in 1 School District (Public)
Clear Creek Elementary	149	144	144	161	157	181	162	149