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 |
978231 |
2523 |
- |
2436 |
= |
87 |
* |
(98 |
/ |
333)
|
= |
25.60360358 |
| 4 |
978232 |
2564 |
- |
2485 |
= |
79 |
* |
(117 |
/ |
333)
|
= |
27.75675673 |
| 5 |
978235 |
2558 |
- |
2528 |
= |
30 |
* |
(118 |
/ |
333)
|
= |
10.63063062 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Wonderland Avenue Elementary
|
64 |
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 |
30957 |
2528 |
- |
2436 |
= |
92 |
* |
(91 |
/ |
321)
|
= |
26.08099683 |
| 4 |
30959 |
2590 |
- |
2485 |
= |
105 |
* |
(119 |
/ |
321)
|
= |
38.92523355 |
| 5 |
30960 |
2605 |
- |
2528 |
= |
77 |
* |
(111 |
/ |
321)
|
= |
26.62616818 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Wonderland Avenue Elementary
|
92 |
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 |
31520 |
2540 |
- |
2436 |
= |
104 |
* |
(103 |
/ |
313)
|
= |
34.22364213 |
| 4 |
31521 |
2588 |
- |
2485 |
= |
103 |
* |
(103 |
/ |
313)
|
= |
33.89456865 |
| 5 |
31523 |
2603 |
- |
2528 |
= |
75 |
* |
(107 |
/ |
313)
|
= |
25.63897763 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Wonderland Avenue Elementary
|
94 |
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 |
31567 |
2537 |
- |
2436 |
= |
101 |
* |
(102 |
/ |
318)
|
= |
32.39622632 |
| 4 |
31569 |
2579 |
- |
2485 |
= |
94 |
* |
(116 |
/ |
318)
|
= |
34.28930816 |
| 5 |
31571 |
2605 |
- |
2528 |
= |
77 |
* |
(100 |
/ |
318)
|
= |
24.21383642 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Wonderland Avenue Elementary
|
91 |
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 |
31744 |
2537 |
- |
2436 |
= |
101 |
* |
(95 |
/ |
307)
|
= |
31.25407165 |
| 4 |
31745 |
2583 |
- |
2485 |
= |
98 |
* |
(111 |
/ |
307)
|
= |
35.43322467 |
| 5 |
31746 |
2590 |
- |
2528 |
= |
62 |
* |
(101 |
/ |
307)
|
= |
20.39739414 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Wonderland Avenue Elementary
|
87 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
64
|
92
|
94
|
91
|
87
|
428.0 |
85.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 121.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 49.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:
