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 |
1573256 |
2486 |
- |
2436 |
= |
50 |
* |
(2569 |
/ |
16999) |
= |
7.5563268 |
4 |
1573257 |
2533 |
- |
2485 |
= |
48 |
* |
(2403 |
/ |
16999) |
= |
6.78534029 |
5 |
1573260 |
2565 |
- |
2528 |
= |
37 |
* |
(2554 |
/ |
16999) |
= |
5.55903288 |
6 |
1573261 |
2607 |
- |
2552 |
= |
55 |
* |
(2484 |
/ |
16999) |
= |
8.03694331 |
7 |
1573264 |
2633 |
- |
2567 |
= |
66 |
* |
(2472 |
/ |
16999) |
= |
9.59774099 |
8 |
1573265 |
2662 |
- |
2586 |
= |
76 |
* |
(2365 |
/ |
16999) |
= |
10.57356308 |
11 |
1573268 |
2670 |
- |
2628 |
= |
42 |
* |
(2152 |
/ |
16999) |
= |
5.31701864 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Irvine Unified
|
53 |
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 |
49232 |
2488 |
- |
2436 |
= |
52 |
* |
(2532 |
/ |
17586) |
= |
7.48686453 |
4 |
49234 |
2537 |
- |
2485 |
= |
52 |
* |
(2641 |
/ |
17586) |
= |
7.80916635 |
5 |
49237 |
2565 |
- |
2528 |
= |
37 |
* |
(2496 |
/ |
17586) |
= |
5.25145 |
6 |
49238 |
2610 |
- |
2552 |
= |
58 |
* |
(2629 |
/ |
17586) |
= |
8.67064707 |
7 |
49241 |
2637 |
- |
2567 |
= |
70 |
* |
(2529 |
/ |
17586) |
= |
10.06653018 |
8 |
49242 |
2669 |
- |
2586 |
= |
83 |
* |
(2540 |
/ |
17586) |
= |
11.98794489 |
11 |
49245 |
2686 |
- |
2628 |
= |
58 |
* |
(2219 |
/ |
17586) |
= |
7.31843507 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Irvine Unified
|
59 |
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 |
50572 |
2488 |
- |
2436 |
= |
52 |
* |
(2583 |
/ |
18180) |
= |
7.38811876 |
4 |
50574 |
2533 |
- |
2485 |
= |
48 |
* |
(2640 |
/ |
18180) |
= |
6.97029701 |
5 |
50577 |
2566 |
- |
2528 |
= |
38 |
* |
(2715 |
/ |
18180) |
= |
5.67491745 |
6 |
50578 |
2607 |
- |
2552 |
= |
55 |
* |
(2589 |
/ |
18180) |
= |
7.8325082 |
7 |
50580 |
2634 |
- |
2567 |
= |
67 |
* |
(2648 |
/ |
18180) |
= |
9.75885586 |
8 |
50583 |
2668 |
- |
2586 |
= |
82 |
* |
(2581 |
/ |
18180) |
= |
11.64147407 |
11 |
50584 |
2685 |
- |
2628 |
= |
57 |
* |
(2424 |
/ |
18180) |
= |
7.59999998 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Irvine Unified
|
57 |
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 |
50594 |
2487 |
- |
2436 |
= |
51 |
* |
(2597 |
/ |
18557) |
= |
7.13730664 |
4 |
50596 |
2533 |
- |
2485 |
= |
48 |
* |
(2671 |
/ |
18557) |
= |
6.90887534 |
5 |
50598 |
2561 |
- |
2528 |
= |
33 |
* |
(2736 |
/ |
18557) |
= |
4.86544159 |
6 |
50600 |
2607 |
- |
2552 |
= |
55 |
* |
(2814 |
/ |
18557) |
= |
8.34024895 |
7 |
50602 |
2633 |
- |
2567 |
= |
66 |
* |
(2644 |
/ |
18557) |
= |
9.40367512 |
8 |
50604 |
2666 |
- |
2586 |
= |
80 |
* |
(2714 |
/ |
18557) |
= |
11.70016704 |
11 |
50606 |
2677 |
- |
2628 |
= |
49 |
* |
(2381 |
/ |
18557) |
= |
6.28706147 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Irvine Unified
|
55 |
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 |
50799 |
2487 |
- |
2436 |
= |
51 |
* |
(2681 |
/ |
19038) |
= |
7.18200437 |
4 |
50800 |
2534 |
- |
2485 |
= |
49 |
* |
(2727 |
/ |
19038) |
= |
7.01875196 |
5 |
50801 |
2562 |
- |
2528 |
= |
34 |
* |
(2737 |
/ |
19038) |
= |
4.88801343 |
6 |
50802 |
2604 |
- |
2552 |
= |
52 |
* |
(2822 |
/ |
19038) |
= |
7.70795251 |
7 |
50803 |
2641 |
- |
2567 |
= |
74 |
* |
(2847 |
/ |
19038) |
= |
11.06618341 |
8 |
50804 |
2664 |
- |
2586 |
= |
78 |
* |
(2698 |
/ |
19038) |
= |
11.05389215 |
11 |
50805 |
2685 |
- |
2628 |
= |
57 |
* |
(2526 |
/ |
19038) |
= |
7.56287423 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Irvine Unified
|
56 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
53
|
59
|
57
|
55
|
56
|
280.0 |
56.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 62.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 50.0
For the lines, you have the data necessary to plot the chart.