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 |
842366 |
2376 |
- |
2436 |
= |
-60 |
* |
(97 |
/ |
249)
|
= |
-23.37349392 |
| 4 |
842369 |
2413 |
- |
2485 |
= |
-72 |
* |
(70 |
/ |
249)
|
= |
-20.24096378 |
| 5 |
842370 |
2456 |
- |
2528 |
= |
-72 |
* |
(82 |
/ |
249)
|
= |
-23.71084337 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Willow Elementary
|
-67 |
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 |
26458 |
2420 |
- |
2436 |
= |
-16 |
* |
(83 |
/ |
249)
|
= |
-5.33333333 |
| 4 |
26460 |
2428 |
- |
2485 |
= |
-57 |
* |
(98 |
/ |
249)
|
= |
-22.43373493 |
| 5 |
26463 |
2475 |
- |
2528 |
= |
-53 |
* |
(68 |
/ |
249)
|
= |
-14.47389556 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Willow Elementary
|
-42 |
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 |
26943 |
2413 |
- |
2436 |
= |
-23 |
* |
(109 |
/ |
286)
|
= |
-8.76573426 |
| 4 |
26946 |
2418 |
- |
2485 |
= |
-67 |
* |
(86 |
/ |
286)
|
= |
-20.1468531 |
| 5 |
26948 |
2464 |
- |
2528 |
= |
-64 |
* |
(91 |
/ |
286)
|
= |
-20.36363635 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Willow Elementary
|
-49 |
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 |
26904 |
2435 |
- |
2436 |
= |
-1 |
* |
(78 |
/ |
260)
|
= |
-0.3 |
| 4 |
26906 |
2459 |
- |
2485 |
= |
-26 |
* |
(101 |
/ |
260)
|
= |
-10.09999999 |
| 5 |
26908 |
2471 |
- |
2528 |
= |
-57 |
* |
(81 |
/ |
260)
|
= |
-17.75769228 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Willow Elementary
|
-28 |
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 |
27030 |
2439 |
- |
2436 |
= |
3 |
* |
(78 |
/ |
257)
|
= |
0.91050584 |
| 4 |
27031 |
2485 |
- |
2485 |
= |
0 |
* |
(81 |
/ |
257)
|
= |
0.0 |
| 5 |
27032 |
2498 |
- |
2528 |
= |
-30 |
* |
(98 |
/ |
257)
|
= |
-11.43968871 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Willow Elementary
|
-11 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-67
|
-42
|
-49
|
-28
|
-11
|
-197.0 |
-39.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 23.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -102.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:
