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 |
6 |
995438 |
2439 |
- |
2552 |
= |
-113 |
* |
(206 |
/ |
629)
|
= |
-37.00794906 |
7 |
995441 |
2433 |
- |
2567 |
= |
-134 |
* |
(198 |
/ |
629)
|
= |
-42.18123998 |
8 |
995442 |
2458 |
- |
2586 |
= |
-128 |
* |
(225 |
/ |
629)
|
= |
-45.78696333 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Audubon Middle
|
-125 |
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 |
6 |
31432 |
2432 |
- |
2552 |
= |
-120 |
* |
(201 |
/ |
621)
|
= |
-38.84057964 |
7 |
31435 |
2426 |
- |
2567 |
= |
-141 |
* |
(214 |
/ |
621)
|
= |
-48.58937198 |
8 |
31437 |
2437 |
- |
2586 |
= |
-149 |
* |
(206 |
/ |
621)
|
= |
-49.42673102 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Audubon Middle
|
-137 |
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 |
6 |
31985 |
2400 |
- |
2552 |
= |
-152 |
* |
(130 |
/ |
525)
|
= |
-37.63809514 |
7 |
31987 |
2441 |
- |
2567 |
= |
-126 |
* |
(183 |
/ |
525)
|
= |
-43.91999993 |
8 |
31990 |
2427 |
- |
2586 |
= |
-159 |
* |
(212 |
/ |
525)
|
= |
-64.20571416 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Audubon Middle
|
-146 |
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 |
6 |
32013 |
2372 |
- |
2552 |
= |
-180 |
* |
(143 |
/ |
481)
|
= |
-53.51351346 |
7 |
32015 |
2424 |
- |
2567 |
= |
-143 |
* |
(134 |
/ |
481)
|
= |
-39.83783775 |
8 |
32017 |
2432 |
- |
2586 |
= |
-154 |
* |
(204 |
/ |
481)
|
= |
-65.3139293 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Audubon Middle
|
-159 |
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 |
6 |
32194 |
2403 |
- |
2552 |
= |
-149 |
* |
(155 |
/ |
447)
|
= |
-51.66666665 |
7 |
32195 |
2419 |
- |
2567 |
= |
-148 |
* |
(147 |
/ |
447)
|
= |
-48.67114088 |
8 |
32196 |
2411 |
- |
2586 |
= |
-175 |
* |
(145 |
/ |
447)
|
= |
-56.76733773 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Audubon Middle
|
-157 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-125
|
-137
|
-146
|
-159
|
-157
|
-724.0 |
-144.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -102.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -186.8
For the lines, you have the data necessary to plot the chart.
Very last step
The percent of students getting a Free or Reduced Price Meal comes from the following sources: