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 |
1040249 |
2393 |
- |
2436 |
= |
-43 |
* |
(820 |
/ |
4638) |
= |
-7.60241479 |
4 |
1040250 |
2426 |
- |
2485 |
= |
-59 |
* |
(785 |
/ |
4638) |
= |
-9.98598529 |
5 |
1040253 |
2454 |
- |
2528 |
= |
-74 |
* |
(785 |
/ |
4638) |
= |
-12.52479511 |
6 |
1040254 |
2471 |
- |
2552 |
= |
-81 |
* |
(766 |
/ |
4638) |
= |
-13.377749 |
7 |
1040257 |
2467 |
- |
2567 |
= |
-100 |
* |
(724 |
/ |
4638) |
= |
-15.6101768 |
8 |
1040258 |
2485 |
- |
2586 |
= |
-101 |
* |
(758 |
/ |
4638) |
= |
-16.50668391 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Mountain View Elementary
|
-76 |
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 |
32659 |
2394 |
- |
2436 |
= |
-42 |
* |
(836 |
/ |
4592) |
= |
-7.64634146 |
4 |
32661 |
2435 |
- |
2485 |
= |
-50 |
* |
(800 |
/ |
4592) |
= |
-8.71080135 |
5 |
32662 |
2461 |
- |
2528 |
= |
-67 |
* |
(756 |
/ |
4592) |
= |
-11.03048778 |
6 |
32665 |
2472 |
- |
2552 |
= |
-80 |
* |
(752 |
/ |
4592) |
= |
-13.10104528 |
7 |
32666 |
2485 |
- |
2567 |
= |
-82 |
* |
(740 |
/ |
4592) |
= |
-13.21428565 |
8 |
32669 |
2482 |
- |
2586 |
= |
-104 |
* |
(708 |
/ |
4592) |
= |
-16.03484314 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Mountain View Elementary
|
-70 |
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 |
33231 |
2398 |
- |
2436 |
= |
-38 |
* |
(771 |
/ |
4504) |
= |
-6.50488454 |
4 |
33233 |
2432 |
- |
2485 |
= |
-53 |
* |
(803 |
/ |
4504) |
= |
-9.4491563 |
5 |
33234 |
2454 |
- |
2528 |
= |
-74 |
* |
(776 |
/ |
4504) |
= |
-12.7495559 |
6 |
33236 |
2472 |
- |
2552 |
= |
-80 |
* |
(711 |
/ |
4504) |
= |
-12.6287744 |
7 |
33238 |
2493 |
- |
2567 |
= |
-74 |
* |
(714 |
/ |
4504) |
= |
-11.7309058 |
8 |
33240 |
2488 |
- |
2586 |
= |
-98 |
* |
(729 |
/ |
4504) |
= |
-15.86190045 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Mountain View Elementary
|
-69 |
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 |
33248 |
2399 |
- |
2436 |
= |
-37 |
* |
(622 |
/ |
4238) |
= |
-5.43039169 |
4 |
33251 |
2438 |
- |
2485 |
= |
-47 |
* |
(740 |
/ |
4238) |
= |
-8.20670126 |
5 |
33252 |
2452 |
- |
2528 |
= |
-76 |
* |
(770 |
/ |
4238) |
= |
-13.80840018 |
6 |
33255 |
2483 |
- |
2552 |
= |
-69 |
* |
(728 |
/ |
4238) |
= |
-11.85276073 |
7 |
33256 |
2482 |
- |
2567 |
= |
-85 |
* |
(690 |
/ |
4238) |
= |
-13.839075 |
8 |
33259 |
2493 |
- |
2586 |
= |
-93 |
* |
(688 |
/ |
4238) |
= |
-15.09768752 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Mountain View Elementary
|
-68 |
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 |
33427 |
2412 |
- |
2436 |
= |
-24 |
* |
(713 |
/ |
4059) |
= |
-4.2158167 |
4 |
33428 |
2445 |
- |
2485 |
= |
-40 |
* |
(592 |
/ |
4059) |
= |
-5.83394924 |
5 |
33429 |
2470 |
- |
2528 |
= |
-58 |
* |
(695 |
/ |
4059) |
= |
-9.93101746 |
6 |
33430 |
2496 |
- |
2552 |
= |
-56 |
* |
(708 |
/ |
4059) |
= |
-9.76792309 |
7 |
33431 |
2500 |
- |
2567 |
= |
-67 |
* |
(686 |
/ |
4059) |
= |
-11.32347865 |
8 |
33432 |
2491 |
- |
2586 |
= |
-95 |
* |
(665 |
/ |
4059) |
= |
-15.56417832 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Mountain View Elementary
|
-57 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-76
|
-70
|
-69
|
-68
|
-57
|
-340.0 |
-68.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -50.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -86.0
For the lines, you have the data necessary to plot the chart.