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 |
2560029 |
2429 |
- |
2436 |
= |
-7 |
* |
(693 |
/ |
4629) |
= |
-1.04795852 |
4 |
2560032 |
2465 |
- |
2485 |
= |
-20 |
* |
(674 |
/ |
4629) |
= |
-2.91207604 |
5 |
2560033 |
2489 |
- |
2528 |
= |
-39 |
* |
(660 |
/ |
4629) |
= |
-5.56059621 |
6 |
2560036 |
2529 |
- |
2552 |
= |
-23 |
* |
(658 |
/ |
4629) |
= |
-3.26938864 |
7 |
2560037 |
2550 |
- |
2567 |
= |
-17 |
* |
(649 |
/ |
4629) |
= |
-2.38345214 |
8 |
2560040 |
2571 |
- |
2586 |
= |
-15 |
* |
(650 |
/ |
4629) |
= |
-2.10628644 |
11 |
2560041 |
2571 |
- |
2628 |
= |
-57 |
* |
(645 |
/ |
4629) |
= |
-7.94232015 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for South San Francisco Unified
|
-25 |
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 |
77986 |
2442 |
- |
2436 |
= |
6 |
* |
(625 |
/ |
4585) |
= |
0.8178844 |
4 |
77988 |
2470 |
- |
2485 |
= |
-15 |
* |
(685 |
/ |
4585) |
= |
-2.24100327 |
5 |
77989 |
2507 |
- |
2528 |
= |
-21 |
* |
(640 |
/ |
4585) |
= |
-2.93129771 |
6 |
77991 |
2523 |
- |
2552 |
= |
-29 |
* |
(658 |
/ |
4585) |
= |
-4.16183205 |
7 |
77994 |
2563 |
- |
2567 |
= |
-4 |
* |
(646 |
/ |
4585) |
= |
-0.56357688 |
8 |
77995 |
2589 |
- |
2586 |
= |
3 |
* |
(634 |
/ |
4585) |
= |
0.41483097 |
11 |
77998 |
2573 |
- |
2628 |
= |
-55 |
* |
(697 |
/ |
4585) |
= |
-8.36095964 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for South San Francisco Unified
|
-17 |
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 |
80147 |
2438 |
- |
2436 |
= |
2 |
* |
(633 |
/ |
4509) |
= |
0.28077179 |
4 |
80148 |
2483 |
- |
2485 |
= |
-2 |
* |
(630 |
/ |
4509) |
= |
-0.27944112 |
5 |
80151 |
2502 |
- |
2528 |
= |
-26 |
* |
(678 |
/ |
4509) |
= |
-3.90951428 |
6 |
80152 |
2524 |
- |
2552 |
= |
-28 |
* |
(631 |
/ |
4509) |
= |
-3.91838544 |
7 |
80154 |
2542 |
- |
2567 |
= |
-25 |
* |
(640 |
/ |
4509) |
= |
-3.54845863 |
8 |
80157 |
2582 |
- |
2586 |
= |
-4 |
* |
(652 |
/ |
4509) |
= |
-0.57839876 |
11 |
80158 |
2552 |
- |
2628 |
= |
-76 |
* |
(645 |
/ |
4509) |
= |
-10.87159009 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for South San Francisco Unified
|
-23 |
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 |
80298 |
2441 |
- |
2436 |
= |
5 |
* |
(609 |
/ |
4446) |
= |
0.68488529 |
4 |
80299 |
2480 |
- |
2485 |
= |
-5 |
* |
(619 |
/ |
4446) |
= |
-0.69613135 |
5 |
80302 |
2507 |
- |
2528 |
= |
-21 |
* |
(635 |
/ |
4446) |
= |
-2.99932523 |
6 |
80303 |
2520 |
- |
2552 |
= |
-32 |
* |
(680 |
/ |
4446) |
= |
-4.89428698 |
7 |
80306 |
2538 |
- |
2567 |
= |
-29 |
* |
(630 |
/ |
4446) |
= |
-4.10931172 |
8 |
80307 |
2559 |
- |
2586 |
= |
-27 |
* |
(619 |
/ |
4446) |
= |
-3.75910929 |
11 |
80310 |
2555 |
- |
2628 |
= |
-73 |
* |
(654 |
/ |
4446) |
= |
-10.7381916 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for South San Francisco Unified
|
-27 |
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 |
80791 |
2442 |
- |
2436 |
= |
6 |
* |
(647 |
/ |
4372) |
= |
0.88792315 |
4 |
80792 |
2485 |
- |
2485 |
= |
0 |
* |
(594 |
/ |
4372) |
= |
0.0 |
5 |
80793 |
2511 |
- |
2528 |
= |
-17 |
* |
(616 |
/ |
4372) |
= |
-2.39524244 |
6 |
80794 |
2520 |
- |
2552 |
= |
-32 |
* |
(610 |
/ |
4372) |
= |
-4.46477584 |
7 |
80795 |
2532 |
- |
2567 |
= |
-35 |
* |
(671 |
/ |
4372) |
= |
-5.37168342 |
8 |
80796 |
2546 |
- |
2586 |
= |
-40 |
* |
(609 |
/ |
4372) |
= |
-5.57182064 |
11 |
80797 |
2565 |
- |
2628 |
= |
-63 |
* |
(625 |
/ |
4372) |
= |
-9.00617565 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for South San Francisco Unified
|
-26 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-25
|
-17
|
-23
|
-27
|
-26
|
-118.0 |
-23.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -14.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -32.6
For the lines, you have the data necessary to plot the chart.