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 |
786686 |
2399 |
- |
2436 |
= |
-37 |
* |
(45498 |
/ |
269861) |
= |
-6.23812256 |
4 |
786689 |
2436 |
- |
2485 |
= |
-49 |
* |
(44328 |
/ |
269861) |
= |
-8.04885476 |
5 |
786690 |
2458 |
- |
2528 |
= |
-70 |
* |
(43442 |
/ |
269861) |
= |
-11.2685419 |
6 |
786693 |
2478 |
- |
2552 |
= |
-74 |
* |
(36538 |
/ |
269861) |
= |
-10.01927655 |
7 |
786694 |
2488 |
- |
2567 |
= |
-79 |
* |
(35886 |
/ |
269861) |
= |
-10.50538603 |
8 |
786697 |
2502 |
- |
2586 |
= |
-84 |
* |
(37129 |
/ |
269861) |
= |
-11.55719418 |
11 |
786698 |
2532 |
- |
2628 |
= |
-96 |
* |
(27040 |
/ |
269861) |
= |
-9.61917427 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Los Angeles Unified
|
-67 |
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 |
24557 |
2411 |
- |
2436 |
= |
-25 |
* |
(43846 |
/ |
267596) |
= |
-4.09628693 |
4 |
24558 |
2446 |
- |
2485 |
= |
-39 |
* |
(44504 |
/ |
267596) |
= |
-6.48610591 |
5 |
24560 |
2464 |
- |
2528 |
= |
-64 |
* |
(42901 |
/ |
267596) |
= |
-10.26048218 |
6 |
24563 |
2479 |
- |
2552 |
= |
-73 |
* |
(36387 |
/ |
267596) |
= |
-9.92634786 |
7 |
24564 |
2495 |
- |
2567 |
= |
-72 |
* |
(35869 |
/ |
267596) |
= |
-9.65099621 |
8 |
24566 |
2510 |
- |
2586 |
= |
-76 |
* |
(36080 |
/ |
267596) |
= |
-10.24708889 |
11 |
24568 |
2548 |
- |
2628 |
= |
-80 |
* |
(28009 |
/ |
267596) |
= |
-8.37351824 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Los Angeles Unified
|
-59 |
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 |
25051 |
2415 |
- |
2436 |
= |
-21 |
* |
(42601 |
/ |
262953) |
= |
-3.40220874 |
4 |
25053 |
2446 |
- |
2485 |
= |
-39 |
* |
(42905 |
/ |
262953) |
= |
-6.3634756 |
5 |
25055 |
2466 |
- |
2528 |
= |
-62 |
* |
(43088 |
/ |
262953) |
= |
-10.15944288 |
6 |
25058 |
2482 |
- |
2552 |
= |
-70 |
* |
(35418 |
/ |
262953) |
= |
-9.42852904 |
7 |
25060 |
2495 |
- |
2567 |
= |
-72 |
* |
(35226 |
/ |
262953) |
= |
-9.64534342 |
8 |
25061 |
2508 |
- |
2586 |
= |
-78 |
* |
(35389 |
/ |
262953) |
= |
-10.49747291 |
11 |
25064 |
2543 |
- |
2628 |
= |
-85 |
* |
(28326 |
/ |
262953) |
= |
-9.15642712 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Los Angeles Unified
|
-59 |
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 |
25074 |
2418 |
- |
2436 |
= |
-18 |
* |
(39802 |
/ |
256286) |
= |
-2.79545506 |
4 |
25077 |
2453 |
- |
2485 |
= |
-32 |
* |
(41760 |
/ |
256286) |
= |
-5.21417478 |
5 |
25078 |
2472 |
- |
2528 |
= |
-56 |
* |
(41405 |
/ |
256286) |
= |
-9.04723624 |
6 |
25081 |
2489 |
- |
2552 |
= |
-63 |
* |
(35900 |
/ |
256286) |
= |
-8.8249065 |
7 |
25082 |
2499 |
- |
2567 |
= |
-68 |
* |
(34353 |
/ |
256286) |
= |
-9.11483261 |
8 |
25085 |
2510 |
- |
2586 |
= |
-76 |
* |
(34642 |
/ |
256286) |
= |
-10.27286703 |
11 |
25086 |
2538 |
- |
2628 |
= |
-90 |
* |
(28424 |
/ |
256286) |
= |
-9.98166105 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Los Angeles 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 |
25248 |
2422 |
- |
2436 |
= |
-14 |
* |
(39071 |
/ |
249763) |
= |
-2.19005216 |
4 |
25249 |
2458 |
- |
2485 |
= |
-27 |
* |
(39120 |
/ |
249763) |
= |
-4.22896904 |
5 |
25250 |
2478 |
- |
2528 |
= |
-50 |
* |
(40528 |
/ |
249763) |
= |
-8.1132914 |
6 |
25251 |
2495 |
- |
2552 |
= |
-57 |
* |
(34387 |
/ |
249763) |
= |
-7.84767558 |
7 |
25252 |
2504 |
- |
2567 |
= |
-63 |
* |
(34736 |
/ |
249763) |
= |
-8.76177811 |
8 |
25253 |
2512 |
- |
2586 |
= |
-74 |
* |
(34106 |
/ |
249763) |
= |
-10.10495545 |
11 |
25254 |
2542 |
- |
2628 |
= |
-86 |
* |
(27815 |
/ |
249763) |
= |
-9.57743936 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Los Angeles Unified
|
-51 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-67
|
-59
|
-59
|
-55
|
-51
|
-291.0 |
-58.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -43.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -73.2
For the lines, you have the data necessary to plot the chart.