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 |
672693 |
2429 |
- |
2436 |
= |
-7 |
* |
(1474 |
/ |
11788) |
= |
-0.87529691 |
4 |
672694 |
2461 |
- |
2485 |
= |
-24 |
* |
(1492 |
/ |
11788) |
= |
-3.03766541 |
5 |
672697 |
2478 |
- |
2528 |
= |
-50 |
* |
(1507 |
/ |
11788) |
= |
-6.39209365 |
6 |
672698 |
2499 |
- |
2552 |
= |
-53 |
* |
(1723 |
/ |
11788) |
= |
-7.74677638 |
7 |
672701 |
2508 |
- |
2567 |
= |
-59 |
* |
(1790 |
/ |
11788) |
= |
-8.95911094 |
8 |
672702 |
2527 |
- |
2586 |
= |
-59 |
* |
(1850 |
/ |
11788) |
= |
-9.25941634 |
11 |
672705 |
2548 |
- |
2628 |
= |
-80 |
* |
(1952 |
/ |
11788) |
= |
-13.24737016 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Downey Unified
|
-50 |
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 |
21300 |
2440 |
- |
2436 |
= |
4 |
* |
(1458 |
/ |
11836) |
= |
0.49273403 |
4 |
21301 |
2472 |
- |
2485 |
= |
-13 |
* |
(1526 |
/ |
11836) |
= |
-1.676073 |
5 |
21303 |
2489 |
- |
2528 |
= |
-39 |
* |
(1530 |
/ |
11836) |
= |
-5.04139912 |
6 |
21305 |
2512 |
- |
2552 |
= |
-40 |
* |
(1634 |
/ |
11836) |
= |
-5.52213584 |
7 |
21307 |
2522 |
- |
2567 |
= |
-45 |
* |
(1801 |
/ |
11836) |
= |
-6.84733014 |
8 |
21310 |
2526 |
- |
2586 |
= |
-60 |
* |
(1815 |
/ |
11836) |
= |
-9.20074344 |
11 |
21312 |
2565 |
- |
2628 |
= |
-63 |
* |
(2072 |
/ |
11836) |
= |
-11.02872588 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Downey Unified
|
-39 |
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 |
21686 |
2439 |
- |
2436 |
= |
3 |
* |
(1455 |
/ |
11635) |
= |
0.37516115 |
4 |
21687 |
2472 |
- |
2485 |
= |
-13 |
* |
(1496 |
/ |
11635) |
= |
-1.67150837 |
5 |
21690 |
2494 |
- |
2528 |
= |
-34 |
* |
(1523 |
/ |
11635) |
= |
-4.45053717 |
6 |
21691 |
2512 |
- |
2552 |
= |
-40 |
* |
(1667 |
/ |
11635) |
= |
-5.73098408 |
7 |
21694 |
2523 |
- |
2567 |
= |
-44 |
* |
(1727 |
/ |
11635) |
= |
-6.53098406 |
8 |
21695 |
2528 |
- |
2586 |
= |
-58 |
* |
(1787 |
/ |
11635) |
= |
-8.90812204 |
11 |
21698 |
2561 |
- |
2628 |
= |
-67 |
* |
(1980 |
/ |
11635) |
= |
-11.40180486 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Downey Unified
|
-38 |
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 |
21660 |
2442 |
- |
2436 |
= |
6 |
* |
(1310 |
/ |
11405) |
= |
0.68917141 |
4 |
21663 |
2481 |
- |
2485 |
= |
-4 |
* |
(1475 |
/ |
11405) |
= |
-0.51731696 |
5 |
21664 |
2495 |
- |
2528 |
= |
-33 |
* |
(1526 |
/ |
11405) |
= |
-4.41543181 |
6 |
21667 |
2520 |
- |
2552 |
= |
-32 |
* |
(1611 |
/ |
11405) |
= |
-4.52012275 |
7 |
21668 |
2522 |
- |
2567 |
= |
-45 |
* |
(1728 |
/ |
11405) |
= |
-6.81806223 |
8 |
21671 |
2536 |
- |
2586 |
= |
-50 |
* |
(1753 |
/ |
11405) |
= |
-7.68522575 |
11 |
21672 |
2548 |
- |
2628 |
= |
-80 |
* |
(2002 |
/ |
11405) |
= |
-14.0429636 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Downey Unified
|
-37 |
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 |
21834 |
2445 |
- |
2436 |
= |
9 |
* |
(1442 |
/ |
11262) |
= |
1.1523708 |
4 |
21835 |
2482 |
- |
2485 |
= |
-3 |
* |
(1350 |
/ |
11262) |
= |
-0.35961641 |
5 |
21836 |
2512 |
- |
2528 |
= |
-16 |
* |
(1519 |
/ |
11262) |
= |
-2.15805362 |
6 |
21837 |
2516 |
- |
2552 |
= |
-36 |
* |
(1617 |
/ |
11262) |
= |
-5.16888652 |
7 |
21838 |
2529 |
- |
2567 |
= |
-38 |
* |
(1675 |
/ |
11262) |
= |
-5.65174923 |
8 |
21839 |
2540 |
- |
2586 |
= |
-46 |
* |
(1740 |
/ |
11262) |
= |
-7.10708574 |
11 |
21840 |
2552 |
- |
2628 |
= |
-76 |
* |
(1919 |
/ |
11262) |
= |
-12.95009767 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Downey Unified
|
-32 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-50
|
-39
|
-38
|
-37
|
-32
|
-196.0 |
-39.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -21.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -57.2
For the lines, you have the data necessary to plot the chart.