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 
3383 
2531 
 
2436 
= 
95 
* 
(112 
/ 
448)

= 
23.75 
4 
3384 
2568 
 
2485 
= 
83 
* 
(78 
/ 
448)

= 
14.45089279 
5 
3385 
2592 
 
2528 
= 
64 
* 
(95 
/ 
448)

= 
13.57142854 
6 
3386 
2620 
 
2552 
= 
68 
* 
(92 
/ 
448)

= 
13.96428566 
7 
3387 
2663 
 
2567 
= 
96 
* 
(71 
/ 
448)

= 
15.21428563 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Cottonwood Creek

81 
Last steps
Compute the average
2019 
Sum 
Average 
81

81.0 
81.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: