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 |
2127644 |
2449 |
- |
2436 |
= |
13 |
* |
(149 |
/ |
584)
|
= |
3.31678082 |
| 4 |
2127647 |
2489 |
- |
2485 |
= |
4 |
* |
(157 |
/ |
584)
|
= |
1.07534246 |
| 5 |
2127648 |
2557 |
- |
2528 |
= |
29 |
* |
(138 |
/ |
584)
|
= |
6.8527397 |
| 6 |
2127651 |
2572 |
- |
2552 |
= |
20 |
* |
(140 |
/ |
584)
|
= |
4.79452054 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Salt Creek Elementary
|
16 |
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 |
65331 |
2486 |
- |
2436 |
= |
50 |
* |
(136 |
/ |
586)
|
= |
11.60409555 |
| 4 |
65332 |
2510 |
- |
2485 |
= |
25 |
* |
(153 |
/ |
586)
|
= |
6.52730375 |
| 5 |
65334 |
2540 |
- |
2528 |
= |
12 |
* |
(156 |
/ |
586)
|
= |
3.19453925 |
| 6 |
65337 |
2582 |
- |
2552 |
= |
30 |
* |
(141 |
/ |
586)
|
= |
7.21843002 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Salt Creek Elementary
|
29 |
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 |
67138 |
2466 |
- |
2436 |
= |
30 |
* |
(121 |
/ |
583)
|
= |
6.22641507 |
| 4 |
67141 |
2538 |
- |
2485 |
= |
53 |
* |
(139 |
/ |
583)
|
= |
12.63636362 |
| 5 |
67143 |
2555 |
- |
2528 |
= |
27 |
* |
(162 |
/ |
583)
|
= |
7.50257289 |
| 6 |
67145 |
2554 |
- |
2552 |
= |
2 |
* |
(161 |
/ |
583)
|
= |
0.55231561 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Salt Creek Elementary
|
27 |
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 |
67235 |
2476 |
- |
2436 |
= |
40 |
* |
(134 |
/ |
556)
|
= |
9.64028776 |
| 4 |
67236 |
2535 |
- |
2485 |
= |
50 |
* |
(120 |
/ |
556)
|
= |
10.7913669 |
| 5 |
67238 |
2574 |
- |
2528 |
= |
46 |
* |
(144 |
/ |
556)
|
= |
11.91366903 |
| 6 |
67240 |
2575 |
- |
2552 |
= |
23 |
* |
(158 |
/ |
556)
|
= |
6.5359712 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Salt Creek Elementary
|
39 |
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 |
67734 |
2471 |
- |
2436 |
= |
35 |
* |
(143 |
/ |
545)
|
= |
9.18348624 |
| 4 |
67735 |
2537 |
- |
2485 |
= |
52 |
* |
(142 |
/ |
545)
|
= |
13.54862382 |
| 5 |
67736 |
2568 |
- |
2528 |
= |
40 |
* |
(122 |
/ |
545)
|
= |
8.95412844 |
| 6 |
67737 |
2592 |
- |
2552 |
= |
40 |
* |
(138 |
/ |
545)
|
= |
10.12844036 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Salt Creek Elementary
|
42 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
16
|
29
|
27
|
39
|
42
|
153.0 |
30.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 60.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 0.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:
