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 |
388920 |
2381 |
- |
2436 |
= |
-55 |
* |
(88 |
/ |
665) |
= |
-7.27819549 |
4 |
388923 |
2429 |
- |
2485 |
= |
-56 |
* |
(92 |
/ |
665) |
= |
-7.74736838 |
5 |
388924 |
2476 |
- |
2528 |
= |
-52 |
* |
(85 |
/ |
665) |
= |
-6.6466165 |
6 |
388927 |
2505 |
- |
2552 |
= |
-47 |
* |
(82 |
/ |
665) |
= |
-5.79548869 |
7 |
388928 |
2474 |
- |
2567 |
= |
-93 |
* |
(90 |
/ |
665) |
= |
-12.58646609 |
8 |
388931 |
2512 |
- |
2586 |
= |
-74 |
* |
(96 |
/ |
665) |
= |
-10.68270675 |
11 |
388932 |
2546 |
- |
2628 |
= |
-82 |
* |
(132 |
/ |
665) |
= |
-16.27669168 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Caruthers Unified
|
-67 |
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 |
11855 |
2399 |
- |
2436 |
= |
-37 |
* |
(79 |
/ |
680) |
= |
-4.29852939 |
4 |
11857 |
2468 |
- |
2485 |
= |
-17 |
* |
(92 |
/ |
680) |
= |
-2.29999999 |
5 |
11860 |
2484 |
- |
2528 |
= |
-44 |
* |
(105 |
/ |
680) |
= |
-6.79411762 |
6 |
11862 |
2517 |
- |
2552 |
= |
-35 |
* |
(83 |
/ |
680) |
= |
-4.27205881 |
7 |
11864 |
2486 |
- |
2567 |
= |
-81 |
* |
(90 |
/ |
680) |
= |
-10.72058822 |
8 |
11866 |
2512 |
- |
2586 |
= |
-74 |
* |
(92 |
/ |
680) |
= |
-10.01176466 |
11 |
11868 |
2544 |
- |
2628 |
= |
-84 |
* |
(139 |
/ |
680) |
= |
-17.17058818 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Caruthers Unified
|
-56 |
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 |
12183 |
2410 |
- |
2436 |
= |
-26 |
* |
(92 |
/ |
690) |
= |
-3.46666666 |
4 |
12184 |
2474 |
- |
2485 |
= |
-11 |
* |
(83 |
/ |
690) |
= |
-1.32318841 |
5 |
12187 |
2489 |
- |
2528 |
= |
-39 |
* |
(95 |
/ |
690) |
= |
-5.3695652 |
6 |
12188 |
2512 |
- |
2552 |
= |
-40 |
* |
(108 |
/ |
690) |
= |
-6.26086956 |
7 |
12191 |
2495 |
- |
2567 |
= |
-72 |
* |
(88 |
/ |
690) |
= |
-9.18260863 |
8 |
12192 |
2512 |
- |
2586 |
= |
-74 |
* |
(90 |
/ |
690) |
= |
-9.65217387 |
11 |
12195 |
2539 |
- |
2628 |
= |
-89 |
* |
(134 |
/ |
690) |
= |
-17.28405792 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Caruthers Unified
|
-53 |
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 |
12213 |
2442 |
- |
2436 |
= |
6 |
* |
(87 |
/ |
709) |
= |
0.73624823 |
4 |
12216 |
2457 |
- |
2485 |
= |
-28 |
* |
(94 |
/ |
709) |
= |
-3.7122708 |
5 |
12217 |
2465 |
- |
2528 |
= |
-63 |
* |
(85 |
/ |
709) |
= |
-7.5528914 |
6 |
12220 |
2518 |
- |
2552 |
= |
-34 |
* |
(95 |
/ |
709) |
= |
-4.55571226 |
7 |
12221 |
2527 |
- |
2567 |
= |
-40 |
* |
(113 |
/ |
709) |
= |
-6.37517628 |
8 |
12224 |
2507 |
- |
2586 |
= |
-79 |
* |
(92 |
/ |
709) |
= |
-10.25105778 |
11 |
12225 |
2566 |
- |
2628 |
= |
-62 |
* |
(143 |
/ |
709) |
= |
-12.50493649 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Caruthers Unified
|
-44 |
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 |
12315 |
2430 |
- |
2436 |
= |
-6 |
* |
(90 |
/ |
756) |
= |
-0.71428571 |
4 |
12316 |
2489 |
- |
2485 |
= |
4 |
* |
(97 |
/ |
756) |
= |
0.51322751 |
5 |
12317 |
2473 |
- |
2528 |
= |
-55 |
* |
(99 |
/ |
756) |
= |
-7.2023809 |
6 |
12318 |
2527 |
- |
2552 |
= |
-25 |
* |
(92 |
/ |
756) |
= |
-3.04232803 |
7 |
12319 |
2486 |
- |
2567 |
= |
-81 |
* |
(103 |
/ |
756) |
= |
-11.03571427 |
8 |
12320 |
2506 |
- |
2586 |
= |
-80 |
* |
(120 |
/ |
756) |
= |
-12.69841264 |
11 |
12321 |
2536 |
- |
2628 |
= |
-92 |
* |
(155 |
/ |
756) |
= |
-18.86243386 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Caruthers Unified
|
-53 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-67
|
-56
|
-53
|
-44
|
-53
|
-273.0 |
-54.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -30.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -78.6
For the lines, you have the data necessary to plot the chart.