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 |
1994231 |
2417 |
- |
2436 |
= |
-19 |
* |
(71 |
/ |
443) |
= |
-3.04514672 |
4 |
1994234 |
2423 |
- |
2485 |
= |
-62 |
* |
(68 |
/ |
443) |
= |
-9.51693 |
5 |
1994235 |
2457 |
- |
2528 |
= |
-71 |
* |
(83 |
/ |
443) |
= |
-13.30248304 |
6 |
1994238 |
2512 |
- |
2552 |
= |
-40 |
* |
(55 |
/ |
443) |
= |
-4.96613992 |
7 |
1994239 |
2463 |
- |
2567 |
= |
-104 |
* |
(54 |
/ |
443) |
= |
-12.67720085 |
8 |
1994242 |
2455 |
- |
2586 |
= |
-131 |
* |
(67 |
/ |
443) |
= |
-19.81264095 |
11 |
1994243 |
2581 |
- |
2628 |
= |
-47 |
* |
(45 |
/ |
443) |
= |
-4.77426635 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Helendale Elementary
|
-68 |
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 |
61327 |
2432 |
- |
2436 |
= |
-4 |
* |
(83 |
/ |
553) |
= |
-0.60036166 |
4 |
61329 |
2442 |
- |
2485 |
= |
-43 |
* |
(77 |
/ |
553) |
= |
-5.98734176 |
5 |
61330 |
2444 |
- |
2528 |
= |
-84 |
* |
(77 |
/ |
553) |
= |
-11.6962025 |
6 |
61333 |
2483 |
- |
2552 |
= |
-69 |
* |
(97 |
/ |
553) |
= |
-12.1030741 |
7 |
61334 |
2509 |
- |
2567 |
= |
-58 |
* |
(68 |
/ |
553) |
= |
-7.13200718 |
8 |
61337 |
2479 |
- |
2586 |
= |
-107 |
* |
(71 |
/ |
553) |
= |
-13.73779377 |
11 |
61338 |
2553 |
- |
2628 |
= |
-75 |
* |
(80 |
/ |
553) |
= |
-10.84990958 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Helendale Elementary
|
-62 |
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 |
63105 |
2421 |
- |
2436 |
= |
-15 |
* |
(89 |
/ |
603) |
= |
-2.21393034 |
4 |
63107 |
2450 |
- |
2485 |
= |
-35 |
* |
(80 |
/ |
603) |
= |
-4.64344941 |
5 |
63108 |
2474 |
- |
2528 |
= |
-54 |
* |
(77 |
/ |
603) |
= |
-6.89552239 |
6 |
63111 |
2461 |
- |
2552 |
= |
-91 |
* |
(87 |
/ |
603) |
= |
-13.12935315 |
7 |
63113 |
2489 |
- |
2567 |
= |
-78 |
* |
(108 |
/ |
603) |
= |
-13.97014921 |
8 |
63115 |
2501 |
- |
2586 |
= |
-85 |
* |
(79 |
/ |
603) |
= |
-11.13598668 |
11 |
63116 |
2528 |
- |
2628 |
= |
-100 |
* |
(83 |
/ |
603) |
= |
-13.7645107 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Helendale Elementary
|
-66 |
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 |
63186 |
2429 |
- |
2436 |
= |
-7 |
* |
(77 |
/ |
617) |
= |
-0.87358184 |
4 |
63189 |
2464 |
- |
2485 |
= |
-21 |
* |
(83 |
/ |
617) |
= |
-2.82495948 |
5 |
63190 |
2499 |
- |
2528 |
= |
-29 |
* |
(76 |
/ |
617) |
= |
-3.57212317 |
6 |
63193 |
2499 |
- |
2552 |
= |
-53 |
* |
(76 |
/ |
617) |
= |
-6.52836303 |
7 |
63194 |
2471 |
- |
2567 |
= |
-96 |
* |
(99 |
/ |
617) |
= |
-15.40356557 |
8 |
63197 |
2482 |
- |
2586 |
= |
-104 |
* |
(105 |
/ |
617) |
= |
-17.69854133 |
11 |
63198 |
2492 |
- |
2628 |
= |
-136 |
* |
(101 |
/ |
617) |
= |
-22.26256066 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Helendale Elementary
|
-69 |
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 |
63461 |
2457 |
- |
2436 |
= |
21 |
* |
(69 |
/ |
543) |
= |
2.66850828 |
4 |
63462 |
2486 |
- |
2485 |
= |
1 |
* |
(70 |
/ |
543) |
= |
0.12891344 |
5 |
63463 |
2482 |
- |
2528 |
= |
-46 |
* |
(82 |
/ |
543) |
= |
-6.94659299 |
6 |
63464 |
2529 |
- |
2552 |
= |
-23 |
* |
(78 |
/ |
543) |
= |
-3.30386738 |
7 |
63465 |
2501 |
- |
2567 |
= |
-66 |
* |
(75 |
/ |
543) |
= |
-9.11602204 |
8 |
63466 |
2516 |
- |
2586 |
= |
-70 |
* |
(93 |
/ |
543) |
= |
-11.98895026 |
11 |
63467 |
2526 |
- |
2628 |
= |
-102 |
* |
(76 |
/ |
543) |
= |
-14.27624303 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Helendale Elementary
|
-43 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-68
|
-62
|
-66
|
-69
|
-43
|
-308.0 |
-61.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: -91.6
For the lines, you have the data necessary to plot the chart.