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 |
1564803 |
2439 |
- |
2436 |
= |
3 |
* |
(1851 |
/ |
12986) |
= |
0.42761435 |
4 |
1564804 |
2494 |
- |
2485 |
= |
9 |
* |
(1775 |
/ |
12986) |
= |
1.23017095 |
5 |
1564807 |
2516 |
- |
2528 |
= |
-12 |
* |
(1904 |
/ |
12986) |
= |
-1.75943323 |
6 |
1564808 |
2540 |
- |
2552 |
= |
-12 |
* |
(1917 |
/ |
12986) |
= |
-1.77144617 |
7 |
1564811 |
2554 |
- |
2567 |
= |
-13 |
* |
(1827 |
/ |
12986) |
= |
-1.82896965 |
8 |
1564812 |
2586 |
- |
2586 |
= |
0 |
* |
(1907 |
/ |
12986) |
= |
0.0 |
11 |
1564815 |
2603 |
- |
2628 |
= |
-25 |
* |
(1805 |
/ |
12986) |
= |
-3.47489603 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Tustin Unified
|
-7 |
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 |
48981 |
2451 |
- |
2436 |
= |
15 |
* |
(1694 |
/ |
12974) |
= |
1.95853244 |
4 |
48983 |
2491 |
- |
2485 |
= |
6 |
* |
(1844 |
/ |
12974) |
= |
0.85278248 |
5 |
48984 |
2529 |
- |
2528 |
= |
1 |
* |
(1787 |
/ |
12974) |
= |
0.13773701 |
6 |
48987 |
2543 |
- |
2552 |
= |
-9 |
* |
(1970 |
/ |
12974) |
= |
-1.36657931 |
7 |
48989 |
2565 |
- |
2567 |
= |
-2 |
* |
(1955 |
/ |
12974) |
= |
-0.30137197 |
8 |
48991 |
2595 |
- |
2586 |
= |
9 |
* |
(1821 |
/ |
12974) |
= |
1.26321874 |
11 |
48993 |
2622 |
- |
2628 |
= |
-6 |
* |
(1903 |
/ |
12974) |
= |
-0.88006783 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Tustin Unified
|
2 |
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 |
50316 |
2447 |
- |
2436 |
= |
11 |
* |
(1676 |
/ |
12885) |
= |
1.43081102 |
4 |
50319 |
2495 |
- |
2485 |
= |
10 |
* |
(1720 |
/ |
12885) |
= |
1.33488552 |
5 |
50320 |
2524 |
- |
2528 |
= |
-4 |
* |
(1853 |
/ |
12885) |
= |
-0.57524253 |
6 |
50323 |
2554 |
- |
2552 |
= |
2 |
* |
(1824 |
/ |
12885) |
= |
0.28311991 |
7 |
50325 |
2563 |
- |
2567 |
= |
-4 |
* |
(2025 |
/ |
12885) |
= |
-0.62863795 |
8 |
50326 |
2594 |
- |
2586 |
= |
8 |
* |
(1955 |
/ |
12885) |
= |
1.21381451 |
11 |
50328 |
2628 |
- |
2628 |
= |
0 |
* |
(1832 |
/ |
12885) |
= |
0.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Tustin Unified
|
3 |
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 |
50340 |
2448 |
- |
2436 |
= |
12 |
* |
(1615 |
/ |
12796) |
= |
1.51453579 |
4 |
50343 |
2493 |
- |
2485 |
= |
8 |
* |
(1699 |
/ |
12796) |
= |
1.06220694 |
5 |
50344 |
2531 |
- |
2528 |
= |
3 |
* |
(1751 |
/ |
12796) |
= |
0.41051891 |
6 |
50347 |
2549 |
- |
2552 |
= |
-3 |
* |
(1890 |
/ |
12796) |
= |
-0.44310722 |
7 |
50348 |
2568 |
- |
2567 |
= |
1 |
* |
(1860 |
/ |
12796) |
= |
0.14535792 |
8 |
50351 |
2587 |
- |
2586 |
= |
1 |
* |
(1999 |
/ |
12796) |
= |
0.15622069 |
11 |
50352 |
2615 |
- |
2628 |
= |
-13 |
* |
(1982 |
/ |
12796) |
= |
-2.01359799 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Tustin Unified
|
1 |
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 |
50537 |
2450 |
- |
2436 |
= |
14 |
* |
(1599 |
/ |
12279) |
= |
1.82311262 |
4 |
50538 |
2495 |
- |
2485 |
= |
10 |
* |
(1609 |
/ |
12279) |
= |
1.31036729 |
5 |
50539 |
2528 |
- |
2528 |
= |
0 |
* |
(1715 |
/ |
12279) |
= |
0.0 |
6 |
50540 |
2553 |
- |
2552 |
= |
1 |
* |
(1792 |
/ |
12279) |
= |
0.14594022 |
7 |
50541 |
2571 |
- |
2567 |
= |
4 |
* |
(1876 |
/ |
12279) |
= |
0.61112468 |
8 |
50542 |
2593 |
- |
2586 |
= |
7 |
* |
(1846 |
/ |
12279) |
= |
1.05236583 |
11 |
50543 |
2612 |
- |
2628 |
= |
-16 |
* |
(1842 |
/ |
12279) |
= |
-2.40019544 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Tustin Unified
|
3 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-7
|
2
|
3
|
1
|
3
|
2.0 |
0.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 12.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -11.6
For the lines, you have the data necessary to plot the chart.