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 |
1776399 |
2433 |
- |
2436 |
= |
-3 |
* |
(1549 |
/ |
11675) |
= |
-0.39802998 |
4 |
1776401 |
2472 |
- |
2485 |
= |
-13 |
* |
(1552 |
/ |
11675) |
= |
-1.72813703 |
5 |
1776403 |
2513 |
- |
2528 |
= |
-15 |
* |
(1578 |
/ |
11675) |
= |
-2.02740899 |
6 |
1776405 |
2529 |
- |
2552 |
= |
-23 |
* |
(1662 |
/ |
11675) |
= |
-3.27417558 |
7 |
1776406 |
2541 |
- |
2567 |
= |
-26 |
* |
(1645 |
/ |
11675) |
= |
-3.66338328 |
8 |
1776408 |
2558 |
- |
2586 |
= |
-28 |
* |
(1831 |
/ |
11675) |
= |
-4.39126338 |
11 |
1776411 |
2596 |
- |
2628 |
= |
-32 |
* |
(1858 |
/ |
11675) |
= |
-5.09259098 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Murrieta Valley Unified
|
-21 |
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 |
55121 |
2439 |
- |
2436 |
= |
3 |
* |
(1462 |
/ |
11691) |
= |
0.37516038 |
4 |
55123 |
2482 |
- |
2485 |
= |
-3 |
* |
(1590 |
/ |
11691) |
= |
-0.40800616 |
5 |
55125 |
2510 |
- |
2528 |
= |
-18 |
* |
(1610 |
/ |
11691) |
= |
-2.47882986 |
6 |
55126 |
2540 |
- |
2552 |
= |
-12 |
* |
(1692 |
/ |
11691) |
= |
-1.73672054 |
7 |
55128 |
2553 |
- |
2567 |
= |
-14 |
* |
(1683 |
/ |
11691) |
= |
-2.01539645 |
8 |
55131 |
2575 |
- |
2586 |
= |
-11 |
* |
(1777 |
/ |
11691) |
= |
-1.67196988 |
11 |
55132 |
2596 |
- |
2628 |
= |
-32 |
* |
(1877 |
/ |
11691) |
= |
-5.13762723 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Murrieta Valley 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 |
56732 |
2444 |
- |
2436 |
= |
8 |
* |
(1487 |
/ |
11921) |
= |
0.99790286 |
4 |
56734 |
2483 |
- |
2485 |
= |
-2 |
* |
(1539 |
/ |
11921) |
= |
-0.25819981 |
5 |
56736 |
2517 |
- |
2528 |
= |
-11 |
* |
(1615 |
/ |
11921) |
= |
-1.49022732 |
6 |
56738 |
2535 |
- |
2552 |
= |
-17 |
* |
(1743 |
/ |
11921) |
= |
-2.48561362 |
7 |
56739 |
2566 |
- |
2567 |
= |
-1 |
* |
(1722 |
/ |
11921) |
= |
-0.14445097 |
8 |
56742 |
2577 |
- |
2586 |
= |
-9 |
* |
(1797 |
/ |
11921) |
= |
-1.35668148 |
11 |
56743 |
2583 |
- |
2628 |
= |
-45 |
* |
(2018 |
/ |
11921) |
= |
-7.6176495 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Murrieta Valley Unified
|
-12 |
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 |
56833 |
2451 |
- |
2436 |
= |
15 |
* |
(1419 |
/ |
11987) |
= |
1.77567365 |
4 |
56834 |
2492 |
- |
2485 |
= |
7 |
* |
(1552 |
/ |
11987) |
= |
0.90631517 |
5 |
56837 |
2521 |
- |
2528 |
= |
-7 |
* |
(1606 |
/ |
11987) |
= |
-0.93784933 |
6 |
56838 |
2542 |
- |
2552 |
= |
-10 |
* |
(1779 |
/ |
11987) |
= |
-1.48410778 |
7 |
56841 |
2546 |
- |
2567 |
= |
-21 |
* |
(1811 |
/ |
11987) |
= |
-3.17268708 |
8 |
56842 |
2587 |
- |
2586 |
= |
1 |
* |
(1777 |
/ |
11987) |
= |
0.14824393 |
11 |
56845 |
2578 |
- |
2628 |
= |
-50 |
* |
(2043 |
/ |
11987) |
= |
-8.52173185 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Murrieta Valley 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 |
57085 |
2455 |
- |
2436 |
= |
19 |
* |
(1526 |
/ |
12037) |
= |
2.40873971 |
4 |
57086 |
2501 |
- |
2485 |
= |
16 |
* |
(1519 |
/ |
12037) |
= |
2.01910774 |
5 |
57087 |
2529 |
- |
2528 |
= |
1 |
* |
(1600 |
/ |
12037) |
= |
0.13292349 |
6 |
57088 |
2541 |
- |
2552 |
= |
-11 |
* |
(1704 |
/ |
12037) |
= |
-1.55719863 |
7 |
57089 |
2562 |
- |
2567 |
= |
-5 |
* |
(1854 |
/ |
12037) |
= |
-0.77012545 |
8 |
57090 |
2572 |
- |
2586 |
= |
-14 |
* |
(1873 |
/ |
12037) |
= |
-2.17844977 |
11 |
57091 |
2605 |
- |
2628 |
= |
-23 |
* |
(1961 |
/ |
12037) |
= |
-3.74702998 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Murrieta Valley Unified
|
-4 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-21
|
-13
|
-12
|
-11
|
-4
|
-61.0 |
-12.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 5.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -30.2
For the lines, you have the data necessary to plot the chart.