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 |
118227 |
2489 |
- |
2436 |
= |
53 |
* |
(1024 |
/ |
7906) |
= |
6.86465975 |
4 |
118230 |
2523 |
- |
2485 |
= |
38 |
* |
(1124 |
/ |
7906) |
= |
5.40247911 |
5 |
118231 |
2565 |
- |
2528 |
= |
37 |
* |
(1123 |
/ |
7906) |
= |
5.25562863 |
6 |
118234 |
2601 |
- |
2552 |
= |
49 |
* |
(1173 |
/ |
7906) |
= |
7.27004802 |
7 |
118235 |
2626 |
- |
2567 |
= |
59 |
* |
(1162 |
/ |
7906) |
= |
8.67164176 |
8 |
118238 |
2646 |
- |
2586 |
= |
60 |
* |
(1192 |
/ |
7906) |
= |
9.0462939 |
11 |
118239 |
2679 |
- |
2628 |
= |
51 |
* |
(1108 |
/ |
7906) |
= |
7.14748292 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Pleasanton Unified
|
50 |
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 |
3288 |
2499 |
- |
2436 |
= |
63 |
* |
(1010 |
/ |
7882) |
= |
8.0728241 |
4 |
3290 |
2534 |
- |
2485 |
= |
49 |
* |
(1058 |
/ |
7882) |
= |
6.57726461 |
5 |
3291 |
2581 |
- |
2528 |
= |
53 |
* |
(1156 |
/ |
7882) |
= |
7.773154 |
6 |
3294 |
2611 |
- |
2552 |
= |
59 |
* |
(1188 |
/ |
7882) |
= |
8.89266679 |
7 |
3296 |
2634 |
- |
2567 |
= |
67 |
* |
(1209 |
/ |
7882) |
= |
10.27696016 |
8 |
3298 |
2653 |
- |
2586 |
= |
67 |
* |
(1188 |
/ |
7882) |
= |
10.09845212 |
11 |
3300 |
2689 |
- |
2628 |
= |
61 |
* |
(1073 |
/ |
7882) |
= |
8.30411062 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Pleasanton Unified
|
60 |
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 |
3399 |
2501 |
- |
2436 |
= |
65 |
* |
(1028 |
/ |
8028) |
= |
8.32336817 |
4 |
3402 |
2536 |
- |
2485 |
= |
51 |
* |
(1054 |
/ |
8028) |
= |
6.69581463 |
5 |
3403 |
2576 |
- |
2528 |
= |
48 |
* |
(1094 |
/ |
8028) |
= |
6.54110611 |
6 |
3406 |
2613 |
- |
2552 |
= |
61 |
* |
(1222 |
/ |
8028) |
= |
9.28525158 |
7 |
3408 |
2635 |
- |
2567 |
= |
68 |
* |
(1236 |
/ |
8028) |
= |
10.46935725 |
8 |
3410 |
2658 |
- |
2586 |
= |
72 |
* |
(1228 |
/ |
8028) |
= |
11.01345286 |
11 |
3411 |
2692 |
- |
2628 |
= |
64 |
* |
(1166 |
/ |
8028) |
= |
9.29546586 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Pleasanton 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 |
3399 |
2499 |
- |
2436 |
= |
63 |
* |
(1005 |
/ |
7992) |
= |
7.92229725 |
4 |
3401 |
2543 |
- |
2485 |
= |
58 |
* |
(1095 |
/ |
7992) |
= |
7.9466967 |
5 |
3403 |
2579 |
- |
2528 |
= |
51 |
* |
(1105 |
/ |
7992) |
= |
7.05142641 |
6 |
3405 |
2612 |
- |
2552 |
= |
60 |
* |
(1152 |
/ |
7992) |
= |
8.64864864 |
7 |
3407 |
2642 |
- |
2567 |
= |
75 |
* |
(1245 |
/ |
7992) |
= |
11.6835585 |
8 |
3409 |
2657 |
- |
2586 |
= |
71 |
* |
(1239 |
/ |
7992) |
= |
11.00713213 |
11 |
3411 |
2682 |
- |
2628 |
= |
54 |
* |
(1151 |
/ |
7992) |
= |
7.77702703 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Pleasanton Unified
|
62 |
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 |
3449 |
2502 |
- |
2436 |
= |
66 |
* |
(1059 |
/ |
7940) |
= |
8.80277072 |
4 |
3450 |
2537 |
- |
2485 |
= |
52 |
* |
(1034 |
/ |
7940) |
= |
6.7717884 |
5 |
3451 |
2586 |
- |
2528 |
= |
58 |
* |
(1100 |
/ |
7940) |
= |
8.03526444 |
6 |
3452 |
2601 |
- |
2552 |
= |
49 |
* |
(1123 |
/ |
7940) |
= |
6.93035263 |
7 |
3453 |
2636 |
- |
2567 |
= |
69 |
* |
(1183 |
/ |
7940) |
= |
10.28047857 |
8 |
3454 |
2657 |
- |
2586 |
= |
71 |
* |
(1255 |
/ |
7940) |
= |
11.22229216 |
11 |
3455 |
2680 |
- |
2628 |
= |
52 |
* |
(1186 |
/ |
7940) |
= |
7.7672544 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Pleasanton Unified
|
60 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
50
|
60
|
62
|
62
|
60
|
294.0 |
58.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 73.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 43.8
For the lines, you have the data necessary to plot the chart.