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 |
1400869 |
2442 |
- |
2436 |
= |
6 |
* |
(103 |
/ |
748) |
= |
0.8262032 |
4 |
1400870 |
2470 |
- |
2485 |
= |
-15 |
* |
(119 |
/ |
748) |
= |
-2.38636364 |
5 |
1400873 |
2524 |
- |
2528 |
= |
-4 |
* |
(122 |
/ |
748) |
= |
-0.65240642 |
6 |
1400874 |
2527 |
- |
2552 |
= |
-25 |
* |
(145 |
/ |
748) |
= |
-4.84625668 |
7 |
1400877 |
2577 |
- |
2567 |
= |
10 |
* |
(139 |
/ |
748) |
= |
1.85828877 |
8 |
1400878 |
2563 |
- |
2586 |
= |
-23 |
* |
(120 |
/ |
748) |
= |
-3.68983956 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Pleasant Ridge Union Elementary
|
-9 |
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 |
44181 |
2441 |
- |
2436 |
= |
5 |
* |
(139 |
/ |
786) |
= |
0.88422392 |
4 |
44182 |
2489 |
- |
2485 |
= |
4 |
* |
(117 |
/ |
786) |
= |
0.59541984 |
5 |
44184 |
2499 |
- |
2528 |
= |
-29 |
* |
(121 |
/ |
786) |
= |
-4.46437658 |
6 |
44186 |
2546 |
- |
2552 |
= |
-6 |
* |
(127 |
/ |
786) |
= |
-0.96946565 |
7 |
44188 |
2572 |
- |
2567 |
= |
5 |
* |
(142 |
/ |
786) |
= |
0.90330789 |
8 |
44190 |
2579 |
- |
2586 |
= |
-7 |
* |
(140 |
/ |
786) |
= |
-1.24681934 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Pleasant Ridge Union Elementary
|
-4 |
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 |
45259 |
2431 |
- |
2436 |
= |
-5 |
* |
(101 |
/ |
767) |
= |
-0.65840939 |
4 |
45261 |
2495 |
- |
2485 |
= |
10 |
* |
(137 |
/ |
767) |
= |
1.78617992 |
5 |
45264 |
2506 |
- |
2528 |
= |
-22 |
* |
(122 |
/ |
767) |
= |
-3.49934809 |
6 |
45265 |
2509 |
- |
2552 |
= |
-43 |
* |
(127 |
/ |
767) |
= |
-7.11994783 |
7 |
45267 |
2585 |
- |
2567 |
= |
18 |
* |
(135 |
/ |
767) |
= |
3.16818774 |
8 |
45269 |
2568 |
- |
2586 |
= |
-18 |
* |
(145 |
/ |
767) |
= |
-3.4028683 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Pleasant Ridge Union Elementary
|
-10 |
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 |
45271 |
2437 |
- |
2436 |
= |
1 |
* |
(110 |
/ |
746) |
= |
0.14745308 |
4 |
45272 |
2483 |
- |
2485 |
= |
-2 |
* |
(106 |
/ |
746) |
= |
-0.2841823 |
5 |
45275 |
2507 |
- |
2528 |
= |
-21 |
* |
(138 |
/ |
746) |
= |
-3.8847185 |
6 |
45276 |
2514 |
- |
2552 |
= |
-38 |
* |
(127 |
/ |
746) |
= |
-6.46916887 |
7 |
45279 |
2542 |
- |
2567 |
= |
-25 |
* |
(129 |
/ |
746) |
= |
-4.3230563 |
8 |
45280 |
2565 |
- |
2586 |
= |
-21 |
* |
(136 |
/ |
746) |
= |
-3.82841823 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Pleasant Ridge Union Elementary
|
-19 |
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 |
45407 |
2441 |
- |
2436 |
= |
5 |
* |
(116 |
/ |
756) |
= |
0.76719577 |
4 |
45408 |
2481 |
- |
2485 |
= |
-4 |
* |
(123 |
/ |
756) |
= |
-0.65079365 |
5 |
45409 |
2508 |
- |
2528 |
= |
-20 |
* |
(113 |
/ |
756) |
= |
-2.98941798 |
6 |
45410 |
2501 |
- |
2552 |
= |
-51 |
* |
(136 |
/ |
756) |
= |
-9.17460313 |
7 |
45411 |
2524 |
- |
2567 |
= |
-43 |
* |
(129 |
/ |
756) |
= |
-7.33730156 |
8 |
45412 |
2509 |
- |
2586 |
= |
-77 |
* |
(139 |
/ |
756) |
= |
-14.15740734 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Pleasant Ridge Union Elementary
|
-34 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-9
|
-4
|
-10
|
-19
|
-34
|
-76.0 |
-15.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 17.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -48.2
For the lines, you have the data necessary to plot the chart.