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 |
3060583 |
2407 |
- |
2436 |
= |
-29 |
* |
(2139 |
/ |
14739) |
= |
-4.20863016 |
4 |
3060584 |
2442 |
- |
2485 |
= |
-43 |
* |
(2201 |
/ |
14739) |
= |
-6.42126332 |
5 |
3060587 |
2468 |
- |
2528 |
= |
-60 |
* |
(2197 |
/ |
14739) |
= |
-8.94361896 |
6 |
3060588 |
2498 |
- |
2552 |
= |
-54 |
* |
(2099 |
/ |
14739) |
= |
-7.69020961 |
7 |
3060591 |
2506 |
- |
2567 |
= |
-61 |
* |
(2055 |
/ |
14739) |
= |
-8.50498673 |
8 |
3060592 |
2529 |
- |
2586 |
= |
-57 |
* |
(2117 |
/ |
14739) |
= |
-8.18705472 |
11 |
3060595 |
2539 |
- |
2628 |
= |
-89 |
* |
(1931 |
/ |
14739) |
= |
-11.66015326 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Visalia Unified
|
-56 |
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 |
94227 |
2410 |
- |
2436 |
= |
-26 |
* |
(2172 |
/ |
14923) |
= |
-3.78422567 |
4 |
94229 |
2449 |
- |
2485 |
= |
-36 |
* |
(2167 |
/ |
14923) |
= |
-5.22763517 |
5 |
94232 |
2474 |
- |
2528 |
= |
-54 |
* |
(2230 |
/ |
14923) |
= |
-8.06942299 |
6 |
94233 |
2497 |
- |
2552 |
= |
-55 |
* |
(2216 |
/ |
14923) |
= |
-8.16725855 |
7 |
94236 |
2512 |
- |
2567 |
= |
-55 |
* |
(2078 |
/ |
14923) |
= |
-7.6586477 |
8 |
94238 |
2551 |
- |
2586 |
= |
-35 |
* |
(2048 |
/ |
14923) |
= |
-4.8033237 |
11 |
94239 |
2546 |
- |
2628 |
= |
-82 |
* |
(2012 |
/ |
14923) |
= |
-11.05568583 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Visalia Unified
|
-49 |
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 |
97001 |
2412 |
- |
2436 |
= |
-24 |
* |
(2123 |
/ |
15029) |
= |
-3.39024552 |
4 |
97003 |
2444 |
- |
2485 |
= |
-41 |
* |
(2201 |
/ |
15029) |
= |
-6.00445804 |
5 |
97006 |
2471 |
- |
2528 |
= |
-57 |
* |
(2186 |
/ |
15029) |
= |
-8.29077113 |
6 |
97008 |
2493 |
- |
2552 |
= |
-59 |
* |
(2234 |
/ |
15029) |
= |
-8.77011111 |
7 |
97010 |
2506 |
- |
2567 |
= |
-61 |
* |
(2185 |
/ |
15029) |
= |
-8.86852081 |
8 |
97012 |
2536 |
- |
2586 |
= |
-50 |
* |
(2095 |
/ |
15029) |
= |
-6.96985825 |
11 |
97014 |
2537 |
- |
2628 |
= |
-91 |
* |
(2005 |
/ |
15029) |
= |
-12.14019561 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Visalia Unified
|
-54 |
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 |
97180 |
2418 |
- |
2436 |
= |
-18 |
* |
(2130 |
/ |
15270) |
= |
-2.51080549 |
4 |
97183 |
2446 |
- |
2485 |
= |
-39 |
* |
(2152 |
/ |
15270) |
= |
-5.49626715 |
5 |
97184 |
2466 |
- |
2528 |
= |
-62 |
* |
(2230 |
/ |
15270) |
= |
-9.05435488 |
6 |
97187 |
2497 |
- |
2552 |
= |
-55 |
* |
(2210 |
/ |
15270) |
= |
-7.96005238 |
7 |
97188 |
2509 |
- |
2567 |
= |
-58 |
* |
(2214 |
/ |
15270) |
= |
-8.40943021 |
8 |
97191 |
2530 |
- |
2586 |
= |
-56 |
* |
(2204 |
/ |
15270) |
= |
-8.08277663 |
11 |
97192 |
2532 |
- |
2628 |
= |
-96 |
* |
(2130 |
/ |
15270) |
= |
-13.39096262 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Visalia Unified
|
-55 |
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 |
97850 |
2415 |
- |
2436 |
= |
-21 |
* |
(2174 |
/ |
15145) |
= |
-3.0144602 |
4 |
97851 |
2459 |
- |
2485 |
= |
-26 |
* |
(2145 |
/ |
15145) |
= |
-3.68240343 |
5 |
97852 |
2481 |
- |
2528 |
= |
-47 |
* |
(2157 |
/ |
15145) |
= |
-6.69389233 |
6 |
97853 |
2499 |
- |
2552 |
= |
-53 |
* |
(2227 |
/ |
15145) |
= |
-7.79339714 |
7 |
97854 |
2507 |
- |
2567 |
= |
-60 |
* |
(2186 |
/ |
15145) |
= |
-8.6602839 |
8 |
97855 |
2534 |
- |
2586 |
= |
-52 |
* |
(2204 |
/ |
15145) |
= |
-7.56738195 |
11 |
97856 |
2552 |
- |
2628 |
= |
-76 |
* |
(2052 |
/ |
15145) |
= |
-10.29725976 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Visalia Unified
|
-48 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-56
|
-49
|
-54
|
-55
|
-48
|
-262.0 |
-52.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -43.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -61.4
For the lines, you have the data necessary to plot the chart.