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 |
1249450 |
2479 |
- |
2436 |
= |
43 |
* |
(356 |
/ |
2076) |
= |
7.37379575 |
4 |
1249453 |
2527 |
- |
2485 |
= |
42 |
* |
(351 |
/ |
2076) |
= |
7.10115605 |
5 |
1249454 |
2559 |
- |
2528 |
= |
31 |
* |
(395 |
/ |
2076) |
= |
5.89836222 |
6 |
1249457 |
2593 |
- |
2552 |
= |
41 |
* |
(324 |
/ |
2076) |
= |
6.39884392 |
7 |
1249458 |
2616 |
- |
2567 |
= |
49 |
* |
(338 |
/ |
2076) |
= |
7.977842 |
8 |
1249461 |
2634 |
- |
2586 |
= |
48 |
* |
(312 |
/ |
2076) |
= |
7.21387282 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Mill Valley Elementary
|
42 |
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 |
38960 |
2494 |
- |
2436 |
= |
58 |
* |
(397 |
/ |
2143) |
= |
10.74475033 |
4 |
38963 |
2538 |
- |
2485 |
= |
53 |
* |
(359 |
/ |
2143) |
= |
8.87867475 |
5 |
38964 |
2579 |
- |
2528 |
= |
51 |
* |
(350 |
/ |
2143) |
= |
8.3294447 |
6 |
38966 |
2590 |
- |
2552 |
= |
38 |
* |
(363 |
/ |
2143) |
= |
6.43677087 |
7 |
38968 |
2617 |
- |
2567 |
= |
50 |
* |
(333 |
/ |
2143) |
= |
7.769482 |
8 |
38971 |
2663 |
- |
2586 |
= |
77 |
* |
(341 |
/ |
2143) |
= |
12.25244983 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Mill Valley Elementary
|
54 |
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 |
39930 |
2490 |
- |
2436 |
= |
54 |
* |
(339 |
/ |
2110) |
= |
8.67582938 |
4 |
39932 |
2533 |
- |
2485 |
= |
48 |
* |
(407 |
/ |
2110) |
= |
9.25876776 |
5 |
39933 |
2569 |
- |
2528 |
= |
41 |
* |
(362 |
/ |
2110) |
= |
7.03412322 |
6 |
39935 |
2601 |
- |
2552 |
= |
49 |
* |
(331 |
/ |
2110) |
= |
7.68672981 |
7 |
39938 |
2598 |
- |
2567 |
= |
31 |
* |
(359 |
/ |
2110) |
= |
5.27440758 |
8 |
39940 |
2641 |
- |
2586 |
= |
55 |
* |
(312 |
/ |
2110) |
= |
8.13270139 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Mill Valley Elementary
|
46 |
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 |
39950 |
2500 |
- |
2436 |
= |
64 |
* |
(327 |
/ |
2060) |
= |
10.1592233 |
4 |
39953 |
2542 |
- |
2485 |
= |
57 |
* |
(318 |
/ |
2060) |
= |
8.79902912 |
5 |
39954 |
2578 |
- |
2528 |
= |
50 |
* |
(404 |
/ |
2060) |
= |
9.8058252 |
6 |
39957 |
2589 |
- |
2552 |
= |
37 |
* |
(349 |
/ |
2060) |
= |
6.26844658 |
7 |
39958 |
2627 |
- |
2567 |
= |
60 |
* |
(309 |
/ |
2060) |
= |
9.0 |
8 |
39961 |
2647 |
- |
2586 |
= |
61 |
* |
(353 |
/ |
2060) |
= |
10.4529126 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Mill Valley Elementary
|
54 |
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 |
40107 |
2498 |
- |
2436 |
= |
62 |
* |
(307 |
/ |
1950) |
= |
9.76102561 |
4 |
40108 |
2547 |
- |
2485 |
= |
62 |
* |
(318 |
/ |
1950) |
= |
10.11076923 |
5 |
40109 |
2573 |
- |
2528 |
= |
45 |
* |
(312 |
/ |
1950) |
= |
7.2 |
6 |
40110 |
2594 |
- |
2552 |
= |
42 |
* |
(374 |
/ |
1950) |
= |
8.05538458 |
7 |
40111 |
2621 |
- |
2567 |
= |
54 |
* |
(340 |
/ |
1950) |
= |
9.4153846 |
8 |
40112 |
2659 |
- |
2586 |
= |
73 |
* |
(299 |
/ |
1950) |
= |
11.19333331 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Mill Valley Elementary
|
56 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
42
|
54
|
46
|
54
|
56
|
252.0 |
50.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 68.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 32.4
For the lines, you have the data necessary to plot the chart.