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 |
2019043 |
2432 |
- |
2436 |
= |
-4 |
* |
(1507 |
/ |
10655) |
= |
-0.56574378 |
4 |
2019044 |
2471 |
- |
2485 |
= |
-14 |
* |
(1458 |
/ |
10655) |
= |
-1.91572031 |
5 |
2019047 |
2495 |
- |
2528 |
= |
-33 |
* |
(1462 |
/ |
10655) |
= |
-4.52801501 |
6 |
2019048 |
2516 |
- |
2552 |
= |
-36 |
* |
(1498 |
/ |
10655) |
= |
-5.06128576 |
7 |
2019051 |
2526 |
- |
2567 |
= |
-41 |
* |
(1523 |
/ |
10655) |
= |
-5.86044107 |
8 |
2019052 |
2567 |
- |
2586 |
= |
-19 |
* |
(1558 |
/ |
10655) |
= |
-2.77822617 |
11 |
2019055 |
2582 |
- |
2628 |
= |
-46 |
* |
(1649 |
/ |
10655) |
= |
-7.11909901 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Redlands Unified
|
-28 |
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 |
62092 |
2448 |
- |
2436 |
= |
12 |
* |
(1474 |
/ |
10738) |
= |
1.64723412 |
4 |
62095 |
2486 |
- |
2485 |
= |
1 |
* |
(1549 |
/ |
10738) |
= |
0.14425405 |
5 |
62097 |
2503 |
- |
2528 |
= |
-25 |
* |
(1491 |
/ |
10738) |
= |
-3.4713168 |
6 |
62098 |
2518 |
- |
2552 |
= |
-34 |
* |
(1454 |
/ |
10738) |
= |
-4.60383681 |
7 |
62101 |
2539 |
- |
2567 |
= |
-28 |
* |
(1555 |
/ |
10738) |
= |
-4.05475879 |
8 |
62102 |
2556 |
- |
2586 |
= |
-30 |
* |
(1545 |
/ |
10738) |
= |
-4.31644626 |
11 |
62105 |
2588 |
- |
2628 |
= |
-40 |
* |
(1670 |
/ |
10738) |
= |
-6.22089772 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Redlands Unified
|
-21 |
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 |
63878 |
2440 |
- |
2436 |
= |
4 |
* |
(1515 |
/ |
10838) |
= |
0.55914375 |
4 |
63881 |
2488 |
- |
2485 |
= |
3 |
* |
(1521 |
/ |
10838) |
= |
0.42101864 |
5 |
63883 |
2506 |
- |
2528 |
= |
-22 |
* |
(1611 |
/ |
10838) |
= |
-3.27016054 |
6 |
63885 |
2520 |
- |
2552 |
= |
-32 |
* |
(1494 |
/ |
10838) |
= |
-4.41114595 |
7 |
63886 |
2531 |
- |
2567 |
= |
-36 |
* |
(1479 |
/ |
10838) |
= |
-4.91271451 |
8 |
63889 |
2555 |
- |
2586 |
= |
-31 |
* |
(1564 |
/ |
10838) |
= |
-4.47351908 |
11 |
63891 |
2599 |
- |
2628 |
= |
-29 |
* |
(1654 |
/ |
10838) |
= |
-4.42572428 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Redlands Unified
|
-21 |
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 |
63983 |
2448 |
- |
2436 |
= |
12 |
* |
(1499 |
/ |
10799) |
= |
1.66570978 |
4 |
63985 |
2482 |
- |
2485 |
= |
-3 |
* |
(1533 |
/ |
10799) |
= |
-0.42587276 |
5 |
63987 |
2510 |
- |
2528 |
= |
-18 |
* |
(1538 |
/ |
10799) |
= |
-2.56357069 |
6 |
63989 |
2524 |
- |
2552 |
= |
-28 |
* |
(1586 |
/ |
10799) |
= |
-4.1122326 |
7 |
63991 |
2539 |
- |
2567 |
= |
-28 |
* |
(1527 |
/ |
10799) |
= |
-3.95925547 |
8 |
63993 |
2543 |
- |
2586 |
= |
-43 |
* |
(1469 |
/ |
10799) |
= |
-5.84933786 |
11 |
63995 |
2605 |
- |
2628 |
= |
-23 |
* |
(1647 |
/ |
10799) |
= |
-3.50782478 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Redlands Unified
|
-19 |
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 |
64355 |
2438 |
- |
2436 |
= |
2 |
* |
(1523 |
/ |
10834) |
= |
0.28115193 |
4 |
64356 |
2485 |
- |
2485 |
= |
0 |
* |
(1525 |
/ |
10834) |
= |
0.0 |
5 |
64357 |
2499 |
- |
2528 |
= |
-29 |
* |
(1570 |
/ |
10834) |
= |
-4.20251061 |
6 |
64358 |
2527 |
- |
2552 |
= |
-25 |
* |
(1534 |
/ |
10834) |
= |
-3.53978215 |
7 |
64359 |
2536 |
- |
2567 |
= |
-31 |
* |
(1580 |
/ |
10834) |
= |
-4.52095255 |
8 |
64360 |
2540 |
- |
2586 |
= |
-46 |
* |
(1540 |
/ |
10834) |
= |
-6.53867451 |
11 |
64361 |
2599 |
- |
2628 |
= |
-29 |
* |
(1562 |
/ |
10834) |
= |
-4.18109655 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Redlands Unified
|
-23 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-28
|
-21
|
-21
|
-19
|
-23
|
-112.0 |
-22.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -13.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -31.4
For the lines, you have the data necessary to plot the chart.