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 |
897675 |
2356 |
- |
2436 |
= |
-80 |
* |
(159 |
/ |
486)
|
= |
-26.17283944 |
4 |
897678 |
2419 |
- |
2485 |
= |
-66 |
* |
(159 |
/ |
486)
|
= |
-21.59259254 |
5 |
897679 |
2457 |
- |
2528 |
= |
-71 |
* |
(168 |
/ |
486)
|
= |
-24.54320985 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Eastman Avenue Elementary
|
-72 |
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 |
28365 |
2387 |
- |
2436 |
= |
-49 |
* |
(167 |
/ |
464)
|
= |
-17.63577586 |
4 |
28366 |
2417 |
- |
2485 |
= |
-68 |
* |
(149 |
/ |
464)
|
= |
-21.83620685 |
5 |
28369 |
2442 |
- |
2528 |
= |
-86 |
* |
(148 |
/ |
464)
|
= |
-27.43103446 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Eastman Avenue Elementary
|
-67 |
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 |
28932 |
2375 |
- |
2436 |
= |
-61 |
* |
(136 |
/ |
435)
|
= |
-19.07126436 |
4 |
28934 |
2415 |
- |
2485 |
= |
-70 |
* |
(154 |
/ |
435)
|
= |
-24.78160916 |
5 |
28936 |
2421 |
- |
2528 |
= |
-107 |
* |
(145 |
/ |
435)
|
= |
-35.66666663 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Eastman Avenue Elementary
|
-80 |
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 |
28980 |
2406 |
- |
2436 |
= |
-30 |
* |
(117 |
/ |
405)
|
= |
-8.66666664 |
4 |
28982 |
2412 |
- |
2485 |
= |
-73 |
* |
(138 |
/ |
405)
|
= |
-24.87407402 |
5 |
28984 |
2436 |
- |
2528 |
= |
-92 |
* |
(150 |
/ |
405)
|
= |
-34.07407404 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Eastman Avenue Elementary
|
-68 |
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 |
29160 |
2394 |
- |
2436 |
= |
-42 |
* |
(136 |
/ |
382)
|
= |
-14.95287956 |
4 |
29161 |
2448 |
- |
2485 |
= |
-37 |
* |
(116 |
/ |
382)
|
= |
-11.23560208 |
5 |
29162 |
2440 |
- |
2528 |
= |
-88 |
* |
(130 |
/ |
382)
|
= |
-29.94764397 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Eastman Avenue Elementary
|
-56 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-72
|
-67
|
-80
|
-68
|
-56
|
-343.0 |
-68.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -44.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -92.6
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: