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 |
581414 |
2382 |
- |
2436 |
= |
-54 |
* |
(28 |
/ |
158) |
= |
-9.56962021 |
4 |
581415 |
2400 |
- |
2485 |
= |
-85 |
* |
(32 |
/ |
158) |
= |
-17.21518983 |
5 |
581418 |
2453 |
- |
2528 |
= |
-75 |
* |
(21 |
/ |
158) |
= |
-9.9683544 |
6 |
581419 |
2426 |
- |
2552 |
= |
-126 |
* |
(26 |
/ |
158) |
= |
-20.73417721 |
7 |
581422 |
2469 |
- |
2567 |
= |
-98 |
* |
(27 |
/ |
158) |
= |
-16.74683535 |
8 |
581423 |
2481 |
- |
2586 |
= |
-105 |
* |
(24 |
/ |
158) |
= |
-15.94936707 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lucerne Elementary
|
-90 |
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 |
18535 |
2381 |
- |
2436 |
= |
-55 |
* |
(32 |
/ |
179) |
= |
-9.8324022 |
4 |
18536 |
2437 |
- |
2485 |
= |
-48 |
* |
(31 |
/ |
179) |
= |
-8.31284914 |
5 |
18538 |
2452 |
- |
2528 |
= |
-76 |
* |
(34 |
/ |
179) |
= |
-14.43575418 |
6 |
18540 |
2472 |
- |
2552 |
= |
-80 |
* |
(23 |
/ |
179) |
= |
-10.2793296 |
7 |
18542 |
2475 |
- |
2567 |
= |
-92 |
* |
(29 |
/ |
179) |
= |
-14.90502792 |
8 |
18545 |
2501 |
- |
2586 |
= |
-85 |
* |
(30 |
/ |
179) |
= |
-14.24581003 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lucerne Elementary
|
-72 |
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 |
18867 |
2398 |
- |
2436 |
= |
-38 |
* |
(23 |
/ |
158) |
= |
-5.53164556 |
4 |
18870 |
2412 |
- |
2485 |
= |
-73 |
* |
(33 |
/ |
158) |
= |
-15.24683541 |
5 |
18871 |
2449 |
- |
2528 |
= |
-79 |
* |
(25 |
/ |
158) |
= |
-12.49999999 |
6 |
18874 |
2461 |
- |
2552 |
= |
-91 |
* |
(28 |
/ |
158) |
= |
-16.1265822 |
7 |
18876 |
2433 |
- |
2567 |
= |
-134 |
* |
(20 |
/ |
158) |
= |
-16.96202525 |
8 |
18878 |
2490 |
- |
2586 |
= |
-96 |
* |
(29 |
/ |
158) |
= |
-17.62025309 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lucerne Elementary
|
-84 |
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 |
18877 |
2397 |
- |
2436 |
= |
-39 |
* |
(27 |
/ |
158) |
= |
-6.66455693 |
4 |
18880 |
2437 |
- |
2485 |
= |
-48 |
* |
(26 |
/ |
158) |
= |
-7.89873418 |
5 |
18881 |
2440 |
- |
2528 |
= |
-88 |
* |
(32 |
/ |
158) |
= |
-17.82278476 |
6 |
18884 |
2500 |
- |
2552 |
= |
-52 |
* |
(27 |
/ |
158) |
= |
-8.8860759 |
7 |
18885 |
2450 |
- |
2567 |
= |
-117 |
* |
(28 |
/ |
158) |
= |
-20.73417711 |
8 |
18888 |
2504 |
- |
2586 |
= |
-82 |
* |
(18 |
/ |
158) |
= |
-9.3417721 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lucerne Elementary
|
-71 |
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 |
19035 |
2408 |
- |
2436 |
= |
-28 |
* |
(32 |
/ |
172) |
= |
-5.20930231 |
4 |
19036 |
2425 |
- |
2485 |
= |
-60 |
* |
(29 |
/ |
172) |
= |
-10.11627906 |
5 |
19037 |
2458 |
- |
2528 |
= |
-70 |
* |
(27 |
/ |
172) |
= |
-10.98837208 |
6 |
19038 |
2451 |
- |
2552 |
= |
-101 |
* |
(30 |
/ |
172) |
= |
-17.616279 |
7 |
19039 |
2489 |
- |
2567 |
= |
-78 |
* |
(28 |
/ |
172) |
= |
-12.69767437 |
8 |
19040 |
2493 |
- |
2586 |
= |
-93 |
* |
(26 |
/ |
172) |
= |
-14.05813947 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lucerne Elementary
|
-71 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-90
|
-72
|
-84
|
-71
|
-71
|
-388.0 |
-77.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -53.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -101.6
For the lines, you have the data necessary to plot the chart.