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 |
322891 |
2332 |
- |
2436 |
= |
-104 |
* |
(89 |
/ |
343)
|
= |
-26.98542267 |
| 4 |
322894 |
2373 |
- |
2485 |
= |
-112 |
* |
(77 |
/ |
343)
|
= |
-25.14285704 |
| 5 |
322895 |
2415 |
- |
2528 |
= |
-113 |
* |
(94 |
/ |
343)
|
= |
-30.96793001 |
| 6 |
322898 |
2448 |
- |
2552 |
= |
-104 |
* |
(83 |
/ |
343)
|
= |
-25.16618073 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Columbia Elementary
|
-108 |
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 |
9634 |
2359 |
- |
2436 |
= |
-77 |
* |
(76 |
/ |
347)
|
= |
-16.86455324 |
| 4 |
9636 |
2382 |
- |
2485 |
= |
-103 |
* |
(95 |
/ |
347)
|
= |
-28.19884725 |
| 5 |
9638 |
2410 |
- |
2528 |
= |
-118 |
* |
(79 |
/ |
347)
|
= |
-26.86455331 |
| 6 |
9640 |
2444 |
- |
2552 |
= |
-108 |
* |
(97 |
/ |
347)
|
= |
-30.19020163 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Columbia Elementary
|
-102 |
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 |
9962 |
2369 |
- |
2436 |
= |
-67 |
* |
(97 |
/ |
352)
|
= |
-18.46306813 |
| 4 |
9964 |
2395 |
- |
2485 |
= |
-90 |
* |
(77 |
/ |
352)
|
= |
-19.6875 |
| 5 |
9965 |
2415 |
- |
2528 |
= |
-113 |
* |
(100 |
/ |
352)
|
= |
-32.10227272 |
| 6 |
9968 |
2431 |
- |
2552 |
= |
-121 |
* |
(78 |
/ |
352)
|
= |
-26.81249999 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Columbia Elementary
|
-97 |
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 |
9980 |
2377 |
- |
2436 |
= |
-59 |
* |
(75 |
/ |
331)
|
= |
-13.36858002 |
| 4 |
9981 |
2406 |
- |
2485 |
= |
-79 |
* |
(90 |
/ |
331)
|
= |
-21.48036252 |
| 5 |
9983 |
2413 |
- |
2528 |
= |
-115 |
* |
(70 |
/ |
331)
|
= |
-24.32024163 |
| 6 |
9985 |
2447 |
- |
2552 |
= |
-105 |
* |
(96 |
/ |
331)
|
= |
-30.45317216 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Columbia Elementary
|
-90 |
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 |
10060 |
2372 |
- |
2436 |
= |
-64 |
* |
(85 |
/ |
305)
|
= |
-17.83606554 |
| 4 |
10061 |
2428 |
- |
2485 |
= |
-57 |
* |
(68 |
/ |
305)
|
= |
-12.70819668 |
| 5 |
10062 |
2459 |
- |
2528 |
= |
-69 |
* |
(89 |
/ |
305)
|
= |
-20.13442618 |
| 6 |
10063 |
2447 |
- |
2552 |
= |
-105 |
* |
(63 |
/ |
305)
|
= |
-21.68852459 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Columbia Elementary
|
-72 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-108
|
-102
|
-97
|
-90
|
-72
|
-469.0 |
-93.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -54.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -132.8
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:
