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 |
6 |
984391 |
2419 |
- |
2552 |
= |
-133 |
* |
(207 |
/ |
755)
|
= |
-36.46490061 |
7 |
984393 |
2424 |
- |
2567 |
= |
-143 |
* |
(279 |
/ |
755)
|
= |
-52.84370849 |
8 |
984394 |
2463 |
- |
2586 |
= |
-123 |
* |
(269 |
/ |
755)
|
= |
-43.82384097 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Bret Harte Preparatory Middle
|
-133 |
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 |
6 |
31136 |
2363 |
- |
2552 |
= |
-189 |
* |
(184 |
/ |
675)
|
= |
-51.51999989 |
7 |
31139 |
2424 |
- |
2567 |
= |
-143 |
* |
(230 |
/ |
675)
|
= |
-48.72592582 |
8 |
31141 |
2430 |
- |
2586 |
= |
-156 |
* |
(261 |
/ |
675)
|
= |
-60.3199999 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Bret Harte Preparatory Middle
|
-161 |
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 |
6 |
31698 |
2383 |
- |
2552 |
= |
-169 |
* |
(198 |
/ |
598)
|
= |
-55.95652158 |
7 |
31700 |
2381 |
- |
2567 |
= |
-186 |
* |
(192 |
/ |
598)
|
= |
-59.71906352 |
8 |
31702 |
2415 |
- |
2586 |
= |
-171 |
* |
(208 |
/ |
598)
|
= |
-59.47826071 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Bret Harte Preparatory Middle
|
-175 |
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 |
6 |
31743 |
2402 |
- |
2552 |
= |
-150 |
* |
(118 |
/ |
505)
|
= |
-35.0495049 |
7 |
31745 |
2407 |
- |
2567 |
= |
-160 |
* |
(216 |
/ |
505)
|
= |
-68.43564352 |
8 |
31747 |
2381 |
- |
2586 |
= |
-205 |
* |
(171 |
/ |
505)
|
= |
-69.41584151 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Bret Harte Preparatory Middle
|
-173 |
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 |
6 |
31920 |
2399 |
- |
2552 |
= |
-153 |
* |
(107 |
/ |
467)
|
= |
-35.05567442 |
7 |
31921 |
2399 |
- |
2567 |
= |
-168 |
* |
(142 |
/ |
467)
|
= |
-51.0835117 |
8 |
31922 |
2406 |
- |
2586 |
= |
-180 |
* |
(218 |
/ |
467)
|
= |
-84.02569578 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Bret Harte Preparatory Middle
|
-170 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-133
|
-161
|
-175
|
-173
|
-170
|
-812.0 |
-162.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -111.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -213.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: