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 |
631297 |
2403 |
- |
2436 |
= |
-33 |
* |
(340 |
/ |
2109) |
= |
-5.32005689 |
4 |
631298 |
2433 |
- |
2485 |
= |
-52 |
* |
(290 |
/ |
2109) |
= |
-7.15030815 |
5 |
631301 |
2457 |
- |
2528 |
= |
-71 |
* |
(280 |
/ |
2109) |
= |
-9.42626835 |
6 |
631302 |
2499 |
- |
2552 |
= |
-53 |
* |
(280 |
/ |
2109) |
= |
-7.03651018 |
7 |
631305 |
2515 |
- |
2567 |
= |
-52 |
* |
(330 |
/ |
2109) |
= |
-8.13655757 |
8 |
631306 |
2497 |
- |
2586 |
= |
-89 |
* |
(313 |
/ |
2109) |
= |
-13.20862964 |
11 |
631309 |
2530 |
- |
2628 |
= |
-98 |
* |
(276 |
/ |
2109) |
= |
-12.82503548 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Bassett Unified
|
-63 |
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 |
20168 |
2428 |
- |
2436 |
= |
-8 |
* |
(240 |
/ |
1987) |
= |
-0.96628082 |
4 |
20169 |
2443 |
- |
2485 |
= |
-42 |
* |
(327 |
/ |
1987) |
= |
-6.91192753 |
5 |
20172 |
2464 |
- |
2528 |
= |
-64 |
* |
(273 |
/ |
1987) |
= |
-8.79315546 |
6 |
20173 |
2491 |
- |
2552 |
= |
-61 |
* |
(267 |
/ |
1987) |
= |
-8.19677905 |
7 |
20175 |
2506 |
- |
2567 |
= |
-61 |
* |
(287 |
/ |
1987) |
= |
-8.81076997 |
8 |
20177 |
2517 |
- |
2586 |
= |
-69 |
* |
(328 |
/ |
1987) |
= |
-11.39003521 |
11 |
20180 |
2534 |
- |
2628 |
= |
-94 |
* |
(265 |
/ |
1987) |
= |
-12.5364871 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Bassett Unified
|
-58 |
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 |
20480 |
2427 |
- |
2436 |
= |
-9 |
* |
(295 |
/ |
1958) |
= |
-1.35597548 |
4 |
20481 |
2458 |
- |
2485 |
= |
-27 |
* |
(246 |
/ |
1958) |
= |
-3.39223696 |
5 |
20483 |
2465 |
- |
2528 |
= |
-63 |
* |
(316 |
/ |
1958) |
= |
-10.16751784 |
6 |
20485 |
2484 |
- |
2552 |
= |
-68 |
* |
(264 |
/ |
1958) |
= |
-9.16853928 |
7 |
20487 |
2492 |
- |
2567 |
= |
-75 |
* |
(269 |
/ |
1958) |
= |
-10.30388145 |
8 |
20490 |
2511 |
- |
2586 |
= |
-75 |
* |
(286 |
/ |
1958) |
= |
-10.95505613 |
11 |
20491 |
2547 |
- |
2628 |
= |
-81 |
* |
(282 |
/ |
1958) |
= |
-11.66598563 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Bassett Unified
|
-57 |
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 |
20471 |
2438 |
- |
2436 |
= |
2 |
* |
(252 |
/ |
1862) |
= |
0.27067669 |
4 |
20473 |
2467 |
- |
2485 |
= |
-18 |
* |
(298 |
/ |
1862) |
= |
-2.88077335 |
5 |
20475 |
2478 |
- |
2528 |
= |
-50 |
* |
(228 |
/ |
1862) |
= |
-6.12244895 |
6 |
20477 |
2489 |
- |
2552 |
= |
-63 |
* |
(303 |
/ |
1862) |
= |
-10.25187969 |
7 |
20479 |
2490 |
- |
2567 |
= |
-77 |
* |
(259 |
/ |
1862) |
= |
-10.71052629 |
8 |
20481 |
2511 |
- |
2586 |
= |
-75 |
* |
(259 |
/ |
1862) |
= |
-10.4323308 |
11 |
20483 |
2540 |
- |
2628 |
= |
-88 |
* |
(263 |
/ |
1862) |
= |
-12.42964554 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Bassett Unified
|
-53 |
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 |
20656 |
2428 |
- |
2436 |
= |
-8 |
* |
(271 |
/ |
1859) |
= |
-1.16621839 |
4 |
20657 |
2472 |
- |
2485 |
= |
-13 |
* |
(254 |
/ |
1859) |
= |
-1.77622377 |
5 |
20658 |
2488 |
- |
2528 |
= |
-40 |
* |
(287 |
/ |
1859) |
= |
-6.17536308 |
6 |
20659 |
2498 |
- |
2552 |
= |
-54 |
* |
(232 |
/ |
1859) |
= |
-6.73910701 |
7 |
20660 |
2492 |
- |
2567 |
= |
-75 |
* |
(308 |
/ |
1859) |
= |
-12.42603548 |
8 |
20661 |
2499 |
- |
2586 |
= |
-87 |
* |
(267 |
/ |
1859) |
= |
-12.49542764 |
11 |
20662 |
2535 |
- |
2628 |
= |
-93 |
* |
(240 |
/ |
1859) |
= |
-12.00645503 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Bassett Unified
|
-53 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-63
|
-58
|
-57
|
-53
|
-53
|
-284.0 |
-56.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -44.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -68.8
For the lines, you have the data necessary to plot the chart.