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 |
974870 |
2475 |
- |
2436 |
= |
39 |
* |
(57 |
/ |
165)
|
= |
13.47272726 |
| 4 |
974873 |
2523 |
- |
2485 |
= |
38 |
* |
(67 |
/ |
165)
|
= |
15.43030303 |
| 5 |
974874 |
2554 |
- |
2528 |
= |
26 |
* |
(41 |
/ |
165)
|
= |
6.46060605 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for West Hollywood Elementary
|
35 |
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 |
30850 |
2507 |
- |
2436 |
= |
71 |
* |
(58 |
/ |
171)
|
= |
24.08187131 |
| 4 |
30853 |
2543 |
- |
2485 |
= |
58 |
* |
(52 |
/ |
171)
|
= |
17.63742689 |
| 5 |
30855 |
2551 |
- |
2528 |
= |
23 |
* |
(61 |
/ |
171)
|
= |
8.20467836 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for West Hollywood Elementary
|
50 |
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 |
31415 |
2490 |
- |
2436 |
= |
54 |
* |
(48 |
/ |
141)
|
= |
18.38297867 |
| 4 |
31418 |
2554 |
- |
2485 |
= |
69 |
* |
(50 |
/ |
141)
|
= |
24.4680851 |
| 5 |
31419 |
2589 |
- |
2528 |
= |
61 |
* |
(43 |
/ |
141)
|
= |
18.60283688 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for West Hollywood Elementary
|
61 |
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 |
31463 |
2494 |
- |
2436 |
= |
58 |
* |
(71 |
/ |
169)
|
= |
24.36686389 |
| 4 |
31465 |
2508 |
- |
2485 |
= |
23 |
* |
(53 |
/ |
169)
|
= |
7.21301774 |
| 5 |
31467 |
2579 |
- |
2528 |
= |
51 |
* |
(45 |
/ |
169)
|
= |
13.57988164 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for West Hollywood Elementary
|
45 |
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 |
31640 |
2481 |
- |
2436 |
= |
45 |
* |
(75 |
/ |
185)
|
= |
18.24324323 |
| 4 |
31641 |
2513 |
- |
2485 |
= |
28 |
* |
(62 |
/ |
185)
|
= |
9.38378378 |
| 5 |
31642 |
2544 |
- |
2528 |
= |
16 |
* |
(48 |
/ |
185)
|
= |
4.15135134 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for West Hollywood Elementary
|
32 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
35
|
50
|
61
|
45
|
32
|
223.0 |
44.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 77.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 11.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:
