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 |
2731040 |
2482 |
- |
2436 |
= |
46 |
* |
(606 |
/ |
3648) |
= |
7.64144737 |
4 |
2731043 |
2528 |
- |
2485 |
= |
43 |
* |
(616 |
/ |
3648) |
= |
7.26096491 |
5 |
2731044 |
2559 |
- |
2528 |
= |
31 |
* |
(629 |
/ |
3648) |
= |
5.3451206 |
6 |
2731047 |
2587 |
- |
2552 |
= |
35 |
* |
(625 |
/ |
3648) |
= |
5.99643639 |
7 |
2731048 |
2597 |
- |
2567 |
= |
30 |
* |
(600 |
/ |
3648) |
= |
4.93421052 |
8 |
2731051 |
2616 |
- |
2586 |
= |
30 |
* |
(572 |
/ |
3648) |
= |
4.70394735 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Union Elementary
|
36 |
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 |
83050 |
2500 |
- |
2436 |
= |
64 |
* |
(686 |
/ |
3818) |
= |
11.49921421 |
4 |
83052 |
2531 |
- |
2485 |
= |
46 |
* |
(629 |
/ |
3818) |
= |
7.57831324 |
5 |
83055 |
2575 |
- |
2528 |
= |
47 |
* |
(618 |
/ |
3818) |
= |
7.60764795 |
6 |
83057 |
2588 |
- |
2552 |
= |
36 |
* |
(655 |
/ |
3818) |
= |
6.17600837 |
7 |
83058 |
2616 |
- |
2567 |
= |
49 |
* |
(618 |
/ |
3818) |
= |
7.93137765 |
8 |
83061 |
2641 |
- |
2586 |
= |
55 |
* |
(612 |
/ |
3818) |
= |
8.81613409 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Union Elementary
|
50 |
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 |
85372 |
2505 |
- |
2436 |
= |
69 |
* |
(644 |
/ |
3906) |
= |
11.37634402 |
4 |
85375 |
2542 |
- |
2485 |
= |
57 |
* |
(712 |
/ |
3906) |
= |
10.39016896 |
5 |
85377 |
2580 |
- |
2528 |
= |
52 |
* |
(648 |
/ |
3906) |
= |
8.62672808 |
6 |
85378 |
2598 |
- |
2552 |
= |
46 |
* |
(629 |
/ |
3906) |
= |
7.40757808 |
7 |
85380 |
2616 |
- |
2567 |
= |
49 |
* |
(653 |
/ |
3906) |
= |
8.19175625 |
8 |
85383 |
2649 |
- |
2586 |
= |
63 |
* |
(620 |
/ |
3906) |
= |
9.99999995 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Union Elementary
|
56 |
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 |
85593 |
2497 |
- |
2436 |
= |
61 |
* |
(608 |
/ |
3938) |
= |
9.41797861 |
4 |
85594 |
2541 |
- |
2485 |
= |
56 |
* |
(672 |
/ |
3938) |
= |
9.55611983 |
5 |
85597 |
2588 |
- |
2528 |
= |
60 |
* |
(715 |
/ |
3938) |
= |
10.8938547 |
6 |
85599 |
2601 |
- |
2552 |
= |
49 |
* |
(670 |
/ |
3938) |
= |
8.33671913 |
7 |
85601 |
2631 |
- |
2567 |
= |
64 |
* |
(616 |
/ |
3938) |
= |
10.01117318 |
8 |
85602 |
2632 |
- |
2586 |
= |
46 |
* |
(657 |
/ |
3938) |
= |
7.67445402 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Union Elementary
|
56 |
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 |
86185 |
2502 |
- |
2436 |
= |
66 |
* |
(610 |
/ |
3955) |
= |
10.17951957 |
4 |
86186 |
2535 |
- |
2485 |
= |
50 |
* |
(626 |
/ |
3955) |
= |
7.91403285 |
5 |
86187 |
2583 |
- |
2528 |
= |
55 |
* |
(696 |
/ |
3955) |
= |
9.67888746 |
6 |
86188 |
2616 |
- |
2552 |
= |
64 |
* |
(728 |
/ |
3955) |
= |
11.78053094 |
7 |
86189 |
2632 |
- |
2567 |
= |
65 |
* |
(668 |
/ |
3955) |
= |
10.97850819 |
8 |
86190 |
2646 |
- |
2586 |
= |
60 |
* |
(627 |
/ |
3955) |
= |
9.51201006 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Union Elementary
|
60 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
36
|
50
|
56
|
56
|
60
|
258.0 |
51.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 78.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 24.6
For the lines, you have the data necessary to plot the chart.