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 |
394996 |
2440 |
- |
2436 |
= |
4 |
* |
(20 |
/ |
111) |
= |
0.72072072 |
4 |
394997 |
2448 |
- |
2485 |
= |
-37 |
* |
(18 |
/ |
111) |
= |
-5.99999999 |
5 |
395000 |
2473 |
- |
2528 |
= |
-55 |
* |
(12 |
/ |
111) |
= |
-5.94594594 |
6 |
395001 |
2543 |
- |
2552 |
= |
-9 |
* |
(15 |
/ |
111) |
= |
-1.21621622 |
7 |
395004 |
2567 |
- |
2567 |
= |
0 |
* |
(21 |
/ |
111) |
= |
0.0 |
8 |
395005 |
2544 |
- |
2586 |
= |
-42 |
* |
(25 |
/ |
111) |
= |
-9.45945945 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lake Elementary
|
-22 |
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 |
12077 |
2385 |
- |
2436 |
= |
-51 |
* |
(20 |
/ |
109) |
= |
-9.35779814 |
4 |
12079 |
2465 |
- |
2485 |
= |
-20 |
* |
(21 |
/ |
109) |
= |
-3.853211 |
5 |
12082 |
2476 |
- |
2528 |
= |
-52 |
* |
(19 |
/ |
109) |
= |
-9.06422015 |
6 |
12083 |
2560 |
- |
2552 |
= |
8 |
* |
(13 |
/ |
109) |
= |
0.95412844 |
7 |
12086 |
2621 |
- |
2567 |
= |
54 |
* |
(16 |
/ |
109) |
= |
7.92660546 |
8 |
12087 |
2557 |
- |
2586 |
= |
-29 |
* |
(20 |
/ |
109) |
= |
-5.3211009 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lake Elementary
|
-19 |
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 |
12410 |
2416 |
- |
2436 |
= |
-20 |
* |
(18 |
/ |
109) |
= |
-3.30275228 |
4 |
12412 |
2449 |
- |
2485 |
= |
-36 |
* |
(20 |
/ |
109) |
= |
-6.60550457 |
5 |
12414 |
2493 |
- |
2528 |
= |
-35 |
* |
(23 |
/ |
109) |
= |
-7.38532109 |
6 |
12417 |
2569 |
- |
2552 |
= |
17 |
* |
(19 |
/ |
109) |
= |
2.96330274 |
7 |
12418 |
2599 |
- |
2567 |
= |
32 |
* |
(15 |
/ |
109) |
= |
4.4036697 |
8 |
12420 |
2607 |
- |
2586 |
= |
21 |
* |
(14 |
/ |
109) |
= |
2.69724769 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lake Elementary
|
-7 |
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 |
12436 |
2422 |
- |
2436 |
= |
-14 |
* |
(19 |
/ |
117) |
= |
-2.27350427 |
4 |
12437 |
2478 |
- |
2485 |
= |
-7 |
* |
(19 |
/ |
117) |
= |
-1.13675213 |
5 |
12440 |
2487 |
- |
2528 |
= |
-41 |
* |
(21 |
/ |
117) |
= |
-7.35897434 |
6 |
12441 |
2577 |
- |
2552 |
= |
25 |
* |
(24 |
/ |
117) |
= |
5.12820513 |
7 |
12444 |
2627 |
- |
2567 |
= |
60 |
* |
(19 |
/ |
117) |
= |
9.74358972 |
8 |
12445 |
2615 |
- |
2586 |
= |
29 |
* |
(15 |
/ |
117) |
= |
3.71794871 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lake Elementary
|
8 |
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 |
12536 |
2458 |
- |
2436 |
= |
22 |
* |
(19 |
/ |
123) |
= |
3.39837397 |
4 |
12537 |
2473 |
- |
2485 |
= |
-12 |
* |
(19 |
/ |
123) |
= |
-1.85365853 |
5 |
12538 |
2520 |
- |
2528 |
= |
-8 |
* |
(20 |
/ |
123) |
= |
-1.30081301 |
6 |
12539 |
2569 |
- |
2552 |
= |
17 |
* |
(22 |
/ |
123) |
= |
3.0406504 |
7 |
12540 |
2622 |
- |
2567 |
= |
55 |
* |
(24 |
/ |
123) |
= |
10.73170731 |
8 |
12541 |
2610 |
- |
2586 |
= |
24 |
* |
(19 |
/ |
123) |
= |
3.70731706 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lake Elementary
|
18 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-22
|
-19
|
-7
|
8
|
18
|
-22.0 |
-4.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 46.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -55.4
For the lines, you have the data necessary to plot the chart.