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 |
565892 |
2334 |
- |
2436 |
= |
-102 |
* |
(32 |
/ |
202) |
= |
-16.15841578 |
4 |
565895 |
2369 |
- |
2485 |
= |
-116 |
* |
(35 |
/ |
202) |
= |
-20.09900982 |
5 |
565896 |
2423 |
- |
2528 |
= |
-105 |
* |
(29 |
/ |
202) |
= |
-15.07425738 |
6 |
565899 |
2417 |
- |
2552 |
= |
-135 |
* |
(45 |
/ |
202) |
= |
-30.0742574 |
7 |
565900 |
2524 |
- |
2567 |
= |
-43 |
* |
(29 |
/ |
202) |
= |
-6.17326731 |
8 |
565903 |
2550 |
- |
2586 |
= |
-36 |
* |
(32 |
/ |
202) |
= |
-5.70297028 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lakeside Union Elementary
|
-93 |
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 |
17997 |
2389 |
- |
2436 |
= |
-47 |
* |
(29 |
/ |
202) |
= |
-6.74752473 |
4 |
17999 |
2374 |
- |
2485 |
= |
-111 |
* |
(39 |
/ |
202) |
= |
-21.43069297 |
5 |
18000 |
2415 |
- |
2528 |
= |
-113 |
* |
(32 |
/ |
202) |
= |
-17.90099003 |
6 |
18003 |
2472 |
- |
2552 |
= |
-80 |
* |
(32 |
/ |
202) |
= |
-12.67326728 |
7 |
18004 |
2489 |
- |
2567 |
= |
-78 |
* |
(39 |
/ |
202) |
= |
-15.05940587 |
8 |
18007 |
2539 |
- |
2586 |
= |
-47 |
* |
(31 |
/ |
202) |
= |
-7.21287126 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lakeside Union Elementary
|
-81 |
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 |
18330 |
2395 |
- |
2436 |
= |
-41 |
* |
(45 |
/ |
224) |
= |
-8.23660714 |
4 |
18333 |
2397 |
- |
2485 |
= |
-88 |
* |
(29 |
/ |
224) |
= |
-11.39285708 |
5 |
18334 |
2404 |
- |
2528 |
= |
-124 |
* |
(41 |
/ |
224) |
= |
-22.69642854 |
6 |
18336 |
2465 |
- |
2552 |
= |
-87 |
* |
(29 |
/ |
224) |
= |
-11.2633928 |
7 |
18339 |
2528 |
- |
2567 |
= |
-39 |
* |
(34 |
/ |
224) |
= |
-5.91964285 |
8 |
18341 |
2495 |
- |
2586 |
= |
-91 |
* |
(46 |
/ |
224) |
= |
-18.68749992 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lakeside Union Elementary
|
-78 |
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 |
18359 |
2378 |
- |
2436 |
= |
-58 |
* |
(39 |
/ |
213) |
= |
-10.61971828 |
4 |
18362 |
2406 |
- |
2485 |
= |
-79 |
* |
(44 |
/ |
213) |
= |
-16.31924875 |
5 |
18363 |
2430 |
- |
2528 |
= |
-98 |
* |
(28 |
/ |
213) |
= |
-12.8826291 |
6 |
18366 |
2454 |
- |
2552 |
= |
-98 |
* |
(45 |
/ |
213) |
= |
-20.70422529 |
7 |
18367 |
2463 |
- |
2567 |
= |
-104 |
* |
(26 |
/ |
213) |
= |
-12.69483561 |
8 |
18370 |
2623 |
- |
2586 |
= |
37 |
* |
(31 |
/ |
213) |
= |
5.38497652 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lakeside Union Elementary
|
-68 |
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 |
18503 |
2413 |
- |
2436 |
= |
-23 |
* |
(32 |
/ |
210) |
= |
-3.5047619 |
4 |
18504 |
2417 |
- |
2485 |
= |
-68 |
* |
(38 |
/ |
210) |
= |
-12.30476184 |
5 |
18505 |
2436 |
- |
2528 |
= |
-92 |
* |
(42 |
/ |
210) |
= |
-18.4 |
6 |
18506 |
2444 |
- |
2552 |
= |
-108 |
* |
(27 |
/ |
210) |
= |
-13.88571422 |
7 |
18507 |
2464 |
- |
2567 |
= |
-103 |
* |
(48 |
/ |
210) |
= |
-23.54285708 |
8 |
18508 |
2490 |
- |
2586 |
= |
-96 |
* |
(23 |
/ |
210) |
= |
-10.51428566 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lakeside Union Elementary
|
-82 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-93
|
-81
|
-78
|
-68
|
-82
|
-402.0 |
-80.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -56.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -104.4
For the lines, you have the data necessary to plot the chart.