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 
2355353 
2419 
 
2436 
= 
17 
* 
(15 
/ 
32)

= 
7.96875 
4 
2355356 
2483 
 
2485 
= 
2 
* 
(11 
/ 
32)

= 
0.6875 
5 
2355357 
0 
 
2528 
= 

* 
(6 
/ 
32)

= 

Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Francisco Public Montessori

9 
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 
71969 
2463 
 
2436 
= 
27 
* 
(33 
/ 
54)

= 
16.5 
4 
71971 
2458 
 
2485 
= 
27 
* 
(12 
/ 
54)

= 
5.99999999 
5 
71974 
0 
 
2528 
= 

* 
(9 
/ 
54)

= 

Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Francisco Public Montessori

11 
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 
73938 
2435 
 
2436 
= 
1 
* 
(34 
/ 
73)

= 
0.46575342 
4 
73940 
2476 
 
2485 
= 
9 
* 
(28 
/ 
73)

= 
3.45205479 
5 
73942 
2494 
 
2528 
= 
34 
* 
(11 
/ 
73)

= 
5.12328765 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Francisco Public Montessori

9 
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 
74108 
2480 
 
2436 
= 
44 
* 
(24 
/ 
78)

= 
13.53846151 
4 
74109 
2433 
 
2485 
= 
52 
* 
(31 
/ 
78)

= 
20.66666664 
5 
74112 
2490 
 
2528 
= 
38 
* 
(23 
/ 
78)

= 
11.20512817 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Francisco Public Montessori

18 
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 
74631 
2448 
 
2436 
= 
12 
* 
(33 
/ 
89)

= 
4.44943819 
4 
74632 
2515 
 
2485 
= 
30 
* 
(29 
/ 
89)

= 
9.77528088 
5 
74633 
2490 
 
2528 
= 
38 
* 
(27 
/ 
89)

= 
11.52808987 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Francisco Public Montessori

3 
Last steps
Compute the average
2015 
2016 
2017 
2018 
2019 
Sum 
Average 
9

11

9

18

3

22.0 
4.4 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 28.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 37.4
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: