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 |
203109 |
2422 |
- |
2436 |
= |
-14 |
* |
(2660 |
/ |
16612) |
= |
-2.24175294 |
4 |
203112 |
2461 |
- |
2485 |
= |
-24 |
* |
(2515 |
/ |
16612) |
= |
-3.63351792 |
5 |
203113 |
2491 |
- |
2528 |
= |
-37 |
* |
(2528 |
/ |
16612) |
= |
-5.63062844 |
6 |
203116 |
2504 |
- |
2552 |
= |
-48 |
* |
(2426 |
/ |
16612) |
= |
-7.00987234 |
7 |
203117 |
2533 |
- |
2567 |
= |
-34 |
* |
(2448 |
/ |
16612) |
= |
-5.01035393 |
8 |
203120 |
2544 |
- |
2586 |
= |
-42 |
* |
(2407 |
/ |
16612) |
= |
-6.08560075 |
11 |
203121 |
2575 |
- |
2628 |
= |
-53 |
* |
(1628 |
/ |
16612) |
= |
-5.19407653 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Mt. Diablo Unified
|
-35 |
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 |
6038 |
2428 |
- |
2436 |
= |
-8 |
* |
(2535 |
/ |
16916) |
= |
-1.19886498 |
4 |
6040 |
2462 |
- |
2485 |
= |
-23 |
* |
(2685 |
/ |
16916) |
= |
-3.65068574 |
5 |
6042 |
2491 |
- |
2528 |
= |
-37 |
* |
(2505 |
/ |
16916) |
= |
-5.47913216 |
6 |
6044 |
2506 |
- |
2552 |
= |
-46 |
* |
(2477 |
/ |
16916) |
= |
-6.73575309 |
7 |
6045 |
2528 |
- |
2567 |
= |
-39 |
* |
(2445 |
/ |
16916) |
= |
-5.63697089 |
8 |
6048 |
2550 |
- |
2586 |
= |
-36 |
* |
(2460 |
/ |
16916) |
= |
-5.2352802 |
11 |
6050 |
2573 |
- |
2628 |
= |
-55 |
* |
(1809 |
/ |
16916) |
= |
-5.88170957 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Mt. Diablo Unified
|
-34 |
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 |
6214 |
2427 |
- |
2436 |
= |
-9 |
* |
(2400 |
/ |
16734) |
= |
-1.29078522 |
4 |
6215 |
2464 |
- |
2485 |
= |
-21 |
* |
(2512 |
/ |
16734) |
= |
-3.15238436 |
5 |
6218 |
2485 |
- |
2528 |
= |
-43 |
* |
(2670 |
/ |
16734) |
= |
-6.86088203 |
6 |
6220 |
2502 |
- |
2552 |
= |
-50 |
* |
(2398 |
/ |
16734) |
= |
-7.16505315 |
7 |
6222 |
2526 |
- |
2567 |
= |
-41 |
* |
(2428 |
/ |
16734) |
= |
-5.94884662 |
8 |
6224 |
2547 |
- |
2586 |
= |
-39 |
* |
(2409 |
/ |
16734) |
= |
-5.61437791 |
11 |
6225 |
2566 |
- |
2628 |
= |
-62 |
* |
(1917 |
/ |
16734) |
= |
-7.10254566 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Mt. Diablo Unified
|
-37 |
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 |
6204 |
2432 |
- |
2436 |
= |
-4 |
* |
(2405 |
/ |
16389) |
= |
-0.58697907 |
4 |
6205 |
2463 |
- |
2485 |
= |
-22 |
* |
(2375 |
/ |
16389) |
= |
-3.18811396 |
5 |
6208 |
2489 |
- |
2528 |
= |
-39 |
* |
(2468 |
/ |
16389) |
= |
-5.87296355 |
6 |
6209 |
2499 |
- |
2552 |
= |
-53 |
* |
(2519 |
/ |
16389) |
= |
-8.14613456 |
7 |
6212 |
2524 |
- |
2567 |
= |
-43 |
* |
(2390 |
/ |
16389) |
= |
-6.27066932 |
8 |
6213 |
2546 |
- |
2586 |
= |
-40 |
* |
(2429 |
/ |
16389) |
= |
-5.92836656 |
11 |
6216 |
2567 |
- |
2628 |
= |
-61 |
* |
(1803 |
/ |
16389) |
= |
-6.71078159 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Mt. Diablo Unified
|
-37 |
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 |
6269 |
2433 |
- |
2436 |
= |
-3 |
* |
(2375 |
/ |
16098) |
= |
-0.44260157 |
4 |
6270 |
2469 |
- |
2485 |
= |
-16 |
* |
(2403 |
/ |
16098) |
= |
-2.38837122 |
5 |
6271 |
2487 |
- |
2528 |
= |
-41 |
* |
(2381 |
/ |
16098) |
= |
-6.06416945 |
6 |
6272 |
2501 |
- |
2552 |
= |
-51 |
* |
(2308 |
/ |
16098) |
= |
-7.3119642 |
7 |
6273 |
2519 |
- |
2567 |
= |
-48 |
* |
(2485 |
/ |
16098) |
= |
-7.4096161 |
8 |
6274 |
2540 |
- |
2586 |
= |
-46 |
* |
(2364 |
/ |
16098) |
= |
-6.75512484 |
11 |
6275 |
2563 |
- |
2628 |
= |
-65 |
* |
(1782 |
/ |
16098) |
= |
-7.1953037 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Mt. Diablo Unified
|
-38 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-35
|
-34
|
-37
|
-37
|
-38
|
-181.0 |
-36.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -33.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -39.2
For the lines, you have the data necessary to plot the chart.