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 |
745753 |
2472 |
- |
2436 |
= |
36 |
* |
(737 |
/ |
5343) |
= |
4.96574957 |
4 |
745754 |
2503 |
- |
2485 |
= |
18 |
* |
(738 |
/ |
5343) |
= |
2.48624368 |
5 |
745757 |
2535 |
- |
2528 |
= |
7 |
* |
(784 |
/ |
5343) |
= |
1.02713831 |
6 |
745758 |
2553 |
- |
2552 |
= |
1 |
* |
(894 |
/ |
5343) |
= |
0.16732173 |
7 |
745761 |
2575 |
- |
2567 |
= |
8 |
* |
(873 |
/ |
5343) |
= |
1.30713082 |
8 |
745762 |
2594 |
- |
2586 |
= |
8 |
* |
(866 |
/ |
5343) |
= |
1.29664982 |
11 |
745765 |
2635 |
- |
2628 |
= |
7 |
* |
(451 |
/ |
5343) |
= |
0.59086655 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Las Virgenes Unified
|
12 |
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 |
23457 |
2469 |
- |
2436 |
= |
33 |
* |
(718 |
/ |
5835) |
= |
4.06066835 |
4 |
23458 |
2515 |
- |
2485 |
= |
30 |
* |
(771 |
/ |
5835) |
= |
3.96401028 |
5 |
23461 |
2545 |
- |
2528 |
= |
17 |
* |
(778 |
/ |
5835) |
= |
2.26666666 |
6 |
23463 |
2560 |
- |
2552 |
= |
8 |
* |
(901 |
/ |
5835) |
= |
1.23530419 |
7 |
23464 |
2583 |
- |
2567 |
= |
16 |
* |
(907 |
/ |
5835) |
= |
2.48706083 |
8 |
23466 |
2599 |
- |
2586 |
= |
13 |
* |
(848 |
/ |
5835) |
= |
1.88928877 |
11 |
23468 |
2612 |
- |
2628 |
= |
-16 |
* |
(912 |
/ |
5835) |
= |
-2.5007712 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Las Virgenes Unified
|
13 |
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 |
23921 |
2473 |
- |
2436 |
= |
37 |
* |
(698 |
/ |
5836) |
= |
4.42529128 |
4 |
23923 |
2513 |
- |
2485 |
= |
28 |
* |
(739 |
/ |
5836) |
= |
3.54557916 |
5 |
23926 |
2545 |
- |
2528 |
= |
17 |
* |
(773 |
/ |
5836) |
= |
2.2517135 |
6 |
23928 |
2567 |
- |
2552 |
= |
15 |
* |
(873 |
/ |
5836) |
= |
2.24383139 |
7 |
23930 |
2583 |
- |
2567 |
= |
16 |
* |
(896 |
/ |
5836) |
= |
2.45647702 |
8 |
23932 |
2602 |
- |
2586 |
= |
16 |
* |
(895 |
/ |
5836) |
= |
2.45373542 |
11 |
23933 |
2614 |
- |
2628 |
= |
-14 |
* |
(962 |
/ |
5836) |
= |
-2.30774502 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Las Virgenes Unified
|
15 |
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 |
23942 |
2469 |
- |
2436 |
= |
33 |
* |
(708 |
/ |
5732) |
= |
4.07606417 |
4 |
23944 |
2515 |
- |
2485 |
= |
30 |
* |
(725 |
/ |
5732) |
= |
3.79448709 |
5 |
23946 |
2539 |
- |
2528 |
= |
11 |
* |
(741 |
/ |
5732) |
= |
1.42201674 |
6 |
23948 |
2565 |
- |
2552 |
= |
13 |
* |
(883 |
/ |
5732) |
= |
2.00261688 |
7 |
23950 |
2588 |
- |
2567 |
= |
21 |
* |
(874 |
/ |
5732) |
= |
3.20202372 |
8 |
23952 |
2597 |
- |
2586 |
= |
11 |
* |
(879 |
/ |
5732) |
= |
1.68684578 |
11 |
23954 |
2602 |
- |
2628 |
= |
-26 |
* |
(922 |
/ |
5732) |
= |
-4.18213536 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Las Virgenes Unified
|
12 |
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 |
24122 |
2470 |
- |
2436 |
= |
34 |
* |
(697 |
/ |
5654) |
= |
4.19136894 |
4 |
24123 |
2514 |
- |
2485 |
= |
29 |
* |
(732 |
/ |
5654) |
= |
3.75451006 |
5 |
24124 |
2539 |
- |
2528 |
= |
11 |
* |
(722 |
/ |
5654) |
= |
1.40466926 |
6 |
24125 |
2562 |
- |
2552 |
= |
10 |
* |
(870 |
/ |
5654) |
= |
1.53873363 |
7 |
24126 |
2584 |
- |
2567 |
= |
17 |
* |
(871 |
/ |
5654) |
= |
2.61885389 |
8 |
24127 |
2595 |
- |
2586 |
= |
9 |
* |
(872 |
/ |
5654) |
= |
1.38804386 |
11 |
24128 |
2617 |
- |
2628 |
= |
-11 |
* |
(890 |
/ |
5654) |
= |
-1.7315175 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Las Virgenes Unified
|
13 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
12
|
13
|
15
|
12
|
13
|
65.0 |
13.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 16.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 10.0
For the lines, you have the data necessary to plot the chart.