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 |
2868735 |
2447 |
- |
2436 |
= |
11 |
* |
(71 |
/ |
599) |
= |
1.30383972 |
4 |
2868736 |
2501 |
- |
2485 |
= |
16 |
* |
(73 |
/ |
599) |
= |
1.94991651 |
5 |
2868738 |
2552 |
- |
2528 |
= |
24 |
* |
(65 |
/ |
599) |
= |
2.60434056 |
6 |
2868740 |
2538 |
- |
2552 |
= |
-14 |
* |
(102 |
/ |
599) |
= |
-2.38397328 |
7 |
2868743 |
2562 |
- |
2567 |
= |
-5 |
* |
(147 |
/ |
599) |
= |
-1.22704508 |
8 |
2868744 |
2578 |
- |
2586 |
= |
-8 |
* |
(141 |
/ |
599) |
= |
-1.88313856 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Oak Grove Union Elementary
|
0 |
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 |
87789 |
2453 |
- |
2436 |
= |
17 |
* |
(68 |
/ |
604) |
= |
1.91390728 |
4 |
87791 |
2512 |
- |
2485 |
= |
27 |
* |
(73 |
/ |
604) |
= |
3.26324503 |
5 |
87792 |
2568 |
- |
2528 |
= |
40 |
* |
(71 |
/ |
604) |
= |
4.70198672 |
6 |
87794 |
2547 |
- |
2552 |
= |
-5 |
* |
(115 |
/ |
604) |
= |
-0.95198675 |
7 |
87797 |
2578 |
- |
2567 |
= |
11 |
* |
(129 |
/ |
604) |
= |
2.34933774 |
8 |
87799 |
2586 |
- |
2586 |
= |
0 |
* |
(148 |
/ |
604) |
= |
0.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Oak Grove Union Elementary
|
11 |
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 |
90311 |
2447 |
- |
2436 |
= |
11 |
* |
(62 |
/ |
589) |
= |
1.15789473 |
4 |
90313 |
2492 |
- |
2485 |
= |
7 |
* |
(72 |
/ |
589) |
= |
0.8556876 |
5 |
90316 |
2547 |
- |
2528 |
= |
19 |
* |
(81 |
/ |
589) |
= |
2.61290322 |
6 |
90318 |
2558 |
- |
2552 |
= |
6 |
* |
(110 |
/ |
589) |
= |
1.12054329 |
7 |
90319 |
2552 |
- |
2567 |
= |
-15 |
* |
(146 |
/ |
589) |
= |
-3.71816637 |
8 |
90322 |
2581 |
- |
2586 |
= |
-5 |
* |
(118 |
/ |
589) |
= |
-1.00169779 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Oak Grove Union Elementary
|
1 |
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 |
90517 |
2439 |
- |
2436 |
= |
3 |
* |
(62 |
/ |
616) |
= |
0.30194805 |
4 |
90519 |
2497 |
- |
2485 |
= |
12 |
* |
(67 |
/ |
616) |
= |
1.3051948 |
5 |
90521 |
2529 |
- |
2528 |
= |
1 |
* |
(76 |
/ |
616) |
= |
0.12337662 |
6 |
90523 |
2559 |
- |
2552 |
= |
7 |
* |
(108 |
/ |
616) |
= |
1.22727273 |
7 |
90525 |
2572 |
- |
2567 |
= |
5 |
* |
(146 |
/ |
616) |
= |
1.18506494 |
8 |
90527 |
2556 |
- |
2586 |
= |
-30 |
* |
(157 |
/ |
616) |
= |
-7.64610387 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Oak Grove Union Elementary
|
-4 |
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 |
91139 |
2443 |
- |
2436 |
= |
7 |
* |
(82 |
/ |
622) |
= |
0.92282958 |
4 |
91140 |
2501 |
- |
2485 |
= |
16 |
* |
(64 |
/ |
622) |
= |
1.64630224 |
5 |
91141 |
2548 |
- |
2528 |
= |
20 |
* |
(72 |
/ |
622) |
= |
2.31511254 |
6 |
91142 |
2544 |
- |
2552 |
= |
-8 |
* |
(106 |
/ |
622) |
= |
-1.36334405 |
7 |
91143 |
2558 |
- |
2567 |
= |
-9 |
* |
(154 |
/ |
622) |
= |
-2.22829582 |
8 |
91144 |
2565 |
- |
2586 |
= |
-21 |
* |
(144 |
/ |
622) |
= |
-4.86173633 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Oak Grove Union Elementary
|
-4 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
0
|
11
|
1
|
-4
|
-4
|
4.0 |
0.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 22.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -20.0
For the lines, you have the data necessary to plot the chart.