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 |
373386 |
2403 |
- |
2436 |
= |
-33 |
* |
(1187 |
/ |
8078) |
= |
-4.8490963 |
4 |
373387 |
2435 |
- |
2485 |
= |
-50 |
* |
(1183 |
/ |
8078) |
= |
-7.322357 |
5 |
373390 |
2459 |
- |
2528 |
= |
-69 |
* |
(1189 |
/ |
8078) |
= |
-10.15610296 |
6 |
373391 |
2482 |
- |
2552 |
= |
-70 |
* |
(1159 |
/ |
8078) |
= |
-10.04332749 |
7 |
373393 |
2487 |
- |
2567 |
= |
-80 |
* |
(1223 |
/ |
8078) |
= |
-12.11190888 |
8 |
373395 |
2492 |
- |
2586 |
= |
-94 |
* |
(1147 |
/ |
8078) |
= |
-13.34711555 |
11 |
373397 |
2508 |
- |
2628 |
= |
-120 |
* |
(990 |
/ |
8078) |
= |
-14.70661044 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Central Unified
|
-73 |
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 |
11331 |
2413 |
- |
2436 |
= |
-23 |
* |
(1191 |
/ |
8288) |
= |
-3.30513995 |
4 |
11333 |
2441 |
- |
2485 |
= |
-44 |
* |
(1219 |
/ |
8288) |
= |
-6.47152506 |
5 |
11336 |
2465 |
- |
2528 |
= |
-63 |
* |
(1195 |
/ |
8288) |
= |
-9.08361481 |
6 |
11337 |
2492 |
- |
2552 |
= |
-60 |
* |
(1212 |
/ |
8288) |
= |
-8.77413126 |
7 |
11340 |
2491 |
- |
2567 |
= |
-76 |
* |
(1215 |
/ |
8288) |
= |
-11.14140924 |
8 |
11342 |
2507 |
- |
2586 |
= |
-79 |
* |
(1222 |
/ |
8288) |
= |
-11.64792464 |
11 |
11344 |
2513 |
- |
2628 |
= |
-115 |
* |
(1034 |
/ |
8288) |
= |
-14.34724901 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Central Unified
|
-65 |
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 |
11656 |
2425 |
- |
2436 |
= |
-11 |
* |
(1160 |
/ |
8200) |
= |
-1.55609755 |
4 |
11658 |
2457 |
- |
2485 |
= |
-28 |
* |
(1202 |
/ |
8200) |
= |
-4.10439022 |
5 |
11660 |
2465 |
- |
2528 |
= |
-63 |
* |
(1221 |
/ |
8200) |
= |
-9.38085366 |
6 |
11661 |
2502 |
- |
2552 |
= |
-50 |
* |
(1218 |
/ |
8200) |
= |
-7.42682925 |
7 |
11663 |
2495 |
- |
2567 |
= |
-72 |
* |
(1219 |
/ |
8200) |
= |
-10.70341459 |
8 |
11666 |
2503 |
- |
2586 |
= |
-83 |
* |
(1197 |
/ |
8200) |
= |
-12.11597555 |
11 |
11668 |
2515 |
- |
2628 |
= |
-113 |
* |
(983 |
/ |
8200) |
= |
-13.54621942 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Central Unified
|
-59 |
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 |
11687 |
2433 |
- |
2436 |
= |
-3 |
* |
(1149 |
/ |
8142) |
= |
-0.42336035 |
4 |
11690 |
2460 |
- |
2485 |
= |
-25 |
* |
(1154 |
/ |
8142) |
= |
-3.54335543 |
5 |
11691 |
2479 |
- |
2528 |
= |
-49 |
* |
(1191 |
/ |
8142) |
= |
-7.1676492 |
6 |
11693 |
2499 |
- |
2552 |
= |
-53 |
* |
(1254 |
/ |
8142) |
= |
-8.16285924 |
7 |
11695 |
2501 |
- |
2567 |
= |
-66 |
* |
(1215 |
/ |
8142) |
= |
-9.84893144 |
8 |
11698 |
2502 |
- |
2586 |
= |
-84 |
* |
(1197 |
/ |
8142) |
= |
-12.3492999 |
11 |
11699 |
2512 |
- |
2628 |
= |
-116 |
* |
(982 |
/ |
8142) |
= |
-13.99066558 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Central Unified
|
-55 |
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 |
11783 |
2430 |
- |
2436 |
= |
-6 |
* |
(1155 |
/ |
8103) |
= |
-0.8552388 |
4 |
11784 |
2467 |
- |
2485 |
= |
-18 |
* |
(1136 |
/ |
8103) |
= |
-2.5235098 |
5 |
11785 |
2484 |
- |
2528 |
= |
-44 |
* |
(1148 |
/ |
8103) |
= |
-6.23374057 |
6 |
11786 |
2513 |
- |
2552 |
= |
-39 |
* |
(1190 |
/ |
8103) |
= |
-5.72750829 |
7 |
11787 |
2502 |
- |
2567 |
= |
-65 |
* |
(1288 |
/ |
8103) |
= |
-10.33197581 |
8 |
11788 |
2522 |
- |
2586 |
= |
-64 |
* |
(1177 |
/ |
8103) |
= |
-9.29630995 |
11 |
11789 |
2507 |
- |
2628 |
= |
-121 |
* |
(1009 |
/ |
8103) |
= |
-15.06713562 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Central Unified
|
-50 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-73
|
-65
|
-59
|
-55
|
-50
|
-302.0 |
-60.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -36.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -84.4
For the lines, you have the data necessary to plot the chart.