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 |
193546 |
2397 |
- |
2436 |
= |
-39 |
* |
(113 |
/ |
871) |
= |
-5.05970147 |
4 |
193549 |
2442 |
- |
2485 |
= |
-43 |
* |
(125 |
/ |
871) |
= |
-6.17106773 |
5 |
193550 |
2437 |
- |
2528 |
= |
-91 |
* |
(115 |
/ |
871) |
= |
-12.01492529 |
6 |
193553 |
2465 |
- |
2552 |
= |
-87 |
* |
(121 |
/ |
871) |
= |
-12.08610786 |
7 |
193554 |
2513 |
- |
2567 |
= |
-54 |
* |
(130 |
/ |
871) |
= |
-8.05970147 |
8 |
193557 |
2481 |
- |
2586 |
= |
-105 |
* |
(124 |
/ |
871) |
= |
-14.94833519 |
11 |
193558 |
2553 |
- |
2628 |
= |
-75 |
* |
(143 |
/ |
871) |
= |
-12.3134328 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for John Swett Unified
|
-71 |
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 |
5770 |
2373 |
- |
2436 |
= |
-63 |
* |
(106 |
/ |
863) |
= |
-7.7381228 |
4 |
5771 |
2445 |
- |
2485 |
= |
-40 |
* |
(122 |
/ |
863) |
= |
-5.65469292 |
5 |
5774 |
2466 |
- |
2528 |
= |
-62 |
* |
(124 |
/ |
863) |
= |
-8.90845884 |
6 |
5776 |
2458 |
- |
2552 |
= |
-94 |
* |
(112 |
/ |
863) |
= |
-12.19930468 |
7 |
5778 |
2491 |
- |
2567 |
= |
-76 |
* |
(120 |
/ |
863) |
= |
-10.56778678 |
8 |
5780 |
2516 |
- |
2586 |
= |
-70 |
* |
(137 |
/ |
863) |
= |
-11.11239857 |
11 |
5782 |
2571 |
- |
2628 |
= |
-57 |
* |
(142 |
/ |
863) |
= |
-9.37891076 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for John Swett Unified
|
-66 |
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 |
5903 |
2387 |
- |
2436 |
= |
-49 |
* |
(107 |
/ |
795) |
= |
-6.59496851 |
4 |
5906 |
2429 |
- |
2485 |
= |
-56 |
* |
(106 |
/ |
795) |
= |
-7.46666665 |
5 |
5908 |
2447 |
- |
2528 |
= |
-81 |
* |
(120 |
/ |
795) |
= |
-12.22641508 |
6 |
5909 |
2470 |
- |
2552 |
= |
-82 |
* |
(112 |
/ |
795) |
= |
-11.55220125 |
7 |
5911 |
2502 |
- |
2567 |
= |
-65 |
* |
(93 |
/ |
795) |
= |
-7.60377358 |
8 |
5913 |
2488 |
- |
2586 |
= |
-98 |
* |
(119 |
/ |
795) |
= |
-14.66918233 |
11 |
5916 |
2559 |
- |
2628 |
= |
-69 |
* |
(138 |
/ |
795) |
= |
-11.97735845 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for John Swett Unified
|
-72 |
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 |
5900 |
2368 |
- |
2436 |
= |
-68 |
* |
(108 |
/ |
712) |
= |
-10.31460672 |
4 |
5901 |
2452 |
- |
2485 |
= |
-33 |
* |
(106 |
/ |
712) |
= |
-4.91292133 |
5 |
5904 |
2443 |
- |
2528 |
= |
-85 |
* |
(101 |
/ |
712) |
= |
-12.05758422 |
6 |
5905 |
2474 |
- |
2552 |
= |
-78 |
* |
(98 |
/ |
712) |
= |
-10.73595502 |
7 |
5908 |
2505 |
- |
2567 |
= |
-62 |
* |
(105 |
/ |
712) |
= |
-9.14325842 |
8 |
5909 |
2484 |
- |
2586 |
= |
-102 |
* |
(86 |
/ |
712) |
= |
-12.32022463 |
11 |
5912 |
2549 |
- |
2628 |
= |
-79 |
* |
(108 |
/ |
712) |
= |
-11.98314605 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for John Swett Unified
|
-71 |
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 |
5969 |
2382 |
- |
2436 |
= |
-54 |
* |
(109 |
/ |
729) |
= |
-8.07407406 |
4 |
5970 |
2435 |
- |
2485 |
= |
-50 |
* |
(99 |
/ |
729) |
= |
-6.79012345 |
5 |
5971 |
2443 |
- |
2528 |
= |
-85 |
* |
(112 |
/ |
729) |
= |
-13.05898486 |
6 |
5972 |
2445 |
- |
2552 |
= |
-107 |
* |
(91 |
/ |
729) |
= |
-13.35665292 |
7 |
5973 |
2481 |
- |
2567 |
= |
-86 |
* |
(96 |
/ |
729) |
= |
-11.32510281 |
8 |
5974 |
2517 |
- |
2586 |
= |
-69 |
* |
(100 |
/ |
729) |
= |
-9.46502056 |
11 |
5975 |
2577 |
- |
2628 |
= |
-51 |
* |
(122 |
/ |
729) |
= |
-8.53497939 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for John Swett Unified
|
-71 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-71
|
-66
|
-72
|
-71
|
-71
|
-351.0 |
-70.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -64.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -76.2
For the lines, you have the data necessary to plot the chart.