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 |
2936280 |
2377 |
- |
2436 |
= |
-59 |
* |
(1780 |
/ |
9781) |
= |
-10.73714344 |
4 |
2936281 |
2408 |
- |
2485 |
= |
-77 |
* |
(1715 |
/ |
9781) |
= |
-13.50117569 |
5 |
2936284 |
2434 |
- |
2528 |
= |
-94 |
* |
(1663 |
/ |
9781) |
= |
-15.98221032 |
6 |
2936285 |
2457 |
- |
2552 |
= |
-95 |
* |
(1620 |
/ |
9781) |
= |
-15.73458742 |
7 |
2936288 |
2469 |
- |
2567 |
= |
-98 |
* |
(1496 |
/ |
9781) |
= |
-14.98906041 |
8 |
2936289 |
2492 |
- |
2586 |
= |
-94 |
* |
(1507 |
/ |
9781) |
= |
-14.48297715 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Modesto City Elementary
|
-85 |
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 |
89899 |
2380 |
- |
2436 |
= |
-56 |
* |
(1789 |
/ |
10053) |
= |
-9.96558237 |
4 |
89902 |
2415 |
- |
2485 |
= |
-70 |
* |
(1796 |
/ |
10053) |
= |
-12.50571966 |
5 |
89904 |
2433 |
- |
2528 |
= |
-95 |
* |
(1752 |
/ |
10053) |
= |
-16.55625183 |
6 |
89906 |
2465 |
- |
2552 |
= |
-87 |
* |
(1670 |
/ |
10053) |
= |
-14.45240224 |
7 |
89908 |
2473 |
- |
2567 |
= |
-94 |
* |
(1528 |
/ |
10053) |
= |
-14.28747633 |
8 |
89910 |
2492 |
- |
2586 |
= |
-94 |
* |
(1517 |
/ |
10053) |
= |
-14.18462143 |
11 |
89912 |
0 |
- |
2628 |
= |
|
* |
(1 |
/ |
10053) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Modesto City Elementary
|
-82 |
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 |
92523 |
2385 |
- |
2436 |
= |
-51 |
* |
(1692 |
/ |
10086) |
= |
-8.55562164 |
4 |
92525 |
2419 |
- |
2485 |
= |
-66 |
* |
(1769 |
/ |
10086) |
= |
-11.57584765 |
5 |
92528 |
2438 |
- |
2528 |
= |
-90 |
* |
(1775 |
/ |
10086) |
= |
-15.83878635 |
6 |
92530 |
2463 |
- |
2552 |
= |
-89 |
* |
(1748 |
/ |
10086) |
= |
-15.42454879 |
7 |
92531 |
2471 |
- |
2567 |
= |
-96 |
* |
(1582 |
/ |
10086) |
= |
-15.05770368 |
8 |
92533 |
2484 |
- |
2586 |
= |
-102 |
* |
(1520 |
/ |
10086) |
= |
-15.37180249 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Modesto City Elementary
|
-82 |
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 |
92722 |
2387 |
- |
2436 |
= |
-49 |
* |
(1577 |
/ |
9968) |
= |
-7.75210674 |
4 |
92725 |
2420 |
- |
2485 |
= |
-65 |
* |
(1701 |
/ |
9968) |
= |
-11.09199436 |
5 |
92726 |
2444 |
- |
2528 |
= |
-84 |
* |
(1754 |
/ |
9968) |
= |
-14.7808988 |
6 |
92729 |
2467 |
- |
2552 |
= |
-85 |
* |
(1748 |
/ |
9968) |
= |
-14.90569818 |
7 |
92730 |
2476 |
- |
2567 |
= |
-91 |
* |
(1641 |
/ |
9968) |
= |
-14.98103926 |
8 |
92733 |
2491 |
- |
2586 |
= |
-95 |
* |
(1547 |
/ |
9968) |
= |
-14.74367976 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Modesto City Elementary
|
-78 |
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 |
93360 |
2393 |
- |
2436 |
= |
-43 |
* |
(1639 |
/ |
9850) |
= |
-7.15502538 |
4 |
93361 |
2426 |
- |
2485 |
= |
-59 |
* |
(1563 |
/ |
9850) |
= |
-9.36213198 |
5 |
93362 |
2442 |
- |
2528 |
= |
-86 |
* |
(1673 |
/ |
9850) |
= |
-14.60690349 |
6 |
93363 |
2472 |
- |
2552 |
= |
-80 |
* |
(1738 |
/ |
9850) |
= |
-14.115736 |
7 |
93364 |
2479 |
- |
2567 |
= |
-88 |
* |
(1633 |
/ |
9850) |
= |
-14.58923858 |
8 |
93365 |
2479 |
- |
2586 |
= |
-107 |
* |
(1604 |
/ |
9850) |
= |
-17.42416237 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Modesto City Elementary
|
-77 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-85
|
-82
|
-82
|
-78
|
-77
|
-404.0 |
-80.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -71.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -89.8
For the lines, you have the data necessary to plot the chart.