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 |
2173358 |
2398 |
- |
2436 |
= |
-38 |
* |
(33 |
/ |
204) |
= |
-6.14705879 |
4 |
2173359 |
2458 |
- |
2485 |
= |
-27 |
* |
(39 |
/ |
204) |
= |
-5.16176469 |
5 |
2173362 |
2442 |
- |
2528 |
= |
-86 |
* |
(30 |
/ |
204) |
= |
-12.64705878 |
6 |
2173363 |
2543 |
- |
2552 |
= |
-9 |
* |
(32 |
/ |
204) |
= |
-1.41176471 |
7 |
2173366 |
2536 |
- |
2567 |
= |
-31 |
* |
(34 |
/ |
204) |
= |
-5.16666665 |
8 |
2173367 |
2568 |
- |
2586 |
= |
-18 |
* |
(36 |
/ |
204) |
= |
-3.17647058 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Julian Union Elementary
|
-34 |
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 |
66722 |
2423 |
- |
2436 |
= |
-13 |
* |
(32 |
/ |
209) |
= |
-1.99043061 |
4 |
66724 |
2450 |
- |
2485 |
= |
-35 |
* |
(33 |
/ |
209) |
= |
-5.52631576 |
5 |
66726 |
2464 |
- |
2528 |
= |
-64 |
* |
(42 |
/ |
209) |
= |
-12.86124397 |
6 |
66728 |
2545 |
- |
2552 |
= |
-7 |
* |
(31 |
/ |
209) |
= |
-1.03827751 |
7 |
66730 |
2575 |
- |
2567 |
= |
8 |
* |
(31 |
/ |
209) |
= |
1.18660286 |
8 |
66731 |
2592 |
- |
2586 |
= |
6 |
* |
(40 |
/ |
209) |
= |
1.14832535 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Julian Union Elementary
|
-19 |
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 |
68552 |
2400 |
- |
2436 |
= |
-36 |
* |
(33 |
/ |
204) |
= |
-5.82352938 |
4 |
68554 |
2480 |
- |
2485 |
= |
-5 |
* |
(37 |
/ |
204) |
= |
-0.90686275 |
5 |
68557 |
2472 |
- |
2528 |
= |
-56 |
* |
(34 |
/ |
204) |
= |
-9.3333333 |
6 |
68558 |
2542 |
- |
2552 |
= |
-10 |
* |
(41 |
/ |
204) |
= |
-2.00980392 |
7 |
68560 |
2575 |
- |
2567 |
= |
8 |
* |
(29 |
/ |
204) |
= |
1.1372549 |
8 |
68562 |
2586 |
- |
2586 |
= |
0 |
* |
(30 |
/ |
204) |
= |
0.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Julian Union Elementary
|
-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 |
68707 |
2392 |
- |
2436 |
= |
-44 |
* |
(33 |
/ |
196) |
= |
-7.40816322 |
4 |
68709 |
2448 |
- |
2485 |
= |
-37 |
* |
(32 |
/ |
196) |
= |
-6.04081632 |
5 |
68711 |
2514 |
- |
2528 |
= |
-14 |
* |
(37 |
/ |
196) |
= |
-2.64285714 |
6 |
68713 |
2484 |
- |
2552 |
= |
-68 |
* |
(32 |
/ |
196) |
= |
-11.10204081 |
7 |
68715 |
2556 |
- |
2567 |
= |
-11 |
* |
(34 |
/ |
196) |
= |
-1.90816326 |
8 |
68717 |
2563 |
- |
2586 |
= |
-23 |
* |
(28 |
/ |
196) |
= |
-3.28571427 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Julian Union Elementary
|
-32 |
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 |
69232 |
2435 |
- |
2436 |
= |
-1 |
* |
(32 |
/ |
198) |
= |
-0.16161616 |
4 |
69233 |
2423 |
- |
2485 |
= |
-62 |
* |
(27 |
/ |
198) |
= |
-8.45454543 |
5 |
69234 |
2491 |
- |
2528 |
= |
-37 |
* |
(34 |
/ |
198) |
= |
-6.35353533 |
6 |
69235 |
2548 |
- |
2552 |
= |
-4 |
* |
(33 |
/ |
198) |
= |
-0.66666666 |
7 |
69236 |
2500 |
- |
2567 |
= |
-67 |
* |
(33 |
/ |
198) |
= |
-11.16666662 |
8 |
69237 |
2556 |
- |
2586 |
= |
-30 |
* |
(39 |
/ |
198) |
= |
-5.90909088 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Julian Union Elementary
|
-33 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-34
|
-19
|
-17
|
-32
|
-33
|
-135.0 |
-27.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -3.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -51.0
For the lines, you have the data necessary to plot the chart.