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 |
1798600 |
2474 |
- |
2436 |
= |
38 |
* |
(160 |
/ |
559)
|
= |
10.87656528 |
4 |
1798601 |
2511 |
- |
2485 |
= |
26 |
* |
(133 |
/ |
559)
|
= |
6.18604649 |
5 |
1798604 |
2547 |
- |
2528 |
= |
19 |
* |
(130 |
/ |
559)
|
= |
4.41860464 |
6 |
1798605 |
2562 |
- |
2552 |
= |
10 |
* |
(136 |
/ |
559)
|
= |
2.43291592 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Sunrise Elementary
|
24 |
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 |
55764 |
2477 |
- |
2436 |
= |
41 |
* |
(173 |
/ |
613)
|
= |
11.57096248 |
4 |
55766 |
2531 |
- |
2485 |
= |
46 |
* |
(170 |
/ |
613)
|
= |
12.75693307 |
5 |
55768 |
2549 |
- |
2528 |
= |
21 |
* |
(141 |
/ |
613)
|
= |
4.83034257 |
6 |
55771 |
2583 |
- |
2552 |
= |
31 |
* |
(129 |
/ |
613)
|
= |
6.52365414 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Sunrise Elementary
|
36 |
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 |
57390 |
2477 |
- |
2436 |
= |
41 |
* |
(169 |
/ |
661)
|
= |
10.4826021 |
4 |
57392 |
2524 |
- |
2485 |
= |
39 |
* |
(181 |
/ |
661)
|
= |
10.67927383 |
5 |
57393 |
2555 |
- |
2528 |
= |
27 |
* |
(164 |
/ |
661)
|
= |
6.69894098 |
6 |
57396 |
2570 |
- |
2552 |
= |
18 |
* |
(147 |
/ |
661)
|
= |
4.00302571 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Sunrise Elementary
|
32 |
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 |
57500 |
2480 |
- |
2436 |
= |
44 |
* |
(101 |
/ |
388)
|
= |
11.45360823 |
4 |
57503 |
2503 |
- |
2485 |
= |
18 |
* |
(98 |
/ |
388)
|
= |
4.54639174 |
5 |
57504 |
2545 |
- |
2528 |
= |
17 |
* |
(92 |
/ |
388)
|
= |
4.03092783 |
6 |
57507 |
2576 |
- |
2552 |
= |
24 |
* |
(97 |
/ |
388)
|
= |
6.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Sunrise Elementary
|
26 |
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 |
57754 |
2484 |
- |
2436 |
= |
48 |
* |
(98 |
/ |
384)
|
= |
12.24999998 |
4 |
57755 |
2519 |
- |
2485 |
= |
34 |
* |
(102 |
/ |
384)
|
= |
9.03125 |
5 |
57756 |
2551 |
- |
2528 |
= |
23 |
* |
(94 |
/ |
384)
|
= |
5.63020832 |
6 |
57757 |
2582 |
- |
2552 |
= |
30 |
* |
(90 |
/ |
384)
|
= |
7.03125 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Sunrise Elementary
|
34 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
24
|
36
|
32
|
26
|
34
|
152.0 |
30.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 45.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 15.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: