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 |
1747058 |
2396 |
- |
2436 |
= |
-40 |
* |
(724 |
/ |
4937) |
= |
-5.86591044 |
4 |
1747061 |
2435 |
- |
2485 |
= |
-50 |
* |
(764 |
/ |
4937) |
= |
-7.7374924 |
5 |
1747062 |
2452 |
- |
2528 |
= |
-76 |
* |
(749 |
/ |
4937) |
= |
-11.53007894 |
6 |
1747065 |
2466 |
- |
2552 |
= |
-86 |
* |
(676 |
/ |
4937) |
= |
-11.77557219 |
7 |
1747066 |
2453 |
- |
2567 |
= |
-114 |
* |
(695 |
/ |
4937) |
= |
-16.04820739 |
8 |
1747069 |
2458 |
- |
2586 |
= |
-128 |
* |
(742 |
/ |
4937) |
= |
-19.2375936 |
11 |
1747070 |
2515 |
- |
2628 |
= |
-113 |
* |
(587 |
/ |
4937) |
= |
-13.43548711 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Jacinto Unified
|
-86 |
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 |
54303 |
2395 |
- |
2436 |
= |
-41 |
* |
(759 |
/ |
4982) |
= |
-6.24628661 |
4 |
54305 |
2431 |
- |
2485 |
= |
-54 |
* |
(750 |
/ |
4982) |
= |
-8.12926535 |
5 |
54306 |
2457 |
- |
2528 |
= |
-71 |
* |
(781 |
/ |
4982) |
= |
-11.13026892 |
6 |
54308 |
2466 |
- |
2552 |
= |
-86 |
* |
(700 |
/ |
4982) |
= |
-12.08350052 |
7 |
54311 |
2478 |
- |
2567 |
= |
-89 |
* |
(682 |
/ |
4982) |
= |
-12.18346045 |
8 |
54312 |
2488 |
- |
2586 |
= |
-98 |
* |
(681 |
/ |
4982) |
= |
-13.39582492 |
11 |
54315 |
2523 |
- |
2628 |
= |
-105 |
* |
(629 |
/ |
4982) |
= |
-13.25672418 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Jacinto Unified
|
-76 |
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 |
55881 |
2400 |
- |
2436 |
= |
-36 |
* |
(784 |
/ |
5252) |
= |
-5.37395278 |
4 |
55884 |
2428 |
- |
2485 |
= |
-57 |
* |
(769 |
/ |
5252) |
= |
-8.34596343 |
5 |
55885 |
2450 |
- |
2528 |
= |
-78 |
* |
(799 |
/ |
5252) |
= |
-11.86633656 |
6 |
55887 |
2473 |
- |
2552 |
= |
-79 |
* |
(749 |
/ |
5252) |
= |
-11.2663747 |
7 |
55890 |
2467 |
- |
2567 |
= |
-100 |
* |
(717 |
/ |
5252) |
= |
-13.6519421 |
8 |
55892 |
2488 |
- |
2586 |
= |
-98 |
* |
(715 |
/ |
5252) |
= |
-13.34158407 |
11 |
55894 |
2499 |
- |
2628 |
= |
-129 |
* |
(719 |
/ |
5252) |
= |
-17.66012941 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Jacinto Unified
|
-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 |
55984 |
2400 |
- |
2436 |
= |
-36 |
* |
(754 |
/ |
5271) |
= |
-5.14968696 |
4 |
55986 |
2441 |
- |
2485 |
= |
-44 |
* |
(776 |
/ |
5271) |
= |
-6.4777082 |
5 |
55988 |
2458 |
- |
2528 |
= |
-70 |
* |
(765 |
/ |
5271) |
= |
-10.1593625 |
6 |
55990 |
2464 |
- |
2552 |
= |
-88 |
* |
(759 |
/ |
5271) |
= |
-12.67159925 |
7 |
55992 |
2468 |
- |
2567 |
= |
-99 |
* |
(782 |
/ |
5271) |
= |
-14.68753556 |
8 |
55994 |
2468 |
- |
2586 |
= |
-118 |
* |
(734 |
/ |
5271) |
= |
-16.43179653 |
11 |
55996 |
2490 |
- |
2628 |
= |
-138 |
* |
(701 |
/ |
5271) |
= |
-18.3528742 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Jacinto Unified
|
-84 |
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 |
56247 |
2398 |
- |
2436 |
= |
-38 |
* |
(750 |
/ |
5286) |
= |
-5.39160044 |
4 |
56248 |
2430 |
- |
2485 |
= |
-55 |
* |
(770 |
/ |
5286) |
= |
-8.01172906 |
5 |
56249 |
2466 |
- |
2528 |
= |
-62 |
* |
(793 |
/ |
5286) |
= |
-9.30117285 |
6 |
56250 |
2475 |
- |
2552 |
= |
-77 |
* |
(744 |
/ |
5286) |
= |
-10.8376844 |
7 |
56251 |
2478 |
- |
2567 |
= |
-89 |
* |
(772 |
/ |
5286) |
= |
-12.99810815 |
8 |
56252 |
2489 |
- |
2586 |
= |
-97 |
* |
(778 |
/ |
5286) |
= |
-14.2765796 |
11 |
56253 |
2478 |
- |
2628 |
= |
-150 |
* |
(679 |
/ |
5286) |
= |
-19.2678774 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Jacinto Unified
|
-80 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-86
|
-76
|
-82
|
-84
|
-80
|
-408.0 |
-81.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -72.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -90.6
For the lines, you have the data necessary to plot the chart.