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 |
2864979 |
2472 |
- |
2436 |
= |
36 |
* |
(34 |
/ |
113) |
= |
10.83185838 |
4 |
2864981 |
2504 |
- |
2485 |
= |
19 |
* |
(28 |
/ |
113) |
= |
4.70796459 |
5 |
2864983 |
2564 |
- |
2528 |
= |
36 |
* |
(29 |
/ |
113) |
= |
9.23893805 |
6 |
2864984 |
2591 |
- |
2552 |
= |
39 |
* |
(22 |
/ |
113) |
= |
7.59292034 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Liberty Elementary
|
32 |
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 |
87641 |
2463 |
- |
2436 |
= |
27 |
* |
(33 |
/ |
120) |
= |
7.425 |
4 |
87642 |
2520 |
- |
2485 |
= |
35 |
* |
(31 |
/ |
120) |
= |
9.04166666 |
5 |
87645 |
2574 |
- |
2528 |
= |
46 |
* |
(30 |
/ |
120) |
= |
11.5 |
6 |
87646 |
2613 |
- |
2552 |
= |
61 |
* |
(26 |
/ |
120) |
= |
13.21666663 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Liberty Elementary
|
41 |
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 |
90142 |
2490 |
- |
2436 |
= |
54 |
* |
(29 |
/ |
116) |
= |
13.5 |
4 |
90143 |
2531 |
- |
2485 |
= |
46 |
* |
(30 |
/ |
116) |
= |
11.89655169 |
5 |
90146 |
2602 |
- |
2528 |
= |
74 |
* |
(28 |
/ |
116) |
= |
17.86206894 |
6 |
90148 |
2620 |
- |
2552 |
= |
68 |
* |
(29 |
/ |
116) |
= |
17.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Liberty Elementary
|
60 |
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 |
90364 |
2494 |
- |
2436 |
= |
58 |
* |
(27 |
/ |
118) |
= |
13.27118642 |
4 |
90366 |
2549 |
- |
2485 |
= |
64 |
* |
(28 |
/ |
118) |
= |
15.18644064 |
5 |
90368 |
2604 |
- |
2528 |
= |
76 |
* |
(34 |
/ |
118) |
= |
21.89830507 |
6 |
90370 |
2623 |
- |
2552 |
= |
71 |
* |
(29 |
/ |
118) |
= |
17.44915248 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Liberty Elementary
|
68 |
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 |
90985 |
2456 |
- |
2436 |
= |
20 |
* |
(32 |
/ |
115) |
= |
5.56521738 |
4 |
90986 |
2564 |
- |
2485 |
= |
79 |
* |
(27 |
/ |
115) |
= |
18.54782603 |
5 |
90987 |
2618 |
- |
2528 |
= |
90 |
* |
(28 |
/ |
115) |
= |
21.9130434 |
6 |
90988 |
2631 |
- |
2552 |
= |
79 |
* |
(28 |
/ |
115) |
= |
19.23478254 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Liberty Elementary
|
65 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
32
|
41
|
60
|
68
|
65
|
266.0 |
53.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 98.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 8.2
For the lines, you have the data necessary to plot the chart.