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 
91124 
2336 
 
2436 
= 
100 
* 
( 
/ 
)

= 

4 
91127 
2371 
 
2485 
= 
114 
* 
( 
/ 
)

= 

5 
91128 
2428 
 
2528 
= 
100 
* 
( 
/ 
)

= 

Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for MLK / Lafayette Elementary


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 
2561 
2348 
 
2436 
= 
88 
* 
( 
/ 
)

= 

4 
2564 
2366 
 
2485 
= 
119 
* 
( 
/ 
)

= 

5 
2565 
2379 
 
2528 
= 
149 
* 
( 
/ 
)

= 

Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for MLK / Lafayette Elementary


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 
2634 
2294 
 
2436 
= 
142 
* 
( 
/ 
)

= 

4 
2635 
2337 
 
2485 
= 
148 
* 
( 
/ 
)

= 

5 
2638 
2354 
 
2528 
= 
174 
* 
( 
/ 
)

= 

Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for MLK / Lafayette Elementary


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 
2637 
0 
 
2436 
= 

* 
( 
/ 
)

= 

4 
2639 
2395 
 
2485 
= 
90 
* 
( 
/ 
)

= 

5 
2641 
2403 
 
2528 
= 
125 
* 
( 
/ 
)

= 

Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for MLK / Lafayette Elementary


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 
2659 
0 
 
2436 
= 

* 
( 
/ 
)

= 

4 
2660 
0 
 
2485 
= 

* 
( 
/ 
)

= 

5 
2661 
2410 
 
2528 
= 
118 
* 
( 
/ 
)

= 

Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for MLK / Lafayette Elementary


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





0.0 
0.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: