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 |
1437462 |
2452 |
- |
2436 |
= |
16 |
* |
(100 |
/ |
339)
|
= |
4.719764 |
| 4 |
1437463 |
2508 |
- |
2485 |
= |
23 |
* |
(134 |
/ |
339)
|
= |
9.09144541 |
| 5 |
1437466 |
2528 |
- |
2528 |
= |
0 |
* |
(105 |
/ |
339)
|
= |
0.0 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Moulton Elementary
|
14 |
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 |
45257 |
2469 |
- |
2436 |
= |
33 |
* |
(101 |
/ |
342)
|
= |
9.74561402 |
| 4 |
45259 |
2520 |
- |
2485 |
= |
35 |
* |
(103 |
/ |
342)
|
= |
10.54093565 |
| 5 |
45260 |
2540 |
- |
2528 |
= |
12 |
* |
(138 |
/ |
342)
|
= |
4.84210525 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Moulton Elementary
|
25 |
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 |
46466 |
2474 |
- |
2436 |
= |
38 |
* |
(112 |
/ |
331)
|
= |
12.85800604 |
| 4 |
46469 |
2536 |
- |
2485 |
= |
51 |
* |
(105 |
/ |
331)
|
= |
16.17824769 |
| 5 |
46471 |
2545 |
- |
2528 |
= |
17 |
* |
(114 |
/ |
331)
|
= |
5.85498489 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Moulton Elementary
|
35 |
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 |
46477 |
2473 |
- |
2436 |
= |
37 |
* |
(102 |
/ |
313)
|
= |
12.05750798 |
| 4 |
46478 |
2524 |
- |
2485 |
= |
39 |
* |
(111 |
/ |
313)
|
= |
13.83067089 |
| 5 |
46481 |
2566 |
- |
2528 |
= |
38 |
* |
(100 |
/ |
313)
|
= |
12.14057505 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Moulton Elementary
|
38 |
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 |
46659 |
2495 |
- |
2436 |
= |
59 |
* |
(99 |
/ |
306)
|
= |
19.08823525 |
| 4 |
46660 |
2536 |
- |
2485 |
= |
51 |
* |
(99 |
/ |
306)
|
= |
16.49999996 |
| 5 |
46661 |
2562 |
- |
2528 |
= |
34 |
* |
(108 |
/ |
306)
|
= |
11.99999998 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Moulton Elementary
|
48 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
14
|
25
|
35
|
38
|
48
|
160.0 |
32.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 68.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -4.0
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:
