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	2174821	2413	-	2436	=	-23	*	(151	/	1199)	=	-2.89658046
4	2174824	2454	-	2485	=	-31	*	(164	/	1199)	=	-4.24020015
5	2174825	2491	-	2528	=	-37	*	(173	/	1199)	=	-5.33861549
6	2174828	2517	-	2552	=	-35	*	(202	/	1199)	=	-5.89658048
7	2174829	2548	-	2567	=	-19	*	(182	/	1199)	=	-2.88407004
8	2174832	2534	-	2586	=	-52	*	(197	/	1199)	=	-8.54378647
11	2174833	2548	-	2628	=	-80	*	(130	/	1199)	=	-8.67389488
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Julian Charter											-38

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	66757	2433	-	2436	=	-3	*	(168	/	1256)	=	-0.40127388
4	66759	2466	-	2485	=	-19	*	(151	/	1256)	=	-2.28423565
5	66762	2494	-	2528	=	-34	*	(180	/	1256)	=	-4.87261143
6	66763	2514	-	2552	=	-38	*	(233	/	1256)	=	-7.04936305
7	66766	2538	-	2567	=	-29	*	(196	/	1256)	=	-4.5254777
8	66768	2557	-	2586	=	-29	*	(185	/	1256)	=	-4.2714968
11	66770	2522	-	2628	=	-106	*	(143	/	1256)	=	-12.06847132
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Julian Charter											-35

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	68590	2420	-	2436	=	-16	*	(204	/	1351)	=	-2.41598814
4	68592	2485	-	2485	=	0	*	(183	/	1351)	=	0.0
5	68595	2493	-	2528	=	-35	*	(192	/	1351)	=	-4.97409325
6	68597	2520	-	2552	=	-32	*	(226	/	1351)	=	-5.35307178
7	68598	2543	-	2567	=	-24	*	(227	/	1351)	=	-4.03256846
8	68601	2553	-	2586	=	-33	*	(196	/	1351)	=	-4.78756476
11	68603	2526	-	2628	=	-102	*	(123	/	1351)	=	-9.28645444
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Julian Charter											-31

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	68745	2428	-	2436	=	-8	*	(148	/	1186)	=	-0.99831366
4	68746	2478	-	2485	=	-7	*	(156	/	1186)	=	-0.92074198
5	68749	2526	-	2528	=	-2	*	(152	/	1186)	=	-0.25632378
6	68750	2535	-	2552	=	-17	*	(196	/	1186)	=	-2.80944349
7	68753	2547	-	2567	=	-20	*	(201	/	1186)	=	-3.38954468
8	68754	2553	-	2586	=	-33	*	(204	/	1186)	=	-5.67622259
11	68757	2536	-	2628	=	-92	*	(129	/	1186)	=	-10.00674533
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Julian Charter											-24

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	69301	0	-	2436	=		*	(4	/	54)	=
4	69302	0	-	2485	=		*	(7	/	54)	=
5	69303	0	-	2528	=		*	(9	/	54)	=
6	69304	0	-	2552	=		*	(8	/	54)	=
7	69305	0	-	2567	=		*	(7	/	54)	=
8	69306	2553	-	2586	=	-33	*	(12	/	54)	=	-7.33333333
11	69307	0	-	2628	=		*	(7	/	54)	=
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Julian Charter											-7

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-38	-35	-31	-24	-7	-135.0	-27.0

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	36%	36%	34%	30%	27%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file