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 |
723666 |
2458 |
- |
2436 |
= |
22 |
* |
(165 |
/ |
952) |
= |
3.81302519 |
4 |
723667 |
2517 |
- |
2485 |
= |
32 |
* |
(143 |
/ |
952) |
= |
4.80672269 |
5 |
723669 |
2551 |
- |
2528 |
= |
23 |
* |
(167 |
/ |
952) |
= |
4.03466386 |
6 |
723671 |
2560 |
- |
2552 |
= |
8 |
* |
(178 |
/ |
952) |
= |
1.49579831 |
7 |
723674 |
2596 |
- |
2567 |
= |
29 |
* |
(178 |
/ |
952) |
= |
5.42226888 |
8 |
723676 |
2620 |
- |
2586 |
= |
34 |
* |
(121 |
/ |
952) |
= |
4.32142856 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Hermosa Beach City Elementary
|
24 |
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 |
22782 |
2502 |
- |
2436 |
= |
66 |
* |
(148 |
/ |
980) |
= |
9.96734693 |
4 |
22785 |
2524 |
- |
2485 |
= |
39 |
* |
(168 |
/ |
980) |
= |
6.68571427 |
5 |
22786 |
2558 |
- |
2528 |
= |
30 |
* |
(143 |
/ |
980) |
= |
4.37755101 |
6 |
22788 |
2582 |
- |
2552 |
= |
30 |
* |
(160 |
/ |
980) |
= |
4.89795918 |
7 |
22790 |
2599 |
- |
2567 |
= |
32 |
* |
(181 |
/ |
980) |
= |
5.91020406 |
8 |
22792 |
2629 |
- |
2586 |
= |
43 |
* |
(180 |
/ |
980) |
= |
7.89795917 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Hermosa Beach City Elementary
|
40 |
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 |
23216 |
2503 |
- |
2436 |
= |
67 |
* |
(142 |
/ |
943) |
= |
10.08907735 |
4 |
23218 |
2542 |
- |
2485 |
= |
57 |
* |
(152 |
/ |
943) |
= |
9.18769879 |
5 |
23220 |
2551 |
- |
2528 |
= |
23 |
* |
(169 |
/ |
943) |
= |
4.12195121 |
6 |
23221 |
2578 |
- |
2552 |
= |
26 |
* |
(144 |
/ |
943) |
= |
3.97030751 |
7 |
23224 |
2593 |
- |
2567 |
= |
26 |
* |
(162 |
/ |
943) |
= |
4.46659595 |
8 |
23225 |
2643 |
- |
2586 |
= |
57 |
* |
(174 |
/ |
943) |
= |
10.51749733 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Hermosa Beach City Elementary
|
42 |
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 |
23218 |
2506 |
- |
2436 |
= |
70 |
* |
(145 |
/ |
920) |
= |
11.03260865 |
4 |
23221 |
2530 |
- |
2485 |
= |
45 |
* |
(145 |
/ |
920) |
= |
7.09239128 |
5 |
23222 |
2587 |
- |
2528 |
= |
59 |
* |
(157 |
/ |
920) |
= |
10.06847821 |
6 |
23225 |
2586 |
- |
2552 |
= |
34 |
* |
(163 |
/ |
920) |
= |
6.02391304 |
7 |
23226 |
2603 |
- |
2567 |
= |
36 |
* |
(149 |
/ |
920) |
= |
5.83043476 |
8 |
23229 |
2631 |
- |
2586 |
= |
45 |
* |
(161 |
/ |
920) |
= |
7.875 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Hermosa Beach City Elementary
|
48 |
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 |
23395 |
2498 |
- |
2436 |
= |
62 |
* |
(143 |
/ |
912) |
= |
9.72149119 |
4 |
23396 |
2548 |
- |
2485 |
= |
63 |
* |
(145 |
/ |
912) |
= |
10.01644736 |
5 |
23397 |
2564 |
- |
2528 |
= |
36 |
* |
(144 |
/ |
912) |
= |
5.6842105 |
6 |
23398 |
2596 |
- |
2552 |
= |
44 |
* |
(168 |
/ |
912) |
= |
8.10526314 |
7 |
23399 |
2605 |
- |
2567 |
= |
38 |
* |
(168 |
/ |
912) |
= |
6.99999999 |
8 |
23400 |
2649 |
- |
2586 |
= |
63 |
* |
(144 |
/ |
912) |
= |
9.94736837 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Hermosa Beach City Elementary
|
50 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
24
|
40
|
42
|
48
|
50
|
204.0 |
40.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 70.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 10.8
For the lines, you have the data necessary to plot the chart.