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 |
1601332 |
2442 |
- |
2436 |
= |
6 |
* |
(324 |
/ |
1901) |
= |
1.02261967 |
4 |
1601333 |
2483 |
- |
2485 |
= |
-2 |
* |
(298 |
/ |
1901) |
= |
-0.3135192 |
5 |
1601336 |
2531 |
- |
2528 |
= |
3 |
* |
(308 |
/ |
1901) |
= |
0.48605997 |
6 |
1601337 |
2554 |
- |
2552 |
= |
2 |
* |
(325 |
/ |
1901) |
= |
0.3419253 |
7 |
1601340 |
2589 |
- |
2567 |
= |
22 |
* |
(316 |
/ |
1901) |
= |
3.6570226 |
8 |
1601341 |
2596 |
- |
2586 |
= |
10 |
* |
(330 |
/ |
1901) |
= |
1.73592845 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Loomis Union Elementary
|
7 |
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 |
50078 |
2451 |
- |
2436 |
= |
15 |
* |
(292 |
/ |
1949) |
= |
2.2473063 |
4 |
50081 |
2492 |
- |
2485 |
= |
7 |
* |
(351 |
/ |
1949) |
= |
1.26064649 |
5 |
50082 |
2553 |
- |
2528 |
= |
25 |
* |
(319 |
/ |
1949) |
= |
4.09184195 |
6 |
50084 |
2556 |
- |
2552 |
= |
4 |
* |
(331 |
/ |
1949) |
= |
0.67932273 |
7 |
50087 |
2590 |
- |
2567 |
= |
23 |
* |
(329 |
/ |
1949) |
= |
3.88250385 |
8 |
50089 |
2617 |
- |
2586 |
= |
31 |
* |
(327 |
/ |
1949) |
= |
5.20112876 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Loomis Union Elementary
|
17 |
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 |
51493 |
2463 |
- |
2436 |
= |
27 |
* |
(299 |
/ |
2012) |
= |
4.01242542 |
4 |
51494 |
2501 |
- |
2485 |
= |
16 |
* |
(326 |
/ |
2012) |
= |
2.59244533 |
5 |
51497 |
2537 |
- |
2528 |
= |
9 |
* |
(362 |
/ |
2012) |
= |
1.61928429 |
6 |
51499 |
2555 |
- |
2552 |
= |
3 |
* |
(347 |
/ |
2012) |
= |
0.51739562 |
7 |
51501 |
2591 |
- |
2567 |
= |
24 |
* |
(340 |
/ |
2012) |
= |
4.05566599 |
8 |
51503 |
2613 |
- |
2586 |
= |
27 |
* |
(338 |
/ |
2012) |
= |
4.53578527 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Loomis Union Elementary
|
17 |
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 |
51523 |
2458 |
- |
2436 |
= |
22 |
* |
(300 |
/ |
2029) |
= |
3.25283389 |
4 |
51524 |
2508 |
- |
2485 |
= |
23 |
* |
(325 |
/ |
2029) |
= |
3.68408082 |
5 |
51527 |
2546 |
- |
2528 |
= |
18 |
* |
(335 |
/ |
2029) |
= |
2.97190733 |
6 |
51528 |
2556 |
- |
2552 |
= |
4 |
* |
(381 |
/ |
2029) |
= |
0.75110892 |
7 |
51531 |
2595 |
- |
2567 |
= |
28 |
* |
(349 |
/ |
2029) |
= |
4.81616559 |
8 |
51532 |
2616 |
- |
2586 |
= |
30 |
* |
(339 |
/ |
2029) |
= |
5.01232134 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Loomis Union Elementary
|
20 |
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 |
51722 |
2459 |
- |
2436 |
= |
23 |
* |
(307 |
/ |
2016) |
= |
3.50248016 |
4 |
51723 |
2515 |
- |
2485 |
= |
30 |
* |
(316 |
/ |
2016) |
= |
4.70238093 |
5 |
51724 |
2550 |
- |
2528 |
= |
22 |
* |
(332 |
/ |
2016) |
= |
3.62301586 |
6 |
51725 |
2570 |
- |
2552 |
= |
18 |
* |
(345 |
/ |
2016) |
= |
3.08035714 |
7 |
51726 |
2599 |
- |
2567 |
= |
32 |
* |
(370 |
/ |
2016) |
= |
5.87301587 |
8 |
51727 |
2632 |
- |
2586 |
= |
46 |
* |
(346 |
/ |
2016) |
= |
7.89484126 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Loomis Union Elementary
|
29 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
7
|
17
|
17
|
20
|
29
|
90.0 |
18.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 39.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -3.0
For the lines, you have the data necessary to plot the chart.