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 |
176867 |
2385 |
- |
2436 |
= |
-51 |
* |
(1342 |
/ |
8948) |
= |
-7.64886005 |
4 |
176868 |
2432 |
- |
2485 |
= |
-53 |
* |
(1222 |
/ |
8948) |
= |
-7.23804199 |
5 |
176871 |
2446 |
- |
2528 |
= |
-82 |
* |
(1315 |
/ |
8948) |
= |
-12.05073755 |
6 |
176872 |
2480 |
- |
2552 |
= |
-72 |
* |
(1254 |
/ |
8948) |
= |
-10.09029946 |
7 |
176875 |
2477 |
- |
2567 |
= |
-90 |
* |
(1257 |
/ |
8948) |
= |
-12.64304871 |
8 |
176876 |
2480 |
- |
2586 |
= |
-106 |
* |
(1341 |
/ |
8948) |
= |
-15.88578445 |
11 |
176879 |
2515 |
- |
2628 |
= |
-113 |
* |
(1217 |
/ |
8948) |
= |
-15.3689092 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Antioch Unified
|
-81 |
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 |
5334 |
2384 |
- |
2436 |
= |
-52 |
* |
(1299 |
/ |
8671) |
= |
-7.79010492 |
4 |
5335 |
2424 |
- |
2485 |
= |
-61 |
* |
(1335 |
/ |
8671) |
= |
-9.39165028 |
5 |
5338 |
2448 |
- |
2528 |
= |
-80 |
* |
(1256 |
/ |
8671) |
= |
-11.58805208 |
6 |
5340 |
2467 |
- |
2552 |
= |
-85 |
* |
(1191 |
/ |
8671) |
= |
-11.67512392 |
7 |
5341 |
2484 |
- |
2567 |
= |
-83 |
* |
(1217 |
/ |
8671) |
= |
-11.6492907 |
8 |
5344 |
2479 |
- |
2586 |
= |
-107 |
* |
(1210 |
/ |
8671) |
= |
-14.93138038 |
11 |
5346 |
2540 |
- |
2628 |
= |
-88 |
* |
(1163 |
/ |
8671) |
= |
-11.80302156 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Antioch Unified
|
-79 |
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 |
5449 |
2384 |
- |
2436 |
= |
-52 |
* |
(1240 |
/ |
8691) |
= |
-7.41916921 |
4 |
5452 |
2422 |
- |
2485 |
= |
-63 |
* |
(1309 |
/ |
8691) |
= |
-9.48878148 |
5 |
5453 |
2445 |
- |
2528 |
= |
-83 |
* |
(1280 |
/ |
8691) |
= |
-12.2241399 |
6 |
5456 |
2472 |
- |
2552 |
= |
-80 |
* |
(1172 |
/ |
8691) |
= |
-10.7881716 |
7 |
5458 |
2468 |
- |
2567 |
= |
-99 |
* |
(1185 |
/ |
8691) |
= |
-13.49844665 |
8 |
5460 |
2475 |
- |
2586 |
= |
-111 |
* |
(1249 |
/ |
8691) |
= |
-15.95201924 |
11 |
5462 |
2522 |
- |
2628 |
= |
-106 |
* |
(1256 |
/ |
8691) |
= |
-15.3188355 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Antioch Unified
|
-85 |
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 |
5446 |
2382 |
- |
2436 |
= |
-54 |
* |
(1178 |
/ |
8524) |
= |
-7.46269357 |
4 |
5447 |
2419 |
- |
2485 |
= |
-66 |
* |
(1238 |
/ |
8524) |
= |
-9.58564048 |
5 |
5450 |
2432 |
- |
2528 |
= |
-96 |
* |
(1268 |
/ |
8524) |
= |
-14.28061939 |
6 |
5451 |
2466 |
- |
2552 |
= |
-86 |
* |
(1232 |
/ |
8524) |
= |
-12.42984514 |
7 |
5454 |
2470 |
- |
2567 |
= |
-97 |
* |
(1159 |
/ |
8524) |
= |
-13.18899572 |
8 |
5455 |
2469 |
- |
2586 |
= |
-117 |
* |
(1203 |
/ |
8524) |
= |
-16.51231811 |
11 |
5458 |
2504 |
- |
2628 |
= |
-124 |
* |
(1246 |
/ |
8524) |
= |
-18.1257625 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Antioch Unified
|
-92 |
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 |
5505 |
2383 |
- |
2436 |
= |
-53 |
* |
(1145 |
/ |
8329) |
= |
-7.28598871 |
4 |
5506 |
2423 |
- |
2485 |
= |
-62 |
* |
(1132 |
/ |
8329) |
= |
-8.42646173 |
5 |
5507 |
2431 |
- |
2528 |
= |
-97 |
* |
(1242 |
/ |
8329) |
= |
-14.46440148 |
6 |
5508 |
2449 |
- |
2552 |
= |
-103 |
* |
(1240 |
/ |
8329) |
= |
-15.33437385 |
7 |
5509 |
2462 |
- |
2567 |
= |
-105 |
* |
(1226 |
/ |
8329) |
= |
-15.45563691 |
8 |
5510 |
2461 |
- |
2586 |
= |
-125 |
* |
(1163 |
/ |
8329) |
= |
-17.454076 |
11 |
5511 |
2502 |
- |
2628 |
= |
-126 |
* |
(1181 |
/ |
8329) |
= |
-17.86601023 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Antioch Unified
|
-96 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-81
|
-79
|
-85
|
-92
|
-96
|
-433.0 |
-86.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -65.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -107.6
For the lines, you have the data necessary to plot the chart.