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 |
1954036 |
2443 |
- |
2436 |
= |
7 |
* |
(2062 |
/ |
14817) |
= |
0.97415131 |
4 |
1954039 |
2478 |
- |
2485 |
= |
-7 |
* |
(2065 |
/ |
14817) |
= |
-0.9755686 |
5 |
1954040 |
2499 |
- |
2528 |
= |
-29 |
* |
(2134 |
/ |
14817) |
= |
-4.17668892 |
6 |
1954043 |
2529 |
- |
2552 |
= |
-23 |
* |
(2126 |
/ |
14817) |
= |
-3.30012823 |
7 |
1954044 |
2543 |
- |
2567 |
= |
-24 |
* |
(2127 |
/ |
14817) |
= |
-3.44523182 |
8 |
1954047 |
2563 |
- |
2586 |
= |
-23 |
* |
(2231 |
/ |
14817) |
= |
-3.46311667 |
11 |
1954048 |
2572 |
- |
2628 |
= |
-56 |
* |
(2072 |
/ |
14817) |
= |
-7.83100489 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Chino Valley Unified
|
-22 |
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 |
60180 |
2448 |
- |
2436 |
= |
12 |
* |
(2038 |
/ |
14853) |
= |
1.64653604 |
4 |
60182 |
2482 |
- |
2485 |
= |
-3 |
* |
(2079 |
/ |
14853) |
= |
-0.41991517 |
5 |
60184 |
2506 |
- |
2528 |
= |
-22 |
* |
(2083 |
/ |
14853) |
= |
-3.08530262 |
6 |
60186 |
2542 |
- |
2552 |
= |
-10 |
* |
(2094 |
/ |
14853) |
= |
-1.40981619 |
7 |
60189 |
2550 |
- |
2567 |
= |
-17 |
* |
(2124 |
/ |
14853) |
= |
-2.43102402 |
8 |
60191 |
2566 |
- |
2586 |
= |
-20 |
* |
(2121 |
/ |
14853) |
= |
-2.85598868 |
11 |
60192 |
2586 |
- |
2628 |
= |
-42 |
* |
(2314 |
/ |
14853) |
= |
-6.54332456 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Chino Valley 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 |
61929 |
2449 |
- |
2436 |
= |
13 |
* |
(1891 |
/ |
14778) |
= |
1.66348625 |
4 |
61931 |
2480 |
- |
2485 |
= |
-5 |
* |
(2091 |
/ |
14778) |
= |
-0.70747056 |
5 |
61932 |
2501 |
- |
2528 |
= |
-27 |
* |
(2117 |
/ |
14778) |
= |
-3.86784407 |
6 |
61934 |
2538 |
- |
2552 |
= |
-14 |
* |
(2111 |
/ |
14778) |
= |
-1.99986465 |
7 |
61936 |
2548 |
- |
2567 |
= |
-19 |
* |
(2127 |
/ |
14778) |
= |
-2.73467315 |
8 |
61938 |
2568 |
- |
2586 |
= |
-18 |
* |
(2156 |
/ |
14778) |
= |
-2.62606576 |
11 |
61940 |
2583 |
- |
2628 |
= |
-45 |
* |
(2285 |
/ |
14778) |
= |
-6.95797808 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Chino Valley Unified
|
-17 |
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 |
62018 |
2448 |
- |
2436 |
= |
12 |
* |
(1990 |
/ |
14991) |
= |
1.59295577 |
4 |
62021 |
2486 |
- |
2485 |
= |
1 |
* |
(2011 |
/ |
14991) |
= |
0.13414715 |
5 |
62023 |
2510 |
- |
2528 |
= |
-18 |
* |
(2165 |
/ |
14991) |
= |
-2.59955973 |
6 |
62024 |
2538 |
- |
2552 |
= |
-14 |
* |
(2211 |
/ |
14991) |
= |
-2.0648389 |
7 |
62027 |
2552 |
- |
2567 |
= |
-15 |
* |
(2200 |
/ |
14991) |
= |
-2.20132079 |
8 |
62029 |
2559 |
- |
2586 |
= |
-27 |
* |
(2214 |
/ |
14991) |
= |
-3.98759255 |
11 |
62030 |
2577 |
- |
2628 |
= |
-51 |
* |
(2200 |
/ |
14991) |
= |
-7.48449067 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Chino Valley Unified
|
-17 |
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 |
62285 |
2447 |
- |
2436 |
= |
11 |
* |
(1942 |
/ |
14681) |
= |
1.45507799 |
4 |
62286 |
2488 |
- |
2485 |
= |
3 |
* |
(2004 |
/ |
14681) |
= |
0.40950889 |
5 |
62287 |
2513 |
- |
2528 |
= |
-15 |
* |
(2016 |
/ |
14681) |
= |
-2.05980519 |
6 |
62288 |
2546 |
- |
2552 |
= |
-6 |
* |
(2132 |
/ |
14681) |
= |
-0.87133029 |
7 |
62289 |
2552 |
- |
2567 |
= |
-15 |
* |
(2194 |
/ |
14681) |
= |
-2.2416729 |
8 |
62290 |
2566 |
- |
2586 |
= |
-20 |
* |
(2227 |
/ |
14681) |
= |
-3.03385326 |
11 |
62291 |
2583 |
- |
2628 |
= |
-45 |
* |
(2166 |
/ |
14681) |
= |
-6.63919349 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Chino Valley Unified
|
-13 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-22
|
-15
|
-17
|
-17
|
-13
|
-84.0 |
-16.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -7.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -25.8
For the lines, you have the data necessary to plot the chart.