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 |
2634764 |
2508 |
- |
2436 |
= |
72 |
* |
(2025 |
/ |
12821) |
= |
11.37196786 |
4 |
2634767 |
2556 |
- |
2485 |
= |
71 |
* |
(2189 |
/ |
12821) |
= |
12.12222135 |
5 |
2634768 |
2594 |
- |
2528 |
= |
66 |
* |
(2244 |
/ |
12821) |
= |
11.55167303 |
6 |
2634771 |
2633 |
- |
2552 |
= |
81 |
* |
(2204 |
/ |
12821) |
= |
13.92434283 |
7 |
2634772 |
2662 |
- |
2567 |
= |
95 |
* |
(2103 |
/ |
12821) |
= |
15.58263777 |
8 |
2634775 |
2680 |
- |
2586 |
= |
94 |
* |
(2056 |
/ |
12821) |
= |
15.07401916 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Cupertino Union
|
80 |
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 |
80340 |
2512 |
- |
2436 |
= |
76 |
* |
(2069 |
/ |
12682) |
= |
12.39899066 |
4 |
80342 |
2568 |
- |
2485 |
= |
83 |
* |
(2006 |
/ |
12682) |
= |
13.12868627 |
5 |
80343 |
2602 |
- |
2528 |
= |
74 |
* |
(2152 |
/ |
12682) |
= |
12.5570099 |
6 |
80345 |
2645 |
- |
2552 |
= |
93 |
* |
(2181 |
/ |
12682) |
= |
15.9937707 |
7 |
80348 |
2671 |
- |
2567 |
= |
104 |
* |
(2188 |
/ |
12682) |
= |
17.94291117 |
8 |
80350 |
2692 |
- |
2586 |
= |
106 |
* |
(2086 |
/ |
12682) |
= |
17.43542018 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Cupertino Union
|
89 |
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 |
82553 |
2512 |
- |
2436 |
= |
76 |
* |
(1983 |
/ |
12486) |
= |
12.07015858 |
4 |
82554 |
2565 |
- |
2485 |
= |
80 |
* |
(2031 |
/ |
12486) |
= |
13.01297448 |
5 |
82556 |
2601 |
- |
2528 |
= |
73 |
* |
(1986 |
/ |
12486) |
= |
11.61124459 |
6 |
82559 |
2644 |
- |
2552 |
= |
92 |
* |
(2121 |
/ |
12486) |
= |
15.62806337 |
7 |
82560 |
2675 |
- |
2567 |
= |
108 |
* |
(2191 |
/ |
12486) |
= |
18.95146556 |
8 |
82563 |
2703 |
- |
2586 |
= |
117 |
* |
(2174 |
/ |
12486) |
= |
20.37145594 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Cupertino Union
|
92 |
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 |
82760 |
2518 |
- |
2436 |
= |
82 |
* |
(1782 |
/ |
11865) |
= |
12.31554991 |
4 |
82761 |
2570 |
- |
2485 |
= |
85 |
* |
(1972 |
/ |
11865) |
= |
14.12726503 |
5 |
82764 |
2602 |
- |
2528 |
= |
74 |
* |
(1982 |
/ |
11865) |
= |
12.36139904 |
6 |
82765 |
2646 |
- |
2552 |
= |
94 |
* |
(1920 |
/ |
11865) |
= |
15.21112512 |
7 |
82768 |
2672 |
- |
2567 |
= |
105 |
* |
(2069 |
/ |
11865) |
= |
18.30973442 |
8 |
82769 |
2710 |
- |
2586 |
= |
124 |
* |
(2140 |
/ |
11865) |
= |
22.36493884 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Cupertino Union
|
95 |
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 |
83377 |
2518 |
- |
2436 |
= |
82 |
* |
(1862 |
/ |
11427) |
= |
13.36168721 |
4 |
83378 |
2571 |
- |
2485 |
= |
86 |
* |
(1751 |
/ |
11427) |
= |
13.17808693 |
5 |
83379 |
2609 |
- |
2528 |
= |
81 |
* |
(1962 |
/ |
11427) |
= |
13.90758725 |
6 |
83380 |
2645 |
- |
2552 |
= |
93 |
* |
(1927 |
/ |
11427) |
= |
15.68311889 |
7 |
83381 |
2677 |
- |
2567 |
= |
110 |
* |
(1915 |
/ |
11427) |
= |
18.43440973 |
8 |
83382 |
2703 |
- |
2586 |
= |
117 |
* |
(2010 |
/ |
11427) |
= |
20.58020476 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Cupertino Union
|
95 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
80
|
89
|
92
|
95
|
95
|
451.0 |
90.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 108.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 72.2
For the lines, you have the data necessary to plot the chart.