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	921692	2403	-	2436	=	-33	*	(50	/	222)	=	-7.43243243
4	921695	2474	-	2485	=	-11	*	(24	/	222)	=	-1.18918919
5	921696	2473	-	2528	=	-55	*	(26	/	222)	=	-6.44144144
6	921699	2497	-	2552	=	-55	*	(45	/	222)	=	-11.14864861
7	921700	2513	-	2567	=	-54	*	(35	/	222)	=	-8.51351348
8	921703	2543	-	2586	=	-43	*	(42	/	222)	=	-8.13513513
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Laurel Elementary											-43

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	29138	2397	-	2436	=	-39	*	(18	/	211)	=	-3.32701418
4	29140	2466	-	2485	=	-19	*	(47	/	211)	=	-4.23222749
5	29142	2519	-	2528	=	-9	*	(23	/	211)	=	-0.98104265
6	29145	2477	-	2552	=	-75	*	(33	/	211)	=	-11.7298578
7	29146	2505	-	2567	=	-62	*	(52	/	211)	=	-15.27962081
8	29149	2500	-	2586	=	-86	*	(38	/	211)	=	-15.4881516
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Laurel Elementary											-51

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	29704	2358	-	2436	=	-78	*	(19	/	215)	=	-6.89302325
4	29706	2422	-	2485	=	-63	*	(17	/	215)	=	-4.98139532
5	29707	2488	-	2528	=	-40	*	(42	/	215)	=	-7.81395348
6	29710	2464	-	2552	=	-88	*	(46	/	215)	=	-18.82790694
7	29712	2496	-	2567	=	-71	*	(44	/	215)	=	-14.5302325
8	29713	2519	-	2586	=	-67	*	(47	/	215)	=	-14.64651162
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Laurel Elementary											-68

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	29753	2380	-	2436	=	-56	*	(27	/	191)	=	-7.91623034
4	29755	2367	-	2485	=	-118	*	(17	/	191)	=	-10.50261773
5	29757	2436	-	2528	=	-92	*	(15	/	191)	=	-7.22513085
6	29759	2497	-	2552	=	-55	*	(45	/	191)	=	-12.95811517
7	29761	2532	-	2567	=	-35	*	(46	/	191)	=	-8.42931936
8	29763	2516	-	2586	=	-70	*	(41	/	191)	=	-15.02617795
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Laurel Elementary											-62

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	29931	2355	-	2436	=	-81	*	(24	/	186)	=	-10.4516129
4	29932	2406	-	2485	=	-79	*	(22	/	186)	=	-9.34408595
5	29933	2399	-	2528	=	-129	*	(21	/	186)	=	-14.56451603
6	29934	2473	-	2552	=	-79	*	(29	/	186)	=	-12.31720426
7	29935	2511	-	2567	=	-56	*	(47	/	186)	=	-14.15053763
8	29936	2520	-	2586	=	-66	*	(43	/	186)	=	-15.25806447
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Laurel Elementary											-76

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-43	-51	-68	-62	-76	-300.0	-60.0

Compute the Upper Control Limit

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

Compute the Lower Control Limit

Simply compute the standard deviation and multiply by 3 and subtract from the average: -99.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	69%	71%	79%	79%	79%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file