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 |
370092 |
2368 |
- |
2436 |
= |
-68 |
* |
(48 |
/ |
350) |
= |
-9.32571428 |
4 |
370095 |
2430 |
- |
2485 |
= |
-55 |
* |
(42 |
/ |
350) |
= |
-6.6 |
5 |
370096 |
2417 |
- |
2528 |
= |
-111 |
* |
(43 |
/ |
350) |
= |
-13.63714276 |
6 |
370099 |
2463 |
- |
2552 |
= |
-89 |
* |
(44 |
/ |
350) |
= |
-11.18857137 |
7 |
370100 |
2505 |
- |
2567 |
= |
-62 |
* |
(54 |
/ |
350) |
= |
-9.56571427 |
8 |
370103 |
2468 |
- |
2586 |
= |
-118 |
* |
(43 |
/ |
350) |
= |
-14.49714276 |
11 |
370104 |
2436 |
- |
2628 |
= |
-192 |
* |
(76 |
/ |
350) |
= |
-41.69142854 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for West Park Elementary
|
-107 |
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 |
11184 |
2413 |
- |
2436 |
= |
-23 |
* |
(37 |
/ |
374) |
= |
-2.27540106 |
4 |
11185 |
2394 |
- |
2485 |
= |
-91 |
* |
(47 |
/ |
374) |
= |
-11.43582886 |
5 |
11187 |
2442 |
- |
2528 |
= |
-86 |
* |
(51 |
/ |
374) |
= |
-11.7272727 |
6 |
11189 |
2439 |
- |
2552 |
= |
-113 |
* |
(45 |
/ |
374) |
= |
-13.59625662 |
7 |
11192 |
2478 |
- |
2567 |
= |
-89 |
* |
(59 |
/ |
374) |
= |
-14.04010689 |
8 |
11193 |
2502 |
- |
2586 |
= |
-84 |
* |
(76 |
/ |
374) |
= |
-17.0695187 |
11 |
11195 |
2464 |
- |
2628 |
= |
-164 |
* |
(59 |
/ |
374) |
= |
-25.87165764 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for West Park Elementary
|
-96 |
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 |
11509 |
2390 |
- |
2436 |
= |
-46 |
* |
(40 |
/ |
372) |
= |
-4.94623653 |
4 |
11512 |
2430 |
- |
2485 |
= |
-55 |
* |
(38 |
/ |
372) |
= |
-5.61827954 |
5 |
11513 |
2405 |
- |
2528 |
= |
-123 |
* |
(51 |
/ |
372) |
= |
-16.8629032 |
6 |
11515 |
2457 |
- |
2552 |
= |
-95 |
* |
(53 |
/ |
372) |
= |
-13.53494621 |
7 |
11518 |
2467 |
- |
2567 |
= |
-100 |
* |
(59 |
/ |
372) |
= |
-15.860215 |
8 |
11519 |
2470 |
- |
2586 |
= |
-116 |
* |
(72 |
/ |
372) |
= |
-22.45161289 |
11 |
11522 |
2437 |
- |
2628 |
= |
-191 |
* |
(59 |
/ |
372) |
= |
-30.29301065 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for West Park Elementary
|
-110 |
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 |
11546 |
2387 |
- |
2436 |
= |
-49 |
* |
(46 |
/ |
407) |
= |
-5.53808354 |
4 |
11547 |
2411 |
- |
2485 |
= |
-74 |
* |
(47 |
/ |
407) |
= |
-8.54545451 |
5 |
11550 |
2448 |
- |
2528 |
= |
-80 |
* |
(37 |
/ |
407) |
= |
-7.2727272 |
6 |
11551 |
2446 |
- |
2552 |
= |
-106 |
* |
(58 |
/ |
407) |
= |
-15.10565105 |
7 |
11554 |
2463 |
- |
2567 |
= |
-104 |
* |
(75 |
/ |
407) |
= |
-19.16461914 |
8 |
11555 |
2448 |
- |
2586 |
= |
-138 |
* |
(80 |
/ |
407) |
= |
-27.12530705 |
11 |
11558 |
2443 |
- |
2628 |
= |
-185 |
* |
(64 |
/ |
407) |
= |
-29.09090905 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for West Park Elementary
|
-112 |
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 |
11639 |
2386 |
- |
2436 |
= |
-50 |
* |
(38 |
/ |
418) |
= |
-4.5454545 |
4 |
11640 |
2412 |
- |
2485 |
= |
-73 |
* |
(47 |
/ |
418) |
= |
-8.20813394 |
5 |
11641 |
2429 |
- |
2528 |
= |
-99 |
* |
(44 |
/ |
418) |
= |
-10.42105254 |
6 |
11642 |
2454 |
- |
2552 |
= |
-98 |
* |
(49 |
/ |
418) |
= |
-11.48803824 |
7 |
11643 |
2450 |
- |
2567 |
= |
-117 |
* |
(72 |
/ |
418) |
= |
-20.15310995 |
8 |
11644 |
2463 |
- |
2586 |
= |
-123 |
* |
(93 |
/ |
418) |
= |
-27.36602867 |
11 |
11645 |
2480 |
- |
2628 |
= |
-148 |
* |
(75 |
/ |
418) |
= |
-26.55502388 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for West Park Elementary
|
-109 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-107
|
-96
|
-110
|
-112
|
-109
|
-534.0 |
-106.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -88.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -124.8
For the lines, you have the data necessary to plot the chart.