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 |
2128409 |
2435 |
- |
2436 |
= |
-1 |
* |
(105 |
/ |
428)
|
= |
-0.2453271 |
| 4 |
2128410 |
2496 |
- |
2485 |
= |
11 |
* |
(103 |
/ |
428)
|
= |
2.64719626 |
| 5 |
2128413 |
2537 |
- |
2528 |
= |
9 |
* |
(123 |
/ |
428)
|
= |
2.58644859 |
| 6 |
2128414 |
2568 |
- |
2552 |
= |
16 |
* |
(97 |
/ |
428)
|
= |
3.62616822 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Wolf Canyon Elementary
|
9 |
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 |
65351 |
2457 |
- |
2436 |
= |
21 |
* |
(112 |
/ |
486)
|
= |
4.83950615 |
| 4 |
65352 |
2488 |
- |
2485 |
= |
3 |
* |
(127 |
/ |
486)
|
= |
0.78395062 |
| 5 |
65355 |
2559 |
- |
2528 |
= |
31 |
* |
(123 |
/ |
486)
|
= |
7.84567899 |
| 6 |
65356 |
2595 |
- |
2552 |
= |
43 |
* |
(124 |
/ |
486)
|
= |
10.97119338 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Wolf Canyon Elementary
|
24 |
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 |
67158 |
2467 |
- |
2436 |
= |
31 |
* |
(122 |
/ |
503)
|
= |
7.51888666 |
| 4 |
67161 |
2503 |
- |
2485 |
= |
18 |
* |
(125 |
/ |
503)
|
= |
4.47316103 |
| 5 |
67163 |
2536 |
- |
2528 |
= |
8 |
* |
(127 |
/ |
503)
|
= |
2.01988071 |
| 6 |
67164 |
2610 |
- |
2552 |
= |
58 |
* |
(129 |
/ |
503)
|
= |
14.87475146 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Wolf Canyon Elementary
|
29 |
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 |
67254 |
2466 |
- |
2436 |
= |
30 |
* |
(98 |
/ |
371)
|
= |
7.92452829 |
| 4 |
67256 |
2509 |
- |
2485 |
= |
24 |
* |
(95 |
/ |
371)
|
= |
6.14555256 |
| 5 |
67258 |
2566 |
- |
2528 |
= |
38 |
* |
(77 |
/ |
371)
|
= |
7.88679242 |
| 6 |
67260 |
2585 |
- |
2552 |
= |
33 |
* |
(101 |
/ |
371)
|
= |
8.98382747 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Wolf Canyon Elementary
|
31 |
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 |
67754 |
2463 |
- |
2436 |
= |
27 |
* |
(108 |
/ |
439)
|
= |
6.64236901 |
| 4 |
67755 |
2514 |
- |
2485 |
= |
29 |
* |
(116 |
/ |
439)
|
= |
7.66287016 |
| 5 |
67756 |
2560 |
- |
2528 |
= |
32 |
* |
(109 |
/ |
439)
|
= |
7.94533027 |
| 6 |
67757 |
2579 |
- |
2552 |
= |
27 |
* |
(106 |
/ |
439)
|
= |
6.51936217 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Wolf Canyon Elementary
|
29 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
9
|
24
|
29
|
31
|
29
|
122.0 |
24.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 48.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 0.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:
