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 |
21473 |
2457 |
- |
2436 |
= |
21 |
* |
(676 |
/ |
4696) |
= |
3.02299828 |
4 |
21476 |
2506 |
- |
2485 |
= |
21 |
* |
(673 |
/ |
4696) |
= |
3.00958262 |
5 |
21477 |
2526 |
- |
2528 |
= |
-2 |
* |
(658 |
/ |
4696) |
= |
-0.2802385 |
6 |
21480 |
2536 |
- |
2552 |
= |
-16 |
* |
(742 |
/ |
4696) |
= |
-2.52810902 |
7 |
21481 |
2574 |
- |
2567 |
= |
7 |
* |
(706 |
/ |
4696) |
= |
1.05238501 |
8 |
21484 |
2584 |
- |
2586 |
= |
-2 |
* |
(671 |
/ |
4696) |
= |
-0.28577513 |
11 |
21485 |
2607 |
- |
2628 |
= |
-21 |
* |
(570 |
/ |
4696) |
= |
-2.54897784 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Castro Valley Unified
|
1 |
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 |
578 |
2481 |
- |
2436 |
= |
45 |
* |
(646 |
/ |
4843) |
= |
6.00247778 |
4 |
580 |
2507 |
- |
2485 |
= |
22 |
* |
(684 |
/ |
4843) |
= |
3.10716496 |
5 |
581 |
2554 |
- |
2528 |
= |
26 |
* |
(679 |
/ |
4843) |
= |
3.64526118 |
6 |
584 |
2563 |
- |
2552 |
= |
11 |
* |
(680 |
/ |
4843) |
= |
1.54449721 |
7 |
586 |
2577 |
- |
2567 |
= |
10 |
* |
(751 |
/ |
4843) |
= |
1.55069172 |
8 |
587 |
2602 |
- |
2586 |
= |
16 |
* |
(702 |
/ |
4843) |
= |
2.31922362 |
11 |
589 |
2606 |
- |
2628 |
= |
-22 |
* |
(701 |
/ |
4843) |
= |
-3.18438982 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Castro Valley Unified
|
15 |
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 |
600 |
2479 |
- |
2436 |
= |
43 |
* |
(660 |
/ |
4898) |
= |
5.79420171 |
4 |
601 |
2526 |
- |
2485 |
= |
41 |
* |
(654 |
/ |
4898) |
= |
5.47447937 |
5 |
603 |
2541 |
- |
2528 |
= |
13 |
* |
(694 |
/ |
4898) |
= |
1.84197631 |
6 |
605 |
2561 |
- |
2552 |
= |
9 |
* |
(719 |
/ |
4898) |
= |
1.32115149 |
7 |
608 |
2584 |
- |
2567 |
= |
17 |
* |
(704 |
/ |
4898) |
= |
2.4434463 |
8 |
610 |
2598 |
- |
2586 |
= |
12 |
* |
(747 |
/ |
4898) |
= |
1.83013475 |
11 |
612 |
2625 |
- |
2628 |
= |
-3 |
* |
(720 |
/ |
4898) |
= |
-0.44099633 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Castro Valley Unified
|
18 |
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 |
623 |
2484 |
- |
2436 |
= |
48 |
* |
(642 |
/ |
4782) |
= |
6.4441656 |
4 |
625 |
2512 |
- |
2485 |
= |
27 |
* |
(673 |
/ |
4782) |
= |
3.79987451 |
5 |
627 |
2558 |
- |
2528 |
= |
30 |
* |
(684 |
/ |
4782) |
= |
4.29109158 |
6 |
629 |
2554 |
- |
2552 |
= |
2 |
* |
(704 |
/ |
4782) |
= |
0.29443747 |
7 |
631 |
2594 |
- |
2567 |
= |
27 |
* |
(717 |
/ |
4782) |
= |
4.04830613 |
8 |
633 |
2603 |
- |
2586 |
= |
17 |
* |
(683 |
/ |
4782) |
= |
2.42806356 |
11 |
635 |
2626 |
- |
2628 |
= |
-2 |
* |
(679 |
/ |
4782) |
= |
-0.2839816 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Castro Valley Unified
|
21 |
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 |
655 |
2485 |
- |
2436 |
= |
49 |
* |
(653 |
/ |
4847) |
= |
6.60140289 |
4 |
656 |
2521 |
- |
2485 |
= |
36 |
* |
(656 |
/ |
4847) |
= |
4.87229213 |
5 |
657 |
2556 |
- |
2528 |
= |
28 |
* |
(677 |
/ |
4847) |
= |
3.9108727 |
6 |
658 |
2567 |
- |
2552 |
= |
15 |
* |
(708 |
/ |
4847) |
= |
2.191046 |
7 |
659 |
2585 |
- |
2567 |
= |
18 |
* |
(710 |
/ |
4847) |
= |
2.63668248 |
8 |
660 |
2604 |
- |
2586 |
= |
18 |
* |
(734 |
/ |
4847) |
= |
2.72580977 |
11 |
661 |
2631 |
- |
2628 |
= |
3 |
* |
(709 |
/ |
4847) |
= |
0.43882814 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Castro Valley Unified
|
23 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
1
|
15
|
18
|
21
|
23
|
78.0 |
15.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 39.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -8.4
For the lines, you have the data necessary to plot the chart.