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 |
359718 |
2424 |
- |
2436 |
= |
-12 |
* |
(916 |
/ |
6034) |
= |
-1.82167716 |
4 |
359721 |
2454 |
- |
2485 |
= |
-31 |
* |
(902 |
/ |
6034) |
= |
-4.63407356 |
5 |
359722 |
2465 |
- |
2528 |
= |
-63 |
* |
(856 |
/ |
6034) |
= |
-8.93735495 |
6 |
359725 |
2512 |
- |
2552 |
= |
-40 |
* |
(889 |
/ |
6034) |
= |
-5.89327144 |
7 |
359726 |
2530 |
- |
2567 |
= |
-37 |
* |
(829 |
/ |
6034) |
= |
-5.08336092 |
8 |
359729 |
2576 |
- |
2586 |
= |
-10 |
* |
(870 |
/ |
6034) |
= |
-1.44182963 |
11 |
359730 |
2551 |
- |
2628 |
= |
-77 |
* |
(772 |
/ |
6034) |
= |
-9.85150805 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Sanger Unified
|
-38 |
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 |
10827 |
2433 |
- |
2436 |
= |
-3 |
* |
(910 |
/ |
6083) |
= |
-0.44879171 |
4 |
10830 |
2463 |
- |
2485 |
= |
-22 |
* |
(934 |
/ |
6083) |
= |
-3.3779385 |
5 |
10831 |
2484 |
- |
2528 |
= |
-44 |
* |
(906 |
/ |
6083) |
= |
-6.55334535 |
6 |
10834 |
2510 |
- |
2552 |
= |
-42 |
* |
(874 |
/ |
6083) |
= |
-6.03452241 |
7 |
10835 |
2539 |
- |
2567 |
= |
-28 |
* |
(869 |
/ |
6083) |
= |
-3.99999998 |
8 |
10838 |
2557 |
- |
2586 |
= |
-29 |
* |
(833 |
/ |
6083) |
= |
-3.97123129 |
11 |
10839 |
2552 |
- |
2628 |
= |
-76 |
* |
(757 |
/ |
6083) |
= |
-9.4578333 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Sanger Unified
|
-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 |
11158 |
2431 |
- |
2436 |
= |
-5 |
* |
(936 |
/ |
6311) |
= |
-0.74156235 |
4 |
11159 |
2464 |
- |
2485 |
= |
-21 |
* |
(926 |
/ |
6311) |
= |
-3.08128664 |
5 |
11161 |
2483 |
- |
2528 |
= |
-45 |
* |
(945 |
/ |
6311) |
= |
-6.7382348 |
6 |
11164 |
2522 |
- |
2552 |
= |
-30 |
* |
(942 |
/ |
6311) |
= |
-4.47789573 |
7 |
11165 |
2520 |
- |
2567 |
= |
-47 |
* |
(886 |
/ |
6311) |
= |
-6.59832037 |
8 |
11168 |
2570 |
- |
2586 |
= |
-16 |
* |
(885 |
/ |
6311) |
= |
-2.24370147 |
11 |
11170 |
2572 |
- |
2628 |
= |
-56 |
* |
(791 |
/ |
6311) |
= |
-7.01885593 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Sanger Unified
|
-31 |
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 |
11186 |
2445 |
- |
2436 |
= |
9 |
* |
(886 |
/ |
6447) |
= |
1.23685435 |
4 |
11187 |
2471 |
- |
2485 |
= |
-14 |
* |
(971 |
/ |
6447) |
= |
-2.10857763 |
5 |
11190 |
2492 |
- |
2528 |
= |
-36 |
* |
(958 |
/ |
6447) |
= |
-5.34946486 |
6 |
11191 |
2524 |
- |
2552 |
= |
-28 |
* |
(973 |
/ |
6447) |
= |
-4.22584145 |
7 |
11194 |
2532 |
- |
2567 |
= |
-35 |
* |
(964 |
/ |
6447) |
= |
-5.23344189 |
8 |
11195 |
2537 |
- |
2586 |
= |
-49 |
* |
(888 |
/ |
6447) |
= |
-6.74918567 |
11 |
11198 |
2586 |
- |
2628 |
= |
-42 |
* |
(807 |
/ |
6447) |
= |
-5.25732896 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Sanger Unified
|
-28 |
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 |
11287 |
2447 |
- |
2436 |
= |
11 |
* |
(960 |
/ |
6499) |
= |
1.62486536 |
4 |
11288 |
2479 |
- |
2485 |
= |
-6 |
* |
(905 |
/ |
6499) |
= |
-0.83551315 |
5 |
11289 |
2494 |
- |
2528 |
= |
-34 |
* |
(967 |
/ |
6499) |
= |
-5.05893211 |
6 |
11290 |
2531 |
- |
2552 |
= |
-21 |
* |
(969 |
/ |
6499) |
= |
-3.13109708 |
7 |
11291 |
2529 |
- |
2567 |
= |
-38 |
* |
(955 |
/ |
6499) |
= |
-5.58393595 |
8 |
11292 |
2547 |
- |
2586 |
= |
-39 |
* |
(952 |
/ |
6499) |
= |
-5.71287889 |
11 |
11293 |
2574 |
- |
2628 |
= |
-54 |
* |
(791 |
/ |
6499) |
= |
-6.57239573 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Sanger Unified
|
-25 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-38
|
-34
|
-31
|
-28
|
-25
|
-156.0 |
-31.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -16.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -46.2
For the lines, you have the data necessary to plot the chart.