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 |
2368418 |
2488 |
- |
2436 |
= |
52 |
* |
(64 |
/ |
383)
|
= |
8.689295 |
| 4 |
2368419 |
2531 |
- |
2485 |
= |
46 |
* |
(66 |
/ |
383)
|
= |
7.92689291 |
| 5 |
2368422 |
2573 |
- |
2528 |
= |
45 |
* |
(65 |
/ |
383)
|
= |
7.63707569 |
| 6 |
2368423 |
2593 |
- |
2552 |
= |
41 |
* |
(63 |
/ |
383)
|
= |
6.7441253 |
| 7 |
2368426 |
2632 |
- |
2567 |
= |
65 |
* |
(64 |
/ |
383)
|
= |
10.86161876 |
| 8 |
2368427 |
2666 |
- |
2586 |
= |
80 |
* |
(61 |
/ |
383)
|
= |
12.74151432 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lawton Alternative Elementary
|
55 |
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 |
72352 |
2492 |
- |
2436 |
= |
56 |
* |
(63 |
/ |
384)
|
= |
9.1875 |
| 4 |
72354 |
2526 |
- |
2485 |
= |
41 |
* |
(62 |
/ |
384)
|
= |
6.61979165 |
| 5 |
72355 |
2588 |
- |
2528 |
= |
60 |
* |
(66 |
/ |
384)
|
= |
10.3125 |
| 6 |
72358 |
2605 |
- |
2552 |
= |
53 |
* |
(65 |
/ |
384)
|
= |
8.97135415 |
| 7 |
72359 |
2647 |
- |
2567 |
= |
80 |
* |
(63 |
/ |
384)
|
= |
13.125 |
| 8 |
72362 |
2653 |
- |
2586 |
= |
67 |
* |
(65 |
/ |
384)
|
= |
11.34114581 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lawton Alternative Elementary
|
60 |
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 |
74326 |
2510 |
- |
2436 |
= |
74 |
* |
(64 |
/ |
379)
|
= |
12.49604219 |
| 4 |
74328 |
2529 |
- |
2485 |
= |
44 |
* |
(64 |
/ |
379)
|
= |
7.43007914 |
| 5 |
74329 |
2580 |
- |
2528 |
= |
52 |
* |
(63 |
/ |
379)
|
= |
8.64379942 |
| 6 |
74332 |
2609 |
- |
2552 |
= |
57 |
* |
(64 |
/ |
379)
|
= |
9.6253298 |
| 7 |
74334 |
2663 |
- |
2567 |
= |
96 |
* |
(63 |
/ |
379)
|
= |
15.95778355 |
| 8 |
74336 |
2675 |
- |
2586 |
= |
89 |
* |
(61 |
/ |
379)
|
= |
14.32453825 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lawton Alternative Elementary
|
68 |
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 |
74499 |
2489 |
- |
2436 |
= |
53 |
* |
(65 |
/ |
391)
|
= |
8.81074168 |
| 4 |
74502 |
2541 |
- |
2485 |
= |
56 |
* |
(66 |
/ |
391)
|
= |
9.45268537 |
| 5 |
74503 |
2597 |
- |
2528 |
= |
69 |
* |
(66 |
/ |
391)
|
= |
11.64705876 |
| 6 |
74506 |
2609 |
- |
2552 |
= |
57 |
* |
(64 |
/ |
391)
|
= |
9.32992325 |
| 7 |
74507 |
2647 |
- |
2567 |
= |
80 |
* |
(65 |
/ |
391)
|
= |
13.29923272 |
| 8 |
74510 |
2694 |
- |
2586 |
= |
108 |
* |
(65 |
/ |
391)
|
= |
17.95396417 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lawton Alternative Elementary
|
70 |
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 |
75028 |
2484 |
- |
2436 |
= |
48 |
* |
(64 |
/ |
385)
|
= |
7.97922077 |
| 4 |
75029 |
2517 |
- |
2485 |
= |
32 |
* |
(65 |
/ |
385)
|
= |
5.40259738 |
| 5 |
75030 |
2602 |
- |
2528 |
= |
74 |
* |
(64 |
/ |
385)
|
= |
12.30129868 |
| 6 |
75031 |
2608 |
- |
2552 |
= |
56 |
* |
(64 |
/ |
385)
|
= |
9.3090909 |
| 7 |
75032 |
2654 |
- |
2567 |
= |
87 |
* |
(64 |
/ |
385)
|
= |
14.46233764 |
| 8 |
75033 |
2667 |
- |
2586 |
= |
81 |
* |
(64 |
/ |
385)
|
= |
13.46493505 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lawton Alternative Elementary
|
63 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
55
|
60
|
68
|
70
|
63
|
316.0 |
63.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 81.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 45.2
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:
