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 |
480187 |
2374 |
- |
2436 |
= |
-62 |
* |
(194 |
/ |
1051) |
= |
-11.4443387 |
4 |
480188 |
2413 |
- |
2485 |
= |
-72 |
* |
(176 |
/ |
1051) |
= |
-12.05708846 |
5 |
480191 |
2447 |
- |
2528 |
= |
-81 |
* |
(188 |
/ |
1051) |
= |
-14.48905798 |
6 |
480192 |
2463 |
- |
2552 |
= |
-89 |
* |
(188 |
/ |
1051) |
= |
-15.92007605 |
7 |
480195 |
2509 |
- |
2567 |
= |
-58 |
* |
(161 |
/ |
1051) |
= |
-8.88487152 |
8 |
480196 |
2503 |
- |
2586 |
= |
-83 |
* |
(144 |
/ |
1051) |
= |
-11.37202663 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Beardsley Elementary
|
-74 |
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 |
15228 |
2381 |
- |
2436 |
= |
-55 |
* |
(224 |
/ |
1114) |
= |
-11.05924595 |
4 |
15229 |
2421 |
- |
2485 |
= |
-64 |
* |
(190 |
/ |
1114) |
= |
-10.91561933 |
5 |
15232 |
2452 |
- |
2528 |
= |
-76 |
* |
(175 |
/ |
1114) |
= |
-11.93895864 |
6 |
15233 |
2476 |
- |
2552 |
= |
-76 |
* |
(194 |
/ |
1114) |
= |
-13.23518849 |
7 |
15235 |
2498 |
- |
2567 |
= |
-69 |
* |
(165 |
/ |
1114) |
= |
-10.21992817 |
8 |
15238 |
2510 |
- |
2586 |
= |
-76 |
* |
(166 |
/ |
1114) |
= |
-11.32495509 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Beardsley Elementary
|
-69 |
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 |
15545 |
2384 |
- |
2436 |
= |
-52 |
* |
(216 |
/ |
1141) |
= |
-9.84399645 |
4 |
15546 |
2408 |
- |
2485 |
= |
-77 |
* |
(210 |
/ |
1141) |
= |
-14.17177908 |
5 |
15549 |
2438 |
- |
2528 |
= |
-90 |
* |
(211 |
/ |
1141) |
= |
-16.64329527 |
6 |
15551 |
2471 |
- |
2552 |
= |
-81 |
* |
(164 |
/ |
1141) |
= |
-11.64241893 |
7 |
15553 |
2505 |
- |
2567 |
= |
-62 |
* |
(188 |
/ |
1141) |
= |
-10.21560031 |
8 |
15554 |
2501 |
- |
2586 |
= |
-85 |
* |
(152 |
/ |
1141) |
= |
-11.32340046 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Beardsley Elementary
|
-74 |
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 |
15565 |
2380 |
- |
2436 |
= |
-56 |
* |
(197 |
/ |
1170) |
= |
-9.42905981 |
4 |
15568 |
2419 |
- |
2485 |
= |
-66 |
* |
(230 |
/ |
1170) |
= |
-12.97435894 |
5 |
15569 |
2423 |
- |
2528 |
= |
-105 |
* |
(194 |
/ |
1170) |
= |
-17.41025633 |
6 |
15572 |
2473 |
- |
2552 |
= |
-79 |
* |
(216 |
/ |
1170) |
= |
-14.58461534 |
7 |
15573 |
2486 |
- |
2567 |
= |
-81 |
* |
(154 |
/ |
1170) |
= |
-10.66153841 |
8 |
15576 |
2501 |
- |
2586 |
= |
-85 |
* |
(179 |
/ |
1170) |
= |
-13.00427342 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Beardsley Elementary
|
-78 |
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 |
15682 |
2391 |
- |
2436 |
= |
-45 |
* |
(209 |
/ |
1175) |
= |
-8.0042553 |
4 |
15683 |
2418 |
- |
2485 |
= |
-67 |
* |
(196 |
/ |
1175) |
= |
-11.17617017 |
5 |
15684 |
2433 |
- |
2528 |
= |
-95 |
* |
(224 |
/ |
1175) |
= |
-18.11063822 |
6 |
15685 |
2446 |
- |
2552 |
= |
-106 |
* |
(200 |
/ |
1175) |
= |
-18.04255309 |
7 |
15686 |
2502 |
- |
2567 |
= |
-65 |
* |
(193 |
/ |
1175) |
= |
-10.67659574 |
8 |
15687 |
2501 |
- |
2586 |
= |
-85 |
* |
(153 |
/ |
1175) |
= |
-11.06808503 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Beardsley Elementary
|
-77 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-74
|
-69
|
-74
|
-78
|
-77
|
-372.0 |
-74.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -65.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -83.4
For the lines, you have the data necessary to plot the chart.