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 |
2717592 |
2442 |
- |
2436 |
= |
6 |
* |
(1267 |
/ |
7666) |
= |
0.99165145 |
4 |
2717593 |
2483 |
- |
2485 |
= |
-2 |
* |
(1261 |
/ |
7666) |
= |
-0.32898513 |
5 |
2717596 |
2514 |
- |
2528 |
= |
-14 |
* |
(1157 |
/ |
7666) |
= |
-2.11296634 |
6 |
2717597 |
2520 |
- |
2552 |
= |
-32 |
* |
(1059 |
/ |
7666) |
= |
-4.4205583 |
7 |
2717600 |
2546 |
- |
2567 |
= |
-21 |
* |
(991 |
/ |
7666) |
= |
-2.71471431 |
8 |
2717601 |
2546 |
- |
2586 |
= |
-40 |
* |
(953 |
/ |
7666) |
= |
-4.97260628 |
11 |
2717604 |
2571 |
- |
2628 |
= |
-57 |
* |
(978 |
/ |
7666) |
= |
-7.27184967 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Santa Clara Unified
|
-21 |
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 |
82701 |
2458 |
- |
2436 |
= |
22 |
* |
(1224 |
/ |
7736) |
= |
3.48086864 |
4 |
82702 |
2494 |
- |
2485 |
= |
9 |
* |
(1203 |
/ |
7736) |
= |
1.39956049 |
5 |
82704 |
2521 |
- |
2528 |
= |
-7 |
* |
(1228 |
/ |
7736) |
= |
-1.11116856 |
6 |
82706 |
2539 |
- |
2552 |
= |
-13 |
* |
(1050 |
/ |
7736) |
= |
-1.76447775 |
7 |
82708 |
2559 |
- |
2567 |
= |
-8 |
* |
(1087 |
/ |
7736) |
= |
-1.12409514 |
8 |
82710 |
2565 |
- |
2586 |
= |
-21 |
* |
(1009 |
/ |
7736) |
= |
-2.7390124 |
11 |
82713 |
2596 |
- |
2628 |
= |
-32 |
* |
(935 |
/ |
7736) |
= |
-3.86763184 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Santa Clara Unified
|
-6 |
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 |
84991 |
2458 |
- |
2436 |
= |
22 |
* |
(1241 |
/ |
7752) |
= |
3.52192982 |
4 |
84992 |
2499 |
- |
2485 |
= |
14 |
* |
(1206 |
/ |
7752) |
= |
2.17801857 |
5 |
84994 |
2515 |
- |
2528 |
= |
-13 |
* |
(1143 |
/ |
7752) |
= |
-1.91679566 |
6 |
84997 |
2534 |
- |
2552 |
= |
-18 |
* |
(1076 |
/ |
7752) |
= |
-2.498452 |
7 |
84998 |
2557 |
- |
2567 |
= |
-10 |
* |
(1013 |
/ |
7752) |
= |
-1.30675954 |
8 |
85000 |
2563 |
- |
2586 |
= |
-23 |
* |
(1061 |
/ |
7752) |
= |
-3.14796182 |
11 |
85003 |
2592 |
- |
2628 |
= |
-36 |
* |
(1012 |
/ |
7752) |
= |
-4.69969038 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Santa Clara Unified
|
-8 |
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 |
85207 |
2469 |
- |
2436 |
= |
33 |
* |
(1123 |
/ |
7552) |
= |
4.90717689 |
4 |
85208 |
2504 |
- |
2485 |
= |
19 |
* |
(1215 |
/ |
7552) |
= |
3.05680613 |
5 |
85211 |
2522 |
- |
2528 |
= |
-6 |
* |
(1174 |
/ |
7552) |
= |
-0.93273305 |
6 |
85212 |
2532 |
- |
2552 |
= |
-20 |
* |
(1036 |
/ |
7552) |
= |
-2.74364406 |
7 |
85215 |
2551 |
- |
2567 |
= |
-16 |
* |
(1055 |
/ |
7552) |
= |
-2.23516949 |
8 |
85216 |
2568 |
- |
2586 |
= |
-18 |
* |
(991 |
/ |
7552) |
= |
-2.36202329 |
11 |
85219 |
2582 |
- |
2628 |
= |
-46 |
* |
(958 |
/ |
7552) |
= |
-5.8352754 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Santa Clara Unified
|
-6 |
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 |
85804 |
2473 |
- |
2436 |
= |
37 |
* |
(1219 |
/ |
7547) |
= |
5.97628196 |
4 |
85805 |
2504 |
- |
2485 |
= |
19 |
* |
(1086 |
/ |
7547) |
= |
2.7340665 |
5 |
85806 |
2530 |
- |
2528 |
= |
2 |
* |
(1170 |
/ |
7547) |
= |
0.31005698 |
6 |
85807 |
2541 |
- |
2552 |
= |
-11 |
* |
(1065 |
/ |
7547) |
= |
-1.55227243 |
7 |
85808 |
2557 |
- |
2567 |
= |
-10 |
* |
(998 |
/ |
7547) |
= |
-1.32237975 |
8 |
85809 |
2555 |
- |
2586 |
= |
-31 |
* |
(1029 |
/ |
7547) |
= |
-4.22671258 |
11 |
85810 |
2596 |
- |
2628 |
= |
-32 |
* |
(980 |
/ |
7547) |
= |
-4.15529347 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Santa Clara Unified
|
-2 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-21
|
-6
|
-8
|
-6
|
-2
|
-43.0 |
-8.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 12.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -29.6
For the lines, you have the data necessary to plot the chart.