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 |
1465451 |
2421 |
- |
2436 |
= |
-15 |
* |
(3438 |
/ |
24330) |
= |
-2.11960542 |
4 |
1465452 |
2456 |
- |
2485 |
= |
-29 |
* |
(3500 |
/ |
24330) |
= |
-4.17180434 |
5 |
1465455 |
2486 |
- |
2528 |
= |
-42 |
* |
(3424 |
/ |
24330) |
= |
-5.91072749 |
6 |
1465456 |
2525 |
- |
2552 |
= |
-27 |
* |
(3667 |
/ |
24330) |
= |
-4.06942045 |
7 |
1465459 |
2531 |
- |
2567 |
= |
-36 |
* |
(3401 |
/ |
24330) |
= |
-5.03230579 |
8 |
1465460 |
2556 |
- |
2586 |
= |
-30 |
* |
(3564 |
/ |
24330) |
= |
-4.39457457 |
11 |
1465463 |
2582 |
- |
2628 |
= |
-46 |
* |
(3336 |
/ |
24330) |
= |
-6.30727496 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Garden Grove Unified
|
-32 |
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 |
46022 |
2439 |
- |
2436 |
= |
3 |
* |
(3278 |
/ |
24156) |
= |
0.40710383 |
4 |
46025 |
2474 |
- |
2485 |
= |
-11 |
* |
(3453 |
/ |
24156) |
= |
-1.57240436 |
5 |
46027 |
2495 |
- |
2528 |
= |
-33 |
* |
(3532 |
/ |
24156) |
= |
-4.82513658 |
6 |
46028 |
2541 |
- |
2552 |
= |
-11 |
* |
(3454 |
/ |
24156) |
= |
-1.57285974 |
7 |
46030 |
2545 |
- |
2567 |
= |
-22 |
* |
(3584 |
/ |
24156) |
= |
-3.26411657 |
8 |
46032 |
2575 |
- |
2586 |
= |
-11 |
* |
(3416 |
/ |
24156) |
= |
-1.55555555 |
11 |
46035 |
2588 |
- |
2628 |
= |
-40 |
* |
(3439 |
/ |
24156) |
= |
-5.6946514 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Garden Grove Unified
|
-18 |
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 |
47252 |
2443 |
- |
2436 |
= |
7 |
* |
(3165 |
/ |
23784) |
= |
0.93150857 |
4 |
47255 |
2479 |
- |
2485 |
= |
-6 |
* |
(3260 |
/ |
23784) |
= |
-0.82240161 |
5 |
47257 |
2499 |
- |
2528 |
= |
-29 |
* |
(3416 |
/ |
23784) |
= |
-4.16515304 |
6 |
47258 |
2536 |
- |
2552 |
= |
-16 |
* |
(3489 |
/ |
23784) |
= |
-2.34712411 |
7 |
47261 |
2551 |
- |
2567 |
= |
-16 |
* |
(3321 |
/ |
23784) |
= |
-2.23410696 |
8 |
47263 |
2579 |
- |
2586 |
= |
-7 |
* |
(3558 |
/ |
23784) |
= |
-1.04717457 |
11 |
47265 |
2595 |
- |
2628 |
= |
-33 |
* |
(3575 |
/ |
23784) |
= |
-4.96026739 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Garden Grove Unified
|
-15 |
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 |
47262 |
2451 |
- |
2436 |
= |
15 |
* |
(2918 |
/ |
22765) |
= |
1.92268833 |
4 |
47265 |
2492 |
- |
2485 |
= |
7 |
* |
(3166 |
/ |
22765) |
= |
0.97351197 |
5 |
47266 |
2513 |
- |
2528 |
= |
-15 |
* |
(3233 |
/ |
22765) |
= |
-2.1302438 |
6 |
47269 |
2545 |
- |
2552 |
= |
-7 |
* |
(3390 |
/ |
22765) |
= |
-1.04238963 |
7 |
47270 |
2553 |
- |
2567 |
= |
-14 |
* |
(3409 |
/ |
22765) |
= |
-2.09646387 |
8 |
47273 |
2586 |
- |
2586 |
= |
0 |
* |
(3293 |
/ |
22765) |
= |
0.0 |
11 |
47274 |
2599 |
- |
2628 |
= |
-29 |
* |
(3356 |
/ |
22765) |
= |
-4.27515921 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Garden Grove Unified
|
-7 |
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 |
47443 |
2454 |
- |
2436 |
= |
18 |
* |
(2952 |
/ |
22377) |
= |
2.37458104 |
4 |
47444 |
2499 |
- |
2485 |
= |
14 |
* |
(2969 |
/ |
22377) |
= |
1.85753228 |
5 |
47445 |
2522 |
- |
2528 |
= |
-6 |
* |
(3151 |
/ |
22377) |
= |
-0.84488537 |
6 |
47446 |
2553 |
- |
2552 |
= |
1 |
* |
(3274 |
/ |
22377) |
= |
0.14631094 |
7 |
47447 |
2556 |
- |
2567 |
= |
-11 |
* |
(3413 |
/ |
22377) |
= |
-1.67774947 |
8 |
47448 |
2581 |
- |
2586 |
= |
-5 |
* |
(3415 |
/ |
22377) |
= |
-0.76306029 |
11 |
47449 |
2603 |
- |
2628 |
= |
-25 |
* |
(3203 |
/ |
22377) |
= |
-3.57845108 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Garden Grove Unified
|
-2 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-32
|
-18
|
-15
|
-7
|
-2
|
-74.0 |
-14.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 18.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -47.8
For the lines, you have the data necessary to plot the chart.