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 |
968716 |
2403 |
- |
2436 |
= |
-33 |
* |
(158 |
/ |
453)
|
= |
-11.50993374 |
| 4 |
968719 |
2431 |
- |
2485 |
= |
-54 |
* |
(151 |
/ |
453)
|
= |
-17.99999998 |
| 5 |
968720 |
2471 |
- |
2528 |
= |
-57 |
* |
(144 |
/ |
453)
|
= |
-18.11920526 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Valerio Street Elementary
|
-48 |
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 |
30652 |
2414 |
- |
2436 |
= |
-22 |
* |
(167 |
/ |
478)
|
= |
-7.68619245 |
| 4 |
30654 |
2437 |
- |
2485 |
= |
-48 |
* |
(154 |
/ |
478)
|
= |
-15.46443514 |
| 5 |
30657 |
2466 |
- |
2528 |
= |
-62 |
* |
(157 |
/ |
478)
|
= |
-20.36401668 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Valerio Street Elementary
|
-44 |
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 |
31218 |
2399 |
- |
2436 |
= |
-37 |
* |
(148 |
/ |
470)
|
= |
-11.65106383 |
| 4 |
31220 |
2423 |
- |
2485 |
= |
-62 |
* |
(169 |
/ |
470)
|
= |
-22.29361702 |
| 5 |
31222 |
2448 |
- |
2528 |
= |
-80 |
* |
(153 |
/ |
470)
|
= |
-26.04255312 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Valerio Street Elementary
|
-60 |
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 |
31264 |
2383 |
- |
2436 |
= |
-53 |
* |
(122 |
/ |
429)
|
= |
-15.07226105 |
| 4 |
31266 |
2418 |
- |
2485 |
= |
-67 |
* |
(143 |
/ |
429)
|
= |
-22.33333331 |
| 5 |
31268 |
2460 |
- |
2528 |
= |
-68 |
* |
(164 |
/ |
429)
|
= |
-25.99533798 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Valerio Street Elementary
|
-63 |
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 |
31440 |
2390 |
- |
2436 |
= |
-46 |
* |
(136 |
/ |
393)
|
= |
-15.91857503 |
| 4 |
31441 |
2402 |
- |
2485 |
= |
-83 |
* |
(116 |
/ |
393)
|
= |
-24.4987277 |
| 5 |
31442 |
2461 |
- |
2528 |
= |
-67 |
* |
(141 |
/ |
393)
|
= |
-24.03816788 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Valerio Street Elementary
|
-64 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-48
|
-44
|
-60
|
-63
|
-64
|
-279.0 |
-55.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -28.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -82.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:
