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 
7 
1362877 
2477 
 
2567 
= 
90 
* 
(2160 
/ 
6400) 
= 
30.375 
8 
1362878 
2502 
 
2586 
= 
84 
* 
(2050 
/ 
6400) 
= 
26.90625 
11 
1362881 
2524 
 
2628 
= 
104 
* 
(2190 
/ 
6400) 
= 
35.5875 
Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Salinas Union High

93 
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 
7 
42882 
2481 
 
2567 
= 
86 
* 
(2183 
/ 
6634) 
= 
28.29936683 
8 
42884 
2502 
 
2586 
= 
84 
* 
(2176 
/ 
6634) 
= 
27.55260774 
11 
42887 
2545 
 
2628 
= 
83 
* 
(2275 
/ 
6634) 
= 
28.46321971 
Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Salinas Union High

84 
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 
7 
43954 
2484 
 
2567 
= 
83 
* 
(2283 
/ 
6876) 
= 
27.55802786 
8 
43956 
2499 
 
2586 
= 
87 
* 
(2179 
/ 
6876) 
= 
27.57024432 
11 
43957 
2530 
 
2628 
= 
98 
* 
(2414 
/ 
6876) 
= 
34.40546829 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Salinas Union High

90 
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 
7 
43971 
2476 
 
2567 
= 
91 
* 
(2381 
/ 
7109) 
= 
30.4784076 
8 
43972 
2504 
 
2586 
= 
82 
* 
(2239 
/ 
7109) 
= 
25.82613583 
11 
43975 
2526 
 
2628 
= 
102 
* 
(2489 
/ 
7109) 
= 
35.71219573 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Salinas Union High

92 
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 
7 
44101 
2491 
 
2567 
= 
76 
* 
(2422 
/ 
7343) 
= 
25.06768344 
8 
44102 
2507 
 
2586 
= 
79 
* 
(2377 
/ 
7343) 
= 
25.57306275 
11 
44103 
2527 
 
2628 
= 
101 
* 
(2544 
/ 
7343) 
= 
34.9916927 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Salinas Union High

86 
Last steps
Compute the average
2015 
2016 
2017 
2018 
2019 
Sum 
Average 
93

84

90

92

86

445.0 
89.0 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 80.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 98.0
For the lines, you have the data necessary to plot the chart.