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	2275073	2439	-	2436	=	3	*	(70	/	476)	=	0.44117647
4	2275074	2458	-	2485	=	-27	*	(62	/	476)	=	-3.5168067
5	2275077	2503	-	2528	=	-25	*	(77	/	476)	=	-4.04411763
6	2275078	2534	-	2552	=	-18	*	(91	/	476)	=	-3.44117646
7	2275081	2577	-	2567	=	10	*	(87	/	476)	=	1.82773109
8	2275082	2579	-	2586	=	-7	*	(89	/	476)	=	-1.30882352
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Bethune K-8											-10

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	69756	2460	-	2436	=	24	*	(55	/	452)	=	2.92035396
4	69757	2476	-	2485	=	-9	*	(73	/	452)	=	-1.45353982
5	69759	2507	-	2528	=	-21	*	(61	/	452)	=	-2.83407079
6	69762	2541	-	2552	=	-11	*	(84	/	452)	=	-2.04424778
7	69764	2577	-	2567	=	10	*	(92	/	452)	=	2.03539823
8	69766	2605	-	2586	=	19	*	(87	/	452)	=	3.65707964
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Bethune K-8											2

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	71589	2444	-	2436	=	8	*	(52	/	428)	=	0.97196262
4	71590	2485	-	2485	=	0	*	(58	/	428)	=	0.0
5	71592	2499	-	2528	=	-29	*	(80	/	428)	=	-5.42056072
6	71595	2537	-	2552	=	-15	*	(75	/	428)	=	-2.62850466
7	71597	2579	-	2567	=	12	*	(74	/	428)	=	2.07476635
8	71598	2567	-	2586	=	-19	*	(89	/	428)	=	-3.95093458
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Bethune K-8											-9

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	71734	2471	-	2436	=	35	*	(47	/	407)	=	4.04176903
4	71735	2467	-	2485	=	-18	*	(55	/	407)	=	-2.43243243
5	71738	2549	-	2528	=	21	*	(60	/	407)	=	3.09582309
6	71739	2524	-	2552	=	-28	*	(86	/	407)	=	-5.91646191
7	71742	2565	-	2567	=	-2	*	(83	/	407)	=	-0.40786241
8	71743	2610	-	2586	=	24	*	(76	/	407)	=	4.48157246
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Bethune K-8											3

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	72222	2454	-	2436	=	18	*	(52	/	398)	=	2.35175879
4	72223	2492	-	2485	=	7	*	(51	/	398)	=	0.89698492
5	72224	2519	-	2528	=	-9	*	(58	/	398)	=	-1.31155779
6	72225	2545	-	2552	=	-7	*	(68	/	398)	=	-1.1959799
7	72226	2544	-	2567	=	-23	*	(89	/	398)	=	-5.14321607
8	72227	2594	-	2586	=	8	*	(80	/	398)	=	1.6080402
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Bethune K-8											-3

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-10	2	-9	3	-3	-17.0	-3.4

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

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	68%	66%	60%	62%	66%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file