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 |
3092962 |
2427 |
- |
2436 |
= |
-9 |
* |
(76 |
/ |
431) |
= |
-1.58700695 |
4 |
3092963 |
2454 |
- |
2485 |
= |
-31 |
* |
(76 |
/ |
431) |
= |
-5.46635729 |
5 |
3092966 |
2500 |
- |
2528 |
= |
-28 |
* |
(82 |
/ |
431) |
= |
-5.32714616 |
6 |
3092967 |
2498 |
- |
2552 |
= |
-54 |
* |
(69 |
/ |
431) |
= |
-8.64501158 |
7 |
3092970 |
2527 |
- |
2567 |
= |
-40 |
* |
(62 |
/ |
431) |
= |
-5.75406032 |
8 |
3092971 |
2555 |
- |
2586 |
= |
-31 |
* |
(66 |
/ |
431) |
= |
-4.74709975 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Sonora Elementary
|
-32 |
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 |
95308 |
2433 |
- |
2436 |
= |
-3 |
* |
(65 |
/ |
463) |
= |
-0.4211663 |
4 |
95311 |
2479 |
- |
2485 |
= |
-6 |
* |
(86 |
/ |
463) |
= |
-1.11447084 |
5 |
95312 |
2495 |
- |
2528 |
= |
-33 |
* |
(81 |
/ |
463) |
= |
-5.77321813 |
6 |
95314 |
2521 |
- |
2552 |
= |
-31 |
* |
(88 |
/ |
463) |
= |
-5.89200861 |
7 |
95317 |
2548 |
- |
2567 |
= |
-19 |
* |
(77 |
/ |
463) |
= |
-3.15982721 |
8 |
95318 |
2553 |
- |
2586 |
= |
-33 |
* |
(66 |
/ |
463) |
= |
-4.70410367 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Sonora Elementary
|
-21 |
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 |
98086 |
2429 |
- |
2436 |
= |
-7 |
* |
(89 |
/ |
483) |
= |
-1.28985507 |
4 |
98088 |
2503 |
- |
2485 |
= |
18 |
* |
(60 |
/ |
483) |
= |
2.23602484 |
5 |
98090 |
2497 |
- |
2528 |
= |
-31 |
* |
(91 |
/ |
483) |
= |
-5.84057971 |
6 |
98091 |
2528 |
- |
2552 |
= |
-24 |
* |
(84 |
/ |
483) |
= |
-4.17391303 |
7 |
98094 |
2551 |
- |
2567 |
= |
-16 |
* |
(87 |
/ |
483) |
= |
-2.88198757 |
8 |
98096 |
2553 |
- |
2586 |
= |
-33 |
* |
(72 |
/ |
483) |
= |
-4.91925463 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Sonora Elementary
|
-17 |
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 |
98251 |
2465 |
- |
2436 |
= |
29 |
* |
(79 |
/ |
507) |
= |
4.51873766 |
4 |
98252 |
2487 |
- |
2485 |
= |
2 |
* |
(86 |
/ |
507) |
= |
0.33925049 |
5 |
98255 |
2501 |
- |
2528 |
= |
-27 |
* |
(71 |
/ |
507) |
= |
-3.78106507 |
6 |
98256 |
2524 |
- |
2552 |
= |
-28 |
* |
(88 |
/ |
507) |
= |
-4.85996053 |
7 |
98259 |
2532 |
- |
2567 |
= |
-35 |
* |
(88 |
/ |
507) |
= |
-6.07495067 |
8 |
98260 |
2537 |
- |
2586 |
= |
-49 |
* |
(95 |
/ |
507) |
= |
-9.18145953 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Sonora Elementary
|
-19 |
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 |
98920 |
2471 |
- |
2436 |
= |
35 |
* |
(75 |
/ |
469) |
= |
5.59701492 |
4 |
98921 |
2494 |
- |
2485 |
= |
9 |
* |
(75 |
/ |
469) |
= |
1.43923241 |
5 |
98922 |
2507 |
- |
2528 |
= |
-21 |
* |
(82 |
/ |
469) |
= |
-3.67164179 |
6 |
98923 |
2515 |
- |
2552 |
= |
-37 |
* |
(66 |
/ |
469) |
= |
-5.206823 |
7 |
98924 |
2529 |
- |
2567 |
= |
-38 |
* |
(87 |
/ |
469) |
= |
-7.04904051 |
8 |
98925 |
2536 |
- |
2586 |
= |
-50 |
* |
(84 |
/ |
469) |
= |
-8.95522385 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Sonora Elementary
|
-18 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-32
|
-21
|
-17
|
-19
|
-18
|
-107.0 |
-21.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -3.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -39.4
For the lines, you have the data necessary to plot the chart.