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 |
6 |
996687 |
2422 |
- |
2552 |
= |
-130 |
* |
(116 |
/ |
1231)
|
= |
-12.25020303 |
7 |
996688 |
2467 |
- |
2567 |
= |
-100 |
* |
(535 |
/ |
1231)
|
= |
-43.4606011 |
8 |
996691 |
2484 |
- |
2586 |
= |
-102 |
* |
(580 |
/ |
1231)
|
= |
-48.05848901 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Thomas A. Edison Middle
|
-104 |
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 |
6 |
31465 |
2461 |
- |
2552 |
= |
-91 |
* |
(187 |
/ |
1240)
|
= |
-13.72338704 |
7 |
31466 |
2471 |
- |
2567 |
= |
-96 |
* |
(522 |
/ |
1240)
|
= |
-40.41290314 |
8 |
31469 |
2487 |
- |
2586 |
= |
-99 |
* |
(531 |
/ |
1240)
|
= |
-42.39435479 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Thomas A. Edison Middle
|
-97 |
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 |
6 |
32017 |
2448 |
- |
2552 |
= |
-104 |
* |
(169 |
/ |
1181)
|
= |
-14.88230307 |
7 |
32019 |
2483 |
- |
2567 |
= |
-84 |
* |
(491 |
/ |
1181)
|
= |
-34.92294658 |
8 |
32022 |
2469 |
- |
2586 |
= |
-117 |
* |
(521 |
/ |
1181)
|
= |
-51.61473322 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Thomas A. Edison Middle
|
-101 |
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 |
6 |
32044 |
2490 |
- |
2552 |
= |
-62 |
* |
(202 |
/ |
1192)
|
= |
-10.50671139 |
7 |
32046 |
2473 |
- |
2567 |
= |
-94 |
* |
(513 |
/ |
1192)
|
= |
-40.45469794 |
8 |
32048 |
2491 |
- |
2586 |
= |
-95 |
* |
(477 |
/ |
1192)
|
= |
-38.01593958 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Thomas A. Edison Middle
|
-89 |
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 |
6 |
32226 |
2458 |
- |
2552 |
= |
-94 |
* |
(191 |
/ |
1194)
|
= |
-15.03685091 |
7 |
32227 |
2479 |
- |
2567 |
= |
-88 |
* |
(523 |
/ |
1194)
|
= |
-38.5460636 |
8 |
32228 |
2468 |
- |
2586 |
= |
-118 |
* |
(480 |
/ |
1194)
|
= |
-47.4371859 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Thomas A. Edison Middle
|
-101 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-104
|
-97
|
-101
|
-89
|
-101
|
-492.0 |
-98.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -83.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -113.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: