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 |
7 |
2283476 |
2618 |
- |
2567 |
= |
51 |
* |
(1889 |
/ |
5892) |
= |
16.35081466 |
8 |
2283477 |
2635 |
- |
2586 |
= |
49 |
* |
(2039 |
/ |
5892) |
= |
16.95706039 |
11 |
2283480 |
2660 |
- |
2628 |
= |
32 |
* |
(1964 |
/ |
5892) |
= |
10.66666666 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Dieguito Union High
|
44 |
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 |
7 |
69952 |
2640 |
- |
2567 |
= |
73 |
* |
(1980 |
/ |
5954) |
= |
24.27611686 |
8 |
69953 |
2644 |
- |
2586 |
= |
58 |
* |
(1916 |
/ |
5954) |
= |
18.66442726 |
11 |
69955 |
2663 |
- |
2628 |
= |
35 |
* |
(2058 |
/ |
5954) |
= |
12.09774941 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Dieguito Union High
|
55 |
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 |
7 |
71787 |
2643 |
- |
2567 |
= |
76 |
* |
(1951 |
/ |
6046) |
= |
24.52464436 |
8 |
71788 |
2655 |
- |
2586 |
= |
69 |
* |
(2010 |
/ |
6046) |
= |
22.93913328 |
11 |
71791 |
2660 |
- |
2628 |
= |
32 |
* |
(2085 |
/ |
6046) |
= |
11.0353953 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Dieguito Union High
|
58 |
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 |
7 |
71931 |
2639 |
- |
2567 |
= |
72 |
* |
(1988 |
/ |
6127) |
= |
23.36151456 |
8 |
71933 |
2654 |
- |
2586 |
= |
68 |
* |
(1976 |
/ |
6127) |
= |
21.93047165 |
11 |
71935 |
2671 |
- |
2628 |
= |
43 |
* |
(2163 |
/ |
6127) |
= |
15.18018603 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Dieguito Union High
|
60 |
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 |
7 |
72417 |
2646 |
- |
2567 |
= |
79 |
* |
(2084 |
/ |
6146) |
= |
26.78750399 |
8 |
72418 |
2655 |
- |
2586 |
= |
69 |
* |
(1989 |
/ |
6146) |
= |
22.33013342 |
11 |
72419 |
2664 |
- |
2628 |
= |
36 |
* |
(2073 |
/ |
6146) |
= |
12.14253169 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Dieguito Union High
|
61 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
44
|
55
|
58
|
60
|
61
|
278.0 |
55.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 73.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 37.6
For the lines, you have the data necessary to plot the chart.