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 |
1532127 |
2394 |
- |
2436 |
= |
-42 |
* |
(4283 |
/ |
27427) |
= |
-6.5587195 |
4 |
1532128 |
2434 |
- |
2485 |
= |
-51 |
* |
(4178 |
/ |
27427) |
= |
-7.76891384 |
5 |
1532131 |
2454 |
- |
2528 |
= |
-74 |
* |
(4038 |
/ |
27427) |
= |
-10.89481162 |
6 |
1532132 |
2458 |
- |
2552 |
= |
-94 |
* |
(3874 |
/ |
27427) |
= |
-13.27728145 |
7 |
1532135 |
2478 |
- |
2567 |
= |
-89 |
* |
(3846 |
/ |
27427) |
= |
-12.48018369 |
8 |
1532136 |
2509 |
- |
2586 |
= |
-77 |
* |
(3851 |
/ |
27427) |
= |
-10.81149955 |
11 |
1532139 |
2529 |
- |
2628 |
= |
-99 |
* |
(3357 |
/ |
27427) |
= |
-12.11736606 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Santa Ana Unified
|
-74 |
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 |
47967 |
2400 |
- |
2436 |
= |
-36 |
* |
(4025 |
/ |
27051) |
= |
-5.35654872 |
4 |
47968 |
2441 |
- |
2485 |
= |
-44 |
* |
(4183 |
/ |
27051) |
= |
-6.80388892 |
5 |
47971 |
2459 |
- |
2528 |
= |
-69 |
* |
(4136 |
/ |
27051) |
= |
-10.54985022 |
6 |
47973 |
2463 |
- |
2552 |
= |
-89 |
* |
(3874 |
/ |
27051) |
= |
-12.74577642 |
7 |
47975 |
2483 |
- |
2567 |
= |
-84 |
* |
(3746 |
/ |
27051) |
= |
-11.63225011 |
8 |
47977 |
2507 |
- |
2586 |
= |
-79 |
* |
(3768 |
/ |
27051) |
= |
-11.00410331 |
11 |
47979 |
2532 |
- |
2628 |
= |
-96 |
* |
(3319 |
/ |
27051) |
= |
-11.77864032 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Santa Ana Unified
|
-70 |
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 |
49275 |
2403 |
- |
2436 |
= |
-33 |
* |
(3989 |
/ |
26690) |
= |
-4.93207193 |
4 |
49277 |
2440 |
- |
2485 |
= |
-45 |
* |
(3899 |
/ |
26690) |
= |
-6.57381038 |
5 |
49278 |
2463 |
- |
2528 |
= |
-65 |
* |
(4045 |
/ |
26690) |
= |
-9.85106779 |
6 |
49280 |
2458 |
- |
2552 |
= |
-94 |
* |
(3904 |
/ |
26690) |
= |
-13.74956903 |
7 |
49282 |
2477 |
- |
2567 |
= |
-90 |
* |
(3775 |
/ |
26690) |
= |
-12.72948669 |
8 |
49285 |
2498 |
- |
2586 |
= |
-88 |
* |
(3672 |
/ |
26690) |
= |
-12.1070063 |
11 |
49287 |
2523 |
- |
2628 |
= |
-105 |
* |
(3406 |
/ |
26690) |
= |
-13.39940049 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Santa Ana Unified
|
-73 |
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 |
49288 |
2402 |
- |
2436 |
= |
-34 |
* |
(3457 |
/ |
25982) |
= |
-4.52382417 |
4 |
49291 |
2450 |
- |
2485 |
= |
-35 |
* |
(3854 |
/ |
25982) |
= |
-5.19167114 |
5 |
49292 |
2469 |
- |
2528 |
= |
-59 |
* |
(3797 |
/ |
25982) |
= |
-8.62223847 |
6 |
49295 |
2456 |
- |
2552 |
= |
-96 |
* |
(3877 |
/ |
25982) |
= |
-14.32499414 |
7 |
49296 |
2481 |
- |
2567 |
= |
-86 |
* |
(3822 |
/ |
25982) |
= |
-12.65075815 |
8 |
49299 |
2495 |
- |
2586 |
= |
-91 |
* |
(3725 |
/ |
25982) |
= |
-13.04653214 |
11 |
49300 |
2521 |
- |
2628 |
= |
-107 |
* |
(3450 |
/ |
25982) |
= |
-14.20791315 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Santa Ana Unified
|
-73 |
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 |
49491 |
2408 |
- |
2436 |
= |
-28 |
* |
(3257 |
/ |
24738) |
= |
-3.68647423 |
4 |
49492 |
2450 |
- |
2485 |
= |
-35 |
* |
(3373 |
/ |
24738) |
= |
-4.77221276 |
5 |
49493 |
2475 |
- |
2528 |
= |
-53 |
* |
(3705 |
/ |
24738) |
= |
-7.93778801 |
6 |
49494 |
2465 |
- |
2552 |
= |
-87 |
* |
(3578 |
/ |
24738) |
= |
-12.58331312 |
7 |
49495 |
2482 |
- |
2567 |
= |
-85 |
* |
(3816 |
/ |
24738) |
= |
-13.11181177 |
8 |
49496 |
2493 |
- |
2586 |
= |
-93 |
* |
(3731 |
/ |
24738) |
= |
-14.02631571 |
11 |
49497 |
2524 |
- |
2628 |
= |
-104 |
* |
(3278 |
/ |
24738) |
= |
-13.78090386 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Santa Ana Unified
|
-70 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-74
|
-70
|
-73
|
-73
|
-70
|
-360.0 |
-72.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -69.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -75.0
For the lines, you have the data necessary to plot the chart.