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 |
1783024 |
2396 |
- |
2436 |
= |
-40 |
* |
(1636 |
/ |
10676) |
= |
-6.12963656 |
4 |
1783027 |
2441 |
- |
2485 |
= |
-44 |
* |
(1555 |
/ |
10676) |
= |
-6.40876729 |
5 |
1783028 |
2459 |
- |
2528 |
= |
-69 |
* |
(1535 |
/ |
10676) |
= |
-9.9208505 |
6 |
1783031 |
2486 |
- |
2552 |
= |
-66 |
* |
(1513 |
/ |
10676) |
= |
-9.35350317 |
7 |
1783032 |
2488 |
- |
2567 |
= |
-79 |
* |
(1543 |
/ |
10676) |
= |
-11.41785309 |
8 |
1783035 |
2504 |
- |
2586 |
= |
-82 |
* |
(1509 |
/ |
10676) |
= |
-11.59029599 |
11 |
1783036 |
2533 |
- |
2628 |
= |
-95 |
* |
(1385 |
/ |
10676) |
= |
-12.32437242 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Val Verde Unified
|
-67 |
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 |
55293 |
2406 |
- |
2436 |
= |
-30 |
* |
(1541 |
/ |
10840) |
= |
-4.26476013 |
4 |
55295 |
2447 |
- |
2485 |
= |
-38 |
* |
(1648 |
/ |
10840) |
= |
-5.77712176 |
5 |
55296 |
2469 |
- |
2528 |
= |
-59 |
* |
(1588 |
/ |
10840) |
= |
-8.64317338 |
6 |
55299 |
2485 |
- |
2552 |
= |
-67 |
* |
(1510 |
/ |
10840) |
= |
-9.33302576 |
7 |
55301 |
2496 |
- |
2567 |
= |
-71 |
* |
(1529 |
/ |
10840) |
= |
-10.01466786 |
8 |
55303 |
2508 |
- |
2586 |
= |
-78 |
* |
(1574 |
/ |
10840) |
= |
-11.32583026 |
11 |
55305 |
2537 |
- |
2628 |
= |
-91 |
* |
(1450 |
/ |
10840) |
= |
-12.17250917 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Val Verde Unified
|
-62 |
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 |
56899 |
2409 |
- |
2436 |
= |
-27 |
* |
(1404 |
/ |
10740) |
= |
-3.52960891 |
4 |
56902 |
2450 |
- |
2485 |
= |
-35 |
* |
(1549 |
/ |
10740) |
= |
-5.04795158 |
5 |
56903 |
2469 |
- |
2528 |
= |
-59 |
* |
(1657 |
/ |
10740) |
= |
-9.10270019 |
6 |
56906 |
2481 |
- |
2552 |
= |
-71 |
* |
(1547 |
/ |
10740) |
= |
-10.22690873 |
7 |
56907 |
2482 |
- |
2567 |
= |
-85 |
* |
(1520 |
/ |
10740) |
= |
-12.02979509 |
8 |
56910 |
2494 |
- |
2586 |
= |
-92 |
* |
(1539 |
/ |
10740) |
= |
-13.18324019 |
11 |
56912 |
2522 |
- |
2628 |
= |
-106 |
* |
(1524 |
/ |
10740) |
= |
-15.04134075 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Val Verde Unified
|
-68 |
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 |
57006 |
2420 |
- |
2436 |
= |
-16 |
* |
(1431 |
/ |
10762) |
= |
-2.12748558 |
4 |
57009 |
2456 |
- |
2485 |
= |
-29 |
* |
(1463 |
/ |
10762) |
= |
-3.94229695 |
5 |
57010 |
2471 |
- |
2528 |
= |
-57 |
* |
(1580 |
/ |
10762) |
= |
-8.36833302 |
6 |
57013 |
2484 |
- |
2552 |
= |
-68 |
* |
(1620 |
/ |
10762) |
= |
-10.23601559 |
7 |
57014 |
2484 |
- |
2567 |
= |
-83 |
* |
(1585 |
/ |
10762) |
= |
-12.22402893 |
8 |
57017 |
2481 |
- |
2586 |
= |
-105 |
* |
(1542 |
/ |
10762) |
= |
-15.04460129 |
11 |
57018 |
2530 |
- |
2628 |
= |
-98 |
* |
(1541 |
/ |
10762) |
= |
-14.0325218 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Val Verde Unified
|
-66 |
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 |
57263 |
2425 |
- |
2436 |
= |
-11 |
* |
(1448 |
/ |
10787) |
= |
-1.47659219 |
4 |
57264 |
2467 |
- |
2485 |
= |
-18 |
* |
(1451 |
/ |
10787) |
= |
-2.42124779 |
5 |
57265 |
2482 |
- |
2528 |
= |
-46 |
* |
(1435 |
/ |
10787) |
= |
-6.11940295 |
6 |
57266 |
2481 |
- |
2552 |
= |
-71 |
* |
(1559 |
/ |
10787) |
= |
-10.26133308 |
7 |
57267 |
2483 |
- |
2567 |
= |
-84 |
* |
(1658 |
/ |
10787) |
= |
-12.91109669 |
8 |
57268 |
2494 |
- |
2586 |
= |
-92 |
* |
(1579 |
/ |
10787) |
= |
-13.46695089 |
11 |
57269 |
2522 |
- |
2628 |
= |
-106 |
* |
(1657 |
/ |
10787) |
= |
-16.28274766 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Val Verde Unified
|
-63 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-67
|
-62
|
-68
|
-66
|
-63
|
-326.0 |
-65.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -59.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -71.2
For the lines, you have the data necessary to plot the chart.