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 |
1066386 |
2495 |
- |
2436 |
= |
59 |
* |
(718 |
/ |
5462) |
= |
7.75576706 |
4 |
1066389 |
2536 |
- |
2485 |
= |
51 |
* |
(755 |
/ |
5462) |
= |
7.04961551 |
5 |
1066390 |
2571 |
- |
2528 |
= |
43 |
* |
(757 |
/ |
5462) |
= |
5.9595386 |
6 |
1066393 |
2594 |
- |
2552 |
= |
42 |
* |
(884 |
/ |
5462) |
= |
6.79751003 |
7 |
1066394 |
2615 |
- |
2567 |
= |
48 |
* |
(786 |
/ |
5462) |
= |
6.90735994 |
8 |
1066397 |
2629 |
- |
2586 |
= |
43 |
* |
(890 |
/ |
5462) |
= |
7.00659097 |
11 |
1066398 |
2669 |
- |
2628 |
= |
41 |
* |
(672 |
/ |
5462) |
= |
5.0443061 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Palos Verdes Peninsula Unified
|
47 |
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 |
33445 |
2503 |
- |
2436 |
= |
67 |
* |
(735 |
/ |
5607) |
= |
8.78277151 |
4 |
33448 |
2538 |
- |
2485 |
= |
53 |
* |
(744 |
/ |
5607) |
= |
7.03263773 |
5 |
33449 |
2566 |
- |
2528 |
= |
38 |
* |
(785 |
/ |
5607) |
= |
5.32013551 |
6 |
33452 |
2606 |
- |
2552 |
= |
54 |
* |
(797 |
/ |
5607) |
= |
7.67576239 |
7 |
33454 |
2623 |
- |
2567 |
= |
56 |
* |
(864 |
/ |
5607) |
= |
8.62921343 |
8 |
33456 |
2642 |
- |
2586 |
= |
56 |
* |
(794 |
/ |
5607) |
= |
7.93008737 |
11 |
33457 |
2658 |
- |
2628 |
= |
30 |
* |
(888 |
/ |
5607) |
= |
4.75120383 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Palos Verdes Peninsula Unified
|
50 |
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 |
34036 |
2498 |
- |
2436 |
= |
62 |
* |
(698 |
/ |
5670) |
= |
7.63245147 |
4 |
34039 |
2532 |
- |
2485 |
= |
47 |
* |
(771 |
/ |
5670) |
= |
6.39100525 |
5 |
34041 |
2566 |
- |
2528 |
= |
38 |
* |
(757 |
/ |
5670) |
= |
5.0733686 |
6 |
34043 |
2596 |
- |
2552 |
= |
44 |
* |
(838 |
/ |
5670) |
= |
6.50299822 |
7 |
34044 |
2625 |
- |
2567 |
= |
58 |
* |
(835 |
/ |
5670) |
= |
8.54144615 |
8 |
34047 |
2645 |
- |
2586 |
= |
59 |
* |
(863 |
/ |
5670) |
= |
8.98007052 |
11 |
34049 |
2677 |
- |
2628 |
= |
49 |
* |
(908 |
/ |
5670) |
= |
7.84691356 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Palos Verdes Peninsula Unified
|
51 |
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 |
34041 |
2495 |
- |
2436 |
= |
59 |
* |
(658 |
/ |
5754) |
= |
6.74695863 |
4 |
34043 |
2534 |
- |
2485 |
= |
49 |
* |
(728 |
/ |
5754) |
= |
6.19951337 |
5 |
34045 |
2566 |
- |
2528 |
= |
38 |
* |
(808 |
/ |
5754) |
= |
5.33611398 |
6 |
34047 |
2596 |
- |
2552 |
= |
44 |
* |
(864 |
/ |
5754) |
= |
6.60688213 |
7 |
34049 |
2619 |
- |
2567 |
= |
52 |
* |
(837 |
/ |
5754) |
= |
7.5641293 |
8 |
34051 |
2650 |
- |
2586 |
= |
64 |
* |
(840 |
/ |
5754) |
= |
9.34306566 |
11 |
34053 |
2657 |
- |
2628 |
= |
29 |
* |
(1019 |
/ |
5754) |
= |
5.13573166 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Palos Verdes Peninsula Unified
|
47 |
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 |
34210 |
2497 |
- |
2436 |
= |
61 |
* |
(747 |
/ |
5679) |
= |
8.02377176 |
4 |
34211 |
2539 |
- |
2485 |
= |
54 |
* |
(666 |
/ |
5679) |
= |
6.33280502 |
5 |
34212 |
2578 |
- |
2528 |
= |
50 |
* |
(753 |
/ |
5679) |
= |
6.6296883 |
6 |
34213 |
2602 |
- |
2552 |
= |
50 |
* |
(869 |
/ |
5679) |
= |
7.65099485 |
7 |
34214 |
2620 |
- |
2567 |
= |
53 |
* |
(886 |
/ |
5679) |
= |
8.26870925 |
8 |
34215 |
2638 |
- |
2586 |
= |
52 |
* |
(869 |
/ |
5679) |
= |
7.95703464 |
11 |
34216 |
2653 |
- |
2628 |
= |
25 |
* |
(889 |
/ |
5679) |
= |
3.9135411 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Palos Verdes Peninsula Unified
|
49 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
47
|
50
|
51
|
47
|
49
|
244.0 |
48.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 51.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 45.8
For the lines, you have the data necessary to plot the chart.