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 |
247087 |
2489 |
- |
2436 |
= |
53 |
* |
(2491 |
/ |
16995) |
= |
7.76834361 |
4 |
247088 |
2531 |
- |
2485 |
= |
46 |
* |
(2469 |
/ |
16995) |
= |
6.68278901 |
5 |
247091 |
2563 |
- |
2528 |
= |
35 |
* |
(2513 |
/ |
16995) |
= |
5.17534567 |
6 |
247092 |
2603 |
- |
2552 |
= |
51 |
* |
(2616 |
/ |
16995) |
= |
7.85030888 |
7 |
247095 |
2615 |
- |
2567 |
= |
48 |
* |
(2548 |
/ |
16995) |
= |
7.1964695 |
8 |
247096 |
2636 |
- |
2586 |
= |
50 |
* |
(2504 |
/ |
16995) |
= |
7.3668726 |
11 |
247099 |
2681 |
- |
2628 |
= |
53 |
* |
(1854 |
/ |
16995) |
= |
5.78181818 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Ramon Valley Unified
|
48 |
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 |
7233 |
2498 |
- |
2436 |
= |
62 |
* |
(2322 |
/ |
17268) |
= |
8.33703956 |
4 |
7235 |
2537 |
- |
2485 |
= |
52 |
* |
(2527 |
/ |
17268) |
= |
7.6096826 |
5 |
7238 |
2570 |
- |
2528 |
= |
42 |
* |
(2519 |
/ |
17268) |
= |
6.12682417 |
6 |
7240 |
2610 |
- |
2552 |
= |
58 |
* |
(2559 |
/ |
17268) |
= |
8.59520496 |
7 |
7242 |
2625 |
- |
2567 |
= |
58 |
* |
(2629 |
/ |
17268) |
= |
8.83032194 |
8 |
7243 |
2651 |
- |
2586 |
= |
65 |
* |
(2520 |
/ |
17268) |
= |
9.48575394 |
11 |
7246 |
2696 |
- |
2628 |
= |
68 |
* |
(2192 |
/ |
17268) |
= |
8.63192027 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Ramon Valley Unified
|
58 |
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 |
7446 |
2500 |
- |
2436 |
= |
64 |
* |
(2286 |
/ |
17558) |
= |
8.3326119 |
4 |
7448 |
2542 |
- |
2485 |
= |
57 |
* |
(2377 |
/ |
17558) |
= |
7.71665333 |
5 |
7450 |
2576 |
- |
2528 |
= |
48 |
* |
(2605 |
/ |
17558) |
= |
7.12154002 |
6 |
7451 |
2610 |
- |
2552 |
= |
58 |
* |
(2549 |
/ |
17558) |
= |
8.4202073 |
7 |
7454 |
2630 |
- |
2567 |
= |
63 |
* |
(2616 |
/ |
17558) |
= |
9.38649046 |
8 |
7456 |
2659 |
- |
2586 |
= |
73 |
* |
(2636 |
/ |
17558) |
= |
10.95956256 |
11 |
7457 |
2683 |
- |
2628 |
= |
55 |
* |
(2489 |
/ |
17558) |
= |
7.79673081 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Ramon Valley Unified
|
60 |
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 |
7463 |
2503 |
- |
2436 |
= |
67 |
* |
(2204 |
/ |
17333) |
= |
8.5194715 |
4 |
7465 |
2544 |
- |
2485 |
= |
59 |
* |
(2344 |
/ |
17333) |
= |
7.97876877 |
5 |
7467 |
2582 |
- |
2528 |
= |
54 |
* |
(2416 |
/ |
17333) |
= |
7.52691393 |
6 |
7469 |
2607 |
- |
2552 |
= |
55 |
* |
(2639 |
/ |
17333) |
= |
8.37391099 |
7 |
7471 |
2630 |
- |
2567 |
= |
63 |
* |
(2593 |
/ |
17333) |
= |
9.42473889 |
8 |
7473 |
2656 |
- |
2586 |
= |
70 |
* |
(2658 |
/ |
17333) |
= |
10.73443714 |
11 |
7475 |
2686 |
- |
2628 |
= |
58 |
* |
(2479 |
/ |
17333) |
= |
8.2952749 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Ramon Valley Unified
|
61 |
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 |
7521 |
2502 |
- |
2436 |
= |
66 |
* |
(2251 |
/ |
17174) |
= |
8.65063465 |
4 |
7522 |
2545 |
- |
2485 |
= |
60 |
* |
(2238 |
/ |
17174) |
= |
7.81879584 |
5 |
7523 |
2587 |
- |
2528 |
= |
59 |
* |
(2390 |
/ |
17174) |
= |
8.21066727 |
6 |
7524 |
2610 |
- |
2552 |
= |
58 |
* |
(2487 |
/ |
17174) |
= |
8.39909165 |
7 |
7525 |
2629 |
- |
2567 |
= |
62 |
* |
(2682 |
/ |
17174) |
= |
9.68231041 |
8 |
7526 |
2655 |
- |
2586 |
= |
69 |
* |
(2599 |
/ |
17174) |
= |
10.44200529 |
11 |
7527 |
2689 |
- |
2628 |
= |
61 |
* |
(2527 |
/ |
17174) |
= |
8.97560265 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Ramon Valley Unified
|
62 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
48
|
58
|
60
|
61
|
62
|
289.0 |
57.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 72.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 42.8
For the lines, you have the data necessary to plot the chart.