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 |
2725896 |
2499 |
- |
2436 |
= |
63 |
* |
(210 |
/ |
1599) |
= |
8.27392117 |
4 |
2725897 |
2573 |
- |
2485 |
= |
88 |
* |
(229 |
/ |
1599) |
= |
12.60287679 |
5 |
2725900 |
2622 |
- |
2528 |
= |
94 |
* |
(269 |
/ |
1599) |
= |
15.81363344 |
6 |
2725901 |
2641 |
- |
2552 |
= |
89 |
* |
(275 |
/ |
1599) |
= |
15.30644152 |
7 |
2725904 |
2678 |
- |
2567 |
= |
111 |
* |
(318 |
/ |
1599) |
= |
22.07504686 |
8 |
2725905 |
2707 |
- |
2586 |
= |
121 |
* |
(298 |
/ |
1599) |
= |
22.55034396 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Saratoga Union Elementary
|
97 |
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 |
82911 |
2529 |
- |
2436 |
= |
93 |
* |
(183 |
/ |
1547) |
= |
11.0012928 |
4 |
82913 |
2575 |
- |
2485 |
= |
90 |
* |
(225 |
/ |
1547) |
= |
13.08985128 |
5 |
82914 |
2621 |
- |
2528 |
= |
93 |
* |
(244 |
/ |
1547) |
= |
14.6683904 |
6 |
82917 |
2661 |
- |
2552 |
= |
109 |
* |
(277 |
/ |
1547) |
= |
19.51712983 |
7 |
82918 |
2670 |
- |
2567 |
= |
103 |
* |
(290 |
/ |
1547) |
= |
19.3083387 |
8 |
82921 |
2711 |
- |
2586 |
= |
125 |
* |
(328 |
/ |
1547) |
= |
26.50290875 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Saratoga Union Elementary
|
104 |
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 |
85221 |
2513 |
- |
2436 |
= |
77 |
* |
(180 |
/ |
1437) |
= |
9.64509392 |
4 |
85223 |
2581 |
- |
2485 |
= |
96 |
* |
(185 |
/ |
1437) |
= |
12.35908138 |
5 |
85224 |
2616 |
- |
2528 |
= |
88 |
* |
(233 |
/ |
1437) |
= |
14.26861515 |
6 |
85226 |
2661 |
- |
2552 |
= |
109 |
* |
(260 |
/ |
1437) |
= |
19.72164228 |
7 |
85228 |
2691 |
- |
2567 |
= |
124 |
* |
(283 |
/ |
1437) |
= |
24.42032006 |
8 |
85231 |
2715 |
- |
2586 |
= |
129 |
* |
(296 |
/ |
1437) |
= |
26.57202501 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Saratoga Union Elementary
|
107 |
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 |
85439 |
2534 |
- |
2436 |
= |
98 |
* |
(203 |
/ |
1414) |
= |
14.06930689 |
4 |
85441 |
2564 |
- |
2485 |
= |
79 |
* |
(192 |
/ |
1414) |
= |
10.72701555 |
5 |
85443 |
2631 |
- |
2528 |
= |
103 |
* |
(207 |
/ |
1414) |
= |
15.07850063 |
6 |
85445 |
2657 |
- |
2552 |
= |
105 |
* |
(239 |
/ |
1414) |
= |
17.74752473 |
7 |
85447 |
2686 |
- |
2567 |
= |
119 |
* |
(273 |
/ |
1414) |
= |
22.97524741 |
8 |
85449 |
2725 |
- |
2586 |
= |
139 |
* |
(300 |
/ |
1414) |
= |
29.49080615 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Saratoga Union Elementary
|
110 |
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 |
86037 |
2533 |
- |
2436 |
= |
97 |
* |
(145 |
/ |
1304) |
= |
10.78604294 |
4 |
86038 |
2579 |
- |
2485 |
= |
94 |
* |
(210 |
/ |
1304) |
= |
15.13803674 |
5 |
86039 |
2608 |
- |
2528 |
= |
80 |
* |
(196 |
/ |
1304) |
= |
12.02453984 |
6 |
86040 |
2662 |
- |
2552 |
= |
110 |
* |
(228 |
/ |
1304) |
= |
19.23312875 |
7 |
86041 |
2684 |
- |
2567 |
= |
117 |
* |
(245 |
/ |
1304) |
= |
21.9823619 |
8 |
86042 |
2705 |
- |
2586 |
= |
119 |
* |
(280 |
/ |
1304) |
= |
25.55214719 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Saratoga Union Elementary
|
105 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
97
|
104
|
107
|
110
|
105
|
523.0 |
104.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 116.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 92.6
For the lines, you have the data necessary to plot the chart.