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 |
646896 |
2427 |
- |
2436 |
= |
-9 |
* |
(1020 |
/ |
7779) |
= |
-1.18010027 |
4 |
646897 |
2481 |
- |
2485 |
= |
-4 |
* |
(977 |
/ |
7779) |
= |
-0.5023782 |
5 |
646900 |
2501 |
- |
2528 |
= |
-27 |
* |
(1041 |
/ |
7779) |
= |
-3.61318933 |
6 |
646901 |
2519 |
- |
2552 |
= |
-33 |
* |
(1178 |
/ |
7779) |
= |
-4.99730042 |
7 |
646904 |
2538 |
- |
2567 |
= |
-29 |
* |
(1189 |
/ |
7779) |
= |
-4.43257486 |
8 |
646905 |
2551 |
- |
2586 |
= |
-35 |
* |
(1173 |
/ |
7779) |
= |
-5.27767065 |
11 |
646908 |
2559 |
- |
2628 |
= |
-69 |
* |
(1201 |
/ |
7779) |
= |
-10.65291166 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Burbank 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 |
20596 |
2444 |
- |
2436 |
= |
8 |
* |
(1005 |
/ |
7568) |
= |
1.06236786 |
4 |
20597 |
2489 |
- |
2485 |
= |
4 |
* |
(1049 |
/ |
7568) |
= |
0.55443974 |
5 |
20600 |
2513 |
- |
2528 |
= |
-15 |
* |
(990 |
/ |
7568) |
= |
-1.9622093 |
6 |
20601 |
2528 |
- |
2552 |
= |
-24 |
* |
(1112 |
/ |
7568) |
= |
-3.52642704 |
7 |
20603 |
2550 |
- |
2567 |
= |
-17 |
* |
(1218 |
/ |
7568) |
= |
-2.73599365 |
8 |
20606 |
2568 |
- |
2586 |
= |
-18 |
* |
(1190 |
/ |
7568) |
= |
-2.83033825 |
11 |
20607 |
2584 |
- |
2628 |
= |
-44 |
* |
(1004 |
/ |
7568) |
= |
-5.83720927 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Burbank Unified
|
-15 |
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 |
20942 |
2446 |
- |
2436 |
= |
10 |
* |
(1013 |
/ |
7849) |
= |
1.29061026 |
4 |
20944 |
2490 |
- |
2485 |
= |
5 |
* |
(1029 |
/ |
7849) |
= |
0.65549752 |
5 |
20946 |
2524 |
- |
2528 |
= |
-4 |
* |
(1057 |
/ |
7849) |
= |
-0.53866734 |
6 |
20947 |
2534 |
- |
2552 |
= |
-18 |
* |
(1070 |
/ |
7849) |
= |
-2.45381576 |
7 |
20950 |
2556 |
- |
2567 |
= |
-11 |
* |
(1148 |
/ |
7849) |
= |
-1.60886737 |
8 |
20951 |
2562 |
- |
2586 |
= |
-24 |
* |
(1225 |
/ |
7849) |
= |
-3.74570009 |
11 |
20954 |
2583 |
- |
2628 |
= |
-45 |
* |
(1307 |
/ |
7849) |
= |
-7.49331122 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Burbank Unified
|
-14 |
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 |
20929 |
2450 |
- |
2436 |
= |
14 |
* |
(999 |
/ |
7683) |
= |
1.82038266 |
4 |
20931 |
2499 |
- |
2485 |
= |
14 |
* |
(1029 |
/ |
7683) |
= |
1.8750488 |
5 |
20933 |
2528 |
- |
2528 |
= |
0 |
* |
(1023 |
/ |
7683) |
= |
0.0 |
6 |
20935 |
2537 |
- |
2552 |
= |
-15 |
* |
(1112 |
/ |
7683) |
= |
-2.17102694 |
7 |
20937 |
2564 |
- |
2567 |
= |
-3 |
* |
(1096 |
/ |
7683) |
= |
-0.42795783 |
8 |
20939 |
2576 |
- |
2586 |
= |
-10 |
* |
(1170 |
/ |
7683) |
= |
-1.52284263 |
11 |
20941 |
2583 |
- |
2628 |
= |
-45 |
* |
(1254 |
/ |
7683) |
= |
-7.34478719 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Burbank Unified
|
-8 |
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 |
21106 |
2458 |
- |
2436 |
= |
22 |
* |
(944 |
/ |
7596) |
= |
2.73407055 |
4 |
21107 |
2501 |
- |
2485 |
= |
16 |
* |
(1020 |
/ |
7596) |
= |
2.1484992 |
5 |
21108 |
2529 |
- |
2528 |
= |
1 |
* |
(1031 |
/ |
7596) |
= |
0.13572933 |
6 |
21109 |
2537 |
- |
2552 |
= |
-15 |
* |
(1118 |
/ |
7596) |
= |
-2.20774091 |
7 |
21110 |
2564 |
- |
2567 |
= |
-3 |
* |
(1149 |
/ |
7596) |
= |
-0.45379147 |
8 |
21111 |
2576 |
- |
2586 |
= |
-10 |
* |
(1097 |
/ |
7596) |
= |
-1.44418114 |
11 |
21112 |
2585 |
- |
2628 |
= |
-43 |
* |
(1237 |
/ |
7596) |
= |
-7.00250128 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Burbank Unified
|
-6 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-31
|
-15
|
-14
|
-8
|
-6
|
-74.0 |
-14.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 12.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -41.8
For the lines, you have the data necessary to plot the chart.