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 |
1639325 |
2394 |
- |
2436 |
= |
-42 |
* |
(1540 |
/ |
10428) |
= |
-6.20253161 |
4 |
1639326 |
2443 |
- |
2485 |
= |
-42 |
* |
(1469 |
/ |
10428) |
= |
-5.91657074 |
5 |
1639329 |
2463 |
- |
2528 |
= |
-65 |
* |
(1499 |
/ |
10428) |
= |
-9.34359413 |
6 |
1639330 |
2482 |
- |
2552 |
= |
-70 |
* |
(1455 |
/ |
10428) |
= |
-9.76697351 |
7 |
1639333 |
2496 |
- |
2567 |
= |
-71 |
* |
(1504 |
/ |
10428) |
= |
-10.24012268 |
8 |
1639334 |
2506 |
- |
2586 |
= |
-80 |
* |
(1510 |
/ |
10428) |
= |
-11.58419632 |
11 |
1639337 |
2536 |
- |
2628 |
= |
-92 |
* |
(1451 |
/ |
10428) |
= |
-12.80130412 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Alvord Unified
|
-66 |
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 |
51266 |
2397 |
- |
2436 |
= |
-39 |
* |
(1251 |
/ |
10185) |
= |
-4.79027979 |
4 |
51268 |
2445 |
- |
2485 |
= |
-40 |
* |
(1553 |
/ |
10185) |
= |
-6.0991654 |
5 |
51270 |
2470 |
- |
2528 |
= |
-58 |
* |
(1486 |
/ |
10185) |
= |
-8.46224837 |
6 |
51273 |
2486 |
- |
2552 |
= |
-66 |
* |
(1459 |
/ |
10185) |
= |
-9.45449188 |
7 |
51274 |
2506 |
- |
2567 |
= |
-61 |
* |
(1484 |
/ |
10185) |
= |
-8.88797249 |
8 |
51277 |
2533 |
- |
2586 |
= |
-53 |
* |
(1489 |
/ |
10185) |
= |
-7.74835541 |
11 |
51279 |
2552 |
- |
2628 |
= |
-76 |
* |
(1463 |
/ |
10185) |
= |
-10.91683844 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Alvord Unified
|
-56 |
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 |
52733 |
2402 |
- |
2436 |
= |
-34 |
* |
(1460 |
/ |
10143) |
= |
-4.89401556 |
4 |
52736 |
2445 |
- |
2485 |
= |
-40 |
* |
(1281 |
/ |
10143) |
= |
-5.0517598 |
5 |
52738 |
2467 |
- |
2528 |
= |
-61 |
* |
(1559 |
/ |
10143) |
= |
-9.37582566 |
6 |
52739 |
2486 |
- |
2552 |
= |
-66 |
* |
(1423 |
/ |
10143) |
= |
-9.25939067 |
7 |
52742 |
2495 |
- |
2567 |
= |
-72 |
* |
(1472 |
/ |
10143) |
= |
-10.44897955 |
8 |
52744 |
2525 |
- |
2586 |
= |
-61 |
* |
(1482 |
/ |
10143) |
= |
-8.9127477 |
11 |
52746 |
2532 |
- |
2628 |
= |
-96 |
* |
(1466 |
/ |
10143) |
= |
-13.8751848 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Alvord Unified
|
-62 |
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 |
52821 |
2410 |
- |
2436 |
= |
-26 |
* |
(1352 |
/ |
9959) |
= |
-3.52967165 |
4 |
52823 |
2447 |
- |
2485 |
= |
-38 |
* |
(1461 |
/ |
9959) |
= |
-5.57465609 |
5 |
52825 |
2467 |
- |
2528 |
= |
-61 |
* |
(1292 |
/ |
9959) |
= |
-7.9136459 |
6 |
52826 |
2490 |
- |
2552 |
= |
-62 |
* |
(1487 |
/ |
9959) |
= |
-9.2573551 |
7 |
52829 |
2496 |
- |
2567 |
= |
-71 |
* |
(1465 |
/ |
9959) |
= |
-10.44432166 |
8 |
52831 |
2512 |
- |
2586 |
= |
-74 |
* |
(1436 |
/ |
9959) |
= |
-10.67014754 |
11 |
52832 |
2517 |
- |
2628 |
= |
-111 |
* |
(1466 |
/ |
9959) |
= |
-16.33959227 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Alvord Unified
|
-64 |
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 |
53063 |
2405 |
- |
2436 |
= |
-31 |
* |
(1398 |
/ |
9704) |
= |
-4.46599339 |
4 |
53064 |
2454 |
- |
2485 |
= |
-31 |
* |
(1322 |
/ |
9704) |
= |
-4.22320691 |
5 |
53065 |
2468 |
- |
2528 |
= |
-60 |
* |
(1464 |
/ |
9704) |
= |
-9.05193732 |
6 |
53066 |
2487 |
- |
2552 |
= |
-65 |
* |
(1220 |
/ |
9704) |
= |
-8.17188788 |
7 |
53067 |
2497 |
- |
2567 |
= |
-70 |
* |
(1502 |
/ |
9704) |
= |
-10.83470731 |
8 |
53068 |
2515 |
- |
2586 |
= |
-71 |
* |
(1415 |
/ |
9704) |
= |
-10.35294722 |
11 |
53069 |
2531 |
- |
2628 |
= |
-97 |
* |
(1383 |
/ |
9704) |
= |
-13.82429925 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Alvord Unified
|
-61 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-66
|
-56
|
-62
|
-64
|
-61
|
-309.0 |
-61.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -52.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -70.8
For the lines, you have the data necessary to plot the chart.