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 |
125721 |
0 |
- |
2436 |
= |
|
* |
(6 |
/ |
95) |
= |
|
4 |
125724 |
2331 |
- |
2485 |
= |
-154 |
* |
(13 |
/ |
95) |
= |
-21.07368417 |
5 |
125725 |
2356 |
- |
2528 |
= |
-172 |
* |
(21 |
/ |
95) |
= |
-38.02105253 |
6 |
125728 |
2326 |
- |
2552 |
= |
-226 |
* |
(4 |
/ |
95) |
= |
-9.51578944 |
7 |
125729 |
2465 |
- |
2567 |
= |
-102 |
* |
(40 |
/ |
95) |
= |
-42.94736836 |
8 |
125732 |
0 |
- |
2586 |
= |
|
* |
(7 |
/ |
95) |
= |
|
11 |
125733 |
0 |
- |
2628 |
= |
|
* |
(4 |
/ |
95) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Amador County Office of Education
|
-112 |
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 |
4 |
3544 |
0 |
- |
2485 |
= |
|
* |
(2 |
/ |
86) |
= |
|
5 |
3546 |
2338 |
- |
2528 |
= |
-190 |
* |
(12 |
/ |
86) |
= |
-26.51162777 |
6 |
3548 |
0 |
- |
2552 |
= |
|
* |
(7 |
/ |
86) |
= |
|
7 |
3550 |
2476 |
- |
2567 |
= |
-91 |
* |
(22 |
/ |
86) |
= |
-23.27906972 |
8 |
3552 |
2437 |
- |
2586 |
= |
-149 |
* |
(42 |
/ |
86) |
= |
-72.76744186 |
11 |
3553 |
0 |
- |
2628 |
= |
|
* |
(1 |
/ |
86) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Amador County Office of Education
|
-123 |
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 |
3621 |
2248 |
- |
2436 |
= |
-188 |
* |
(11 |
/ |
128) |
= |
-16.15625 |
4 |
3623 |
0 |
- |
2485 |
= |
|
* |
(0 |
/ |
128) |
= |
|
5 |
3626 |
2322 |
- |
2528 |
= |
-206 |
* |
(11 |
/ |
128) |
= |
-17.703125 |
6 |
3628 |
0 |
- |
2552 |
= |
|
* |
(0 |
/ |
128) |
= |
|
7 |
3630 |
2430 |
- |
2567 |
= |
-137 |
* |
(44 |
/ |
128) |
= |
-47.09375 |
8 |
3631 |
2496 |
- |
2586 |
= |
-90 |
* |
(31 |
/ |
128) |
= |
-21.796875 |
11 |
3633 |
2394 |
- |
2628 |
= |
-234 |
* |
(15 |
/ |
128) |
= |
-27.421875 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Amador County Office of Education
|
-130 |
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 |
3622 |
0 |
- |
2436 |
= |
|
* |
(0 |
/ |
111) |
= |
|
4 |
3623 |
2325 |
- |
2485 |
= |
-160 |
* |
(15 |
/ |
111) |
= |
-21.6216216 |
5 |
3626 |
0 |
- |
2528 |
= |
|
* |
(0 |
/ |
111) |
= |
|
6 |
3627 |
2368 |
- |
2552 |
= |
-184 |
* |
(12 |
/ |
111) |
= |
-19.89189187 |
7 |
3630 |
2452 |
- |
2567 |
= |
-115 |
* |
(27 |
/ |
111) |
= |
-27.97297295 |
8 |
3631 |
2443 |
- |
2586 |
= |
-143 |
* |
(36 |
/ |
111) |
= |
-46.37837833 |
11 |
3634 |
0 |
- |
2628 |
= |
|
* |
(0 |
/ |
111) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Amador County Office of Education
|
-116 |
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 |
3675 |
0 |
- |
2436 |
= |
|
* |
(0 |
/ |
78) |
= |
|
4 |
3676 |
2325 |
- |
2485 |
= |
-160 |
* |
(11 |
/ |
78) |
= |
-22.56410256 |
5 |
3677 |
2347 |
- |
2528 |
= |
-181 |
* |
(16 |
/ |
78) |
= |
-37.12820511 |
6 |
3678 |
0 |
- |
2552 |
= |
|
* |
(4 |
/ |
78) |
= |
|
7 |
3679 |
2427 |
- |
2567 |
= |
-140 |
* |
(22 |
/ |
78) |
= |
-39.48717948 |
8 |
3680 |
2409 |
- |
2586 |
= |
-177 |
* |
(12 |
/ |
78) |
= |
-27.23076908 |
11 |
3681 |
0 |
- |
2628 |
= |
|
* |
(10 |
/ |
78) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Amador County Office of Education
|
-126 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-112
|
-123
|
-130
|
-116
|
-126
|
-607.0 |
-121.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -100.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -142.4
For the lines, you have the data necessary to plot the chart.