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 |
1043824 |
2450 |
- |
2436 |
= |
14 |
* |
(924 |
/ |
3877) |
= |
3.33660046 |
4 |
1043827 |
2493 |
- |
2485 |
= |
8 |
* |
(967 |
/ |
3877) |
= |
1.99535723 |
5 |
1043828 |
2519 |
- |
2528 |
= |
-9 |
* |
(1010 |
/ |
3877) |
= |
-2.34459634 |
6 |
1043831 |
2559 |
- |
2552 |
= |
7 |
* |
(976 |
/ |
3877) |
= |
1.76218725 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Newhall
|
5 |
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 |
32796 |
2465 |
- |
2436 |
= |
29 |
* |
(990 |
/ |
3926) |
= |
7.31278654 |
4 |
32799 |
2509 |
- |
2485 |
= |
24 |
* |
(949 |
/ |
3926) |
= |
5.8013245 |
5 |
32800 |
2545 |
- |
2528 |
= |
17 |
* |
(974 |
/ |
3926) |
= |
4.21752419 |
6 |
32803 |
2573 |
- |
2552 |
= |
21 |
* |
(1013 |
/ |
3926) |
= |
5.41849209 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Newhall
|
23 |
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 |
33366 |
2477 |
- |
2436 |
= |
41 |
* |
(921 |
/ |
3959) |
= |
9.53801462 |
4 |
33369 |
2511 |
- |
2485 |
= |
26 |
* |
(1030 |
/ |
3959) |
= |
6.76433441 |
5 |
33370 |
2550 |
- |
2528 |
= |
22 |
* |
(983 |
/ |
3959) |
= |
5.46249051 |
6 |
33372 |
2588 |
- |
2552 |
= |
36 |
* |
(1025 |
/ |
3959) |
= |
9.32053547 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Newhall
|
31 |
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 |
33386 |
2482 |
- |
2436 |
= |
46 |
* |
(864 |
/ |
3826) |
= |
10.38787244 |
4 |
33388 |
2522 |
- |
2485 |
= |
37 |
* |
(930 |
/ |
3826) |
= |
8.99372712 |
5 |
33390 |
2548 |
- |
2528 |
= |
20 |
* |
(1019 |
/ |
3826) |
= |
5.32671196 |
6 |
33392 |
2592 |
- |
2552 |
= |
40 |
* |
(1013 |
/ |
3826) |
= |
10.59069524 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Newhall
|
35 |
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 |
33559 |
2478 |
- |
2436 |
= |
42 |
* |
(904 |
/ |
3803) |
= |
9.98369707 |
4 |
33560 |
2526 |
- |
2485 |
= |
41 |
* |
(891 |
/ |
3803) |
= |
9.60583748 |
5 |
33561 |
2552 |
- |
2528 |
= |
24 |
* |
(953 |
/ |
3803) |
= |
6.01419931 |
6 |
33562 |
2593 |
- |
2552 |
= |
41 |
* |
(1055 |
/ |
3803) |
= |
11.37391533 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Newhall
|
37 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
5
|
23
|
31
|
35
|
37
|
131.0 |
26.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 65.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -12.8
For the lines, you have the data necessary to plot the chart.