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 |
902178 |
2362 |
- |
2436 |
= |
-74 |
* |
(117 |
/ |
343)
|
= |
-25.24198245 |
| 4 |
902179 |
2421 |
- |
2485 |
= |
-64 |
* |
(112 |
/ |
343)
|
= |
-20.89795917 |
| 5 |
902182 |
2447 |
- |
2528 |
= |
-81 |
* |
(114 |
/ |
343)
|
= |
-26.9212828 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Fernangeles Elementary
|
-73 |
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 |
28506 |
2380 |
- |
2436 |
= |
-56 |
* |
(113 |
/ |
333)
|
= |
-19.00300298 |
| 4 |
28509 |
2419 |
- |
2485 |
= |
-66 |
* |
(115 |
/ |
333)
|
= |
-22.79279277 |
| 5 |
28511 |
2455 |
- |
2528 |
= |
-73 |
* |
(105 |
/ |
333)
|
= |
-23.018018 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Fernangeles Elementary
|
-65 |
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 |
29073 |
2400 |
- |
2436 |
= |
-36 |
* |
(108 |
/ |
321)
|
= |
-12.11214953 |
| 4 |
29075 |
2420 |
- |
2485 |
= |
-65 |
* |
(108 |
/ |
321)
|
= |
-21.86915887 |
| 5 |
29078 |
2438 |
- |
2528 |
= |
-90 |
* |
(105 |
/ |
321)
|
= |
-29.43925227 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Fernangeles Elementary
|
-63 |
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 |
29123 |
2396 |
- |
2436 |
= |
-40 |
* |
(107 |
/ |
307)
|
= |
-13.94136804 |
| 4 |
29125 |
2440 |
- |
2485 |
= |
-45 |
* |
(98 |
/ |
307)
|
= |
-14.36482085 |
| 5 |
29127 |
2447 |
- |
2528 |
= |
-81 |
* |
(102 |
/ |
307)
|
= |
-26.91205212 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Fernangeles Elementary
|
-55 |
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 |
29302 |
2394 |
- |
2436 |
= |
-42 |
* |
(83 |
/ |
290)
|
= |
-12.02068963 |
| 4 |
29303 |
2446 |
- |
2485 |
= |
-39 |
* |
(107 |
/ |
290)
|
= |
-14.38965516 |
| 5 |
29304 |
2452 |
- |
2528 |
= |
-76 |
* |
(100 |
/ |
290)
|
= |
-26.20689654 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Fernangeles Elementary
|
-53 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-73
|
-65
|
-63
|
-55
|
-53
|
-309.0 |
-61.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -37.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -85.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:
