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	2255739	2389	-	2436	=	-47	*	(81	/	383)	=	-9.93994775
4	2255742	2456	-	2485	=	-29	*	(74	/	383)	=	-5.60313315
5	2255743	2438	-	2528	=	-90	*	(63	/	383)	=	-14.80417749
6	2255746	2464	-	2552	=	-88	*	(49	/	383)	=	-11.25848557
7	2255747	2471	-	2567	=	-96	*	(67	/	383)	=	-16.7937336
8	2255750	2500	-	2586	=	-86	*	(49	/	383)	=	-11.0026109
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Logan K-8											-69

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	69215	2434	-	2436	=	-2	*	(76	/	375)	=	-0.40533333
4	69218	2431	-	2485	=	-54	*	(71	/	375)	=	-10.22399998
5	69219	2480	-	2528	=	-48	*	(71	/	375)	=	-9.08799998
6	69221	2435	-	2552	=	-117	*	(55	/	375)	=	-17.15999992
7	69224	2484	-	2567	=	-83	*	(45	/	375)	=	-9.96
8	69226	2522	-	2586	=	-64	*	(57	/	375)	=	-9.728
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Logan K-8											-57

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	71049	2411	-	2436	=	-25	*	(55	/	340)	=	-4.04411763
4	71051	2469	-	2485	=	-16	*	(67	/	340)	=	-3.15294117
5	71052	2471	-	2528	=	-57	*	(66	/	340)	=	-11.06470588
6	71054	2488	-	2552	=	-64	*	(65	/	340)	=	-12.23529408
7	71056	2459	-	2567	=	-108	*	(45	/	340)	=	-14.29411763
8	71059	2485	-	2586	=	-101	*	(42	/	340)	=	-12.47647051
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Logan K-8											-57

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	71194	2395	-	2436	=	-41	*	(67	/	316)	=	-8.69303796
4	71196	2470	-	2485	=	-15	*	(49	/	316)	=	-2.32594937
5	71197	2506	-	2528	=	-22	*	(56	/	316)	=	-3.89873416
6	71200	2465	-	2552	=	-87	*	(50	/	316)	=	-13.76582278
7	71201	2490	-	2567	=	-77	*	(56	/	316)	=	-13.64556955
8	71204	2480	-	2586	=	-106	*	(38	/	316)	=	-12.74683538
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Logan K-8											-55

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	71684	2427	-	2436	=	-9	*	(47	/	289)	=	-1.46366781
4	71685	2446	-	2485	=	-39	*	(66	/	289)	=	-8.90657438
5	71686	2516	-	2528	=	-12	*	(41	/	289)	=	-1.70242214
6	71687	2499	-	2552	=	-53	*	(52	/	289)	=	-9.53633214
7	71688	2489	-	2567	=	-78	*	(41	/	289)	=	-11.06574394
8	71689	2522	-	2586	=	-64	*	(42	/	289)	=	-9.30103802
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Logan K-8											-42

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-69	-57	-57	-55	-42	-280.0	-56.0

Compute the Upper Control Limit

Simply compute the standard deviation and multiply by 3 and add to the average: -29.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.

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	91%	96%	98%	98%	97%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file