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 |
1055988 |
2379 |
- |
2436 |
= |
-57 |
* |
(2263 |
/ |
12980) |
= |
-9.93767332 |
4 |
1055989 |
2414 |
- |
2485 |
= |
-71 |
* |
(2194 |
/ |
12980) |
= |
-12.00107853 |
5 |
1055992 |
2445 |
- |
2528 |
= |
-83 |
* |
(2071 |
/ |
12980) |
= |
-13.24291211 |
6 |
1055993 |
2477 |
- |
2552 |
= |
-75 |
* |
(2172 |
/ |
12980) |
= |
-12.550077 |
7 |
1055996 |
2470 |
- |
2567 |
= |
-97 |
* |
(2116 |
/ |
12980) |
= |
-15.81294291 |
8 |
1055997 |
2499 |
- |
2586 |
= |
-87 |
* |
(2086 |
/ |
12980) |
= |
-13.98166403 |
11 |
1056000 |
2599 |
- |
2628 |
= |
-29 |
* |
(78 |
/ |
12980) |
= |
-0.17426808 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Palmdale Elementary
|
-78 |
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 |
33128 |
2385 |
- |
2436 |
= |
-51 |
* |
(2158 |
/ |
12397) |
= |
-8.87779297 |
4 |
33131 |
2421 |
- |
2485 |
= |
-64 |
* |
(2269 |
/ |
12397) |
= |
-11.71380166 |
5 |
33132 |
2444 |
- |
2528 |
= |
-84 |
* |
(2193 |
/ |
12397) |
= |
-14.85940142 |
6 |
33134 |
2469 |
- |
2552 |
= |
-83 |
* |
(2105 |
/ |
12397) |
= |
-14.09332895 |
7 |
33137 |
2477 |
- |
2567 |
= |
-90 |
* |
(1772 |
/ |
12397) |
= |
-12.86440263 |
8 |
33138 |
2481 |
- |
2586 |
= |
-105 |
* |
(1900 |
/ |
12397) |
= |
-16.09260303 |
11 |
33141 |
0 |
- |
2628 |
= |
|
* |
(0 |
/ |
12397) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Palmdale Elementary
|
-79 |
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 |
33704 |
2385 |
- |
2436 |
= |
-51 |
* |
(2099 |
/ |
12252) |
= |
-8.73726737 |
4 |
33707 |
2418 |
- |
2485 |
= |
-67 |
* |
(2172 |
/ |
12252) |
= |
-11.87757099 |
5 |
33708 |
2444 |
- |
2528 |
= |
-84 |
* |
(2318 |
/ |
12252) |
= |
-15.89226248 |
6 |
33710 |
2458 |
- |
2552 |
= |
-94 |
* |
(2224 |
/ |
12252) |
= |
-17.0630101 |
7 |
33713 |
2472 |
- |
2567 |
= |
-95 |
* |
(1671 |
/ |
12252) |
= |
-12.95666012 |
8 |
33714 |
2476 |
- |
2586 |
= |
-110 |
* |
(1768 |
/ |
12252) |
= |
-15.8733267 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Palmdale Elementary
|
-82 |
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 |
33731 |
2389 |
- |
2436 |
= |
-47 |
* |
(2075 |
/ |
11857) |
= |
-8.22509908 |
4 |
33733 |
2423 |
- |
2485 |
= |
-62 |
* |
(2120 |
/ |
11857) |
= |
-11.08543471 |
5 |
33735 |
2447 |
- |
2528 |
= |
-81 |
* |
(2187 |
/ |
11857) |
= |
-14.94028841 |
6 |
33737 |
2439 |
- |
2552 |
= |
-113 |
* |
(2017 |
/ |
11857) |
= |
-19.22248458 |
7 |
33739 |
2460 |
- |
2567 |
= |
-107 |
* |
(1785 |
/ |
11857) |
= |
-16.10820607 |
8 |
33741 |
2471 |
- |
2586 |
= |
-115 |
* |
(1673 |
/ |
11857) |
= |
-16.22627978 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Palmdale Elementary
|
-86 |
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 |
33909 |
2393 |
- |
2436 |
= |
-43 |
* |
(2090 |
/ |
12284) |
= |
-7.31602082 |
4 |
33910 |
2428 |
- |
2485 |
= |
-57 |
* |
(2129 |
/ |
12284) |
= |
-9.87894822 |
5 |
33911 |
2456 |
- |
2528 |
= |
-72 |
* |
(2155 |
/ |
12284) |
= |
-12.63106476 |
6 |
33912 |
2437 |
- |
2552 |
= |
-115 |
* |
(1965 |
/ |
12284) |
= |
-18.39588082 |
7 |
33913 |
2454 |
- |
2567 |
= |
-113 |
* |
(2042 |
/ |
12284) |
= |
-18.78427216 |
8 |
33914 |
2471 |
- |
2586 |
= |
-115 |
* |
(1903 |
/ |
12284) |
= |
-17.81545098 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Palmdale Elementary
|
-85 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-78
|
-79
|
-82
|
-86
|
-85
|
-410.0 |
-82.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -73.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -91.0
For the lines, you have the data necessary to plot the chart.