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 |
1358325 |
2375 |
- |
2436 |
= |
-61 |
* |
(1303 |
/ |
5071) |
= |
-15.67402875 |
4 |
1358326 |
2410 |
- |
2485 |
= |
-75 |
* |
(1345 |
/ |
5071) |
= |
-19.89252608 |
5 |
1358329 |
2434 |
- |
2528 |
= |
-94 |
* |
(1216 |
/ |
5071) |
= |
-22.54072173 |
6 |
1358330 |
2458 |
- |
2552 |
= |
-94 |
* |
(1207 |
/ |
5071) |
= |
-22.37389072 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Salinas City Elementary
|
-80 |
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 |
42739 |
2378 |
- |
2436 |
= |
-58 |
* |
(1308 |
/ |
5113) |
= |
-14.83747306 |
4 |
42741 |
2410 |
- |
2485 |
= |
-75 |
* |
(1286 |
/ |
5113) |
= |
-18.8636808 |
5 |
42743 |
2436 |
- |
2528 |
= |
-92 |
* |
(1304 |
/ |
5113) |
= |
-23.46332874 |
6 |
42744 |
2457 |
- |
2552 |
= |
-95 |
* |
(1215 |
/ |
5113) |
= |
-22.57480925 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Salinas City Elementary
|
-80 |
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 |
43807 |
2389 |
- |
2436 |
= |
-47 |
* |
(1261 |
/ |
5143) |
= |
-11.52381875 |
4 |
43809 |
2408 |
- |
2485 |
= |
-77 |
* |
(1309 |
/ |
5143) |
= |
-19.59809444 |
5 |
43812 |
2433 |
- |
2528 |
= |
-95 |
* |
(1273 |
/ |
5143) |
= |
-23.51448569 |
6 |
43813 |
2459 |
- |
2552 |
= |
-93 |
* |
(1300 |
/ |
5143) |
= |
-23.50768031 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Salinas City Elementary
|
-78 |
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 |
43830 |
2394 |
- |
2436 |
= |
-42 |
* |
(1198 |
/ |
5010) |
= |
-10.04311375 |
4 |
43833 |
2422 |
- |
2485 |
= |
-63 |
* |
(1262 |
/ |
5010) |
= |
-15.86946104 |
5 |
43834 |
2439 |
- |
2528 |
= |
-89 |
* |
(1294 |
/ |
5010) |
= |
-22.98722554 |
6 |
43837 |
2459 |
- |
2552 |
= |
-93 |
* |
(1256 |
/ |
5010) |
= |
-23.31496999 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Salinas City Elementary
|
-72 |
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 |
43958 |
2401 |
- |
2436 |
= |
-35 |
* |
(1202 |
/ |
4938) |
= |
-8.51964358 |
4 |
43959 |
2433 |
- |
2485 |
= |
-52 |
* |
(1206 |
/ |
4938) |
= |
-12.69987846 |
5 |
43960 |
2452 |
- |
2528 |
= |
-76 |
* |
(1262 |
/ |
4938) |
= |
-19.42324826 |
6 |
43961 |
2472 |
- |
2552 |
= |
-80 |
* |
(1268 |
/ |
4938) |
= |
-20.54272984 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Salinas City Elementary
|
-61 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-80
|
-80
|
-78
|
-72
|
-61
|
-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.