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	2256290	2434	-	2436	=	-2	*	(113	/	421)	=	-0.5368171
4	2256291	2470	-	2485	=	-15	*	(105	/	421)	=	-3.74109263
5	2256294	2475	-	2528	=	-53	*	(68	/	421)	=	-8.56057007
6	2256295	2540	-	2552	=	-12	*	(51	/	421)	=	-1.4536817
7	2256298	2553	-	2567	=	-14	*	(50	/	421)	=	-1.66270783
8	2256299	2616	-	2586	=	30	*	(34	/	421)	=	2.42280285
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Longfellow K-8											-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	69235	2465	-	2436	=	29	*	(111	/	465)	=	6.92258063
4	69237	2463	-	2485	=	-22	*	(107	/	465)	=	-5.06236557
5	69239	2509	-	2528	=	-19	*	(100	/	465)	=	-4.0860215
6	69242	2556	-	2552	=	4	*	(49	/	465)	=	0.42150538
7	69244	2582	-	2567	=	15	*	(51	/	465)	=	1.64516129
8	69246	2600	-	2586	=	14	*	(47	/	465)	=	1.41505375
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Longfellow K-8											1

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	71068	2471	-	2436	=	35	*	(124	/	477)	=	9.09853249
4	71070	2485	-	2485	=	0	*	(98	/	477)	=	0.0
5	71072	2519	-	2528	=	-9	*	(98	/	477)	=	-1.8490566
6	71074	2557	-	2552	=	5	*	(65	/	477)	=	0.68134172
7	71077	2617	-	2567	=	50	*	(45	/	477)	=	4.7169811
8	71079	2620	-	2586	=	34	*	(47	/	477)	=	3.3501048
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Longfellow K-8											16

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	71213	2494	-	2436	=	58	*	(85	/	435)	=	11.33333328
4	71216	2499	-	2485	=	14	*	(113	/	435)	=	3.6367816
5	71217	2535	-	2528	=	7	*	(91	/	435)	=	1.46436781
6	71220	2562	-	2552	=	10	*	(57	/	435)	=	1.31034482
7	71221	2603	-	2567	=	36	*	(48	/	435)	=	3.97241377
8	71224	2633	-	2586	=	47	*	(41	/	435)	=	4.42988503
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Longfellow K-8											26

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	71704	2490	-	2436	=	54	*	(70	/	403)	=	9.37965258
4	71705	2511	-	2485	=	26	*	(77	/	403)	=	4.96774192
5	71706	2523	-	2528	=	-5	*	(103	/	403)	=	-1.27791563
6	71707	2592	-	2552	=	40	*	(60	/	403)	=	5.95533496
7	71708	2604	-	2567	=	37	*	(53	/	403)	=	4.86600494
8	71709	2625	-	2586	=	39	*	(40	/	403)	=	3.87096774
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Longfellow K-8											28

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-14	1	16	26	28	57.0	11.4

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

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	45%	44%	41%	40%	37%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file