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 |
2201941 |
2475 |
- |
2436 |
= |
39 |
* |
(2726 |
/ |
18361) |
= |
5.7902075 |
4 |
2201942 |
2524 |
- |
2485 |
= |
39 |
* |
(2726 |
/ |
18361) |
= |
5.7902075 |
5 |
2201945 |
2552 |
- |
2528 |
= |
24 |
* |
(2681 |
/ |
18361) |
= |
3.50438429 |
6 |
2201946 |
2571 |
- |
2552 |
= |
19 |
* |
(2651 |
/ |
18361) |
= |
2.74326017 |
7 |
2201949 |
2597 |
- |
2567 |
= |
30 |
* |
(2634 |
/ |
18361) |
= |
4.30368714 |
8 |
2201950 |
2609 |
- |
2586 |
= |
23 |
* |
(2583 |
/ |
18361) |
= |
3.23560808 |
11 |
2201953 |
2652 |
- |
2628 |
= |
24 |
* |
(2360 |
/ |
18361) |
= |
3.0847993 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Poway Unified
|
28 |
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 |
67630 |
2481 |
- |
2436 |
= |
45 |
* |
(2615 |
/ |
18719) |
= |
6.28639349 |
4 |
67631 |
2527 |
- |
2485 |
= |
42 |
* |
(2707 |
/ |
18719) |
= |
6.07372185 |
5 |
67634 |
2563 |
- |
2528 |
= |
35 |
* |
(2757 |
/ |
18719) |
= |
5.15492278 |
6 |
67636 |
2568 |
- |
2552 |
= |
16 |
* |
(2688 |
/ |
18719) |
= |
2.29755862 |
7 |
67637 |
2602 |
- |
2567 |
= |
35 |
* |
(2639 |
/ |
18719) |
= |
4.93429136 |
8 |
67639 |
2633 |
- |
2586 |
= |
47 |
* |
(2648 |
/ |
18719) |
= |
6.64864576 |
11 |
67642 |
2657 |
- |
2628 |
= |
29 |
* |
(2665 |
/ |
18719) |
= |
4.12869276 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Poway Unified
|
36 |
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 |
69412 |
2483 |
- |
2436 |
= |
47 |
* |
(2604 |
/ |
18676) |
= |
6.55322335 |
4 |
69415 |
2528 |
- |
2485 |
= |
43 |
* |
(2651 |
/ |
18676) |
= |
6.10371597 |
5 |
69417 |
2561 |
- |
2528 |
= |
33 |
* |
(2751 |
/ |
18676) |
= |
4.86094452 |
6 |
69419 |
2576 |
- |
2552 |
= |
24 |
* |
(2763 |
/ |
18676) |
= |
3.55065324 |
7 |
69421 |
2591 |
- |
2567 |
= |
24 |
* |
(2693 |
/ |
18676) |
= |
3.46069822 |
8 |
69423 |
2630 |
- |
2586 |
= |
44 |
* |
(2655 |
/ |
18676) |
= |
6.25508673 |
11 |
69424 |
2656 |
- |
2628 |
= |
28 |
* |
(2559 |
/ |
18676) |
= |
3.8365817 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Poway Unified
|
35 |
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 |
69575 |
2485 |
- |
2436 |
= |
49 |
* |
(2511 |
/ |
18784) |
= |
6.55020225 |
4 |
69578 |
2532 |
- |
2485 |
= |
47 |
* |
(2659 |
/ |
18784) |
= |
6.65316222 |
5 |
69579 |
2563 |
- |
2528 |
= |
35 |
* |
(2673 |
/ |
18784) |
= |
4.98056857 |
6 |
69582 |
2575 |
- |
2552 |
= |
23 |
* |
(2847 |
/ |
18784) |
= |
3.4859987 |
7 |
69583 |
2603 |
- |
2567 |
= |
36 |
* |
(2801 |
/ |
18784) |
= |
5.36818568 |
8 |
69586 |
2621 |
- |
2586 |
= |
35 |
* |
(2689 |
/ |
18784) |
= |
5.01038115 |
11 |
69587 |
2645 |
- |
2628 |
= |
17 |
* |
(2604 |
/ |
18784) |
= |
2.35668654 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Poway Unified
|
34 |
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 |
70101 |
2487 |
- |
2436 |
= |
51 |
* |
(2543 |
/ |
18714) |
= |
6.93026607 |
4 |
70102 |
2536 |
- |
2485 |
= |
51 |
* |
(2517 |
/ |
18714) |
= |
6.85941004 |
5 |
70103 |
2572 |
- |
2528 |
= |
44 |
* |
(2671 |
/ |
18714) |
= |
6.28000424 |
6 |
70104 |
2577 |
- |
2552 |
= |
25 |
* |
(2721 |
/ |
18714) |
= |
3.63497915 |
7 |
70105 |
2602 |
- |
2567 |
= |
35 |
* |
(2832 |
/ |
18714) |
= |
5.29656939 |
8 |
70106 |
2636 |
- |
2586 |
= |
50 |
* |
(2760 |
/ |
18714) |
= |
7.37415835 |
11 |
70107 |
2675 |
- |
2628 |
= |
47 |
* |
(2670 |
/ |
18714) |
= |
6.70567485 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Poway Unified
|
43 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
28
|
36
|
35
|
34
|
43
|
176.0 |
35.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 50.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 20.2
For the lines, you have the data necessary to plot the chart.