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 |
384464 |
2371 |
- |
2436 |
= |
-65 |
* |
(153 |
/ |
1032) |
= |
-9.63662785 |
4 |
384465 |
2400 |
- |
2485 |
= |
-85 |
* |
(133 |
/ |
1032) |
= |
-10.95445728 |
5 |
384468 |
2402 |
- |
2528 |
= |
-126 |
* |
(161 |
/ |
1032) |
= |
-19.65697663 |
6 |
384469 |
2444 |
- |
2552 |
= |
-108 |
* |
(175 |
/ |
1032) |
= |
-18.31395344 |
7 |
384472 |
2452 |
- |
2567 |
= |
-115 |
* |
(146 |
/ |
1032) |
= |
-16.26937982 |
8 |
384473 |
2463 |
- |
2586 |
= |
-123 |
* |
(141 |
/ |
1032) |
= |
-16.80523244 |
11 |
384476 |
2503 |
- |
2628 |
= |
-125 |
* |
(123 |
/ |
1032) |
= |
-14.89825575 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Golden Plains Unified
|
-107 |
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 |
11676 |
2379 |
- |
2436 |
= |
-57 |
* |
(148 |
/ |
998) |
= |
-8.4529058 |
4 |
11677 |
2409 |
- |
2485 |
= |
-76 |
* |
(159 |
/ |
998) |
= |
-12.10821641 |
5 |
11680 |
2416 |
- |
2528 |
= |
-112 |
* |
(122 |
/ |
998) |
= |
-13.69138266 |
6 |
11681 |
2426 |
- |
2552 |
= |
-126 |
* |
(158 |
/ |
998) |
= |
-19.94789576 |
7 |
11684 |
2463 |
- |
2567 |
= |
-104 |
* |
(168 |
/ |
998) |
= |
-17.50701399 |
8 |
11686 |
2498 |
- |
2586 |
= |
-88 |
* |
(139 |
/ |
998) |
= |
-12.25651302 |
11 |
11688 |
2502 |
- |
2628 |
= |
-126 |
* |
(104 |
/ |
998) |
= |
-13.13026042 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Golden Plains Unified
|
-97 |
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 |
12005 |
2400 |
- |
2436 |
= |
-36 |
* |
(132 |
/ |
965) |
= |
-4.9243523 |
4 |
12007 |
2392 |
- |
2485 |
= |
-93 |
* |
(137 |
/ |
965) |
= |
-13.20310872 |
5 |
12009 |
2397 |
- |
2528 |
= |
-131 |
* |
(155 |
/ |
965) |
= |
-21.04145069 |
6 |
12011 |
2422 |
- |
2552 |
= |
-130 |
* |
(122 |
/ |
965) |
= |
-16.4352331 |
7 |
12014 |
2449 |
- |
2567 |
= |
-118 |
* |
(158 |
/ |
965) |
= |
-19.32020714 |
8 |
12016 |
2490 |
- |
2586 |
= |
-96 |
* |
(173 |
/ |
965) |
= |
-17.21036266 |
11 |
12018 |
2530 |
- |
2628 |
= |
-98 |
* |
(88 |
/ |
965) |
= |
-8.93678748 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Golden Plains Unified
|
-101 |
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 |
12041 |
2373 |
- |
2436 |
= |
-63 |
* |
(118 |
/ |
932) |
= |
-7.97639485 |
4 |
12044 |
2416 |
- |
2485 |
= |
-69 |
* |
(130 |
/ |
932) |
= |
-9.62446348 |
5 |
12046 |
2402 |
- |
2528 |
= |
-126 |
* |
(136 |
/ |
932) |
= |
-18.386266 |
6 |
12048 |
2403 |
- |
2552 |
= |
-149 |
* |
(154 |
/ |
932) |
= |
-24.6201716 |
7 |
12049 |
2445 |
- |
2567 |
= |
-122 |
* |
(117 |
/ |
932) |
= |
-15.31545056 |
8 |
12052 |
2460 |
- |
2586 |
= |
-126 |
* |
(158 |
/ |
932) |
= |
-21.3605149 |
11 |
12053 |
2480 |
- |
2628 |
= |
-148 |
* |
(119 |
/ |
932) |
= |
-18.89699564 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Golden Plains Unified
|
-116 |
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 |
12137 |
2389 |
- |
2436 |
= |
-47 |
* |
(107 |
/ |
854) |
= |
-5.88875878 |
4 |
12138 |
2404 |
- |
2485 |
= |
-81 |
* |
(116 |
/ |
854) |
= |
-11.00234186 |
5 |
12139 |
2419 |
- |
2528 |
= |
-109 |
* |
(126 |
/ |
854) |
= |
-16.08196715 |
6 |
12140 |
2447 |
- |
2552 |
= |
-105 |
* |
(133 |
/ |
854) |
= |
-16.35245892 |
7 |
12141 |
2427 |
- |
2567 |
= |
-140 |
* |
(154 |
/ |
854) |
= |
-25.24590152 |
8 |
12142 |
2450 |
- |
2586 |
= |
-136 |
* |
(114 |
/ |
854) |
= |
-18.1545667 |
11 |
12143 |
2496 |
- |
2628 |
= |
-132 |
* |
(104 |
/ |
854) |
= |
-16.07494139 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Golden Plains Unified
|
-109 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-107
|
-97
|
-101
|
-116
|
-109
|
-530.0 |
-106.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -85.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -127.0
For the lines, you have the data necessary to plot the chart.