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 |
2418372 |
2398 |
- |
2436 |
= |
-38 |
* |
(1883 |
/ |
12391) |
= |
-5.77467513 |
4 |
2418373 |
2436 |
- |
2485 |
= |
-49 |
* |
(1795 |
/ |
12391) |
= |
-7.09829714 |
5 |
2418376 |
2453 |
- |
2528 |
= |
-75 |
* |
(1624 |
/ |
12391) |
= |
-9.8297151 |
6 |
2418377 |
2484 |
- |
2552 |
= |
-68 |
* |
(1714 |
/ |
12391) |
= |
-9.40618187 |
7 |
2418380 |
2499 |
- |
2567 |
= |
-68 |
* |
(1781 |
/ |
12391) |
= |
-9.77386807 |
8 |
2418381 |
2530 |
- |
2586 |
= |
-56 |
* |
(1825 |
/ |
12391) |
= |
-8.24792186 |
11 |
2418384 |
2534 |
- |
2628 |
= |
-94 |
* |
(1769 |
/ |
12391) |
= |
-13.41990154 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Manteca Unified
|
-64 |
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 |
73827 |
2404 |
- |
2436 |
= |
-32 |
* |
(1767 |
/ |
12351) |
= |
-4.57809082 |
4 |
73829 |
2436 |
- |
2485 |
= |
-49 |
* |
(1885 |
/ |
12351) |
= |
-7.47834183 |
5 |
73832 |
2461 |
- |
2528 |
= |
-67 |
* |
(1794 |
/ |
12351) |
= |
-9.73184353 |
6 |
73834 |
2485 |
- |
2552 |
= |
-67 |
* |
(1670 |
/ |
12351) |
= |
-9.05918544 |
7 |
73835 |
2503 |
- |
2567 |
= |
-64 |
* |
(1739 |
/ |
12351) |
= |
-9.01109216 |
8 |
73838 |
2523 |
- |
2586 |
= |
-63 |
* |
(1769 |
/ |
12351) |
= |
-9.02331795 |
11 |
73839 |
2543 |
- |
2628 |
= |
-85 |
* |
(1727 |
/ |
12351) |
= |
-11.88527239 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Manteca Unified
|
-61 |
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 |
75804 |
2401 |
- |
2436 |
= |
-35 |
* |
(1695 |
/ |
12491) |
= |
-4.74941957 |
4 |
75807 |
2434 |
- |
2485 |
= |
-51 |
* |
(1769 |
/ |
12491) |
= |
-7.22272032 |
5 |
75808 |
2453 |
- |
2528 |
= |
-75 |
* |
(1917 |
/ |
12491) |
= |
-11.51028735 |
6 |
75811 |
2488 |
- |
2552 |
= |
-64 |
* |
(1818 |
/ |
12491) |
= |
-9.31486669 |
7 |
75813 |
2505 |
- |
2567 |
= |
-62 |
* |
(1697 |
/ |
12491) |
= |
-8.42318465 |
8 |
75815 |
2526 |
- |
2586 |
= |
-60 |
* |
(1782 |
/ |
12491) |
= |
-8.55976302 |
11 |
75817 |
2528 |
- |
2628 |
= |
-100 |
* |
(1813 |
/ |
12491) |
= |
-14.5144504 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Manteca Unified
|
-64 |
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 |
75991 |
2406 |
- |
2436 |
= |
-30 |
* |
(1619 |
/ |
12388) |
= |
-3.92072973 |
4 |
75993 |
2444 |
- |
2485 |
= |
-41 |
* |
(1719 |
/ |
12388) |
= |
-5.68929608 |
5 |
75995 |
2463 |
- |
2528 |
= |
-65 |
* |
(1791 |
/ |
12388) |
= |
-9.39740068 |
6 |
75997 |
2497 |
- |
2552 |
= |
-55 |
* |
(1909 |
/ |
12388) |
= |
-8.47554081 |
7 |
75999 |
2508 |
- |
2567 |
= |
-59 |
* |
(1861 |
/ |
12388) |
= |
-8.86333548 |
8 |
76001 |
2529 |
- |
2586 |
= |
-57 |
* |
(1711 |
/ |
12388) |
= |
-7.87269938 |
11 |
76003 |
2525 |
- |
2628 |
= |
-103 |
* |
(1778 |
/ |
12388) |
= |
-14.78317718 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Manteca Unified
|
-59 |
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 |
76517 |
2414 |
- |
2436 |
= |
-22 |
* |
(1754 |
/ |
12637) |
= |
-3.05357283 |
4 |
76518 |
2446 |
- |
2485 |
= |
-39 |
* |
(1663 |
/ |
12637) |
= |
-5.13230987 |
5 |
76519 |
2465 |
- |
2528 |
= |
-63 |
* |
(1773 |
/ |
12637) |
= |
-8.83904402 |
6 |
76520 |
2490 |
- |
2552 |
= |
-62 |
* |
(1822 |
/ |
12637) |
= |
-8.93914692 |
7 |
76521 |
2514 |
- |
2567 |
= |
-53 |
* |
(1929 |
/ |
12637) |
= |
-8.09029042 |
8 |
76522 |
2528 |
- |
2586 |
= |
-58 |
* |
(1878 |
/ |
12637) |
= |
-8.61945082 |
11 |
76523 |
2532 |
- |
2628 |
= |
-96 |
* |
(1818 |
/ |
12637) |
= |
-13.81087277 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Manteca Unified
|
-56 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-64
|
-61
|
-64
|
-59
|
-56
|
-304.0 |
-60.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -51.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -69.8
For the lines, you have the data necessary to plot the chart.