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 |
664278 |
2419 |
- |
2436 |
= |
-17 |
* |
(800 |
/ |
6195) |
= |
-2.1953188 |
4 |
664281 |
2444 |
- |
2485 |
= |
-41 |
* |
(837 |
/ |
6195) |
= |
-5.53946728 |
5 |
664282 |
2484 |
- |
2528 |
= |
-44 |
* |
(871 |
/ |
6195) |
= |
-6.18627922 |
6 |
664285 |
2489 |
- |
2552 |
= |
-63 |
* |
(794 |
/ |
6195) |
= |
-8.07457625 |
7 |
664286 |
2507 |
- |
2567 |
= |
-60 |
* |
(861 |
/ |
6195) |
= |
-8.338983 |
8 |
664289 |
2521 |
- |
2586 |
= |
-65 |
* |
(907 |
/ |
6195) |
= |
-9.51654555 |
11 |
664290 |
2558 |
- |
2628 |
= |
-70 |
* |
(1125 |
/ |
6195) |
= |
-12.71186434 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Covina-Valley Unified
|
-53 |
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 |
21085 |
2436 |
- |
2436 |
= |
0 |
* |
(758 |
/ |
6060) |
= |
0.0 |
4 |
21088 |
2460 |
- |
2485 |
= |
-25 |
* |
(785 |
/ |
6060) |
= |
-3.23844883 |
5 |
21090 |
2492 |
- |
2528 |
= |
-36 |
* |
(868 |
/ |
6060) |
= |
-5.15643563 |
6 |
21092 |
2503 |
- |
2552 |
= |
-49 |
* |
(849 |
/ |
6060) |
= |
-6.86485144 |
7 |
21094 |
2507 |
- |
2567 |
= |
-60 |
* |
(805 |
/ |
6060) |
= |
-7.97029698 |
8 |
21095 |
2530 |
- |
2586 |
= |
-56 |
* |
(860 |
/ |
6060) |
= |
-7.9471947 |
11 |
21097 |
2557 |
- |
2628 |
= |
-71 |
* |
(1135 |
/ |
6060) |
= |
-13.29785476 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Covina-Valley Unified
|
-44 |
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 |
21444 |
2442 |
- |
2436 |
= |
6 |
* |
(820 |
/ |
6106) |
= |
0.80576482 |
4 |
21446 |
2464 |
- |
2485 |
= |
-21 |
* |
(769 |
/ |
6106) |
= |
-2.64477562 |
5 |
21447 |
2491 |
- |
2528 |
= |
-37 |
* |
(818 |
/ |
6106) |
= |
-4.95676383 |
6 |
21449 |
2513 |
- |
2552 |
= |
-39 |
* |
(846 |
/ |
6106) |
= |
-5.40353748 |
7 |
21451 |
2520 |
- |
2567 |
= |
-47 |
* |
(896 |
/ |
6106) |
= |
-6.89682277 |
8 |
21453 |
2534 |
- |
2586 |
= |
-52 |
* |
(808 |
/ |
6106) |
= |
-6.88110051 |
11 |
21456 |
2557 |
- |
2628 |
= |
-71 |
* |
(1149 |
/ |
6106) |
= |
-13.36046512 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Covina-Valley Unified
|
-39 |
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 |
21430 |
2451 |
- |
2436 |
= |
15 |
* |
(724 |
/ |
5923) |
= |
1.8335303 |
4 |
21433 |
2474 |
- |
2485 |
= |
-11 |
* |
(825 |
/ |
5923) |
= |
-1.53216275 |
5 |
21434 |
2498 |
- |
2528 |
= |
-30 |
* |
(753 |
/ |
5923) |
= |
-3.81394563 |
6 |
21437 |
2505 |
- |
2552 |
= |
-47 |
* |
(828 |
/ |
5923) |
= |
-6.57031908 |
7 |
21438 |
2517 |
- |
2567 |
= |
-50 |
* |
(870 |
/ |
5923) |
= |
-7.3442512 |
8 |
21441 |
2524 |
- |
2586 |
= |
-62 |
* |
(886 |
/ |
5923) |
= |
-9.2743542 |
11 |
21442 |
2556 |
- |
2628 |
= |
-72 |
* |
(1037 |
/ |
5923) |
= |
-12.60577404 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Covina-Valley Unified
|
-39 |
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 |
21602 |
2447 |
- |
2436 |
= |
11 |
* |
(739 |
/ |
5794) |
= |
1.4030031 |
4 |
21603 |
2481 |
- |
2485 |
= |
-4 |
* |
(739 |
/ |
5794) |
= |
-0.51018294 |
5 |
21604 |
2503 |
- |
2528 |
= |
-25 |
* |
(837 |
/ |
5794) |
= |
-3.61149463 |
6 |
21605 |
2500 |
- |
2552 |
= |
-52 |
* |
(769 |
/ |
5794) |
= |
-6.90162236 |
7 |
21606 |
2514 |
- |
2567 |
= |
-53 |
* |
(826 |
/ |
5794) |
= |
-7.55574731 |
8 |
21607 |
2539 |
- |
2586 |
= |
-47 |
* |
(880 |
/ |
5794) |
= |
-7.13841903 |
11 |
21608 |
2564 |
- |
2628 |
= |
-64 |
* |
(1004 |
/ |
5794) |
= |
-11.09009318 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Covina-Valley Unified
|
-35 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-53
|
-44
|
-39
|
-39
|
-35
|
-210.0 |
-42.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -24.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -60.0
For the lines, you have the data necessary to plot the chart.