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 |
1965863 |
2386 |
- |
2436 |
= |
-50 |
* |
(1858 |
/ |
12533) |
= |
-7.41243115 |
4 |
1965866 |
2418 |
- |
2485 |
= |
-67 |
* |
(1829 |
/ |
12533) |
= |
-9.77762704 |
5 |
1965867 |
2441 |
- |
2528 |
= |
-87 |
* |
(1798 |
/ |
12533) |
= |
-12.48112979 |
6 |
1965870 |
2472 |
- |
2552 |
= |
-80 |
* |
(1891 |
/ |
12533) |
= |
-12.07053376 |
7 |
1965871 |
2477 |
- |
2567 |
= |
-90 |
* |
(1862 |
/ |
12533) |
= |
-13.37110029 |
8 |
1965874 |
2501 |
- |
2586 |
= |
-85 |
* |
(1817 |
/ |
12533) |
= |
-12.3230671 |
11 |
1965875 |
2507 |
- |
2628 |
= |
-121 |
* |
(1478 |
/ |
12533) |
= |
-14.26936883 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Colton Joint Unified
|
-82 |
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 |
60508 |
2393 |
- |
2436 |
= |
-43 |
* |
(1819 |
/ |
12556) |
= |
-6.22945205 |
4 |
60511 |
2426 |
- |
2485 |
= |
-59 |
* |
(1866 |
/ |
12556) |
= |
-8.76823827 |
5 |
60513 |
2447 |
- |
2528 |
= |
-81 |
* |
(1849 |
/ |
12556) |
= |
-11.92808211 |
6 |
60515 |
2471 |
- |
2552 |
= |
-81 |
* |
(1802 |
/ |
12556) |
= |
-11.62488048 |
7 |
60516 |
2473 |
- |
2567 |
= |
-94 |
* |
(1878 |
/ |
12556) |
= |
-14.05957304 |
8 |
60519 |
2497 |
- |
2586 |
= |
-89 |
* |
(1834 |
/ |
12556) |
= |
-12.99984063 |
11 |
60520 |
2511 |
- |
2628 |
= |
-117 |
* |
(1508 |
/ |
12556) |
= |
-14.05192733 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Colton Joint Unified
|
-80 |
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 |
62256 |
2407 |
- |
2436 |
= |
-29 |
* |
(1568 |
/ |
12190) |
= |
-3.7302707 |
4 |
62259 |
2428 |
- |
2485 |
= |
-57 |
* |
(1804 |
/ |
12190) |
= |
-8.43543884 |
5 |
62261 |
2457 |
- |
2528 |
= |
-71 |
* |
(1856 |
/ |
12190) |
= |
-10.81017224 |
6 |
62263 |
2481 |
- |
2552 |
= |
-71 |
* |
(1816 |
/ |
12190) |
= |
-10.5771944 |
7 |
62265 |
2482 |
- |
2567 |
= |
-85 |
* |
(1764 |
/ |
12190) |
= |
-12.30024605 |
8 |
62267 |
2486 |
- |
2586 |
= |
-100 |
* |
(1832 |
/ |
12190) |
= |
-15.028712 |
11 |
62269 |
2508 |
- |
2628 |
= |
-120 |
* |
(1550 |
/ |
12190) |
= |
-15.25840848 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Colton Joint Unified
|
-76 |
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 |
62337 |
2413 |
- |
2436 |
= |
-23 |
* |
(1689 |
/ |
11987) |
= |
-3.24076081 |
4 |
62339 |
2436 |
- |
2485 |
= |
-49 |
* |
(1543 |
/ |
11987) |
= |
-6.30741637 |
5 |
62341 |
2453 |
- |
2528 |
= |
-75 |
* |
(1806 |
/ |
11987) |
= |
-11.29974135 |
6 |
62343 |
2484 |
- |
2552 |
= |
-68 |
* |
(1880 |
/ |
11987) |
= |
-10.6648869 |
7 |
62345 |
2475 |
- |
2567 |
= |
-92 |
* |
(1791 |
/ |
11987) |
= |
-13.7458913 |
8 |
62347 |
2482 |
- |
2586 |
= |
-104 |
* |
(1759 |
/ |
11987) |
= |
-15.26119962 |
11 |
62349 |
2518 |
- |
2628 |
= |
-110 |
* |
(1519 |
/ |
11987) |
= |
-13.93926743 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Colton Joint Unified
|
-74 |
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 |
62619 |
2416 |
- |
2436 |
= |
-20 |
* |
(1625 |
/ |
11633) |
= |
-2.79377632 |
4 |
62620 |
2446 |
- |
2485 |
= |
-39 |
* |
(1649 |
/ |
11633) |
= |
-5.52832457 |
5 |
62621 |
2465 |
- |
2528 |
= |
-63 |
* |
(1522 |
/ |
11633) |
= |
-8.24258572 |
6 |
62622 |
2483 |
- |
2552 |
= |
-69 |
* |
(1822 |
/ |
11633) |
= |
-10.80701446 |
7 |
62623 |
2478 |
- |
2567 |
= |
-89 |
* |
(1808 |
/ |
11633) |
= |
-13.83237341 |
8 |
62624 |
2473 |
- |
2586 |
= |
-113 |
* |
(1725 |
/ |
11633) |
= |
-16.75621076 |
11 |
62625 |
2505 |
- |
2628 |
= |
-123 |
* |
(1482 |
/ |
11633) |
= |
-15.6697326 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Colton Joint Unified
|
-74 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-82
|
-80
|
-76
|
-74
|
-74
|
-386.0 |
-77.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -68.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -86.2
For the lines, you have the data necessary to plot the chart.