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 |
380782 |
2399 |
- |
2436 |
= |
-37 |
* |
(408 |
/ |
2621) |
= |
-5.75963371 |
4 |
380783 |
2431 |
- |
2485 |
= |
-54 |
* |
(393 |
/ |
2621) |
= |
-8.09690953 |
5 |
380786 |
2448 |
- |
2528 |
= |
-80 |
* |
(398 |
/ |
2621) |
= |
-12.14803504 |
6 |
380787 |
2477 |
- |
2552 |
= |
-75 |
* |
(380 |
/ |
2621) |
= |
-10.87371225 |
7 |
380790 |
2504 |
- |
2567 |
= |
-63 |
* |
(329 |
/ |
2621) |
= |
-7.9080503 |
8 |
380791 |
2514 |
- |
2586 |
= |
-72 |
* |
(393 |
/ |
2621) |
= |
-10.79587937 |
11 |
380794 |
2532 |
- |
2628 |
= |
-96 |
* |
(320 |
/ |
2621) |
= |
-11.72071728 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Kerman Unified
|
-67 |
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 |
11545 |
2407 |
- |
2436 |
= |
-29 |
* |
(372 |
/ |
2625) |
= |
-4.10971427 |
4 |
11547 |
2458 |
- |
2485 |
= |
-27 |
* |
(403 |
/ |
2625) |
= |
-4.14514284 |
5 |
11549 |
2456 |
- |
2528 |
= |
-72 |
* |
(399 |
/ |
2625) |
= |
-10.944 |
6 |
11551 |
2496 |
- |
2552 |
= |
-56 |
* |
(395 |
/ |
2625) |
= |
-8.42666664 |
7 |
11554 |
2498 |
- |
2567 |
= |
-69 |
* |
(387 |
/ |
2625) |
= |
-10.1725714 |
8 |
11555 |
2516 |
- |
2586 |
= |
-70 |
* |
(333 |
/ |
2625) |
= |
-8.87999994 |
11 |
11558 |
2534 |
- |
2628 |
= |
-94 |
* |
(336 |
/ |
2625) |
= |
-12.032 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Kerman Unified
|
-59 |
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 |
11877 |
2412 |
- |
2436 |
= |
-24 |
* |
(395 |
/ |
2718) |
= |
-3.4878587 |
4 |
11879 |
2464 |
- |
2485 |
= |
-21 |
* |
(370 |
/ |
2718) |
= |
-2.85871963 |
5 |
11882 |
2479 |
- |
2528 |
= |
-49 |
* |
(401 |
/ |
2718) |
= |
-7.22921265 |
6 |
11884 |
2508 |
- |
2552 |
= |
-44 |
* |
(410 |
/ |
2718) |
= |
-6.63723324 |
7 |
11886 |
2503 |
- |
2567 |
= |
-64 |
* |
(406 |
/ |
2718) |
= |
-9.55997056 |
8 |
11888 |
2507 |
- |
2586 |
= |
-79 |
* |
(385 |
/ |
2718) |
= |
-11.19021333 |
11 |
11889 |
2515 |
- |
2628 |
= |
-113 |
* |
(351 |
/ |
2718) |
= |
-14.59271514 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Kerman Unified
|
-56 |
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 |
11913 |
2420 |
- |
2436 |
= |
-16 |
* |
(391 |
/ |
2773) |
= |
-2.25604038 |
4 |
11916 |
2467 |
- |
2485 |
= |
-18 |
* |
(386 |
/ |
2773) |
= |
-2.50558961 |
5 |
11917 |
2487 |
- |
2528 |
= |
-41 |
* |
(370 |
/ |
2773) |
= |
-5.47060942 |
6 |
11920 |
2521 |
- |
2552 |
= |
-31 |
* |
(394 |
/ |
2773) |
= |
-4.40461594 |
7 |
11921 |
2491 |
- |
2567 |
= |
-76 |
* |
(427 |
/ |
2773) |
= |
-11.70284883 |
8 |
11924 |
2510 |
- |
2586 |
= |
-76 |
* |
(407 |
/ |
2773) |
= |
-11.15470605 |
11 |
11925 |
2535 |
- |
2628 |
= |
-93 |
* |
(398 |
/ |
2773) |
= |
-13.34799854 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Kerman Unified
|
-51 |
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 |
12009 |
2428 |
- |
2436 |
= |
-8 |
* |
(368 |
/ |
2697) |
= |
-1.09158324 |
4 |
12010 |
2472 |
- |
2485 |
= |
-13 |
* |
(407 |
/ |
2697) |
= |
-1.96180941 |
5 |
12011 |
2494 |
- |
2528 |
= |
-34 |
* |
(392 |
/ |
2697) |
= |
-4.94178715 |
6 |
12012 |
2521 |
- |
2552 |
= |
-31 |
* |
(375 |
/ |
2697) |
= |
-4.31034481 |
7 |
12013 |
2506 |
- |
2567 |
= |
-61 |
* |
(397 |
/ |
2697) |
= |
-8.97923617 |
8 |
12014 |
2508 |
- |
2586 |
= |
-78 |
* |
(413 |
/ |
2697) |
= |
-11.94438258 |
11 |
12015 |
2535 |
- |
2628 |
= |
-93 |
* |
(345 |
/ |
2697) |
= |
-11.89655172 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Kerman Unified
|
-45 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-67
|
-59
|
-56
|
-51
|
-45
|
-278.0 |
-55.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -31.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -79.6
For the lines, you have the data necessary to plot the chart.