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 |
3090864 |
2391 |
- |
2436 |
= |
-45 |
* |
(51 |
/ |
299) |
= |
-7.67558525 |
4 |
3090865 |
2434 |
- |
2485 |
= |
-51 |
* |
(44 |
/ |
299) |
= |
-7.50501669 |
5 |
3090868 |
2487 |
- |
2528 |
= |
-41 |
* |
(49 |
/ |
299) |
= |
-6.71906352 |
6 |
3090869 |
2475 |
- |
2552 |
= |
-77 |
* |
(47 |
/ |
299) |
= |
-12.1036789 |
7 |
3090872 |
2478 |
- |
2567 |
= |
-89 |
* |
(62 |
/ |
299) |
= |
-18.45484945 |
8 |
3090873 |
2507 |
- |
2586 |
= |
-79 |
* |
(46 |
/ |
299) |
= |
-12.15384609 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Curtis Creek Elementary
|
-65 |
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 |
95229 |
2432 |
- |
2436 |
= |
-4 |
* |
(62 |
/ |
319) |
= |
-0.77742946 |
4 |
95230 |
2449 |
- |
2485 |
= |
-36 |
* |
(50 |
/ |
319) |
= |
-5.6426332 |
5 |
95232 |
2453 |
- |
2528 |
= |
-75 |
* |
(48 |
/ |
319) |
= |
-11.28526643 |
6 |
95235 |
2486 |
- |
2552 |
= |
-66 |
* |
(46 |
/ |
319) |
= |
-9.51724132 |
7 |
95237 |
2488 |
- |
2567 |
= |
-79 |
* |
(54 |
/ |
319) |
= |
-13.37304068 |
8 |
95238 |
2469 |
- |
2586 |
= |
-117 |
* |
(59 |
/ |
319) |
= |
-21.63949843 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Curtis Creek 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 |
98003 |
2469 |
- |
2436 |
= |
33 |
* |
(41 |
/ |
279) |
= |
4.84946237 |
4 |
98005 |
2443 |
- |
2485 |
= |
-42 |
* |
(54 |
/ |
279) |
= |
-8.12903225 |
5 |
98007 |
2478 |
- |
2528 |
= |
-50 |
* |
(47 |
/ |
279) |
= |
-8.42293905 |
6 |
98009 |
2507 |
- |
2552 |
= |
-45 |
* |
(52 |
/ |
279) |
= |
-8.38709676 |
7 |
98012 |
2506 |
- |
2567 |
= |
-61 |
* |
(42 |
/ |
279) |
= |
-9.18279567 |
8 |
98014 |
2488 |
- |
2586 |
= |
-98 |
* |
(43 |
/ |
279) |
= |
-15.10394257 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Curtis Creek Elementary
|
-44 |
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 |
98185 |
2429 |
- |
2436 |
= |
-7 |
* |
(44 |
/ |
276) |
= |
-1.11594202 |
4 |
98186 |
2464 |
- |
2485 |
= |
-21 |
* |
(42 |
/ |
276) |
= |
-3.19565217 |
5 |
98188 |
2505 |
- |
2528 |
= |
-23 |
* |
(51 |
/ |
276) |
= |
-4.24999998 |
6 |
98191 |
2470 |
- |
2552 |
= |
-82 |
* |
(47 |
/ |
276) |
= |
-13.96376811 |
7 |
98192 |
2506 |
- |
2567 |
= |
-61 |
* |
(49 |
/ |
276) |
= |
-10.82971009 |
8 |
98195 |
2529 |
- |
2586 |
= |
-57 |
* |
(43 |
/ |
276) |
= |
-8.88043476 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Curtis Creek Elementary
|
-42 |
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 |
98854 |
2431 |
- |
2436 |
= |
-5 |
* |
(48 |
/ |
315) |
= |
-0.76190476 |
4 |
98855 |
2445 |
- |
2485 |
= |
-40 |
* |
(50 |
/ |
315) |
= |
-6.34920632 |
5 |
98856 |
2487 |
- |
2528 |
= |
-41 |
* |
(51 |
/ |
315) |
= |
-6.6380952 |
6 |
98857 |
2492 |
- |
2552 |
= |
-60 |
* |
(54 |
/ |
315) |
= |
-10.28571426 |
7 |
98858 |
2508 |
- |
2567 |
= |
-59 |
* |
(56 |
/ |
315) |
= |
-10.48888884 |
8 |
98859 |
2512 |
- |
2586 |
= |
-74 |
* |
(56 |
/ |
315) |
= |
-13.1555555 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Curtis Creek Elementary
|
-48 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-65
|
-62
|
-44
|
-42
|
-48
|
-261.0 |
-52.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -22.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -82.2
For the lines, you have the data necessary to plot the chart.