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 |
2311543 |
2410 |
- |
2436 |
= |
-26 |
* |
(1612 |
/ |
10990) |
= |
-3.81364875 |
4 |
2311544 |
2449 |
- |
2485 |
= |
-36 |
* |
(1681 |
/ |
10990) |
= |
-5.50646039 |
5 |
2311547 |
2465 |
- |
2528 |
= |
-63 |
* |
(1681 |
/ |
10990) |
= |
-9.63630568 |
6 |
2311548 |
2499 |
- |
2552 |
= |
-53 |
* |
(1473 |
/ |
10990) |
= |
-7.10363966 |
7 |
2311551 |
2506 |
- |
2567 |
= |
-61 |
* |
(1522 |
/ |
10990) |
= |
-8.44786164 |
8 |
2311552 |
2514 |
- |
2586 |
= |
-72 |
* |
(1507 |
/ |
10990) |
= |
-9.87297538 |
11 |
2311555 |
2569 |
- |
2628 |
= |
-59 |
* |
(1514 |
/ |
10990) |
= |
-8.12793446 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Vista Unified
|
-53 |
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 |
70753 |
2419 |
- |
2436 |
= |
-17 |
* |
(1737 |
/ |
11075) |
= |
-2.66627539 |
4 |
70756 |
2454 |
- |
2485 |
= |
-31 |
* |
(1608 |
/ |
11075) |
= |
-4.50094806 |
5 |
70757 |
2471 |
- |
2528 |
= |
-57 |
* |
(1638 |
/ |
11075) |
= |
-8.43033859 |
6 |
70760 |
2494 |
- |
2552 |
= |
-58 |
* |
(1541 |
/ |
11075) |
= |
-8.0702483 |
7 |
70762 |
2518 |
- |
2567 |
= |
-49 |
* |
(1455 |
/ |
11075) |
= |
-6.43747178 |
8 |
70764 |
2516 |
- |
2586 |
= |
-70 |
* |
(1498 |
/ |
11075) |
= |
-9.46817151 |
11 |
70765 |
2564 |
- |
2628 |
= |
-64 |
* |
(1598 |
/ |
11075) |
= |
-9.2344921 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Vista Unified
|
-49 |
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 |
72607 |
2429 |
- |
2436 |
= |
-7 |
* |
(1554 |
/ |
10925) |
= |
-0.99569793 |
4 |
72608 |
2452 |
- |
2485 |
= |
-33 |
* |
(1706 |
/ |
10925) |
= |
-5.153135 |
5 |
72611 |
2478 |
- |
2528 |
= |
-50 |
* |
(1599 |
/ |
10925) |
= |
-7.3180778 |
6 |
72613 |
2498 |
- |
2552 |
= |
-54 |
* |
(1468 |
/ |
10925) |
= |
-7.25601829 |
7 |
72615 |
2504 |
- |
2567 |
= |
-63 |
* |
(1551 |
/ |
10925) |
= |
-8.94398167 |
8 |
72616 |
2515 |
- |
2586 |
= |
-71 |
* |
(1445 |
/ |
10925) |
= |
-9.39084667 |
11 |
72618 |
2575 |
- |
2628 |
= |
-53 |
* |
(1602 |
/ |
10925) |
= |
-7.77171622 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Vista Unified
|
-47 |
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 |
72735 |
2431 |
- |
2436 |
= |
-5 |
* |
(1502 |
/ |
10498) |
= |
-0.71537436 |
4 |
72738 |
2459 |
- |
2485 |
= |
-26 |
* |
(1520 |
/ |
10498) |
= |
-3.76452656 |
5 |
72739 |
2483 |
- |
2528 |
= |
-45 |
* |
(1643 |
/ |
10498) |
= |
-7.04277005 |
6 |
72742 |
2499 |
- |
2552 |
= |
-53 |
* |
(1389 |
/ |
10498) |
= |
-7.01247855 |
7 |
72743 |
2504 |
- |
2567 |
= |
-63 |
* |
(1386 |
/ |
10498) |
= |
-8.31758426 |
8 |
72745 |
2513 |
- |
2586 |
= |
-73 |
* |
(1525 |
/ |
10498) |
= |
-10.60440077 |
11 |
72747 |
2568 |
- |
2628 |
= |
-60 |
* |
(1533 |
/ |
10498) |
= |
-8.76166884 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Vista Unified
|
-46 |
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 |
73215 |
2432 |
- |
2436 |
= |
-4 |
* |
(1513 |
/ |
10211) |
= |
-0.59269415 |
4 |
73216 |
2466 |
- |
2485 |
= |
-19 |
* |
(1477 |
/ |
10211) |
= |
-2.74831063 |
5 |
73217 |
2486 |
- |
2528 |
= |
-42 |
* |
(1522 |
/ |
10211) |
= |
-6.26030748 |
6 |
73218 |
2511 |
- |
2552 |
= |
-41 |
* |
(1465 |
/ |
10211) |
= |
-5.88238173 |
7 |
73219 |
2515 |
- |
2567 |
= |
-52 |
* |
(1395 |
/ |
10211) |
= |
-7.1041034 |
8 |
73220 |
2527 |
- |
2586 |
= |
-59 |
* |
(1384 |
/ |
10211) |
= |
-7.99686608 |
11 |
73221 |
2571 |
- |
2628 |
= |
-57 |
* |
(1455 |
/ |
10211) |
= |
-8.12212317 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Vista Unified
|
-39 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-53
|
-49
|
-47
|
-46
|
-39
|
-234.0 |
-46.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -31.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -61.8
For the lines, you have the data necessary to plot the chart.