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 
11 
2642188 
2589 
 
2628 
= 
39 
* 
(5020 
/ 
5020) 
= 
39.0 
Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for East Side Union High

39 
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 
6 
80568 
0 
 
2552 
= 

* 
(0 
/ 
5288) 
= 

8 
80570 
0 
 
2586 
= 

* 
(0 
/ 
5288) 
= 

11 
80572 
2591 
 
2628 
= 
37 
* 
(5288 
/ 
5288) 
= 
37.0 
Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for East Side Union High

37 
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 
8 
82781 
0 
 
2586 
= 

* 
(0 
/ 
5478) 
= 

11 
82782 
2594 
 
2628 
= 
34 
* 
(5478 
/ 
5478) 
= 
34.0 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for East Side Union High

34 
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 
8 
82989 
0 
 
2586 
= 

* 
(0 
/ 
5138) 
= 

11 
82992 
2590 
 
2628 
= 
38 
* 
(5138 
/ 
5138) 
= 
38.0 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for East Side Union High

38 
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 
11 
83600 
2598 
 
2628 
= 
30 
* 
(5011 
/ 
5011) 
= 
30.0 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for East Side Union High

30 
Last steps
Compute the average
2015 
2016 
2017 
2018 
2019 
Sum 
Average 
39

37

34

38

30

178.0 
35.6 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 26.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 44.6
For the lines, you have the data necessary to plot the chart.