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	1994992	2399	-	2436	=	-37	*	(66	/	427)	=	-5.71896953
4	1994993	2442	-	2485	=	-43	*	(61	/	427)	=	-6.14285711
5	1994996	2463	-	2528	=	-65	*	(75	/	427)	=	-11.41686182
6	1994997	2496	-	2552	=	-56	*	(72	/	427)	=	-9.4426229
7	1995000	2523	-	2567	=	-44	*	(70	/	427)	=	-7.21311474
8	1995001	2531	-	2586	=	-55	*	(65	/	427)	=	-8.37236532
11	1995004	2586	-	2628	=	-42	*	(18	/	427)	=	-1.77049177
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Empire Springs Charter											-50

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	61351	2409	-	2436	=	-27	*	(72	/	482)	=	-4.03319501
4	61353	2447	-	2485	=	-38	*	(80	/	482)	=	-6.30705391
5	61355	2464	-	2528	=	-64	*	(75	/	482)	=	-9.95850618
6	61356	2504	-	2552	=	-48	*	(92	/	482)	=	-9.16182571
7	61359	2498	-	2567	=	-69	*	(92	/	482)	=	-13.17012446
8	61360	2565	-	2586	=	-21	*	(47	/	482)	=	-2.04771783
11	61362	2544	-	2628	=	-84	*	(24	/	482)	=	-4.1825726
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Empire Springs Charter											-49

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	63129	2409	-	2436	=	-27	*	(94	/	535)	=	-4.74392522
4	63130	2431	-	2485	=	-54	*	(82	/	535)	=	-8.27663551
5	63133	2463	-	2528	=	-65	*	(81	/	535)	=	-9.84112149
6	63134	2490	-	2552	=	-62	*	(82	/	535)	=	-9.50280374
7	63136	2518	-	2567	=	-49	*	(90	/	535)	=	-8.24299065
8	63138	2516	-	2586	=	-70	*	(75	/	535)	=	-9.81308405
11	63141	2525	-	2628	=	-103	*	(31	/	535)	=	-5.96822428
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Empire Springs Charter											-56

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	63211	2399	-	2436	=	-37	*	(99	/	654)	=	-5.6009174
4	63213	2446	-	2485	=	-39	*	(116	/	654)	=	-6.91743117
5	63215	2458	-	2528	=	-70	*	(102	/	654)	=	-10.91743114
6	63217	2481	-	2552	=	-71	*	(103	/	654)	=	-11.18195713
7	63219	2520	-	2567	=	-47	*	(100	/	654)	=	-7.18654431
8	63221	2507	-	2586	=	-79	*	(104	/	654)	=	-12.56269107
11	63223	2530	-	2628	=	-98	*	(30	/	654)	=	-4.49541278
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Empire Springs Charter											-59

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	63485	2395	-	2436	=	-41	*	(90	/	738)	=	-4.99999998
4	63486	2442	-	2485	=	-43	*	(98	/	738)	=	-5.71002706
5	63487	2453	-	2528	=	-75	*	(127	/	738)	=	-12.906504
6	63488	2483	-	2552	=	-69	*	(123	/	738)	=	-11.49999995
7	63489	2496	-	2567	=	-71	*	(139	/	738)	=	-13.37262869
8	63490	2501	-	2586	=	-85	*	(118	/	738)	=	-13.59078583
11	63491	2532	-	2628	=	-96	*	(43	/	738)	=	-5.59349587
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Empire Springs Charter											-68

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-50	-49	-56	-59	-68	-282.0	-56.4

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

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

Very last step

The percent of students getting a Free or Reduced Price Meal comes from the following sources:

	2015	2016	2017	2018	2019
Percent	35%	29%	40%	43%	48%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file