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 |
70876 |
2395 |
- |
2436 |
= |
-41 |
* |
(3298 |
/ |
18220) |
= |
-7.42140504 |
4 |
70879 |
2433 |
- |
2485 |
= |
-52 |
* |
(3135 |
/ |
18220) |
= |
-8.94731063 |
5 |
70880 |
2468 |
- |
2528 |
= |
-60 |
* |
(3022 |
/ |
18220) |
= |
-9.9517014 |
6 |
70883 |
2453 |
- |
2552 |
= |
-99 |
* |
(2293 |
/ |
18220) |
= |
-12.45922059 |
7 |
70884 |
2470 |
- |
2567 |
= |
-97 |
* |
(2344 |
/ |
18220) |
= |
-12.479034 |
8 |
70887 |
2483 |
- |
2586 |
= |
-103 |
* |
(2494 |
/ |
18220) |
= |
-14.09890224 |
11 |
70888 |
2503 |
- |
2628 |
= |
-125 |
* |
(1634 |
/ |
18220) |
= |
-11.2102085 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Oakland Unified
|
-77 |
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 |
1882 |
2400 |
- |
2436 |
= |
-36 |
* |
(3196 |
/ |
17963) |
= |
-6.40516615 |
4 |
1883 |
2433 |
- |
2485 |
= |
-52 |
* |
(3199 |
/ |
17963) |
= |
-9.26059118 |
5 |
1886 |
2460 |
- |
2528 |
= |
-68 |
* |
(2997 |
/ |
17963) |
= |
-11.34532087 |
6 |
1887 |
2458 |
- |
2552 |
= |
-94 |
* |
(2254 |
/ |
17963) |
= |
-11.79513438 |
7 |
1890 |
2476 |
- |
2567 |
= |
-91 |
* |
(2208 |
/ |
17963) |
= |
-11.18565939 |
8 |
1891 |
2478 |
- |
2586 |
= |
-108 |
* |
(2273 |
/ |
17963) |
= |
-13.66609136 |
11 |
1894 |
2498 |
- |
2628 |
= |
-130 |
* |
(1836 |
/ |
17963) |
= |
-13.28731274 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Oakland Unified
|
-77 |
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 |
1939 |
2404 |
- |
2436 |
= |
-32 |
* |
(3151 |
/ |
17940) |
= |
-5.6205128 |
4 |
1941 |
2440 |
- |
2485 |
= |
-45 |
* |
(3093 |
/ |
17940) |
= |
-7.75836117 |
5 |
1943 |
2462 |
- |
2528 |
= |
-66 |
* |
(3137 |
/ |
17940) |
= |
-11.54080264 |
6 |
1946 |
2452 |
- |
2552 |
= |
-100 |
* |
(2240 |
/ |
17940) |
= |
-12.4860646 |
7 |
1947 |
2468 |
- |
2567 |
= |
-99 |
* |
(2309 |
/ |
17940) |
= |
-12.7419732 |
8 |
1950 |
2483 |
- |
2586 |
= |
-103 |
* |
(2234 |
/ |
17940) |
= |
-12.82619839 |
11 |
1951 |
2490 |
- |
2628 |
= |
-138 |
* |
(1776 |
/ |
17940) |
= |
-13.66153839 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Oakland Unified
|
-77 |
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 |
1950 |
2405 |
- |
2436 |
= |
-31 |
* |
(3096 |
/ |
17861) |
= |
-5.3734953 |
4 |
1952 |
2441 |
- |
2485 |
= |
-44 |
* |
(3120 |
/ |
17861) |
= |
-7.68601979 |
5 |
1954 |
2466 |
- |
2528 |
= |
-62 |
* |
(3008 |
/ |
17861) |
= |
-10.44152063 |
6 |
1956 |
2455 |
- |
2552 |
= |
-97 |
* |
(2369 |
/ |
17861) |
= |
-12.86562895 |
7 |
1958 |
2473 |
- |
2567 |
= |
-94 |
* |
(2251 |
/ |
17861) |
= |
-11.84670504 |
8 |
1960 |
2484 |
- |
2586 |
= |
-102 |
* |
(2233 |
/ |
17861) |
= |
-12.75214149 |
11 |
1962 |
2495 |
- |
2628 |
= |
-133 |
* |
(1784 |
/ |
17861) |
= |
-13.28436253 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Oakland Unified
|
-74 |
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 |
1977 |
2411 |
- |
2436 |
= |
-25 |
* |
(3027 |
/ |
17575) |
= |
-4.30583213 |
4 |
1978 |
2444 |
- |
2485 |
= |
-41 |
* |
(2984 |
/ |
17575) |
= |
-6.96125175 |
5 |
1979 |
2465 |
- |
2528 |
= |
-63 |
* |
(3063 |
/ |
17575) |
= |
-10.97974395 |
6 |
1980 |
2459 |
- |
2552 |
= |
-93 |
* |
(2181 |
/ |
17575) |
= |
-11.5409957 |
7 |
1981 |
2473 |
- |
2567 |
= |
-94 |
* |
(2272 |
/ |
17575) |
= |
-12.15180648 |
8 |
1982 |
2481 |
- |
2586 |
= |
-105 |
* |
(2154 |
/ |
17575) |
= |
-12.86884778 |
11 |
1983 |
2477 |
- |
2628 |
= |
-151 |
* |
(1894 |
/ |
17575) |
= |
-16.27277381 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Oakland Unified
|
-75 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-77
|
-77
|
-77
|
-74
|
-75
|
-380.0 |
-76.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -73.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -79.0
For the lines, you have the data necessary to plot the chart.