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 |
2292168 |
2404 |
- |
2436 |
= |
-32 |
* |
(549 |
/ |
3232) |
= |
-5.43564355 |
4 |
2292169 |
2424 |
- |
2485 |
= |
-61 |
* |
(560 |
/ |
3232) |
= |
-10.56930689 |
5 |
2292172 |
2457 |
- |
2528 |
= |
-71 |
* |
(510 |
/ |
3232) |
= |
-11.20358906 |
6 |
2292173 |
2478 |
- |
2552 |
= |
-74 |
* |
(555 |
/ |
3232) |
= |
-12.70730198 |
7 |
2292176 |
2468 |
- |
2567 |
= |
-99 |
* |
(470 |
/ |
3232) |
= |
-14.39665841 |
8 |
2292177 |
2504 |
- |
2586 |
= |
-82 |
* |
(588 |
/ |
3232) |
= |
-14.91831683 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Ysidro Elementary
|
-69 |
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 |
70200 |
2415 |
- |
2436 |
= |
-21 |
* |
(552 |
/ |
3219) |
= |
-3.60111835 |
4 |
70201 |
2426 |
- |
2485 |
= |
-59 |
* |
(566 |
/ |
3219) |
= |
-10.37402918 |
5 |
70204 |
2458 |
- |
2528 |
= |
-70 |
* |
(577 |
/ |
3219) |
= |
-12.54737491 |
6 |
70206 |
2499 |
- |
2552 |
= |
-53 |
* |
(519 |
/ |
3219) |
= |
-8.54520034 |
7 |
70208 |
2492 |
- |
2567 |
= |
-75 |
* |
(524 |
/ |
3219) |
= |
-12.20876048 |
8 |
70210 |
2497 |
- |
2586 |
= |
-89 |
* |
(481 |
/ |
3219) |
= |
-13.29885054 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Ysidro Elementary
|
-61 |
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 |
72048 |
2420 |
- |
2436 |
= |
-16 |
* |
(514 |
/ |
3247) |
= |
-2.5327995 |
4 |
72050 |
2422 |
- |
2485 |
= |
-63 |
* |
(553 |
/ |
3247) |
= |
-10.72959653 |
5 |
72053 |
2456 |
- |
2528 |
= |
-72 |
* |
(569 |
/ |
3247) |
= |
-12.61718503 |
6 |
72054 |
2484 |
- |
2552 |
= |
-68 |
* |
(573 |
/ |
3247) |
= |
-11.99999998 |
7 |
72056 |
2501 |
- |
2567 |
= |
-66 |
* |
(505 |
/ |
3247) |
= |
-10.26485981 |
8 |
72058 |
2504 |
- |
2586 |
= |
-82 |
* |
(533 |
/ |
3247) |
= |
-13.46042497 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Ysidro Elementary
|
-62 |
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 |
72187 |
2408 |
- |
2436 |
= |
-28 |
* |
(480 |
/ |
3151) |
= |
-4.26531258 |
4 |
72190 |
2435 |
- |
2485 |
= |
-50 |
* |
(531 |
/ |
3151) |
= |
-8.4258965 |
5 |
72191 |
2473 |
- |
2528 |
= |
-55 |
* |
(534 |
/ |
3151) |
= |
-9.3208505 |
6 |
72194 |
2488 |
- |
2552 |
= |
-64 |
* |
(562 |
/ |
3151) |
= |
-11.41478893 |
7 |
72195 |
2480 |
- |
2567 |
= |
-87 |
* |
(533 |
/ |
3151) |
= |
-14.71628046 |
8 |
72198 |
2520 |
- |
2586 |
= |
-66 |
* |
(511 |
/ |
3151) |
= |
-10.70326877 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Ysidro Elementary
|
-59 |
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 |
72682 |
2426 |
- |
2436 |
= |
-10 |
* |
(491 |
/ |
3049) |
= |
-1.61036405 |
4 |
72683 |
2447 |
- |
2485 |
= |
-38 |
* |
(456 |
/ |
3049) |
= |
-5.68317478 |
5 |
72684 |
2475 |
- |
2528 |
= |
-53 |
* |
(520 |
/ |
3049) |
= |
-9.03902916 |
6 |
72685 |
2502 |
- |
2552 |
= |
-50 |
* |
(545 |
/ |
3049) |
= |
-8.9373565 |
7 |
72686 |
2473 |
- |
2567 |
= |
-94 |
* |
(507 |
/ |
3049) |
= |
-15.63069854 |
8 |
72687 |
2501 |
- |
2586 |
= |
-85 |
* |
(530 |
/ |
3049) |
= |
-14.77533614 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Ysidro Elementary
|
-56 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-69
|
-61
|
-62
|
-59
|
-56
|
-307.0 |
-61.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -49.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -73.4
For the lines, you have the data necessary to plot the chart.