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 |
3151924 |
2457 |
- |
2436 |
= |
21 |
* |
(1210 |
/ |
9756) |
= |
2.60455104 |
4 |
3151925 |
2502 |
- |
2485 |
= |
17 |
* |
(1240 |
/ |
9756) |
= |
2.16072161 |
5 |
3151928 |
2532 |
- |
2528 |
= |
4 |
* |
(1380 |
/ |
9756) |
= |
0.56580566 |
6 |
3151929 |
2556 |
- |
2552 |
= |
4 |
* |
(1451 |
/ |
9756) |
= |
0.59491595 |
7 |
3151932 |
2573 |
- |
2567 |
= |
6 |
* |
(1427 |
/ |
9756) |
= |
0.87761377 |
8 |
3151933 |
2599 |
- |
2586 |
= |
13 |
* |
(1492 |
/ |
9756) |
= |
1.98810988 |
11 |
3151936 |
2630 |
- |
2628 |
= |
2 |
* |
(1556 |
/ |
9756) |
= |
0.31898319 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Conejo Valley Unified
|
9 |
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 |
97146 |
2455 |
- |
2436 |
= |
19 |
* |
(1227 |
/ |
9825) |
= |
2.37282442 |
4 |
97148 |
2505 |
- |
2485 |
= |
20 |
* |
(1263 |
/ |
9825) |
= |
2.57099236 |
5 |
97151 |
2532 |
- |
2528 |
= |
4 |
* |
(1323 |
/ |
9825) |
= |
0.53862595 |
6 |
97152 |
2564 |
- |
2552 |
= |
12 |
* |
(1460 |
/ |
9825) |
= |
1.7832061 |
7 |
97155 |
2588 |
- |
2567 |
= |
21 |
* |
(1448 |
/ |
9825) |
= |
3.09496181 |
8 |
97157 |
2609 |
- |
2586 |
= |
23 |
* |
(1439 |
/ |
9825) |
= |
3.36865139 |
11 |
97158 |
2624 |
- |
2628 |
= |
-4 |
* |
(1665 |
/ |
9825) |
= |
-0.67786259 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Conejo 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 |
99957 |
2458 |
- |
2436 |
= |
22 |
* |
(1150 |
/ |
9702) |
= |
2.60770974 |
4 |
99959 |
2501 |
- |
2485 |
= |
16 |
* |
(1233 |
/ |
9702) |
= |
2.03339517 |
5 |
99962 |
2534 |
- |
2528 |
= |
6 |
* |
(1299 |
/ |
9702) |
= |
0.80333951 |
6 |
99964 |
2562 |
- |
2552 |
= |
10 |
* |
(1386 |
/ |
9702) |
= |
1.42857142 |
7 |
99965 |
2582 |
- |
2567 |
= |
15 |
* |
(1479 |
/ |
9702) |
= |
2.28664193 |
8 |
99968 |
2614 |
- |
2586 |
= |
28 |
* |
(1432 |
/ |
9702) |
= |
4.13275612 |
11 |
99970 |
2631 |
- |
2628 |
= |
3 |
* |
(1723 |
/ |
9702) |
= |
0.53277675 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Conejo Valley 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 |
100109 |
2465 |
- |
2436 |
= |
29 |
* |
(1118 |
/ |
9426) |
= |
3.43963505 |
4 |
100111 |
2504 |
- |
2485 |
= |
19 |
* |
(1173 |
/ |
9426) |
= |
2.36441755 |
5 |
100113 |
2523 |
- |
2528 |
= |
-5 |
* |
(1241 |
/ |
9426) |
= |
-0.65828559 |
6 |
100115 |
2563 |
- |
2552 |
= |
11 |
* |
(1377 |
/ |
9426) |
= |
1.60693825 |
7 |
100117 |
2580 |
- |
2567 |
= |
13 |
* |
(1406 |
/ |
9426) |
= |
1.9391046 |
8 |
100119 |
2611 |
- |
2586 |
= |
25 |
* |
(1473 |
/ |
9426) |
= |
3.90674728 |
11 |
100121 |
2608 |
- |
2628 |
= |
-20 |
* |
(1638 |
/ |
9426) |
= |
-3.4754933 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Conejo Valley Unified
|
9 |
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 |
100777 |
2466 |
- |
2436 |
= |
30 |
* |
(1159 |
/ |
9101) |
= |
3.82045929 |
4 |
100778 |
2504 |
- |
2485 |
= |
19 |
* |
(1163 |
/ |
9101) |
= |
2.42797495 |
5 |
100779 |
2535 |
- |
2528 |
= |
7 |
* |
(1168 |
/ |
9101) |
= |
0.89836282 |
6 |
100780 |
2553 |
- |
2552 |
= |
1 |
* |
(1307 |
/ |
9101) |
= |
0.14361059 |
7 |
100781 |
2579 |
- |
2567 |
= |
12 |
* |
(1385 |
/ |
9101) |
= |
1.82617295 |
8 |
100782 |
2606 |
- |
2586 |
= |
20 |
* |
(1376 |
/ |
9101) |
= |
3.02384352 |
11 |
100783 |
2617 |
- |
2628 |
= |
-11 |
* |
(1543 |
/ |
9101) |
= |
-1.86495989 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Conejo Valley Unified
|
10 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
9
|
13
|
14
|
9
|
10
|
55.0 |
11.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 17.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 5.0
For the lines, you have the data necessary to plot the chart.