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 |
1397053 |
2436 |
- |
2436 |
= |
0 |
* |
(170 |
/ |
1069) |
= |
0.0 |
4 |
1397054 |
2442 |
- |
2485 |
= |
-43 |
* |
(189 |
/ |
1069) |
= |
-7.60243216 |
5 |
1397057 |
2478 |
- |
2528 |
= |
-50 |
* |
(184 |
/ |
1069) |
= |
-8.60617395 |
6 |
1397058 |
2503 |
- |
2552 |
= |
-49 |
* |
(172 |
/ |
1069) |
= |
-7.88400372 |
7 |
1397061 |
2537 |
- |
2567 |
= |
-30 |
* |
(164 |
/ |
1069) |
= |
-4.60243215 |
8 |
1397062 |
2540 |
- |
2586 |
= |
-46 |
* |
(190 |
/ |
1069) |
= |
-8.17586529 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Grass Valley Elementary
|
-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 school |
= |
Weighted Distance From Standard |
3 |
44053 |
2416 |
- |
2436 |
= |
-20 |
* |
(190 |
/ |
1046) |
= |
-3.63288718 |
4 |
44054 |
2474 |
- |
2485 |
= |
-11 |
* |
(172 |
/ |
1046) |
= |
-1.80879541 |
5 |
44056 |
2472 |
- |
2528 |
= |
-56 |
* |
(180 |
/ |
1046) |
= |
-9.63671128 |
6 |
44058 |
2516 |
- |
2552 |
= |
-36 |
* |
(180 |
/ |
1046) |
= |
-6.19502868 |
7 |
44060 |
2524 |
- |
2567 |
= |
-43 |
* |
(172 |
/ |
1046) |
= |
-7.07074568 |
8 |
44063 |
2544 |
- |
2586 |
= |
-42 |
* |
(152 |
/ |
1046) |
= |
-6.10325045 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Grass Valley Elementary
|
-34 |
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 |
45122 |
2431 |
- |
2436 |
= |
-5 |
* |
(212 |
/ |
1097) |
= |
-0.96627165 |
4 |
45123 |
2462 |
- |
2485 |
= |
-23 |
* |
(190 |
/ |
1097) |
= |
-3.98359161 |
5 |
45126 |
2499 |
- |
2528 |
= |
-29 |
* |
(177 |
/ |
1097) |
= |
-4.67912489 |
6 |
45128 |
2501 |
- |
2552 |
= |
-51 |
* |
(174 |
/ |
1097) |
= |
-8.0893345 |
7 |
45129 |
2539 |
- |
2567 |
= |
-28 |
* |
(177 |
/ |
1097) |
= |
-4.51777575 |
8 |
45132 |
2540 |
- |
2586 |
= |
-46 |
* |
(167 |
/ |
1097) |
= |
-7.0027347 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Grass Valley Elementary
|
-29 |
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 |
45137 |
2435 |
- |
2436 |
= |
-1 |
* |
(190 |
/ |
1101) |
= |
-0.17257039 |
4 |
45138 |
2478 |
- |
2485 |
= |
-7 |
* |
(205 |
/ |
1101) |
= |
-1.30336058 |
5 |
45140 |
2479 |
- |
2528 |
= |
-49 |
* |
(175 |
/ |
1101) |
= |
-7.78837419 |
6 |
45142 |
2520 |
- |
2552 |
= |
-32 |
* |
(182 |
/ |
1101) |
= |
-5.28973658 |
7 |
45145 |
2525 |
- |
2567 |
= |
-42 |
* |
(168 |
/ |
1101) |
= |
-6.40871931 |
8 |
45147 |
2552 |
- |
2586 |
= |
-34 |
* |
(181 |
/ |
1101) |
= |
-5.5894641 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Grass Valley Elementary
|
-27 |
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 |
45269 |
2425 |
- |
2436 |
= |
-11 |
* |
(189 |
/ |
1146) |
= |
-1.81413612 |
4 |
45270 |
2476 |
- |
2485 |
= |
-9 |
* |
(198 |
/ |
1146) |
= |
-1.55497382 |
5 |
45271 |
2487 |
- |
2528 |
= |
-41 |
* |
(208 |
/ |
1146) |
= |
-7.44153575 |
6 |
45272 |
2503 |
- |
2552 |
= |
-49 |
* |
(186 |
/ |
1146) |
= |
-7.95287954 |
7 |
45273 |
2535 |
- |
2567 |
= |
-32 |
* |
(182 |
/ |
1146) |
= |
-5.08202442 |
8 |
45274 |
2508 |
- |
2586 |
= |
-78 |
* |
(183 |
/ |
1146) |
= |
-12.45549731 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Grass Valley Elementary
|
-36 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-37
|
-34
|
-29
|
-27
|
-36
|
-163.0 |
-32.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -20.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -44.6
For the lines, you have the data necessary to plot the chart.