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 |
1012865 |
2358 |
- |
2436 |
= |
-78 |
* |
(89 |
/ |
245)
|
= |
-28.33469387 |
| 4 |
1012866 |
2418 |
- |
2485 |
= |
-67 |
* |
(67 |
/ |
245)
|
= |
-18.32244893 |
| 5 |
1012869 |
2413 |
- |
2528 |
= |
-115 |
* |
(89 |
/ |
245)
|
= |
-41.77551019 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Columbus Avenue
|
-88 |
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 |
31968 |
2385 |
- |
2436 |
= |
-51 |
* |
(95 |
/ |
248)
|
= |
-19.53629032 |
| 4 |
31970 |
2400 |
- |
2485 |
= |
-85 |
* |
(88 |
/ |
248)
|
= |
-30.16129027 |
| 5 |
31973 |
2427 |
- |
2528 |
= |
-101 |
* |
(65 |
/ |
248)
|
= |
-26.47177417 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Columbus Avenue
|
-76 |
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 |
32522 |
2386 |
- |
2436 |
= |
-50 |
* |
(92 |
/ |
277)
|
= |
-16.60649815 |
| 4 |
32523 |
2403 |
- |
2485 |
= |
-82 |
* |
(96 |
/ |
277)
|
= |
-28.41877255 |
| 5 |
32526 |
2415 |
- |
2528 |
= |
-113 |
* |
(89 |
/ |
277)
|
= |
-36.30685909 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Columbus Avenue
|
-81 |
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 |
32538 |
2372 |
- |
2436 |
= |
-64 |
* |
(72 |
/ |
246)
|
= |
-18.73170726 |
| 4 |
32541 |
2411 |
- |
2485 |
= |
-74 |
* |
(84 |
/ |
246)
|
= |
-25.26829264 |
| 5 |
32542 |
2409 |
- |
2528 |
= |
-119 |
* |
(90 |
/ |
246)
|
= |
-43.5365853 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Columbus Avenue
|
-88 |
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 |
32720 |
2384 |
- |
2436 |
= |
-52 |
* |
(70 |
/ |
222)
|
= |
-16.39639638 |
| 4 |
32721 |
2417 |
- |
2485 |
= |
-68 |
* |
(68 |
/ |
222)
|
= |
-20.82882881 |
| 5 |
32722 |
2407 |
- |
2528 |
= |
-121 |
* |
(84 |
/ |
222)
|
= |
-45.78378374 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Columbus Avenue
|
-83 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-88
|
-76
|
-81
|
-88
|
-83
|
-416.0 |
-83.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -68.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -98.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:
