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 |
114844 |
2494 |
- |
2436 |
= |
58 |
* |
(812 |
/ |
4882) |
= |
9.64686601 |
4 |
114847 |
2529 |
- |
2485 |
= |
44 |
* |
(774 |
/ |
4882) |
= |
6.97582956 |
5 |
114848 |
2567 |
- |
2528 |
= |
39 |
* |
(721 |
/ |
4882) |
= |
5.75972959 |
6 |
114851 |
2581 |
- |
2552 |
= |
29 |
* |
(760 |
/ |
4882) |
= |
4.51454322 |
7 |
114852 |
2606 |
- |
2567 |
= |
39 |
* |
(686 |
/ |
4882) |
= |
5.48013106 |
8 |
114855 |
2625 |
- |
2586 |
= |
39 |
* |
(627 |
/ |
4882) |
= |
5.00880783 |
11 |
114856 |
2650 |
- |
2628 |
= |
22 |
* |
(502 |
/ |
4882) |
= |
2.26218762 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Dublin Unified
|
40 |
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 |
3191 |
2503 |
- |
2436 |
= |
67 |
* |
(844 |
/ |
5262) |
= |
10.74648416 |
4 |
3193 |
2543 |
- |
2485 |
= |
58 |
* |
(872 |
/ |
5262) |
= |
9.61155451 |
5 |
3196 |
2568 |
- |
2528 |
= |
40 |
* |
(811 |
/ |
5262) |
= |
6.16495628 |
6 |
3198 |
2592 |
- |
2552 |
= |
40 |
* |
(764 |
/ |
5262) |
= |
5.80767768 |
7 |
3200 |
2621 |
- |
2567 |
= |
54 |
* |
(763 |
/ |
5262) |
= |
7.8301026 |
8 |
3202 |
2637 |
- |
2586 |
= |
51 |
* |
(704 |
/ |
5262) |
= |
6.82326108 |
11 |
3203 |
2663 |
- |
2628 |
= |
35 |
* |
(504 |
/ |
5262) |
= |
3.35233749 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Dublin Unified
|
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 |
3303 |
2492 |
- |
2436 |
= |
56 |
* |
(983 |
/ |
5683) |
= |
9.68643318 |
4 |
3306 |
2544 |
- |
2485 |
= |
59 |
* |
(872 |
/ |
5683) |
= |
9.05296496 |
5 |
3308 |
2573 |
- |
2528 |
= |
45 |
* |
(903 |
/ |
5683) |
= |
7.15027271 |
6 |
3310 |
2598 |
- |
2552 |
= |
46 |
* |
(820 |
/ |
5683) |
= |
6.6373394 |
7 |
3311 |
2619 |
- |
2567 |
= |
52 |
* |
(777 |
/ |
5683) |
= |
7.10962517 |
8 |
3314 |
2650 |
- |
2586 |
= |
64 |
* |
(770 |
/ |
5683) |
= |
8.67147629 |
11 |
3315 |
2647 |
- |
2628 |
= |
19 |
* |
(558 |
/ |
5683) |
= |
1.86556394 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Dublin Unified
|
50 |
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 |
3299 |
2504 |
- |
2436 |
= |
68 |
* |
(942 |
/ |
5964) |
= |
10.74044265 |
4 |
3301 |
2540 |
- |
2485 |
= |
55 |
* |
(986 |
/ |
5964) |
= |
9.09289068 |
5 |
3303 |
2576 |
- |
2528 |
= |
48 |
* |
(902 |
/ |
5964) |
= |
7.25955734 |
6 |
3305 |
2591 |
- |
2552 |
= |
39 |
* |
(900 |
/ |
5964) |
= |
5.88531185 |
7 |
3307 |
2620 |
- |
2567 |
= |
53 |
* |
(822 |
/ |
5964) |
= |
7.30482893 |
8 |
3309 |
2644 |
- |
2586 |
= |
58 |
* |
(780 |
/ |
5964) |
= |
7.58551306 |
11 |
3311 |
2670 |
- |
2628 |
= |
42 |
* |
(632 |
/ |
5964) |
= |
4.45070422 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Dublin Unified
|
52 |
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 |
3333 |
2505 |
- |
2436 |
= |
69 |
* |
(1010 |
/ |
6355) |
= |
10.96616834 |
4 |
3334 |
2544 |
- |
2485 |
= |
59 |
* |
(952 |
/ |
6355) |
= |
8.83839494 |
5 |
3335 |
2578 |
- |
2528 |
= |
50 |
* |
(1004 |
/ |
6355) |
= |
7.89929185 |
6 |
3336 |
2595 |
- |
2552 |
= |
43 |
* |
(921 |
/ |
6355) |
= |
6.23178597 |
7 |
3337 |
2615 |
- |
2567 |
= |
48 |
* |
(920 |
/ |
6355) |
= |
6.94885915 |
8 |
3338 |
2647 |
- |
2586 |
= |
61 |
* |
(837 |
/ |
6355) |
= |
8.03414634 |
11 |
3339 |
2667 |
- |
2628 |
= |
39 |
* |
(711 |
/ |
6355) |
= |
4.36333595 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Dublin Unified
|
53 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
40
|
50
|
50
|
52
|
53
|
245.0 |
49.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 64.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 34.0
For the lines, you have the data necessary to plot the chart.