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 |
124480 |
2403 |
- |
2436 |
= |
-33 |
* |
(11 |
/ |
50) |
= |
-7.26 |
4 |
124481 |
2482 |
- |
2485 |
= |
-3 |
* |
(11 |
/ |
50) |
= |
-0.66 |
5 |
124484 |
0 |
- |
2528 |
= |
|
* |
(9 |
/ |
50) |
= |
|
6 |
124485 |
0 |
- |
2552 |
= |
|
* |
(9 |
/ |
50) |
= |
|
7 |
124488 |
0 |
- |
2567 |
= |
|
* |
(2 |
/ |
50) |
= |
|
8 |
124489 |
0 |
- |
2586 |
= |
|
* |
(7 |
/ |
50) |
= |
|
11 |
124492 |
0 |
- |
2628 |
= |
|
* |
(1 |
/ |
50) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Alpine County Unified
|
-8 |
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 |
3499 |
2437 |
- |
2436 |
= |
1 |
* |
(11 |
/ |
53) |
= |
0.20754717 |
4 |
3502 |
0 |
- |
2485 |
= |
|
* |
(10 |
/ |
53) |
= |
|
5 |
3504 |
0 |
- |
2528 |
= |
|
* |
(10 |
/ |
53) |
= |
|
6 |
3506 |
0 |
- |
2552 |
= |
|
* |
(10 |
/ |
53) |
= |
|
7 |
3507 |
0 |
- |
2567 |
= |
|
* |
(9 |
/ |
53) |
= |
|
8 |
3510 |
0 |
- |
2586 |
= |
|
* |
(3 |
/ |
53) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Alpine County Unified
|
0 |
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 |
3577 |
2393 |
- |
2436 |
= |
-43 |
* |
(12 |
/ |
59) |
= |
-8.74576269 |
4 |
3580 |
2456 |
- |
2485 |
= |
-29 |
* |
(11 |
/ |
59) |
= |
-5.40677963 |
5 |
3581 |
0 |
- |
2528 |
= |
|
* |
(0 |
/ |
59) |
= |
|
6 |
3584 |
0 |
- |
2552 |
= |
|
* |
(0 |
/ |
59) |
= |
|
7 |
3585 |
0 |
- |
2567 |
= |
|
* |
(0 |
/ |
59) |
= |
|
8 |
3588 |
0 |
- |
2586 |
= |
|
* |
(0 |
/ |
59) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Alpine County Unified
|
-14 |
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 |
3577 |
0 |
- |
2436 |
= |
|
* |
(0 |
/ |
56) |
= |
|
4 |
3580 |
2457 |
- |
2485 |
= |
-28 |
* |
(11 |
/ |
56) |
= |
-5.49999999 |
5 |
3582 |
0 |
- |
2528 |
= |
|
* |
(0 |
/ |
56) |
= |
|
6 |
3584 |
2526 |
- |
2552 |
= |
-26 |
* |
(12 |
/ |
56) |
= |
-5.57142856 |
7 |
3585 |
0 |
- |
2567 |
= |
|
* |
(0 |
/ |
56) |
= |
|
8 |
3588 |
0 |
- |
2586 |
= |
|
* |
(0 |
/ |
56) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Alpine County Unified
|
-11 |
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 |
3626 |
0 |
- |
2436 |
= |
|
* |
(7 |
/ |
52) |
= |
|
4 |
3627 |
0 |
- |
2485 |
= |
|
* |
(7 |
/ |
52) |
= |
|
5 |
3628 |
2490 |
- |
2528 |
= |
-38 |
* |
(11 |
/ |
52) |
= |
-8.03846152 |
6 |
3629 |
0 |
- |
2552 |
= |
|
* |
(7 |
/ |
52) |
= |
|
7 |
3630 |
0 |
- |
2567 |
= |
|
* |
(10 |
/ |
52) |
= |
|
8 |
3631 |
0 |
- |
2586 |
= |
|
* |
(10 |
/ |
52) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Alpine County Unified
|
-8 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-8
|
0
|
-14
|
-11
|
-8
|
-41.0 |
-8.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -4.25
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -16.25
For the lines, you have the data necessary to plot the chart.