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 |
1115634 |
2489 |
- |
2436 |
= |
53 |
* |
(330 |
/ |
2414) |
= |
7.2452361 |
4 |
1115636 |
2545 |
- |
2485 |
= |
60 |
* |
(354 |
/ |
2414) |
= |
8.79867438 |
5 |
1115637 |
2590 |
- |
2528 |
= |
62 |
* |
(342 |
/ |
2414) |
= |
8.78376134 |
6 |
1115639 |
2612 |
- |
2552 |
= |
60 |
* |
(385 |
/ |
2414) |
= |
9.56917974 |
7 |
1115642 |
2615 |
- |
2567 |
= |
48 |
* |
(326 |
/ |
2414) |
= |
6.48218722 |
8 |
1115644 |
2667 |
- |
2586 |
= |
81 |
* |
(379 |
/ |
2414) |
= |
12.71706707 |
11 |
1115645 |
2644 |
- |
2628 |
= |
16 |
* |
(298 |
/ |
2414) |
= |
1.97514498 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for South Pasadena Unified
|
56 |
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 |
34852 |
2498 |
- |
2436 |
= |
62 |
* |
(344 |
/ |
2433) |
= |
8.76613232 |
4 |
34854 |
2542 |
- |
2485 |
= |
57 |
* |
(333 |
/ |
2433) |
= |
7.80147965 |
5 |
34855 |
2592 |
- |
2528 |
= |
64 |
* |
(367 |
/ |
2433) |
= |
9.65392518 |
6 |
34857 |
2631 |
- |
2552 |
= |
79 |
* |
(354 |
/ |
2433) |
= |
11.49445126 |
7 |
34859 |
2630 |
- |
2567 |
= |
63 |
* |
(378 |
/ |
2433) |
= |
9.78791612 |
8 |
34862 |
2674 |
- |
2586 |
= |
88 |
* |
(325 |
/ |
2433) |
= |
11.7550349 |
11 |
34864 |
2680 |
- |
2628 |
= |
52 |
* |
(332 |
/ |
2433) |
= |
7.0957665 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for South Pasadena Unified
|
66 |
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 |
35497 |
2496 |
- |
2436 |
= |
60 |
* |
(389 |
/ |
2600) |
= |
8.97692304 |
4 |
35500 |
2547 |
- |
2485 |
= |
62 |
* |
(354 |
/ |
2600) |
= |
8.44153845 |
5 |
35501 |
2597 |
- |
2528 |
= |
69 |
* |
(345 |
/ |
2600) |
= |
9.15576918 |
6 |
35504 |
2632 |
- |
2552 |
= |
80 |
* |
(377 |
/ |
2600) |
= |
11.6 |
7 |
35506 |
2637 |
- |
2567 |
= |
70 |
* |
(370 |
/ |
2600) |
= |
9.96153844 |
8 |
35508 |
2679 |
- |
2586 |
= |
93 |
* |
(380 |
/ |
2600) |
= |
13.59230768 |
11 |
35509 |
2682 |
- |
2628 |
= |
54 |
* |
(385 |
/ |
2600) |
= |
7.99615384 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for South Pasadena Unified
|
70 |
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 |
35508 |
2508 |
- |
2436 |
= |
72 |
* |
(344 |
/ |
2542) |
= |
9.74350901 |
4 |
35510 |
2551 |
- |
2485 |
= |
66 |
* |
(388 |
/ |
2542) |
= |
10.07395745 |
5 |
35512 |
2591 |
- |
2528 |
= |
63 |
* |
(365 |
/ |
2542) |
= |
9.04602674 |
6 |
35514 |
2634 |
- |
2552 |
= |
82 |
* |
(357 |
/ |
2542) |
= |
11.51612895 |
7 |
35516 |
2641 |
- |
2567 |
= |
74 |
* |
(385 |
/ |
2542) |
= |
11.2077104 |
8 |
35518 |
2668 |
- |
2586 |
= |
82 |
* |
(340 |
/ |
2542) |
= |
10.9677419 |
11 |
35520 |
2684 |
- |
2628 |
= |
56 |
* |
(363 |
/ |
2542) |
= |
7.99685286 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for South Pasadena Unified
|
71 |
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 |
35678 |
2512 |
- |
2436 |
= |
76 |
* |
(359 |
/ |
2574) |
= |
10.59984456 |
4 |
35679 |
2548 |
- |
2485 |
= |
63 |
* |
(357 |
/ |
2574) |
= |
8.73776219 |
5 |
35680 |
2597 |
- |
2528 |
= |
69 |
* |
(396 |
/ |
2574) |
= |
10.61538456 |
6 |
35681 |
2623 |
- |
2552 |
= |
71 |
* |
(391 |
/ |
2574) |
= |
10.78515922 |
7 |
35682 |
2647 |
- |
2567 |
= |
80 |
* |
(372 |
/ |
2574) |
= |
11.56177152 |
8 |
35683 |
2679 |
- |
2586 |
= |
93 |
* |
(381 |
/ |
2574) |
= |
13.76573426 |
11 |
35684 |
2684 |
- |
2628 |
= |
56 |
* |
(318 |
/ |
2574) |
= |
6.91841489 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for South Pasadena Unified
|
73 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
56
|
66
|
70
|
71
|
73
|
336.0 |
67.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 85.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 49.2
For the lines, you have the data necessary to plot the chart.