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 |
1126208 |
2461 |
- |
2436 |
= |
25 |
* |
(1549 |
/ |
12185) |
= |
3.1780878 |
4 |
1126209 |
2503 |
- |
2485 |
= |
18 |
* |
(1620 |
/ |
12185) |
= |
2.39310626 |
5 |
1126212 |
2531 |
- |
2528 |
= |
3 |
* |
(1679 |
/ |
12185) |
= |
0.4133771 |
6 |
1126213 |
2547 |
- |
2552 |
= |
-5 |
* |
(1800 |
/ |
12185) |
= |
-0.73861305 |
7 |
1126216 |
2568 |
- |
2567 |
= |
1 |
* |
(1780 |
/ |
12185) |
= |
0.14608125 |
8 |
1126217 |
2592 |
- |
2586 |
= |
6 |
* |
(1798 |
/ |
12185) |
= |
0.88535084 |
11 |
1126220 |
2617 |
- |
2628 |
= |
-11 |
* |
(1959 |
/ |
12185) |
= |
-1.76848584 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Torrance Unified
|
5 |
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 |
35143 |
2467 |
- |
2436 |
= |
31 |
* |
(1585 |
/ |
12161) |
= |
4.04037496 |
4 |
35145 |
2514 |
- |
2485 |
= |
29 |
* |
(1564 |
/ |
12161) |
= |
3.72962748 |
5 |
35148 |
2535 |
- |
2528 |
= |
7 |
* |
(1639 |
/ |
12161) |
= |
0.9434257 |
6 |
35149 |
2558 |
- |
2552 |
= |
6 |
* |
(1805 |
/ |
12161) |
= |
0.89055176 |
7 |
35151 |
2575 |
- |
2567 |
= |
8 |
* |
(1825 |
/ |
12161) |
= |
1.20055916 |
8 |
35154 |
2596 |
- |
2586 |
= |
10 |
* |
(1770 |
/ |
12161) |
= |
1.45547241 |
11 |
35155 |
2630 |
- |
2628 |
= |
2 |
* |
(1973 |
/ |
12161) |
= |
0.32447989 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Torrance Unified
|
13 |
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 |
35823 |
2472 |
- |
2436 |
= |
36 |
* |
(1624 |
/ |
12202) |
= |
4.79134566 |
4 |
35825 |
2516 |
- |
2485 |
= |
31 |
* |
(1611 |
/ |
12202) |
= |
4.09285362 |
5 |
35827 |
2544 |
- |
2528 |
= |
16 |
* |
(1597 |
/ |
12202) |
= |
2.09408293 |
6 |
35830 |
2555 |
- |
2552 |
= |
3 |
* |
(1767 |
/ |
12202) |
= |
0.43443698 |
7 |
35831 |
2579 |
- |
2567 |
= |
12 |
* |
(1848 |
/ |
12202) |
= |
1.81740697 |
8 |
35833 |
2595 |
- |
2586 |
= |
9 |
* |
(1835 |
/ |
12202) |
= |
1.35346664 |
11 |
35835 |
2625 |
- |
2628 |
= |
-3 |
* |
(1920 |
/ |
12202) |
= |
-0.47205376 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Torrance 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 |
35829 |
2479 |
- |
2436 |
= |
43 |
* |
(1536 |
/ |
12142) |
= |
5.43963102 |
4 |
35832 |
2520 |
- |
2485 |
= |
35 |
* |
(1626 |
/ |
12142) |
= |
4.68703673 |
5 |
35833 |
2547 |
- |
2528 |
= |
19 |
* |
(1618 |
/ |
12142) |
= |
2.53187284 |
6 |
35836 |
2567 |
- |
2552 |
= |
15 |
* |
(1763 |
/ |
12142) |
= |
2.17797726 |
7 |
35837 |
2582 |
- |
2567 |
= |
15 |
* |
(1776 |
/ |
12142) |
= |
2.19403722 |
8 |
35839 |
2601 |
- |
2586 |
= |
15 |
* |
(1862 |
/ |
12142) |
= |
2.30028002 |
11 |
35841 |
2630 |
- |
2628 |
= |
2 |
* |
(1961 |
/ |
12142) |
= |
0.32301104 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Torrance Unified
|
20 |
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 |
36002 |
2481 |
- |
2436 |
= |
45 |
* |
(1584 |
/ |
11873) |
= |
6.00353744 |
4 |
36003 |
2525 |
- |
2485 |
= |
40 |
* |
(1510 |
/ |
11873) |
= |
5.08717256 |
5 |
36004 |
2556 |
- |
2528 |
= |
28 |
* |
(1661 |
/ |
11873) |
= |
3.91712286 |
6 |
36005 |
2570 |
- |
2552 |
= |
18 |
* |
(1743 |
/ |
11873) |
= |
2.6424661 |
7 |
36006 |
2588 |
- |
2567 |
= |
21 |
* |
(1766 |
/ |
11873) |
= |
3.12355764 |
8 |
36007 |
2595 |
- |
2586 |
= |
9 |
* |
(1772 |
/ |
11873) |
= |
1.34321569 |
11 |
36008 |
2631 |
- |
2628 |
= |
3 |
* |
(1837 |
/ |
11873) |
= |
0.46416239 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Torrance Unified
|
23 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
5
|
13
|
14
|
20
|
23
|
75.0 |
15.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 33.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -3.0
For the lines, you have the data necessary to plot the chart.