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 |
934267 |
2395 |
- |
2436 |
= |
-41 |
* |
(69 |
/ |
228)
|
= |
-12.4078947 |
| 4 |
934268 |
2437 |
- |
2485 |
= |
-48 |
* |
(73 |
/ |
228)
|
= |
-15.36842102 |
| 5 |
934271 |
2461 |
- |
2528 |
= |
-67 |
* |
(86 |
/ |
228)
|
= |
-25.27192979 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Napa Street Elementary
|
-53 |
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 |
29547 |
2382 |
- |
2436 |
= |
-54 |
* |
(66 |
/ |
213)
|
= |
-16.73239432 |
| 4 |
29548 |
2419 |
- |
2485 |
= |
-66 |
* |
(70 |
/ |
213)
|
= |
-21.6901408 |
| 5 |
29551 |
2457 |
- |
2528 |
= |
-71 |
* |
(77 |
/ |
213)
|
= |
-25.66666664 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Napa Street Elementary
|
-64 |
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 |
30112 |
2410 |
- |
2436 |
= |
-26 |
* |
(85 |
/ |
215)
|
= |
-10.27906976 |
| 4 |
30113 |
2417 |
- |
2485 |
= |
-68 |
* |
(65 |
/ |
215)
|
= |
-20.55813951 |
| 5 |
30115 |
2471 |
- |
2528 |
= |
-57 |
* |
(65 |
/ |
215)
|
= |
-17.23255812 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Napa Street Elementary
|
-48 |
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 |
30161 |
2382 |
- |
2436 |
= |
-54 |
* |
(80 |
/ |
229)
|
= |
-18.86462881 |
| 4 |
30163 |
2448 |
- |
2485 |
= |
-37 |
* |
(87 |
/ |
229)
|
= |
-14.05676853 |
| 5 |
30165 |
2466 |
- |
2528 |
= |
-62 |
* |
(62 |
/ |
229)
|
= |
-16.7860262 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Napa Street Elementary
|
-50 |
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 |
30334 |
2387 |
- |
2436 |
= |
-49 |
* |
(69 |
/ |
223)
|
= |
-15.16143496 |
| 4 |
30335 |
2423 |
- |
2485 |
= |
-62 |
* |
(76 |
/ |
223)
|
= |
-21.13004479 |
| 5 |
30336 |
2470 |
- |
2528 |
= |
-58 |
* |
(78 |
/ |
223)
|
= |
-20.28699547 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Napa Street Elementary
|
-57 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-53
|
-64
|
-48
|
-50
|
-57
|
-272.0 |
-54.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -36.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -72.4
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:
