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 |
3144073 |
2425 |
- |
2436 |
= |
-11 |
* |
(1287 |
/ |
9050) |
= |
-1.56430938 |
4 |
3144076 |
2469 |
- |
2485 |
= |
-16 |
* |
(1273 |
/ |
9050) |
= |
-2.25060773 |
5 |
3144077 |
2506 |
- |
2528 |
= |
-22 |
* |
(1300 |
/ |
9050) |
= |
-3.16022098 |
6 |
3144080 |
2516 |
- |
2552 |
= |
-36 |
* |
(1332 |
/ |
9050) |
= |
-5.29856352 |
7 |
3144081 |
2532 |
- |
2567 |
= |
-35 |
* |
(1245 |
/ |
9050) |
= |
-4.8149171 |
8 |
3144084 |
2541 |
- |
2586 |
= |
-45 |
* |
(1338 |
/ |
9050) |
= |
-6.65303864 |
11 |
3144085 |
2556 |
- |
2628 |
= |
-72 |
* |
(1275 |
/ |
9050) |
= |
-10.14364634 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Ventura Unified
|
-34 |
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 |
96916 |
2432 |
- |
2436 |
= |
-4 |
* |
(1204 |
/ |
8885) |
= |
-0.54203714 |
4 |
96919 |
2478 |
- |
2485 |
= |
-7 |
* |
(1299 |
/ |
8885) |
= |
-1.02341024 |
5 |
96920 |
2511 |
- |
2528 |
= |
-17 |
* |
(1258 |
/ |
8885) |
= |
-2.40697805 |
6 |
96922 |
2513 |
- |
2552 |
= |
-39 |
* |
(1309 |
/ |
8885) |
= |
-5.74575125 |
7 |
96924 |
2535 |
- |
2567 |
= |
-32 |
* |
(1330 |
/ |
8885) |
= |
-4.79009565 |
8 |
96927 |
2554 |
- |
2586 |
= |
-32 |
* |
(1241 |
/ |
8885) |
= |
-4.46955542 |
11 |
96929 |
2568 |
- |
2628 |
= |
-60 |
* |
(1244 |
/ |
8885) |
= |
-8.40067524 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Ventura Unified
|
-27 |
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 |
99716 |
2434 |
- |
2436 |
= |
-2 |
* |
(1204 |
/ |
9073) |
= |
-0.26540284 |
4 |
99717 |
2479 |
- |
2485 |
= |
-6 |
* |
(1242 |
/ |
9073) |
= |
-0.82133803 |
5 |
99720 |
2512 |
- |
2528 |
= |
-16 |
* |
(1314 |
/ |
9073) |
= |
-2.31720488 |
6 |
99721 |
2521 |
- |
2552 |
= |
-31 |
* |
(1295 |
/ |
9073) |
= |
-4.42466658 |
7 |
99724 |
2534 |
- |
2567 |
= |
-33 |
* |
(1305 |
/ |
9073) |
= |
-4.74650058 |
8 |
99726 |
2561 |
- |
2586 |
= |
-25 |
* |
(1339 |
/ |
9073) |
= |
-3.68951835 |
11 |
99727 |
2569 |
- |
2628 |
= |
-59 |
* |
(1374 |
/ |
9073) |
= |
-8.93486165 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Ventura Unified
|
-25 |
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 |
99873 |
2434 |
- |
2436 |
= |
-2 |
* |
(1183 |
/ |
8718) |
= |
-0.27139252 |
4 |
99874 |
2478 |
- |
2485 |
= |
-7 |
* |
(1205 |
/ |
8718) |
= |
-0.96753843 |
5 |
99877 |
2506 |
- |
2528 |
= |
-22 |
* |
(1246 |
/ |
8718) |
= |
-3.14429914 |
6 |
99878 |
2522 |
- |
2552 |
= |
-30 |
* |
(1290 |
/ |
8718) |
= |
-4.43909151 |
7 |
99881 |
2532 |
- |
2567 |
= |
-35 |
* |
(1289 |
/ |
8718) |
= |
-5.17492542 |
8 |
99882 |
2554 |
- |
2586 |
= |
-32 |
* |
(1269 |
/ |
8718) |
= |
-4.65794906 |
11 |
99885 |
2556 |
- |
2628 |
= |
-72 |
* |
(1236 |
/ |
8718) |
= |
-10.20784579 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Ventura Unified
|
-29 |
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 |
100541 |
2437 |
- |
2436 |
= |
1 |
* |
(1157 |
/ |
8409) |
= |
0.13759068 |
4 |
100542 |
2479 |
- |
2485 |
= |
-6 |
* |
(1171 |
/ |
8409) |
= |
-0.83553335 |
5 |
100543 |
2506 |
- |
2528 |
= |
-22 |
* |
(1188 |
/ |
8409) |
= |
-3.10809844 |
6 |
100544 |
2513 |
- |
2552 |
= |
-39 |
* |
(1211 |
/ |
8409) |
= |
-5.61648231 |
7 |
100545 |
2533 |
- |
2567 |
= |
-34 |
* |
(1278 |
/ |
8409) |
= |
-5.16732071 |
8 |
100546 |
2552 |
- |
2586 |
= |
-34 |
* |
(1247 |
/ |
8409) |
= |
-5.04197883 |
11 |
100547 |
2589 |
- |
2628 |
= |
-39 |
* |
(1157 |
/ |
8409) |
= |
-5.36603636 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Ventura Unified
|
-25 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-34
|
-27
|
-25
|
-29
|
-25
|
-140.0 |
-28.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -19.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -37.0
For the lines, you have the data necessary to plot the chart.