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 |
2004845 |
2363 |
- |
2436 |
= |
-73 |
* |
(72 |
/ |
462) |
= |
-11.37662332 |
4 |
2004848 |
2441 |
- |
2485 |
= |
-44 |
* |
(68 |
/ |
462) |
= |
-6.47619047 |
5 |
2004849 |
2470 |
- |
2528 |
= |
-58 |
* |
(76 |
/ |
462) |
= |
-9.54112551 |
6 |
2004852 |
2475 |
- |
2552 |
= |
-77 |
* |
(67 |
/ |
462) |
= |
-11.16666667 |
7 |
2004853 |
2488 |
- |
2567 |
= |
-79 |
* |
(50 |
/ |
462) |
= |
-8.54978353 |
8 |
2004856 |
2474 |
- |
2586 |
= |
-112 |
* |
(67 |
/ |
462) |
= |
-16.24242424 |
11 |
2004857 |
2476 |
- |
2628 |
= |
-152 |
* |
(62 |
/ |
462) |
= |
-20.39826837 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Needles Unified
|
-84 |
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 |
61653 |
2377 |
- |
2436 |
= |
-59 |
* |
(93 |
/ |
507) |
= |
-10.82248517 |
4 |
61654 |
2408 |
- |
2485 |
= |
-77 |
* |
(80 |
/ |
507) |
= |
-12.14990138 |
5 |
61656 |
2475 |
- |
2528 |
= |
-53 |
* |
(77 |
/ |
507) |
= |
-8.04930965 |
6 |
61659 |
2470 |
- |
2552 |
= |
-82 |
* |
(77 |
/ |
507) |
= |
-12.45364889 |
7 |
61661 |
2483 |
- |
2567 |
= |
-84 |
* |
(75 |
/ |
507) |
= |
-12.4260355 |
8 |
61662 |
2489 |
- |
2586 |
= |
-97 |
* |
(54 |
/ |
507) |
= |
-10.33136088 |
11 |
61664 |
2509 |
- |
2628 |
= |
-119 |
* |
(51 |
/ |
507) |
= |
-11.97041409 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Needles 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 |
63432 |
2391 |
- |
2436 |
= |
-45 |
* |
(78 |
/ |
533) |
= |
-6.58536584 |
4 |
63434 |
2404 |
- |
2485 |
= |
-81 |
* |
(84 |
/ |
533) |
= |
-12.76547842 |
5 |
63436 |
2485 |
- |
2528 |
= |
-43 |
* |
(74 |
/ |
533) |
= |
-5.9699812 |
6 |
63439 |
2460 |
- |
2552 |
= |
-92 |
* |
(81 |
/ |
533) |
= |
-13.98123825 |
7 |
63441 |
2472 |
- |
2567 |
= |
-95 |
* |
(88 |
/ |
533) |
= |
-15.68480296 |
8 |
63442 |
2485 |
- |
2586 |
= |
-101 |
* |
(71 |
/ |
533) |
= |
-13.45403376 |
11 |
63445 |
2495 |
- |
2628 |
= |
-133 |
* |
(57 |
/ |
533) |
= |
-14.22326445 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Needles Unified
|
-83 |
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 |
63534 |
2388 |
- |
2436 |
= |
-48 |
* |
(60 |
/ |
533) |
= |
-5.40337709 |
4 |
63536 |
2437 |
- |
2485 |
= |
-48 |
* |
(73 |
/ |
533) |
= |
-6.5741088 |
5 |
63538 |
2499 |
- |
2528 |
= |
-29 |
* |
(88 |
/ |
533) |
= |
-4.78799248 |
6 |
63540 |
2467 |
- |
2552 |
= |
-85 |
* |
(79 |
/ |
533) |
= |
-12.59849906 |
7 |
63542 |
2481 |
- |
2567 |
= |
-86 |
* |
(82 |
/ |
533) |
= |
-13.23076916 |
8 |
63544 |
2493 |
- |
2586 |
= |
-93 |
* |
(85 |
/ |
533) |
= |
-14.8311444 |
11 |
63546 |
2501 |
- |
2628 |
= |
-127 |
* |
(66 |
/ |
533) |
= |
-15.72607878 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Needles Unified
|
-73 |
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 |
63797 |
2408 |
- |
2436 |
= |
-28 |
* |
(71 |
/ |
529) |
= |
-3.758034 |
4 |
63798 |
2436 |
- |
2485 |
= |
-49 |
* |
(65 |
/ |
529) |
= |
-6.02079391 |
5 |
63799 |
2486 |
- |
2528 |
= |
-42 |
* |
(81 |
/ |
529) |
= |
-6.43100186 |
6 |
63800 |
2472 |
- |
2552 |
= |
-80 |
* |
(90 |
/ |
529) |
= |
-13.610586 |
7 |
63801 |
2468 |
- |
2567 |
= |
-99 |
* |
(77 |
/ |
529) |
= |
-14.41020785 |
8 |
63802 |
2481 |
- |
2586 |
= |
-105 |
* |
(89 |
/ |
529) |
= |
-17.66540633 |
11 |
63803 |
2496 |
- |
2628 |
= |
-132 |
* |
(56 |
/ |
529) |
= |
-13.97353492 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Needles Unified
|
-76 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-84
|
-78
|
-83
|
-73
|
-76
|
-394.0 |
-78.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -66.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -90.8
For the lines, you have the data necessary to plot the chart.