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 |
1104553 |
2468 |
- |
2436 |
= |
32 |
* |
(808 |
/ |
5790) |
= |
4.46563037 |
4 |
1104556 |
2511 |
- |
2485 |
= |
26 |
* |
(763 |
/ |
5790) |
= |
3.42625215 |
5 |
1104557 |
2545 |
- |
2528 |
= |
17 |
* |
(852 |
/ |
5790) |
= |
2.5015544 |
6 |
1104560 |
2551 |
- |
2552 |
= |
-1 |
* |
(860 |
/ |
5790) |
= |
-0.14853195 |
7 |
1104561 |
2571 |
- |
2567 |
= |
4 |
* |
(804 |
/ |
5790) |
= |
0.55544041 |
8 |
1104564 |
2588 |
- |
2586 |
= |
2 |
* |
(851 |
/ |
5790) |
= |
0.29395509 |
11 |
1104565 |
2604 |
- |
2628 |
= |
-24 |
* |
(852 |
/ |
5790) |
= |
-3.53160622 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Santa Monica-Malibu Unified
|
8 |
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 |
34547 |
2484 |
- |
2436 |
= |
48 |
* |
(801 |
/ |
5707) |
= |
6.73698965 |
4 |
34550 |
2527 |
- |
2485 |
= |
42 |
* |
(802 |
/ |
5707) |
= |
5.90222531 |
5 |
34552 |
2553 |
- |
2528 |
= |
25 |
* |
(746 |
/ |
5707) |
= |
3.26791658 |
6 |
34554 |
2554 |
- |
2552 |
= |
2 |
* |
(855 |
/ |
5707) |
= |
0.29963203 |
7 |
34555 |
2579 |
- |
2567 |
= |
12 |
* |
(864 |
/ |
5707) |
= |
1.81671631 |
8 |
34557 |
2592 |
- |
2586 |
= |
6 |
* |
(803 |
/ |
5707) |
= |
0.84422639 |
11 |
34560 |
2620 |
- |
2628 |
= |
-8 |
* |
(836 |
/ |
5707) |
= |
-1.17189416 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Santa Monica-Malibu Unified
|
18 |
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 |
35173 |
2486 |
- |
2436 |
= |
50 |
* |
(790 |
/ |
5600) |
= |
7.0535714 |
4 |
35176 |
2527 |
- |
2485 |
= |
42 |
* |
(804 |
/ |
5600) |
= |
6.02999998 |
5 |
35177 |
2564 |
- |
2528 |
= |
36 |
* |
(821 |
/ |
5600) |
= |
5.27785711 |
6 |
35180 |
2564 |
- |
2552 |
= |
12 |
* |
(782 |
/ |
5600) |
= |
1.67571428 |
7 |
35181 |
2583 |
- |
2567 |
= |
16 |
* |
(840 |
/ |
5600) |
= |
2.4 |
8 |
35183 |
2588 |
- |
2586 |
= |
2 |
* |
(771 |
/ |
5600) |
= |
0.27535714 |
11 |
35185 |
2622 |
- |
2628 |
= |
-6 |
* |
(792 |
/ |
5600) |
= |
-0.84857143 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Santa Monica-Malibu Unified
|
22 |
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 |
35184 |
2476 |
- |
2436 |
= |
40 |
* |
(656 |
/ |
5497) |
= |
4.7735128 |
4 |
35186 |
2528 |
- |
2485 |
= |
43 |
* |
(802 |
/ |
5497) |
= |
6.27360377 |
5 |
35188 |
2563 |
- |
2528 |
= |
35 |
* |
(805 |
/ |
5497) |
= |
5.12552299 |
6 |
35190 |
2566 |
- |
2552 |
= |
14 |
* |
(816 |
/ |
5497) |
= |
2.07822448 |
7 |
35192 |
2578 |
- |
2567 |
= |
11 |
* |
(781 |
/ |
5497) |
= |
1.56285246 |
8 |
35194 |
2600 |
- |
2586 |
= |
14 |
* |
(826 |
/ |
5497) |
= |
2.10369292 |
11 |
35196 |
2624 |
- |
2628 |
= |
-4 |
* |
(811 |
/ |
5497) |
= |
-0.59014008 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Santa Monica-Malibu 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 |
35358 |
2478 |
- |
2436 |
= |
42 |
* |
(706 |
/ |
5298) |
= |
5.59682899 |
4 |
35359 |
2528 |
- |
2485 |
= |
43 |
* |
(660 |
/ |
5298) |
= |
5.35673837 |
5 |
35360 |
2564 |
- |
2528 |
= |
36 |
* |
(784 |
/ |
5298) |
= |
5.32729328 |
6 |
35361 |
2557 |
- |
2552 |
= |
5 |
* |
(820 |
/ |
5298) |
= |
0.77387693 |
7 |
35362 |
2576 |
- |
2567 |
= |
9 |
* |
(800 |
/ |
5298) |
= |
1.35900339 |
8 |
35363 |
2597 |
- |
2586 |
= |
11 |
* |
(781 |
/ |
5298) |
= |
1.6215553 |
11 |
35364 |
2646 |
- |
2628 |
= |
18 |
* |
(747 |
/ |
5298) |
= |
2.53793884 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Santa Monica-Malibu Unified
|
23 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
8
|
18
|
22
|
21
|
23
|
92.0 |
18.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 36.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 0.4
For the lines, you have the data necessary to plot the chart.