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 |
131046 |
2348 |
- |
2436 |
= |
-88 |
* |
(27 |
/ |
210) |
= |
-11.31428566 |
4 |
131047 |
2403 |
- |
2485 |
= |
-82 |
* |
(17 |
/ |
210) |
= |
-6.63809516 |
5 |
131050 |
2422 |
- |
2528 |
= |
-106 |
* |
(13 |
/ |
210) |
= |
-6.56190467 |
6 |
131051 |
2416 |
- |
2552 |
= |
-136 |
* |
(21 |
/ |
210) |
= |
-13.6 |
7 |
131054 |
2431 |
- |
2567 |
= |
-136 |
* |
(55 |
/ |
210) |
= |
-35.6190475 |
8 |
131055 |
2435 |
- |
2586 |
= |
-151 |
* |
(21 |
/ |
210) |
= |
-15.1 |
11 |
131058 |
2499 |
- |
2628 |
= |
-129 |
* |
(56 |
/ |
210) |
= |
-34.39999991 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Butte County Office of Education
|
-123 |
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 |
3717 |
2374 |
- |
2436 |
= |
-62 |
* |
(13 |
/ |
213) |
= |
-3.78403751 |
4 |
3720 |
2388 |
- |
2485 |
= |
-97 |
* |
(28 |
/ |
213) |
= |
-12.7511737 |
5 |
3721 |
2442 |
- |
2528 |
= |
-86 |
* |
(17 |
/ |
213) |
= |
-6.86384972 |
6 |
3724 |
2454 |
- |
2552 |
= |
-98 |
* |
(13 |
/ |
213) |
= |
-5.98122057 |
7 |
3725 |
2425 |
- |
2567 |
= |
-142 |
* |
(66 |
/ |
213) |
= |
-43.99999987 |
8 |
3728 |
2459 |
- |
2586 |
= |
-127 |
* |
(23 |
/ |
213) |
= |
-13.71361494 |
11 |
3729 |
2509 |
- |
2628 |
= |
-119 |
* |
(53 |
/ |
213) |
= |
-29.61032863 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Butte County Office of Education
|
-117 |
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 |
3805 |
2348 |
- |
2436 |
= |
-88 |
* |
(15 |
/ |
187) |
= |
-7.05882346 |
4 |
3808 |
2376 |
- |
2485 |
= |
-109 |
* |
(13 |
/ |
187) |
= |
-7.57754004 |
5 |
3810 |
2407 |
- |
2528 |
= |
-121 |
* |
(21 |
/ |
187) |
= |
-13.58823527 |
6 |
3812 |
2449 |
- |
2552 |
= |
-103 |
* |
(17 |
/ |
187) |
= |
-9.36363627 |
7 |
3813 |
2435 |
- |
2567 |
= |
-132 |
* |
(33 |
/ |
187) |
= |
-23.29411762 |
8 |
3816 |
2453 |
- |
2586 |
= |
-133 |
* |
(32 |
/ |
187) |
= |
-22.7593582 |
11 |
3817 |
2501 |
- |
2628 |
= |
-127 |
* |
(56 |
/ |
187) |
= |
-38.03208548 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Butte County Office of Education
|
-122 |
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 |
3808 |
2376 |
- |
2436 |
= |
-60 |
* |
(12 |
/ |
173) |
= |
-4.16184966 |
4 |
3809 |
2403 |
- |
2485 |
= |
-82 |
* |
(15 |
/ |
173) |
= |
-7.10982656 |
5 |
3812 |
2413 |
- |
2528 |
= |
-115 |
* |
(18 |
/ |
173) |
= |
-11.96531783 |
6 |
3813 |
2376 |
- |
2552 |
= |
-176 |
* |
(25 |
/ |
173) |
= |
-25.43352592 |
7 |
3816 |
2495 |
- |
2567 |
= |
-72 |
* |
(20 |
/ |
173) |
= |
-8.32369939 |
8 |
3817 |
2423 |
- |
2586 |
= |
-163 |
* |
(24 |
/ |
173) |
= |
-22.61271665 |
11 |
3820 |
2501 |
- |
2628 |
= |
-127 |
* |
(59 |
/ |
173) |
= |
-43.31213867 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Butte County Office of Education
|
-123 |
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 |
3849 |
0 |
- |
2436 |
= |
|
* |
(8 |
/ |
159) |
= |
|
4 |
3850 |
0 |
- |
2485 |
= |
|
* |
(9 |
/ |
159) |
= |
|
5 |
3851 |
2434 |
- |
2528 |
= |
-94 |
* |
(15 |
/ |
159) |
= |
-8.86792447 |
6 |
3852 |
2401 |
- |
2552 |
= |
-151 |
* |
(18 |
/ |
159) |
= |
-17.0943396 |
7 |
3853 |
2426 |
- |
2567 |
= |
-141 |
* |
(30 |
/ |
159) |
= |
-26.60377355 |
8 |
3854 |
2469 |
- |
2586 |
= |
-117 |
* |
(22 |
/ |
159) |
= |
-16.18867914 |
11 |
3855 |
2470 |
- |
2628 |
= |
-158 |
* |
(57 |
/ |
159) |
= |
-56.64150943 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Butte County Office of Education
|
-125 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-123
|
-117
|
-122
|
-123
|
-125
|
-610.0 |
-122.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -113.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -131.0
For the lines, you have the data necessary to plot the chart.