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 |
2038591 |
2381 |
- |
2436 |
= |
-55 |
* |
(4266 |
/ |
25727) |
= |
-9.11999066 |
4 |
2038594 |
2417 |
- |
2485 |
= |
-68 |
* |
(4041 |
/ |
25727) |
= |
-10.68091885 |
5 |
2038595 |
2438 |
- |
2528 |
= |
-90 |
* |
(3872 |
/ |
25727) |
= |
-13.54530258 |
6 |
2038598 |
2464 |
- |
2552 |
= |
-88 |
* |
(3845 |
/ |
25727) |
= |
-13.15194153 |
7 |
2038599 |
2474 |
- |
2567 |
= |
-93 |
* |
(3447 |
/ |
25727) |
= |
-12.46048894 |
8 |
2038602 |
2496 |
- |
2586 |
= |
-90 |
* |
(3425 |
/ |
25727) |
= |
-11.98157571 |
11 |
2038603 |
2512 |
- |
2628 |
= |
-116 |
* |
(2831 |
/ |
25727) |
= |
-12.76464406 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Bernardino City Unified
|
-84 |
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 |
62619 |
2392 |
- |
2436 |
= |
-44 |
* |
(4147 |
/ |
26435) |
= |
-6.90251558 |
4 |
62621 |
2425 |
- |
2485 |
= |
-60 |
* |
(4293 |
/ |
26435) |
= |
-9.7439001 |
5 |
62622 |
2442 |
- |
2528 |
= |
-86 |
* |
(4010 |
/ |
26435) |
= |
-13.04558347 |
6 |
62625 |
2468 |
- |
2552 |
= |
-84 |
* |
(3814 |
/ |
26435) |
= |
-12.11938711 |
7 |
62626 |
2490 |
- |
2567 |
= |
-77 |
* |
(3596 |
/ |
26435) |
= |
-10.47444675 |
8 |
62628 |
2507 |
- |
2586 |
= |
-79 |
* |
(3429 |
/ |
26435) |
= |
-10.24743705 |
11 |
62630 |
2514 |
- |
2628 |
= |
-114 |
* |
(3146 |
/ |
26435) |
= |
-13.56701335 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Bernardino City Unified
|
-76 |
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 |
64413 |
2399 |
- |
2436 |
= |
-37 |
* |
(3911 |
/ |
25888) |
= |
-5.58973267 |
4 |
64415 |
2430 |
- |
2485 |
= |
-55 |
* |
(4023 |
/ |
25888) |
= |
-8.54701018 |
5 |
64416 |
2446 |
- |
2528 |
= |
-82 |
* |
(4179 |
/ |
25888) |
= |
-13.23694373 |
6 |
64418 |
2481 |
- |
2552 |
= |
-71 |
* |
(3792 |
/ |
25888) |
= |
-10.39987637 |
7 |
64420 |
2490 |
- |
2567 |
= |
-77 |
* |
(3476 |
/ |
25888) |
= |
-10.33884421 |
8 |
64423 |
2512 |
- |
2586 |
= |
-74 |
* |
(3453 |
/ |
25888) |
= |
-9.87028739 |
11 |
64424 |
2507 |
- |
2628 |
= |
-121 |
* |
(3054 |
/ |
25888) |
= |
-14.27433552 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Bernardino City Unified
|
-72 |
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 |
64520 |
2410 |
- |
2436 |
= |
-26 |
* |
(3818 |
/ |
26092) |
= |
-3.80453778 |
4 |
64521 |
2439 |
- |
2485 |
= |
-46 |
* |
(3926 |
/ |
26092) |
= |
-6.9215085 |
5 |
64524 |
2455 |
- |
2528 |
= |
-73 |
* |
(4067 |
/ |
26092) |
= |
-11.37862176 |
6 |
64525 |
2481 |
- |
2552 |
= |
-71 |
* |
(4127 |
/ |
26092) |
= |
-11.23014711 |
7 |
64528 |
2493 |
- |
2567 |
= |
-74 |
* |
(3620 |
/ |
26092) |
= |
-10.26674838 |
8 |
64529 |
2512 |
- |
2586 |
= |
-74 |
* |
(3393 |
/ |
26092) |
= |
-9.62294949 |
11 |
64532 |
2512 |
- |
2628 |
= |
-116 |
* |
(3141 |
/ |
26092) |
= |
-13.96428022 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Bernardino City Unified
|
-67 |
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 |
64891 |
2412 |
- |
2436 |
= |
-24 |
* |
(3999 |
/ |
25947) |
= |
-3.69892471 |
4 |
64892 |
2445 |
- |
2485 |
= |
-40 |
* |
(3730 |
/ |
25947) |
= |
-5.75018304 |
5 |
64893 |
2463 |
- |
2528 |
= |
-65 |
* |
(3873 |
/ |
25947) |
= |
-9.70227772 |
6 |
64894 |
2487 |
- |
2552 |
= |
-65 |
* |
(3882 |
/ |
25947) |
= |
-9.72482362 |
7 |
64895 |
2495 |
- |
2567 |
= |
-72 |
* |
(3881 |
/ |
25947) |
= |
-10.76933743 |
8 |
64896 |
2507 |
- |
2586 |
= |
-79 |
* |
(3501 |
/ |
25947) |
= |
-10.65938255 |
11 |
64897 |
2510 |
- |
2628 |
= |
-118 |
* |
(3081 |
/ |
25947) |
= |
-14.01156202 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Bernardino City Unified
|
-64 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-84
|
-76
|
-72
|
-67
|
-64
|
-363.0 |
-72.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -51.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -93.6
For the lines, you have the data necessary to plot the chart.