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 |
312873 |
2387 |
- |
2436 |
= |
-49 |
* |
(5897 |
/ |
35825) |
= |
-8.06568038 |
4 |
312874 |
2418 |
- |
2485 |
= |
-67 |
* |
(5565 |
/ |
35825) |
= |
-10.40767615 |
5 |
312877 |
2442 |
- |
2528 |
= |
-86 |
* |
(5526 |
/ |
35825) |
= |
-13.26548495 |
6 |
312878 |
2467 |
- |
2552 |
= |
-85 |
* |
(5364 |
/ |
35825) |
= |
-12.72686666 |
7 |
312881 |
2468 |
- |
2567 |
= |
-99 |
* |
(4935 |
/ |
35825) |
= |
-13.63754354 |
8 |
312882 |
2476 |
- |
2586 |
= |
-110 |
* |
(4868 |
/ |
35825) |
= |
-14.94710393 |
11 |
312885 |
2514 |
- |
2628 |
= |
-114 |
* |
(3670 |
/ |
35825) |
= |
-11.67843679 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Fresno Unified
|
-85 |
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 |
9340 |
2400 |
- |
2436 |
= |
-36 |
* |
(5629 |
/ |
36194) |
= |
-5.5988285 |
4 |
9341 |
2431 |
- |
2485 |
= |
-54 |
* |
(5810 |
/ |
36194) |
= |
-8.66828752 |
5 |
9343 |
2448 |
- |
2528 |
= |
-80 |
* |
(5491 |
/ |
36194) |
= |
-12.13681824 |
6 |
9346 |
2470 |
- |
2552 |
= |
-82 |
* |
(5481 |
/ |
36194) |
= |
-12.417583 |
7 |
9347 |
2469 |
- |
2567 |
= |
-98 |
* |
(5132 |
/ |
36194) |
= |
-13.89556279 |
8 |
9349 |
2480 |
- |
2586 |
= |
-106 |
* |
(4862 |
/ |
36194) |
= |
-14.23915564 |
11 |
9352 |
2523 |
- |
2628 |
= |
-105 |
* |
(3789 |
/ |
36194) |
= |
-10.9920152 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Fresno Unified
|
-78 |
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 |
9662 |
2406 |
- |
2436 |
= |
-30 |
* |
(5727 |
/ |
36245) |
= |
-4.74024003 |
4 |
9664 |
2436 |
- |
2485 |
= |
-49 |
* |
(5513 |
/ |
36245) |
= |
-7.45308316 |
5 |
9666 |
2455 |
- |
2528 |
= |
-73 |
* |
(5694 |
/ |
36245) |
= |
-11.46811969 |
6 |
9667 |
2479 |
- |
2552 |
= |
-73 |
* |
(5410 |
/ |
36245) |
= |
-10.89612359 |
7 |
9669 |
2469 |
- |
2567 |
= |
-98 |
* |
(5170 |
/ |
36245) |
= |
-13.97875567 |
8 |
9672 |
2476 |
- |
2586 |
= |
-110 |
* |
(4990 |
/ |
36245) |
= |
-15.14415771 |
11 |
9673 |
2514 |
- |
2628 |
= |
-114 |
* |
(3741 |
/ |
36245) |
= |
-11.7664229 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Fresno Unified
|
-75 |
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 |
9669 |
2412 |
- |
2436 |
= |
-24 |
* |
(5423 |
/ |
36286) |
= |
-3.5868379 |
4 |
9672 |
2445 |
- |
2485 |
= |
-40 |
* |
(5703 |
/ |
36286) |
= |
-6.28672212 |
5 |
9673 |
2462 |
- |
2528 |
= |
-66 |
* |
(5432 |
/ |
36286) |
= |
-9.88017413 |
6 |
9676 |
2487 |
- |
2552 |
= |
-65 |
* |
(5649 |
/ |
36286) |
= |
-10.11919194 |
7 |
9677 |
2475 |
- |
2567 |
= |
-92 |
* |
(5192 |
/ |
36286) |
= |
-13.1638648 |
8 |
9680 |
2483 |
- |
2586 |
= |
-103 |
* |
(5075 |
/ |
36286) |
= |
-14.40569361 |
11 |
9681 |
2509 |
- |
2628 |
= |
-119 |
* |
(3812 |
/ |
36286) |
= |
-12.50146051 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Fresno Unified
|
-70 |
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 |
9763 |
2419 |
- |
2436 |
= |
-17 |
* |
(5818 |
/ |
36545) |
= |
-2.70641675 |
4 |
9764 |
2456 |
- |
2485 |
= |
-29 |
* |
(5352 |
/ |
36545) |
= |
-4.24703788 |
5 |
9765 |
2471 |
- |
2528 |
= |
-57 |
* |
(5632 |
/ |
36545) |
= |
-8.78434803 |
6 |
9766 |
2492 |
- |
2552 |
= |
-60 |
* |
(5388 |
/ |
36545) |
= |
-8.84608014 |
7 |
9767 |
2483 |
- |
2567 |
= |
-84 |
* |
(5345 |
/ |
36545) |
= |
-12.28567519 |
8 |
9768 |
2485 |
- |
2586 |
= |
-101 |
* |
(5036 |
/ |
36545) |
= |
-13.91807351 |
11 |
9769 |
2512 |
- |
2628 |
= |
-116 |
* |
(3974 |
/ |
36545) |
= |
-12.61414694 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Fresno Unified
|
-63 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-85
|
-78
|
-75
|
-70
|
-63
|
-371.0 |
-74.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -50.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -98.2
For the lines, you have the data necessary to plot the chart.