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 |
2126467 |
2425 |
- |
2436 |
= |
-11 |
* |
(3500 |
/ |
13705) |
= |
-2.80919372 |
4 |
2126468 |
2466 |
- |
2485 |
= |
-19 |
* |
(3457 |
/ |
13705) |
= |
-4.79263041 |
5 |
2126471 |
2506 |
- |
2528 |
= |
-22 |
* |
(3320 |
/ |
13705) |
= |
-5.32944179 |
6 |
2126472 |
2531 |
- |
2552 |
= |
-21 |
* |
(3428 |
/ |
13705) |
= |
-5.25268149 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Chula Vista Elementary
|
-18 |
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 |
65297 |
2443 |
- |
2436 |
= |
7 |
* |
(3243 |
/ |
13636) |
= |
1.66478439 |
4 |
65299 |
2479 |
- |
2485 |
= |
-6 |
* |
(3526 |
/ |
13636) |
= |
-1.55148137 |
5 |
65300 |
2503 |
- |
2528 |
= |
-25 |
* |
(3478 |
/ |
13636) |
= |
-6.37650335 |
6 |
65302 |
2541 |
- |
2552 |
= |
-11 |
* |
(3385 |
/ |
13636) |
= |
-2.73063948 |
7 |
65305 |
0 |
- |
2567 |
= |
|
* |
(3 |
/ |
13636) |
= |
|
8 |
65306 |
0 |
- |
2586 |
= |
|
* |
(1 |
/ |
13636) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Chula Vista Elementary
|
-9 |
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 |
67109 |
2446 |
- |
2436 |
= |
10 |
* |
(3123 |
/ |
13362) |
= |
2.33722496 |
4 |
67111 |
2484 |
- |
2485 |
= |
-1 |
* |
(3236 |
/ |
13362) |
= |
-0.24217931 |
5 |
67113 |
2512 |
- |
2528 |
= |
-16 |
* |
(3532 |
/ |
13362) |
= |
-4.22930698 |
6 |
67115 |
2539 |
- |
2552 |
= |
-13 |
* |
(3471 |
/ |
13362) |
= |
-3.37696453 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Chula Vista Elementary
|
-6 |
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 |
67205 |
2445 |
- |
2436 |
= |
9 |
* |
(3022 |
/ |
13134) |
= |
2.07080859 |
4 |
67207 |
2487 |
- |
2485 |
= |
2 |
* |
(3181 |
/ |
13134) |
= |
0.48439165 |
5 |
67209 |
2512 |
- |
2528 |
= |
-16 |
* |
(3322 |
/ |
13134) |
= |
-4.04690117 |
6 |
67211 |
2546 |
- |
2552 |
= |
-6 |
* |
(3609 |
/ |
13134) |
= |
-1.64869803 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Chula Vista Elementary
|
-3 |
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 |
67703 |
2452 |
- |
2436 |
= |
16 |
* |
(3224 |
/ |
12925) |
= |
3.99102514 |
4 |
67704 |
2489 |
- |
2485 |
= |
4 |
* |
(3097 |
/ |
12925) |
= |
0.95845261 |
5 |
67705 |
2511 |
- |
2528 |
= |
-17 |
* |
(3215 |
/ |
12925) |
= |
-4.22862668 |
6 |
67706 |
2542 |
- |
2552 |
= |
-10 |
* |
(3388 |
/ |
12925) |
= |
-2.62127659 |
7 |
67707 |
0 |
- |
2567 |
= |
|
* |
(0 |
/ |
12925) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Chula Vista Elementary
|
-2 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-18
|
-9
|
-6
|
-3
|
-2
|
-38.0 |
-7.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 10.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -25.6
For the lines, you have the data necessary to plot the chart.