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 |
6120 |
2451 |
- |
2436 |
= |
15 |
* |
(698 |
/ |
4473) |
= |
2.34071093 |
4 |
6121 |
2502 |
- |
2485 |
= |
17 |
* |
(734 |
/ |
4473) |
= |
2.78962665 |
5 |
6124 |
2532 |
- |
2528 |
= |
4 |
* |
(766 |
/ |
4473) |
= |
0.68499888 |
6 |
6125 |
2548 |
- |
2552 |
= |
-4 |
* |
(537 |
/ |
4473) |
= |
-0.48021462 |
7 |
6128 |
2569 |
- |
2567 |
= |
2 |
* |
(600 |
/ |
4473) |
= |
0.26827632 |
8 |
6129 |
2583 |
- |
2586 |
= |
-3 |
* |
(525 |
/ |
4473) |
= |
-0.35211268 |
11 |
6132 |
2610 |
- |
2628 |
= |
-18 |
* |
(613 |
/ |
4473) |
= |
-2.4668008 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Alameda Unified
|
3 |
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 |
188 |
2454 |
- |
2436 |
= |
18 |
* |
(796 |
/ |
4687) |
= |
3.05696606 |
4 |
189 |
2500 |
- |
2485 |
= |
15 |
* |
(713 |
/ |
4687) |
= |
2.2818434 |
5 |
192 |
2535 |
- |
2528 |
= |
7 |
* |
(719 |
/ |
4687) |
= |
1.0738212 |
6 |
194 |
2556 |
- |
2552 |
= |
4 |
* |
(597 |
/ |
4687) |
= |
0.50949434 |
7 |
195 |
2583 |
- |
2567 |
= |
16 |
* |
(540 |
/ |
4687) |
= |
1.84339662 |
8 |
197 |
2592 |
- |
2586 |
= |
6 |
* |
(614 |
/ |
4687) |
= |
0.78600384 |
11 |
199 |
2627 |
- |
2628 |
= |
-1 |
* |
(708 |
/ |
4687) |
= |
-0.15105611 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Alameda Unified
|
9 |
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 |
189 |
2464 |
- |
2436 |
= |
28 |
* |
(705 |
/ |
4704) |
= |
4.19642854 |
4 |
191 |
2498 |
- |
2485 |
= |
13 |
* |
(768 |
/ |
4704) |
= |
2.12244898 |
5 |
193 |
2534 |
- |
2528 |
= |
6 |
* |
(719 |
/ |
4704) |
= |
0.91709183 |
6 |
195 |
2561 |
- |
2552 |
= |
9 |
* |
(596 |
/ |
4704) |
= |
1.14030612 |
7 |
198 |
2578 |
- |
2567 |
= |
11 |
* |
(604 |
/ |
4704) |
= |
1.41241496 |
8 |
199 |
2595 |
- |
2586 |
= |
9 |
* |
(555 |
/ |
4704) |
= |
1.06186224 |
11 |
201 |
2616 |
- |
2628 |
= |
-12 |
* |
(757 |
/ |
4704) |
= |
-1.93112244 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Alameda Unified
|
9 |
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 |
209 |
2473 |
- |
2436 |
= |
37 |
* |
(672 |
/ |
4668) |
= |
5.32647812 |
4 |
211 |
2505 |
- |
2485 |
= |
20 |
* |
(698 |
/ |
4668) |
= |
2.99057412 |
5 |
213 |
2536 |
- |
2528 |
= |
8 |
* |
(770 |
/ |
4668) |
= |
1.31962296 |
6 |
215 |
2551 |
- |
2552 |
= |
-1 |
* |
(594 |
/ |
4668) |
= |
-0.12724936 |
7 |
217 |
2581 |
- |
2567 |
= |
14 |
* |
(610 |
/ |
4668) |
= |
1.82947729 |
8 |
219 |
2610 |
- |
2586 |
= |
24 |
* |
(603 |
/ |
4668) |
= |
3.10025705 |
11 |
221 |
2620 |
- |
2628 |
= |
-8 |
* |
(721 |
/ |
4668) |
= |
-1.23564695 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Alameda Unified
|
13 |
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 |
241 |
2474 |
- |
2436 |
= |
38 |
* |
(703 |
/ |
4585) |
= |
5.82639039 |
4 |
242 |
2506 |
- |
2485 |
= |
21 |
* |
(665 |
/ |
4585) |
= |
3.04580151 |
5 |
243 |
2539 |
- |
2528 |
= |
11 |
* |
(704 |
/ |
4585) |
= |
1.68898582 |
6 |
244 |
2553 |
- |
2552 |
= |
1 |
* |
(649 |
/ |
4585) |
= |
0.14154853 |
7 |
245 |
2567 |
- |
2567 |
= |
0 |
* |
(583 |
/ |
4585) |
= |
0.0 |
8 |
246 |
2601 |
- |
2586 |
= |
15 |
* |
(590 |
/ |
4585) |
= |
1.93020719 |
11 |
247 |
2631 |
- |
2628 |
= |
3 |
* |
(691 |
/ |
4585) |
= |
0.4521265 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Alameda Unified
|
13 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
3
|
9
|
9
|
13
|
13
|
47.0 |
9.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 21.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -2.6
For the lines, you have the data necessary to plot the chart.