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 |
900816 |
2369 |
- |
2436 |
= |
-67 |
* |
(153 |
/ |
484)
|
= |
-21.17975203 |
| 4 |
900817 |
2420 |
- |
2485 |
= |
-65 |
* |
(122 |
/ |
484)
|
= |
-16.38429748 |
| 5 |
900820 |
2457 |
- |
2528 |
= |
-71 |
* |
(112 |
/ |
484)
|
= |
-16.42975202 |
| 6 |
900821 |
2444 |
- |
2552 |
= |
-108 |
* |
(97 |
/ |
484)
|
= |
-21.64462808 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Evergreen Avenue Elementary
|
-76 |
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 |
28465 |
2372 |
- |
2436 |
= |
-64 |
* |
(111 |
/ |
464)
|
= |
-15.31034477 |
| 4 |
28467 |
2415 |
- |
2485 |
= |
-70 |
* |
(149 |
/ |
464)
|
= |
-22.47844823 |
| 5 |
28468 |
2439 |
- |
2528 |
= |
-89 |
* |
(115 |
/ |
464)
|
= |
-22.0581896 |
| 6 |
28471 |
2455 |
- |
2552 |
= |
-97 |
* |
(89 |
/ |
464)
|
= |
-18.60560337 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Evergreen Avenue Elementary
|
-78 |
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 |
29031 |
2393 |
- |
2436 |
= |
-43 |
* |
(107 |
/ |
438)
|
= |
-10.50456619 |
| 4 |
29034 |
2446 |
- |
2485 |
= |
-39 |
* |
(103 |
/ |
438)
|
= |
-9.17123286 |
| 5 |
29035 |
2456 |
- |
2528 |
= |
-72 |
* |
(136 |
/ |
438)
|
= |
-22.35616438 |
| 6 |
29037 |
2479 |
- |
2552 |
= |
-73 |
* |
(92 |
/ |
438)
|
= |
-15.33333333 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Evergreen Avenue Elementary
|
-57 |
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 |
29080 |
2403 |
- |
2436 |
= |
-33 |
* |
(99 |
/ |
421)
|
= |
-7.760095 |
| 4 |
29082 |
2447 |
- |
2485 |
= |
-38 |
* |
(104 |
/ |
421)
|
= |
-9.38717336 |
| 5 |
29084 |
2466 |
- |
2528 |
= |
-62 |
* |
(100 |
/ |
421)
|
= |
-14.72684084 |
| 6 |
29086 |
2502 |
- |
2552 |
= |
-50 |
* |
(118 |
/ |
421)
|
= |
-14.01425175 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Evergreen Avenue Elementary
|
-46 |
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 |
29261 |
2425 |
- |
2436 |
= |
-11 |
* |
(93 |
/ |
364)
|
= |
-2.81043956 |
| 4 |
29262 |
2460 |
- |
2485 |
= |
-25 |
* |
(96 |
/ |
364)
|
= |
-6.59340658 |
| 5 |
29263 |
2461 |
- |
2528 |
= |
-67 |
* |
(97 |
/ |
364)
|
= |
-17.85439557 |
| 6 |
29264 |
2511 |
- |
2552 |
= |
-41 |
* |
(78 |
/ |
364)
|
= |
-8.78571427 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Evergreen Avenue Elementary
|
-36 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-76
|
-78
|
-57
|
-46
|
-36
|
-293.0 |
-58.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -4.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -112.6
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:
