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 district 
= 
Weighted Distance From Standard 
11 
694043 
2554 
 
2628 
= 
74 
* 
(2091 
/ 
4134) 
= 
37.42960812772133 
Step 4 
SUM Weighted Distance From Standard to get
2015 Difference From Standard for El Monte Union High

37 
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 district 
= 
Weighted Distance From Standard 
11 
21946 
2566 
 
2628 
= 
62 
* 
(2065 
/ 
2047) 
= 
62.54518808011724 
Step 4 
SUM Weighted Distance From Standard to get
2016 Difference From Standard for El Monte Union High

62 
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 district 
= 
Weighted Distance From Standard 
11 
22363 
2565 
 
2628 
= 
63 
* 
(2197 
/ 
2196) 
= 
63.02868852459017 
Step 4 
SUM Weighted Distance From Standard to get
2017 Difference From Standard for El Monte Union High

63 
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 district 
= 
Weighted Distance From Standard 
11 
22348 
2563 
 
2628 
= 
65 
* 
(2082 
/ 
2081) 
= 
65.03123498318116 
Step 4 
SUM Weighted Distance From Standard to get
2018 Difference From Standard for El Monte Union High

65 
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 district 
= 
Weighted Distance From Standard 
11 
22524 
2572 
 
2628 
= 
56 
* 
(1994 
/ 
1992) 
= 
56.05622489959839 
Step 4 
SUM Weighted Distance From Standard to get
2019 Difference From Standard for El Monte Union High

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

62

63

65

56

283.0 
56.6 
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3: 23.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3: 89.6
You know have all of the data necessary to plot the chart in this page!