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 |
27094 |
2486 |
- |
2436 |
= |
50 |
* |
(2686 |
/ |
17714) |
= |
7.58157385 |
4 |
27095 |
2533 |
- |
2485 |
= |
48 |
* |
(2725 |
/ |
17714) |
= |
7.38399005 |
5 |
27098 |
2571 |
- |
2528 |
= |
43 |
* |
(2705 |
/ |
17714) |
= |
6.56627523 |
6 |
27099 |
2597 |
- |
2552 |
= |
45 |
* |
(2557 |
/ |
17714) |
= |
6.49570959 |
7 |
27102 |
2616 |
- |
2567 |
= |
49 |
* |
(2492 |
/ |
17714) |
= |
6.89330471 |
8 |
27103 |
2640 |
- |
2586 |
= |
54 |
* |
(2322 |
/ |
17714) |
= |
7.07846899 |
11 |
27106 |
2655 |
- |
2628 |
= |
27 |
* |
(2227 |
/ |
17714) |
= |
3.39443376 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Fremont Unified
|
45 |
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 |
724 |
2488 |
- |
2436 |
= |
52 |
* |
(2691 |
/ |
18129) |
= |
7.71868276 |
4 |
725 |
2537 |
- |
2485 |
= |
52 |
* |
(2716 |
/ |
18129) |
= |
7.79039108 |
5 |
727 |
2572 |
- |
2528 |
= |
44 |
* |
(2736 |
/ |
18129) |
= |
6.64041039 |
6 |
730 |
2609 |
- |
2552 |
= |
57 |
* |
(2711 |
/ |
18129) |
= |
8.52374643 |
7 |
731 |
2626 |
- |
2567 |
= |
59 |
* |
(2516 |
/ |
18129) |
= |
8.18820674 |
8 |
734 |
2650 |
- |
2586 |
= |
64 |
* |
(2482 |
/ |
18129) |
= |
8.76209382 |
11 |
736 |
2659 |
- |
2628 |
= |
31 |
* |
(2277 |
/ |
18129) |
= |
3.89359588 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Fremont Unified
|
52 |
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 |
766 |
2488 |
- |
2436 |
= |
52 |
* |
(2669 |
/ |
18511) |
= |
7.49759598 |
4 |
768 |
2533 |
- |
2485 |
= |
48 |
* |
(2684 |
/ |
18511) |
= |
6.95975362 |
5 |
769 |
2578 |
- |
2528 |
= |
50 |
* |
(2679 |
/ |
18511) |
= |
7.2362379 |
6 |
772 |
2610 |
- |
2552 |
= |
58 |
* |
(2742 |
/ |
18511) |
= |
8.59143212 |
7 |
773 |
2632 |
- |
2567 |
= |
65 |
* |
(2662 |
/ |
18511) |
= |
9.34741503 |
8 |
776 |
2649 |
- |
2586 |
= |
63 |
* |
(2527 |
/ |
18511) |
= |
8.60034571 |
11 |
777 |
2675 |
- |
2628 |
= |
47 |
* |
(2548 |
/ |
18511) |
= |
6.4694506 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Fremont Unified
|
55 |
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 |
789 |
2497 |
- |
2436 |
= |
61 |
* |
(2707 |
/ |
18437) |
= |
8.95628352 |
4 |
791 |
2539 |
- |
2485 |
= |
54 |
* |
(2664 |
/ |
18437) |
= |
7.80257092 |
5 |
793 |
2576 |
- |
2528 |
= |
48 |
* |
(2675 |
/ |
18437) |
= |
6.96425664 |
6 |
795 |
2613 |
- |
2552 |
= |
61 |
* |
(2655 |
/ |
18437) |
= |
8.78423821 |
7 |
797 |
2632 |
- |
2567 |
= |
65 |
* |
(2712 |
/ |
18437) |
= |
9.56120841 |
8 |
799 |
2659 |
- |
2586 |
= |
73 |
* |
(2647 |
/ |
18437) |
= |
10.48060964 |
11 |
801 |
2678 |
- |
2628 |
= |
50 |
* |
(2377 |
/ |
18437) |
= |
6.4462765 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Fremont Unified
|
59 |
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 |
819 |
2504 |
- |
2436 |
= |
68 |
* |
(2670 |
/ |
18307) |
= |
9.91751787 |
4 |
820 |
2548 |
- |
2485 |
= |
63 |
* |
(2674 |
/ |
18307) |
= |
9.2020538 |
5 |
821 |
2579 |
- |
2528 |
= |
51 |
* |
(2619 |
/ |
18307) |
= |
7.29606158 |
6 |
822 |
2612 |
- |
2552 |
= |
60 |
* |
(2619 |
/ |
18307) |
= |
8.58360186 |
7 |
823 |
2637 |
- |
2567 |
= |
70 |
* |
(2596 |
/ |
18307) |
= |
9.92625767 |
8 |
824 |
2657 |
- |
2586 |
= |
71 |
* |
(2674 |
/ |
18307) |
= |
10.37056857 |
11 |
825 |
2676 |
- |
2628 |
= |
48 |
* |
(2455 |
/ |
18307) |
= |
6.43688203 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Fremont Unified
|
62 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
45
|
52
|
55
|
59
|
62
|
273.0 |
54.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 72.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 36.6
For the lines, you have the data necessary to plot the chart.