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 |
134771 |
2418 |
- |
2436 |
= |
-18 |
* |
(842 |
/ |
5968) |
= |
-2.53954422 |
4 |
134774 |
2462 |
- |
2485 |
= |
-23 |
* |
(762 |
/ |
5968) |
= |
-2.9366622 |
5 |
134775 |
2499 |
- |
2528 |
= |
-29 |
* |
(800 |
/ |
5968) |
= |
-3.88739945 |
6 |
134778 |
2511 |
- |
2552 |
= |
-41 |
* |
(847 |
/ |
5968) |
= |
-5.81886727 |
7 |
134779 |
2540 |
- |
2567 |
= |
-27 |
* |
(849 |
/ |
5968) |
= |
-3.84098525 |
8 |
134782 |
2556 |
- |
2586 |
= |
-30 |
* |
(909 |
/ |
5968) |
= |
-4.56936996 |
11 |
134783 |
2584 |
- |
2628 |
= |
-44 |
* |
(959 |
/ |
5968) |
= |
-7.07037531 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Chico Unified
|
-31 |
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 |
3876 |
2426 |
- |
2436 |
= |
-10 |
* |
(875 |
/ |
6028) |
= |
-1.45155938 |
4 |
3878 |
2477 |
- |
2485 |
= |
-8 |
* |
(845 |
/ |
6028) |
= |
-1.1214333 |
5 |
3879 |
2501 |
- |
2528 |
= |
-27 |
* |
(786 |
/ |
6028) |
= |
-3.52057066 |
6 |
3882 |
2516 |
- |
2552 |
= |
-36 |
* |
(806 |
/ |
6028) |
= |
-4.81353682 |
7 |
3883 |
2540 |
- |
2567 |
= |
-27 |
* |
(891 |
/ |
6028) |
= |
-3.99087589 |
8 |
3885 |
2561 |
- |
2586 |
= |
-25 |
* |
(842 |
/ |
6028) |
= |
-3.49203715 |
11 |
3888 |
2595 |
- |
2628 |
= |
-33 |
* |
(983 |
/ |
6028) |
= |
-5.38138686 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Chico Unified
|
-24 |
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 |
3955 |
2425 |
- |
2436 |
= |
-11 |
* |
(776 |
/ |
6109) |
= |
-1.39728269 |
4 |
3957 |
2477 |
- |
2485 |
= |
-8 |
* |
(882 |
/ |
6109) |
= |
-1.15501718 |
5 |
3960 |
2491 |
- |
2528 |
= |
-37 |
* |
(886 |
/ |
6109) |
= |
-5.36618104 |
6 |
3962 |
2503 |
- |
2552 |
= |
-49 |
* |
(812 |
/ |
6109) |
= |
-6.51301356 |
7 |
3964 |
2542 |
- |
2567 |
= |
-25 |
* |
(868 |
/ |
6109) |
= |
-3.55213618 |
8 |
3965 |
2552 |
- |
2586 |
= |
-34 |
* |
(886 |
/ |
6109) |
= |
-4.93108528 |
11 |
3967 |
2596 |
- |
2628 |
= |
-32 |
* |
(999 |
/ |
6109) |
= |
-5.23293501 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Chico Unified
|
-28 |
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 |
3962 |
2423 |
- |
2436 |
= |
-13 |
* |
(821 |
/ |
6115) |
= |
-1.74538021 |
4 |
3963 |
2479 |
- |
2485 |
= |
-6 |
* |
(790 |
/ |
6115) |
= |
-0.77514309 |
5 |
3966 |
2505 |
- |
2528 |
= |
-23 |
* |
(875 |
/ |
6115) |
= |
-3.29108748 |
6 |
3967 |
2499 |
- |
2552 |
= |
-53 |
* |
(901 |
/ |
6115) |
= |
-7.8091578 |
7 |
3970 |
2544 |
- |
2567 |
= |
-23 |
* |
(840 |
/ |
6115) |
= |
-3.15944399 |
8 |
3971 |
2566 |
- |
2586 |
= |
-20 |
* |
(850 |
/ |
6115) |
= |
-2.78004904 |
11 |
3974 |
2594 |
- |
2628 |
= |
-34 |
* |
(1038 |
/ |
6115) |
= |
-5.77138182 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Chico Unified
|
-25 |
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 |
4005 |
2428 |
- |
2436 |
= |
-8 |
* |
(924 |
/ |
6181) |
= |
-1.19592298 |
4 |
4006 |
2478 |
- |
2485 |
= |
-7 |
* |
(831 |
/ |
6181) |
= |
-0.94110985 |
5 |
4007 |
2498 |
- |
2528 |
= |
-30 |
* |
(862 |
/ |
6181) |
= |
-4.18378902 |
6 |
4008 |
2508 |
- |
2552 |
= |
-44 |
* |
(905 |
/ |
6181) |
= |
-6.44232323 |
7 |
4009 |
2542 |
- |
2567 |
= |
-25 |
* |
(913 |
/ |
6181) |
= |
-3.69276815 |
8 |
4010 |
2566 |
- |
2586 |
= |
-20 |
* |
(820 |
/ |
6181) |
= |
-2.65329234 |
11 |
4011 |
2587 |
- |
2628 |
= |
-41 |
* |
(926 |
/ |
6181) |
= |
-6.14237175 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Chico Unified
|
-25 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-31
|
-24
|
-28
|
-25
|
-25
|
-133.0 |
-26.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -20.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -32.6
For the lines, you have the data necessary to plot the chart.