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 |
825980 |
2387 |
- |
2436 |
= |
-49 |
* |
(95 |
/ |
280)
|
= |
-16.62499999 |
4 |
825983 |
2409 |
- |
2485 |
= |
-76 |
* |
(90 |
/ |
280)
|
= |
-24.4285714 |
5 |
825984 |
2443 |
- |
2528 |
= |
-85 |
* |
(95 |
/ |
280)
|
= |
-28.83928569 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Julie Korenstein Elementary
|
-70 |
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 |
25869 |
2389 |
- |
2436 |
= |
-47 |
* |
(79 |
/ |
244)
|
= |
-15.21721308 |
4 |
25870 |
2433 |
- |
2485 |
= |
-52 |
* |
(83 |
/ |
244)
|
= |
-17.68852457 |
5 |
25873 |
2422 |
- |
2528 |
= |
-106 |
* |
(82 |
/ |
244)
|
= |
-35.62295074 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Julie Korenstein 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 |
26350 |
2389 |
- |
2436 |
= |
-47 |
* |
(81 |
/ |
239)
|
= |
-15.92887025 |
4 |
26352 |
2425 |
- |
2485 |
= |
-60 |
* |
(75 |
/ |
239)
|
= |
-18.82845186 |
5 |
26353 |
2428 |
- |
2528 |
= |
-100 |
* |
(83 |
/ |
239)
|
= |
-34.7280334 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Julie Korenstein Elementary
|
-69 |
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 |
26323 |
2389 |
- |
2436 |
= |
-47 |
* |
(80 |
/ |
230)
|
= |
-16.34782604 |
4 |
26325 |
2432 |
- |
2485 |
= |
-53 |
* |
(78 |
/ |
230)
|
= |
-17.973913 |
5 |
26327 |
2430 |
- |
2528 |
= |
-98 |
* |
(72 |
/ |
230)
|
= |
-30.67826084 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Julie Korenstein Elementary
|
-65 |
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 |
26458 |
2393 |
- |
2436 |
= |
-43 |
* |
(72 |
/ |
220)
|
= |
-14.07272726 |
4 |
26459 |
2440 |
- |
2485 |
= |
-45 |
* |
(68 |
/ |
220)
|
= |
-13.90909091 |
5 |
26460 |
2445 |
- |
2528 |
= |
-83 |
* |
(80 |
/ |
220)
|
= |
-30.18181813 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Julie Korenstein Elementary
|
-58 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-70
|
-69
|
-69
|
-65
|
-58
|
-331.0 |
-66.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -54.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -78.2
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: