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 |
3094404 |
2406 |
- |
2436 |
= |
-30 |
* |
(63 |
/ |
309) |
= |
-6.11650485 |
4 |
3094405 |
2436 |
- |
2485 |
= |
-49 |
* |
(51 |
/ |
309) |
= |
-8.08737861 |
5 |
3094408 |
2469 |
- |
2528 |
= |
-59 |
* |
(46 |
/ |
309) |
= |
-8.78317147 |
6 |
3094409 |
2542 |
- |
2552 |
= |
-10 |
* |
(48 |
/ |
309) |
= |
-1.55339805 |
7 |
3094412 |
2515 |
- |
2567 |
= |
-52 |
* |
(50 |
/ |
309) |
= |
-8.41423944 |
8 |
3094413 |
2555 |
- |
2586 |
= |
-31 |
* |
(51 |
/ |
309) |
= |
-5.11650483 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Soulsbyville Elementary
|
-38 |
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 |
95357 |
2384 |
- |
2436 |
= |
-52 |
* |
(56 |
/ |
326) |
= |
-8.93251533 |
4 |
95359 |
2461 |
- |
2485 |
= |
-24 |
* |
(63 |
/ |
326) |
= |
-4.63803679 |
5 |
95361 |
2468 |
- |
2528 |
= |
-60 |
* |
(51 |
/ |
326) |
= |
-9.38650302 |
6 |
95362 |
2536 |
- |
2552 |
= |
-16 |
* |
(53 |
/ |
326) |
= |
-2.60122699 |
7 |
95365 |
2526 |
- |
2567 |
= |
-41 |
* |
(49 |
/ |
326) |
= |
-6.16257667 |
8 |
95366 |
2517 |
- |
2586 |
= |
-69 |
* |
(54 |
/ |
326) |
= |
-11.4294478 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Soulsbyville Elementary
|
-43 |
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 |
98133 |
2424 |
- |
2436 |
= |
-12 |
* |
(57 |
/ |
325) |
= |
-2.10461538 |
4 |
98135 |
2448 |
- |
2485 |
= |
-37 |
* |
(59 |
/ |
325) |
= |
-6.71692306 |
5 |
98137 |
2469 |
- |
2528 |
= |
-59 |
* |
(64 |
/ |
325) |
= |
-11.61846148 |
6 |
98140 |
2524 |
- |
2552 |
= |
-28 |
* |
(44 |
/ |
325) |
= |
-3.79076922 |
7 |
98141 |
2508 |
- |
2567 |
= |
-59 |
* |
(50 |
/ |
325) |
= |
-9.07692303 |
8 |
98144 |
2507 |
- |
2586 |
= |
-79 |
* |
(51 |
/ |
325) |
= |
-12.396923 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Soulsbyville Elementary
|
-46 |
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 |
98299 |
2415 |
- |
2436 |
= |
-21 |
* |
(60 |
/ |
345) |
= |
-3.6521739 |
4 |
98300 |
2461 |
- |
2485 |
= |
-24 |
* |
(66 |
/ |
345) |
= |
-4.59130433 |
5 |
98303 |
2446 |
- |
2528 |
= |
-82 |
* |
(63 |
/ |
345) |
= |
-14.97391299 |
6 |
98304 |
2553 |
- |
2552 |
= |
1 |
* |
(65 |
/ |
345) |
= |
0.1884058 |
7 |
98306 |
2496 |
- |
2567 |
= |
-71 |
* |
(46 |
/ |
345) |
= |
-9.46666664 |
8 |
98309 |
2522 |
- |
2586 |
= |
-64 |
* |
(45 |
/ |
345) |
= |
-8.34782605 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Soulsbyville Elementary
|
-41 |
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 |
98968 |
2402 |
- |
2436 |
= |
-34 |
* |
(51 |
/ |
350) |
= |
-4.95428569 |
4 |
98969 |
2450 |
- |
2485 |
= |
-35 |
* |
(61 |
/ |
350) |
= |
-6.09999999 |
5 |
98970 |
2482 |
- |
2528 |
= |
-46 |
* |
(63 |
/ |
350) |
= |
-8.28 |
6 |
98971 |
2498 |
- |
2552 |
= |
-54 |
* |
(63 |
/ |
350) |
= |
-9.72 |
7 |
98972 |
2547 |
- |
2567 |
= |
-20 |
* |
(66 |
/ |
350) |
= |
-3.77142856 |
8 |
98973 |
2508 |
- |
2586 |
= |
-78 |
* |
(46 |
/ |
350) |
= |
-10.25142854 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Soulsbyville Elementary
|
-43 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-38
|
-43
|
-46
|
-41
|
-43
|
-211.0 |
-42.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -36.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -48.2
For the lines, you have the data necessary to plot the chart.