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 |
2697989 |
2501 |
- |
2436 |
= |
65 |
* |
(952 |
/ |
6215) |
= |
9.95655668 |
4 |
2697992 |
2561 |
- |
2485 |
= |
76 |
* |
(1018 |
/ |
6215) |
= |
12.44859206 |
5 |
2697993 |
2592 |
- |
2528 |
= |
64 |
* |
(1025 |
/ |
6215) |
= |
10.55510861 |
6 |
2697996 |
2623 |
- |
2552 |
= |
71 |
* |
(993 |
/ |
6215) |
= |
11.3440064 |
7 |
2697997 |
2646 |
- |
2567 |
= |
79 |
* |
(936 |
/ |
6215) |
= |
11.89766686 |
8 |
2698000 |
2691 |
- |
2586 |
= |
105 |
* |
(940 |
/ |
6215) |
= |
15.88093322 |
11 |
2698001 |
2730 |
- |
2628 |
= |
102 |
* |
(351 |
/ |
6215) |
= |
5.76057923 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Palo Alto Unified
|
78 |
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 |
82167 |
2504 |
- |
2436 |
= |
68 |
* |
(897 |
/ |
6087) |
= |
10.02069984 |
4 |
82168 |
2560 |
- |
2485 |
= |
75 |
* |
(946 |
/ |
6087) |
= |
11.65598813 |
5 |
82170 |
2599 |
- |
2528 |
= |
71 |
* |
(1036 |
/ |
6087) |
= |
12.08411366 |
6 |
82173 |
2632 |
- |
2552 |
= |
80 |
* |
(965 |
/ |
6087) |
= |
12.68276648 |
7 |
82175 |
2650 |
- |
2567 |
= |
83 |
* |
(999 |
/ |
6087) |
= |
13.62198125 |
8 |
82176 |
2694 |
- |
2586 |
= |
108 |
* |
(920 |
/ |
6087) |
= |
16.32331192 |
11 |
82178 |
2752 |
- |
2628 |
= |
124 |
* |
(324 |
/ |
6087) |
= |
6.60029568 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Palo Alto Unified
|
83 |
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 |
84454 |
2501 |
- |
2436 |
= |
65 |
* |
(849 |
/ |
5812) |
= |
9.49501027 |
4 |
84456 |
2548 |
- |
2485 |
= |
63 |
* |
(922 |
/ |
5812) |
= |
9.99415003 |
5 |
84459 |
2587 |
- |
2528 |
= |
59 |
* |
(963 |
/ |
5812) |
= |
9.77580865 |
6 |
84461 |
2636 |
- |
2552 |
= |
84 |
* |
(1008 |
/ |
5812) |
= |
14.56847893 |
7 |
84463 |
2655 |
- |
2567 |
= |
88 |
* |
(951 |
/ |
5812) |
= |
14.39917406 |
8 |
84464 |
2687 |
- |
2586 |
= |
101 |
* |
(960 |
/ |
5812) |
= |
16.6827253 |
11 |
84466 |
2713 |
- |
2628 |
= |
85 |
* |
(159 |
/ |
5812) |
= |
2.32536132 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Palo Alto Unified
|
77 |
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 |
84670 |
2514 |
- |
2436 |
= |
78 |
* |
(843 |
/ |
5858) |
= |
11.22464998 |
4 |
84672 |
2556 |
- |
2485 |
= |
71 |
* |
(865 |
/ |
5858) |
= |
10.48395351 |
5 |
84674 |
2588 |
- |
2528 |
= |
60 |
* |
(909 |
/ |
5858) |
= |
9.31034478 |
6 |
84676 |
2636 |
- |
2552 |
= |
84 |
* |
(929 |
/ |
5858) |
= |
13.32127003 |
7 |
84678 |
2657 |
- |
2567 |
= |
90 |
* |
(997 |
/ |
5858) |
= |
15.31751445 |
8 |
84680 |
2684 |
- |
2586 |
= |
98 |
* |
(974 |
/ |
5858) |
= |
16.2942983 |
11 |
84682 |
2748 |
- |
2628 |
= |
120 |
* |
(341 |
/ |
5858) |
= |
6.98531916 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Palo Alto Unified
|
83 |
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 |
85268 |
2507 |
- |
2436 |
= |
71 |
* |
(798 |
/ |
5877) |
= |
9.64063297 |
4 |
85269 |
2557 |
- |
2485 |
= |
72 |
* |
(853 |
/ |
5877) |
= |
10.45022969 |
5 |
85270 |
2590 |
- |
2528 |
= |
62 |
* |
(864 |
/ |
5877) |
= |
9.11485448 |
6 |
85271 |
2627 |
- |
2552 |
= |
75 |
* |
(873 |
/ |
5877) |
= |
11.1408882 |
7 |
85272 |
2657 |
- |
2567 |
= |
90 |
* |
(910 |
/ |
5877) |
= |
13.93568145 |
8 |
85273 |
2684 |
- |
2586 |
= |
98 |
* |
(1000 |
/ |
5877) |
= |
16.67517432 |
11 |
85274 |
2727 |
- |
2628 |
= |
99 |
* |
(579 |
/ |
5877) |
= |
9.75344555 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Palo Alto Unified
|
81 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
78
|
83
|
77
|
83
|
81
|
402.0 |
80.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 86.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 74.4
For the lines, you have the data necessary to plot the chart.