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 |
552328 |
2367 |
- |
2436 |
= |
-69 |
* |
(123 |
/ |
734) |
= |
-11.56267024 |
4 |
552329 |
2413 |
- |
2485 |
= |
-72 |
* |
(124 |
/ |
734) |
= |
-12.16348769 |
5 |
552332 |
2433 |
- |
2528 |
= |
-95 |
* |
(120 |
/ |
734) |
= |
-15.53133511 |
6 |
552333 |
2439 |
- |
2552 |
= |
-113 |
* |
(101 |
/ |
734) |
= |
-15.54904623 |
7 |
552336 |
2447 |
- |
2567 |
= |
-120 |
* |
(123 |
/ |
734) |
= |
-20.10899172 |
8 |
552337 |
2464 |
- |
2586 |
= |
-122 |
* |
(115 |
/ |
734) |
= |
-19.11444138 |
11 |
552340 |
2491 |
- |
2628 |
= |
-137 |
* |
(28 |
/ |
734) |
= |
-5.22615791 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Armona Union Elementary
|
-99 |
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 |
17545 |
2374 |
- |
2436 |
= |
-62 |
* |
(96 |
/ |
710) |
= |
-8.38309855 |
4 |
17547 |
2415 |
- |
2485 |
= |
-70 |
* |
(127 |
/ |
710) |
= |
-12.52112673 |
5 |
17548 |
2436 |
- |
2528 |
= |
-92 |
* |
(123 |
/ |
710) |
= |
-15.93802811 |
6 |
17551 |
2445 |
- |
2552 |
= |
-107 |
* |
(107 |
/ |
710) |
= |
-16.12535208 |
7 |
17552 |
2478 |
- |
2567 |
= |
-89 |
* |
(103 |
/ |
710) |
= |
-12.91126756 |
8 |
17555 |
2465 |
- |
2586 |
= |
-121 |
* |
(131 |
/ |
710) |
= |
-22.32535208 |
11 |
17557 |
2502 |
- |
2628 |
= |
-126 |
* |
(23 |
/ |
710) |
= |
-4.08169012 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Armona Union Elementary
|
-92 |
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 |
17884 |
2412 |
- |
2436 |
= |
-24 |
* |
(102 |
/ |
725) |
= |
-3.37655172 |
4 |
17886 |
2404 |
- |
2485 |
= |
-81 |
* |
(92 |
/ |
725) |
= |
-10.27862063 |
5 |
17888 |
2463 |
- |
2528 |
= |
-65 |
* |
(125 |
/ |
725) |
= |
-11.20689655 |
6 |
17891 |
2454 |
- |
2552 |
= |
-98 |
* |
(128 |
/ |
725) |
= |
-17.30206895 |
7 |
17892 |
2482 |
- |
2567 |
= |
-85 |
* |
(124 |
/ |
725) |
= |
-14.53793097 |
8 |
17894 |
2474 |
- |
2586 |
= |
-112 |
* |
(113 |
/ |
725) |
= |
-17.45655162 |
11 |
17896 |
2469 |
- |
2628 |
= |
-159 |
* |
(41 |
/ |
725) |
= |
-8.99172412 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Armona Union Elementary
|
-83 |
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 |
17898 |
2426 |
- |
2436 |
= |
-10 |
* |
(111 |
/ |
749) |
= |
-1.48197596 |
4 |
17899 |
2460 |
- |
2485 |
= |
-25 |
* |
(110 |
/ |
749) |
= |
-3.67156208 |
5 |
17902 |
2457 |
- |
2528 |
= |
-71 |
* |
(88 |
/ |
749) |
= |
-8.34178901 |
6 |
17903 |
2450 |
- |
2552 |
= |
-102 |
* |
(129 |
/ |
749) |
= |
-17.56742318 |
7 |
17906 |
2486 |
- |
2567 |
= |
-81 |
* |
(133 |
/ |
749) |
= |
-14.38317753 |
8 |
17907 |
2468 |
- |
2586 |
= |
-118 |
* |
(136 |
/ |
749) |
= |
-21.42590109 |
11 |
17910 |
2475 |
- |
2628 |
= |
-153 |
* |
(42 |
/ |
749) |
= |
-8.5794392 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Armona Union Elementary
|
-75 |
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 |
18047 |
2421 |
- |
2436 |
= |
-15 |
* |
(121 |
/ |
764) |
= |
-2.37565445 |
4 |
18048 |
2446 |
- |
2485 |
= |
-39 |
* |
(111 |
/ |
764) |
= |
-5.66623036 |
5 |
18049 |
2482 |
- |
2528 |
= |
-46 |
* |
(105 |
/ |
764) |
= |
-6.32198948 |
6 |
18050 |
2435 |
- |
2552 |
= |
-117 |
* |
(94 |
/ |
764) |
= |
-14.39528793 |
7 |
18051 |
2474 |
- |
2567 |
= |
-93 |
* |
(145 |
/ |
764) |
= |
-17.65052348 |
8 |
18052 |
2463 |
- |
2586 |
= |
-123 |
* |
(155 |
/ |
764) |
= |
-24.95418846 |
11 |
18053 |
2442 |
- |
2628 |
= |
-186 |
* |
(33 |
/ |
764) |
= |
-8.03403136 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Armona Union Elementary
|
-79 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-99
|
-92
|
-83
|
-75
|
-79
|
-428.0 |
-85.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -58.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -112.6
For the lines, you have the data necessary to plot the chart.