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 |
102711 |
2508 |
- |
2436 |
= |
72 |
* |
(194 |
/ |
1428) |
= |
9.78151255 |
4 |
102712 |
2539 |
- |
2485 |
= |
54 |
* |
(205 |
/ |
1428) |
= |
7.75210079 |
5 |
102715 |
2602 |
- |
2528 |
= |
74 |
* |
(233 |
/ |
1428) |
= |
12.07422968 |
6 |
102716 |
2625 |
- |
2552 |
= |
73 |
* |
(225 |
/ |
1428) |
= |
11.50210083 |
7 |
102719 |
2630 |
- |
2567 |
= |
63 |
* |
(192 |
/ |
1428) |
= |
8.4705882 |
8 |
102720 |
2663 |
- |
2586 |
= |
77 |
* |
(208 |
/ |
1428) |
= |
11.21568625 |
11 |
102723 |
2695 |
- |
2628 |
= |
67 |
* |
(171 |
/ |
1428) |
= |
8.02310923 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Piedmont City Unified
|
69 |
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 |
2889 |
2527 |
- |
2436 |
= |
91 |
* |
(217 |
/ |
1505) |
= |
13.12093019 |
4 |
2892 |
2563 |
- |
2485 |
= |
78 |
* |
(197 |
/ |
1505) |
= |
10.2099667 |
5 |
2893 |
2595 |
- |
2528 |
= |
67 |
* |
(214 |
/ |
1505) |
= |
9.5269103 |
6 |
2895 |
2631 |
- |
2552 |
= |
79 |
* |
(244 |
/ |
1505) |
= |
12.80797336 |
7 |
2898 |
2658 |
- |
2567 |
= |
91 |
* |
(228 |
/ |
1505) |
= |
13.78604646 |
8 |
2900 |
2656 |
- |
2586 |
= |
70 |
* |
(193 |
/ |
1505) |
= |
8.97674414 |
11 |
2901 |
2700 |
- |
2628 |
= |
72 |
* |
(212 |
/ |
1505) |
= |
10.14219266 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Piedmont City Unified
|
79 |
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 |
2963 |
2523 |
- |
2436 |
= |
87 |
* |
(181 |
/ |
1484) |
= |
10.6111859 |
4 |
2965 |
2565 |
- |
2485 |
= |
80 |
* |
(222 |
/ |
1484) |
= |
11.96765496 |
5 |
2967 |
2598 |
- |
2528 |
= |
70 |
* |
(204 |
/ |
1484) |
= |
9.62264149 |
6 |
2969 |
2617 |
- |
2552 |
= |
65 |
* |
(202 |
/ |
1484) |
= |
8.84770887 |
7 |
2971 |
2664 |
- |
2567 |
= |
97 |
* |
(245 |
/ |
1484) |
= |
16.01415088 |
8 |
2974 |
2670 |
- |
2586 |
= |
84 |
* |
(237 |
/ |
1484) |
= |
13.41509434 |
11 |
2975 |
2679 |
- |
2628 |
= |
51 |
* |
(193 |
/ |
1484) |
= |
6.63274931 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Piedmont City Unified
|
77 |
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 |
2965 |
2524 |
- |
2436 |
= |
88 |
* |
(159 |
/ |
1437) |
= |
9.73695193 |
4 |
2967 |
2574 |
- |
2485 |
= |
89 |
* |
(184 |
/ |
1437) |
= |
11.39596379 |
5 |
2969 |
2605 |
- |
2528 |
= |
77 |
* |
(222 |
/ |
1437) |
= |
11.89561581 |
6 |
2971 |
2624 |
- |
2552 |
= |
72 |
* |
(208 |
/ |
1437) |
= |
10.42171186 |
7 |
2973 |
2652 |
- |
2567 |
= |
85 |
* |
(212 |
/ |
1437) |
= |
12.54001388 |
8 |
2975 |
2683 |
- |
2586 |
= |
97 |
* |
(242 |
/ |
1437) |
= |
16.33542099 |
11 |
2977 |
2683 |
- |
2628 |
= |
55 |
* |
(210 |
/ |
1437) |
= |
8.03757829 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Piedmont City Unified
|
80 |
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 |
2993 |
2530 |
- |
2436 |
= |
94 |
* |
(157 |
/ |
1348) |
= |
10.94807115 |
4 |
2994 |
2564 |
- |
2485 |
= |
79 |
* |
(163 |
/ |
1348) |
= |
9.5526706 |
5 |
2995 |
2607 |
- |
2528 |
= |
79 |
* |
(187 |
/ |
1348) |
= |
10.95919877 |
6 |
2996 |
2633 |
- |
2552 |
= |
81 |
* |
(230 |
/ |
1348) |
= |
13.82047475 |
7 |
2997 |
2651 |
- |
2567 |
= |
84 |
* |
(209 |
/ |
1348) |
= |
13.02373884 |
8 |
2998 |
2676 |
- |
2586 |
= |
90 |
* |
(208 |
/ |
1348) |
= |
13.8872403 |
11 |
2999 |
2701 |
- |
2628 |
= |
73 |
* |
(194 |
/ |
1348) |
= |
10.50593465 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Piedmont City Unified
|
83 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
69
|
79
|
77
|
80
|
83
|
388.0 |
77.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 92.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 62.6
For the lines, you have the data necessary to plot the chart.