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 |
871166 |
2342 |
- |
2436 |
= |
-94 |
* |
(31 |
/ |
127)
|
= |
-22.94488187 |
| 4 |
871169 |
2385 |
- |
2485 |
= |
-100 |
* |
(39 |
/ |
127)
|
= |
-30.7086614 |
| 5 |
871170 |
2404 |
- |
2528 |
= |
-124 |
* |
(28 |
/ |
127)
|
= |
-27.33858256 |
| 6 |
871173 |
2396 |
- |
2552 |
= |
-156 |
* |
(29 |
/ |
127)
|
= |
-35.62204714 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Annalee Avenue Elementary
|
-117 |
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 |
27557 |
2374 |
- |
2436 |
= |
-62 |
* |
(28 |
/ |
109)
|
= |
-15.92660545 |
| 4 |
27558 |
2395 |
- |
2485 |
= |
-90 |
* |
(36 |
/ |
109)
|
= |
-29.72477061 |
| 5 |
27561 |
2414 |
- |
2528 |
= |
-114 |
* |
(34 |
/ |
109)
|
= |
-35.55963297 |
| 6 |
27562 |
2425 |
- |
2552 |
= |
-127 |
* |
(11 |
/ |
109)
|
= |
-12.81651374 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Annalee Avenue Elementary
|
-94 |
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 |
28129 |
2381 |
- |
2436 |
= |
-55 |
* |
(30 |
/ |
110)
|
= |
-14.99999996 |
| 4 |
28131 |
2431 |
- |
2485 |
= |
-54 |
* |
(25 |
/ |
110)
|
= |
-12.27272726 |
| 5 |
28134 |
2428 |
- |
2528 |
= |
-100 |
* |
(30 |
/ |
110)
|
= |
-27.2727272 |
| 6 |
28135 |
2454 |
- |
2552 |
= |
-98 |
* |
(25 |
/ |
110)
|
= |
-22.27272725 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Annalee Avenue Elementary
|
-77 |
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 |
28181 |
2380 |
- |
2436 |
= |
-56 |
* |
(32 |
/ |
112)
|
= |
-15.99999996 |
| 4 |
28183 |
2415 |
- |
2485 |
= |
-70 |
* |
(27 |
/ |
112)
|
= |
-16.87499996 |
| 5 |
28185 |
2433 |
- |
2528 |
= |
-95 |
* |
(28 |
/ |
112)
|
= |
-23.75 |
| 6 |
28187 |
2456 |
- |
2552 |
= |
-96 |
* |
(25 |
/ |
112)
|
= |
-21.42857136 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Annalee Avenue 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 |
28361 |
2431 |
- |
2436 |
= |
-5 |
* |
(39 |
/ |
125)
|
= |
-1.56 |
| 4 |
28362 |
2431 |
- |
2485 |
= |
-54 |
* |
(33 |
/ |
125)
|
= |
-14.256 |
| 5 |
28363 |
2484 |
- |
2528 |
= |
-44 |
* |
(33 |
/ |
125)
|
= |
-11.616 |
| 6 |
28364 |
2454 |
- |
2552 |
= |
-98 |
* |
(20 |
/ |
125)
|
= |
-15.68 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Annalee Avenue Elementary
|
-43 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-117
|
-94
|
-77
|
-78
|
-43
|
-409.0 |
-81.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -0.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -162.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:
