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 
2756407 
2439 
 
2436 
= 
3 
* 
(377 
/ 
1116) 
= 
1.01344086 
4 
2756408 
2472 
 
2485 
= 
13 
* 
(344 
/ 
1116) 
= 
4.00716845 
5 
2756411 
2508 
 
2528 
= 
20 
* 
(395 
/ 
1116) 
= 
7.07885304 
Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Santa Cruz City Elementary

10 
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 
83852 
2430 
 
2436 
= 
6 
* 
(344 
/ 
1058) 
= 
1.95085066 
4 
83854 
2472 
 
2485 
= 
13 
* 
(367 
/ 
1058) 
= 
4.50945179 
5 
83856 
2516 
 
2528 
= 
12 
* 
(344 
/ 
1058) 
= 
3.90170131 
6 
83859 
0 
 
2552 
= 

* 
(0 
/ 
1058) 
= 

7 
83860 
0 
 
2567 
= 

* 
(3 
/ 
1058) 
= 

Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Santa Cruz City Elementary

10 
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 
86169 
2431 
 
2436 
= 
5 
* 
(310 
/ 
1011) 
= 
1.53313551 
4 
86170 
2459 
 
2485 
= 
26 
* 
(330 
/ 
1011) 
= 
8.48664687 
5 
86173 
2508 
 
2528 
= 
20 
* 
(371 
/ 
1011) 
= 
7.33926804 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Santa Cruz City Elementary

17 
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 
86400 
2424 
 
2436 
= 
12 
* 
(347 
/ 
984) 
= 
4.23170731 
4 
86403 
2453 
 
2485 
= 
32 
* 
(304 
/ 
984) 
= 
9.88617885 
5 
86404 
2501 
 
2528 
= 
27 
* 
(333 
/ 
984) 
= 
9.13719512 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Santa Cruz City Elementary

23 
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 
87000 
2436 
 
2436 
= 
0 
* 
(293 
/ 
938) 
= 
0.0 
4 
87001 
2463 
 
2485 
= 
22 
* 
(340 
/ 
938) 
= 
7.97441363 
5 
87002 
2507 
 
2528 
= 
21 
* 
(305 
/ 
938) 
= 
6.82835819 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Santa Cruz City Elementary

15 
Last steps
Compute the average
2015 
2016 
2017 
2018 
2019 
Sum 
Average 
10

10

17

23

15

75.0 
15.0 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 0.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 30.0
For the lines, you have the data necessary to plot the chart.