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 |
2381829 |
2381 |
- |
2436 |
= |
-55 |
* |
(41 |
/ |
127)
|
= |
-17.75590548 |
4 |
2381831 |
2407 |
- |
2485 |
= |
-78 |
* |
(47 |
/ |
127)
|
= |
-28.86614172 |
5 |
2381832 |
2432 |
- |
2528 |
= |
-96 |
* |
(39 |
/ |
127)
|
= |
-29.48031494 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Drew (Charles) College Preparatory Academy
|
-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 |
72733 |
2348 |
- |
2436 |
= |
-88 |
* |
(27 |
/ |
102)
|
= |
-23.29411762 |
4 |
72735 |
2402 |
- |
2485 |
= |
-83 |
* |
(37 |
/ |
102)
|
= |
-30.10784313 |
5 |
72738 |
2409 |
- |
2528 |
= |
-119 |
* |
(38 |
/ |
102)
|
= |
-44.33333326 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Drew (Charles) College Preparatory Academy
|
-98 |
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 |
74705 |
2334 |
- |
2436 |
= |
-102 |
* |
(31 |
/ |
90)
|
= |
-35.13333329 |
4 |
74708 |
2390 |
- |
2485 |
= |
-95 |
* |
(25 |
/ |
90)
|
= |
-26.38888882 |
5 |
74710 |
2437 |
- |
2528 |
= |
-91 |
* |
(34 |
/ |
90)
|
= |
-34.37777771 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Drew (Charles) College Preparatory Academy
|
-96 |
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 |
74879 |
2346 |
- |
2436 |
= |
-90 |
* |
(32 |
/ |
86)
|
= |
-33.48837207 |
4 |
74882 |
2408 |
- |
2485 |
= |
-77 |
* |
(30 |
/ |
86)
|
= |
-26.86046509 |
5 |
74883 |
2408 |
- |
2528 |
= |
-120 |
* |
(24 |
/ |
86)
|
= |
-33.48837204 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Drew (Charles) College Preparatory Academy
|
-94 |
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 |
75405 |
2341 |
- |
2436 |
= |
-95 |
* |
(20 |
/ |
73)
|
= |
-26.02739719 |
4 |
75406 |
2380 |
- |
2485 |
= |
-105 |
* |
(28 |
/ |
73)
|
= |
-40.27397252 |
5 |
75407 |
2421 |
- |
2528 |
= |
-107 |
* |
(25 |
/ |
73)
|
= |
-36.64383557 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Drew (Charles) College Preparatory Academy
|
-103 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-76
|
-98
|
-96
|
-94
|
-103
|
-467.0 |
-93.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -63.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -123.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: