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	2359521	2411	-	2436	=	-25	*	(63	/	380)	=	-4.14473683
4	2359524	2456	-	2485	=	-29	*	(69	/	380)	=	-5.26578946
5	2359525	2451	-	2528	=	-77	*	(67	/	380)	=	-13.57631575
6	2359528	2488	-	2552	=	-64	*	(59	/	380)	=	-9.93684205
7	2359529	2526	-	2567	=	-41	*	(62	/	380)	=	-6.68947365
8	2359532	2512	-	2586	=	-74	*	(60	/	380)	=	-11.68421046
Step 4	SUM Weighted Distance From Standard to get 2015 Difference From Standard for Carmichael (Bessie)/FEC											-51

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	72092	2419	-	2436	=	-17	*	(67	/	382)	=	-2.98167539
4	72093	2450	-	2485	=	-35	*	(64	/	382)	=	-5.86387435
5	72095	2481	-	2528	=	-47	*	(62	/	382)	=	-7.62827221
6	72097	2425	-	2552	=	-127	*	(64	/	382)	=	-21.27748691
7	72099	2519	-	2567	=	-48	*	(60	/	382)	=	-7.53926698
8	72102	2504	-	2586	=	-82	*	(65	/	382)	=	-13.95287958
Step 4	SUM Weighted Distance From Standard to get 2016 Difference From Standard for Carmichael (Bessie)/FEC											-59

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	74066	2407	-	2436	=	-29	*	(70	/	376)	=	-5.39893615
4	74068	2430	-	2485	=	-55	*	(61	/	376)	=	-8.92287231
5	74070	2460	-	2528	=	-68	*	(57	/	376)	=	-10.30851059
6	74071	2495	-	2552	=	-57	*	(63	/	376)	=	-9.55053189
7	74073	2487	-	2567	=	-80	*	(63	/	376)	=	-13.40425528
8	74075	2517	-	2586	=	-69	*	(62	/	376)	=	-11.37765957
Step 4	SUM Weighted Distance From Standard to get 2017 Difference From Standard for Carmichael (Bessie)/FEC											-59

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	74240	2395	-	2436	=	-41	*	(70	/	368)	=	-7.79891303
4	74241	2444	-	2485	=	-41	*	(60	/	368)	=	-6.6847826
5	74244	2450	-	2528	=	-78	*	(54	/	368)	=	-11.44565214
6	74245	2435	-	2552	=	-117	*	(58	/	368)	=	-18.44021732
7	74248	2531	-	2567	=	-36	*	(63	/	368)	=	-6.16304347
8	74249	2487	-	2586	=	-99	*	(63	/	368)	=	-16.94836955
Step 4	SUM Weighted Distance From Standard to get 2018 Difference From Standard for Carmichael (Bessie)/FEC											-67

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	74766	2382	-	2436	=	-54	*	(68	/	374)	=	-9.81818177
4	74767	2421	-	2485	=	-64	*	(65	/	374)	=	-11.12299462
5	74768	2452	-	2528	=	-76	*	(57	/	374)	=	-11.58288769
6	74769	2470	-	2552	=	-82	*	(62	/	374)	=	-13.59358288
7	74770	2484	-	2567	=	-83	*	(58	/	374)	=	-12.87165768
8	74771	2531	-	2586	=	-55	*	(64	/	374)	=	-9.41176467
Step 4	SUM Weighted Distance From Standard to get 2019 Difference From Standard for Carmichael (Bessie)/FEC											-68

Last steps

Compute the average

2015	2016	2017	2018	2019	Sum	Average
-51	-59	-59	-67	-68	-304.0	-60.8

Compute the Upper Control Limit

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

Compute the Lower Control Limit

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

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	85%	81%	76%	76%	77%
Data source	2015 data file	2016 data file	2017 data file	2018 data file	2019 data file