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 |
984917 |
2509 |
- |
2552 |
= |
-43 |
* |
(475 |
/ |
1464)
|
= |
-13.95150269 |
7 |
984920 |
2519 |
- |
2567 |
= |
-48 |
* |
(498 |
/ |
1464)
|
= |
-16.32786883 |
8 |
984921 |
2520 |
- |
2586 |
= |
-66 |
* |
(491 |
/ |
1464)
|
= |
-22.13524586 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Oliver Wendell Holmes Middle
|
-52 |
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 |
31152 |
2512 |
- |
2552 |
= |
-40 |
* |
(436 |
/ |
1404)
|
= |
-12.4216524 |
7 |
31154 |
2527 |
- |
2567 |
= |
-40 |
* |
(484 |
/ |
1404)
|
= |
-13.78917376 |
8 |
31156 |
2544 |
- |
2586 |
= |
-42 |
* |
(484 |
/ |
1404)
|
= |
-14.47863245 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Oliver Wendell Holmes Middle
|
-41 |
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 |
31714 |
2510 |
- |
2552 |
= |
-42 |
* |
(419 |
/ |
1331)
|
= |
-13.22163784 |
7 |
31715 |
2525 |
- |
2567 |
= |
-42 |
* |
(435 |
/ |
1331)
|
= |
-13.7265214 |
8 |
31718 |
2560 |
- |
2586 |
= |
-26 |
* |
(477 |
/ |
1331)
|
= |
-9.31780616 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Oliver Wendell Holmes Middle
|
-36 |
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 |
31758 |
2522 |
- |
2552 |
= |
-30 |
* |
(427 |
/ |
1277)
|
= |
-10.03132341 |
7 |
31760 |
2531 |
- |
2567 |
= |
-36 |
* |
(422 |
/ |
1277)
|
= |
-11.89663272 |
8 |
31762 |
2550 |
- |
2586 |
= |
-36 |
* |
(428 |
/ |
1277)
|
= |
-12.06577915 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Oliver Wendell Holmes Middle
|
-34 |
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 |
31936 |
2537 |
- |
2552 |
= |
-15 |
* |
(420 |
/ |
1271)
|
= |
-4.95672698 |
7 |
31937 |
2536 |
- |
2567 |
= |
-31 |
* |
(435 |
/ |
1271)
|
= |
-10.60975608 |
8 |
31938 |
2563 |
- |
2586 |
= |
-23 |
* |
(416 |
/ |
1271)
|
= |
-7.52793075 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Oliver Wendell Holmes Middle
|
-23 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-52
|
-41
|
-36
|
-34
|
-23
|
-186.0 |
-37.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -7.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -67.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: