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 |
2820911 |
2403 |
- |
2436 |
= |
-33 |
* |
(1702 |
/ |
11203) |
= |
-5.0134785 |
4 |
2820914 |
2445 |
- |
2485 |
= |
-40 |
* |
(1707 |
/ |
11203) |
= |
-6.094796 |
5 |
2820915 |
2468 |
- |
2528 |
= |
-60 |
* |
(1688 |
/ |
11203) |
= |
-9.04043556 |
6 |
2820918 |
2493 |
- |
2552 |
= |
-59 |
* |
(1623 |
/ |
11203) |
= |
-8.54744263 |
7 |
2820919 |
2510 |
- |
2567 |
= |
-57 |
* |
(1560 |
/ |
11203) |
= |
-7.93715966 |
8 |
2820922 |
2526 |
- |
2586 |
= |
-60 |
* |
(1530 |
/ |
11203) |
= |
-8.19423366 |
11 |
2820923 |
2552 |
- |
2628 |
= |
-76 |
* |
(1393 |
/ |
11203) |
= |
-9.44996874 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Fairfield-Suisun Unified
|
-54 |
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 |
86363 |
2408 |
- |
2436 |
= |
-28 |
* |
(1666 |
/ |
11378) |
= |
-4.09984179 |
4 |
86364 |
2443 |
- |
2485 |
= |
-42 |
* |
(1713 |
/ |
11378) |
= |
-6.3232554 |
5 |
86366 |
2471 |
- |
2528 |
= |
-57 |
* |
(1742 |
/ |
11378) |
= |
-8.72684125 |
6 |
86369 |
2486 |
- |
2552 |
= |
-66 |
* |
(1686 |
/ |
11378) |
= |
-9.77992613 |
7 |
86370 |
2506 |
- |
2567 |
= |
-61 |
* |
(1606 |
/ |
11378) |
= |
-8.61012475 |
8 |
86372 |
2530 |
- |
2586 |
= |
-56 |
* |
(1534 |
/ |
11378) |
= |
-7.55000876 |
11 |
86374 |
2555 |
- |
2628 |
= |
-73 |
* |
(1431 |
/ |
11378) |
= |
-9.18113897 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Fairfield-Suisun Unified
|
-54 |
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 |
88719 |
2412 |
- |
2436 |
= |
-24 |
* |
(1634 |
/ |
11461) |
= |
-3.42169094 |
4 |
88721 |
2450 |
- |
2485 |
= |
-35 |
* |
(1692 |
/ |
11461) |
= |
-5.16708836 |
5 |
88722 |
2479 |
- |
2528 |
= |
-49 |
* |
(1722 |
/ |
11461) |
= |
-7.36218478 |
6 |
88725 |
2487 |
- |
2552 |
= |
-65 |
* |
(1715 |
/ |
11461) |
= |
-9.72646363 |
7 |
88726 |
2497 |
- |
2567 |
= |
-70 |
* |
(1630 |
/ |
11461) |
= |
-9.95550122 |
8 |
88729 |
2519 |
- |
2586 |
= |
-67 |
* |
(1594 |
/ |
11461) |
= |
-9.31838405 |
11 |
88731 |
2544 |
- |
2628 |
= |
-84 |
* |
(1474 |
/ |
11461) |
= |
-10.80324571 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Fairfield-Suisun Unified
|
-56 |
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 |
88946 |
2413 |
- |
2436 |
= |
-23 |
* |
(1496 |
/ |
11374) |
= |
-3.02514506 |
4 |
88947 |
2458 |
- |
2485 |
= |
-27 |
* |
(1662 |
/ |
11374) |
= |
-3.94531387 |
5 |
88950 |
2484 |
- |
2528 |
= |
-44 |
* |
(1703 |
/ |
11374) |
= |
-6.58800771 |
6 |
88951 |
2488 |
- |
2552 |
= |
-64 |
* |
(1708 |
/ |
11374) |
= |
-9.61069101 |
7 |
88954 |
2500 |
- |
2567 |
= |
-67 |
* |
(1704 |
/ |
11374) |
= |
-10.03762966 |
8 |
88955 |
2516 |
- |
2586 |
= |
-70 |
* |
(1634 |
/ |
11374) |
= |
-10.05626867 |
11 |
88958 |
2531 |
- |
2628 |
= |
-97 |
* |
(1467 |
/ |
11374) |
= |
-12.51090199 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Fairfield-Suisun Unified
|
-56 |
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 |
89560 |
2422 |
- |
2436 |
= |
-14 |
* |
(1640 |
/ |
11234) |
= |
-2.04379561 |
4 |
89561 |
2461 |
- |
2485 |
= |
-24 |
* |
(1499 |
/ |
11234) |
= |
-3.20242121 |
5 |
89562 |
2488 |
- |
2528 |
= |
-40 |
* |
(1667 |
/ |
11234) |
= |
-5.93555276 |
6 |
89563 |
2486 |
- |
2552 |
= |
-66 |
* |
(1672 |
/ |
11234) |
= |
-9.8230372 |
7 |
89564 |
2503 |
- |
2567 |
= |
-64 |
* |
(1667 |
/ |
11234) |
= |
-9.49688442 |
8 |
89565 |
2516 |
- |
2586 |
= |
-70 |
* |
(1682 |
/ |
11234) |
= |
-10.48068357 |
11 |
89566 |
2534 |
- |
2628 |
= |
-94 |
* |
(1407 |
/ |
11234) |
= |
-11.77301045 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Fairfield-Suisun Unified
|
-53 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-54
|
-54
|
-56
|
-56
|
-53
|
-273.0 |
-54.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -51.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -57.6
For the lines, you have the data necessary to plot the chart.