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 |
1020375 |
2381 |
- |
2436 |
= |
-55 |
* |
(207 |
/ |
1160) |
= |
-9.81465513 |
4 |
1020376 |
2430 |
- |
2485 |
= |
-55 |
* |
(187 |
/ |
1160) |
= |
-8.86637928 |
5 |
1020379 |
2449 |
- |
2528 |
= |
-79 |
* |
(177 |
/ |
1160) |
= |
-12.05431027 |
6 |
1020380 |
2456 |
- |
2552 |
= |
-96 |
* |
(194 |
/ |
1160) |
= |
-16.05517238 |
7 |
1020383 |
2479 |
- |
2567 |
= |
-88 |
* |
(195 |
/ |
1160) |
= |
-14.79310342 |
8 |
1020384 |
2508 |
- |
2586 |
= |
-78 |
* |
(200 |
/ |
1160) |
= |
-13.44827585 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Los Nietos
|
-75 |
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 |
32028 |
2401 |
- |
2436 |
= |
-35 |
* |
(194 |
/ |
1121) |
= |
-6.05709188 |
4 |
32031 |
2432 |
- |
2485 |
= |
-53 |
* |
(209 |
/ |
1121) |
= |
-9.88135588 |
5 |
32033 |
2466 |
- |
2528 |
= |
-62 |
* |
(188 |
/ |
1121) |
= |
-10.39785905 |
6 |
32034 |
2480 |
- |
2552 |
= |
-72 |
* |
(165 |
/ |
1121) |
= |
-10.59768058 |
7 |
32037 |
2482 |
- |
2567 |
= |
-85 |
* |
(181 |
/ |
1121) |
= |
-13.72435322 |
8 |
32038 |
2514 |
- |
2586 |
= |
-72 |
* |
(184 |
/ |
1121) |
= |
-11.81801959 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Los Nietos
|
-62 |
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 |
32553 |
2407 |
- |
2436 |
= |
-29 |
* |
(177 |
/ |
1096) |
= |
-4.68339415 |
4 |
32554 |
2445 |
- |
2485 |
= |
-40 |
* |
(192 |
/ |
1096) |
= |
-7.00729924 |
5 |
32557 |
2451 |
- |
2528 |
= |
-77 |
* |
(214 |
/ |
1096) |
= |
-15.0346715 |
6 |
32559 |
2508 |
- |
2552 |
= |
-44 |
* |
(184 |
/ |
1096) |
= |
-7.38686128 |
7 |
32561 |
2493 |
- |
2567 |
= |
-74 |
* |
(154 |
/ |
1096) |
= |
-10.39781015 |
8 |
32563 |
2522 |
- |
2586 |
= |
-64 |
* |
(175 |
/ |
1096) |
= |
-10.21897805 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Los Nietos
|
-55 |
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 |
32571 |
2413 |
- |
2436 |
= |
-23 |
* |
(163 |
/ |
1083) |
= |
-3.4616805 |
4 |
32573 |
2460 |
- |
2485 |
= |
-25 |
* |
(178 |
/ |
1083) |
= |
-4.1089566 |
5 |
32575 |
2478 |
- |
2528 |
= |
-50 |
* |
(189 |
/ |
1083) |
= |
-8.72576175 |
6 |
32577 |
2495 |
- |
2552 |
= |
-57 |
* |
(216 |
/ |
1083) |
= |
-11.36842103 |
7 |
32579 |
2525 |
- |
2567 |
= |
-42 |
* |
(184 |
/ |
1083) |
= |
-7.13573406 |
8 |
32581 |
2536 |
- |
2586 |
= |
-50 |
* |
(153 |
/ |
1083) |
= |
-7.0637119 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Los Nietos
|
-42 |
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 |
32757 |
2428 |
- |
2436 |
= |
-8 |
* |
(152 |
/ |
1025) |
= |
-1.18634146 |
4 |
32758 |
2471 |
- |
2485 |
= |
-14 |
* |
(154 |
/ |
1025) |
= |
-2.10341463 |
5 |
32759 |
2489 |
- |
2528 |
= |
-39 |
* |
(179 |
/ |
1025) |
= |
-6.81073169 |
6 |
32760 |
2507 |
- |
2552 |
= |
-45 |
* |
(181 |
/ |
1025) |
= |
-7.94634143 |
7 |
32761 |
2500 |
- |
2567 |
= |
-67 |
* |
(191 |
/ |
1025) |
= |
-12.48487802 |
8 |
32762 |
2567 |
- |
2586 |
= |
-19 |
* |
(168 |
/ |
1025) |
= |
-3.11414634 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Los Nietos
|
-34 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-75
|
-62
|
-55
|
-42
|
-34
|
-268.0 |
-53.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -5.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -101.6
For the lines, you have the data necessary to plot the chart.