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 |
146096 |
2458 |
- |
2436 |
= |
22 |
* |
(29 |
/ |
167) |
= |
3.82035927 |
4 |
146097 |
2504 |
- |
2485 |
= |
19 |
* |
(32 |
/ |
167) |
= |
3.64071855 |
5 |
146100 |
2538 |
- |
2528 |
= |
10 |
* |
(26 |
/ |
167) |
= |
1.55688622 |
6 |
146101 |
2535 |
- |
2552 |
= |
-17 |
* |
(24 |
/ |
167) |
= |
-2.44311376 |
7 |
146104 |
2567 |
- |
2567 |
= |
0 |
* |
(27 |
/ |
167) |
= |
0.0 |
8 |
146105 |
2564 |
- |
2586 |
= |
-22 |
* |
(29 |
/ |
167) |
= |
-3.82035927 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Manzanita Elementary
|
3 |
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 |
4265 |
2441 |
- |
2436 |
= |
5 |
* |
(34 |
/ |
167) |
= |
1.01796407 |
4 |
4267 |
2472 |
- |
2485 |
= |
-13 |
* |
(27 |
/ |
167) |
= |
-2.1017964 |
5 |
4269 |
2535 |
- |
2528 |
= |
7 |
* |
(32 |
/ |
167) |
= |
1.34131736 |
6 |
4271 |
2561 |
- |
2552 |
= |
9 |
* |
(24 |
/ |
167) |
= |
1.29341317 |
7 |
4274 |
2571 |
- |
2567 |
= |
4 |
* |
(26 |
/ |
167) |
= |
0.62275449 |
8 |
4276 |
2593 |
- |
2586 |
= |
7 |
* |
(24 |
/ |
167) |
= |
1.00598802 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Manzanita Elementary
|
3 |
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 |
4345 |
2463 |
- |
2436 |
= |
27 |
* |
(27 |
/ |
174) |
= |
4.18965515 |
4 |
4348 |
2459 |
- |
2485 |
= |
-26 |
* |
(35 |
/ |
174) |
= |
-5.22988505 |
5 |
4349 |
2543 |
- |
2528 |
= |
15 |
* |
(27 |
/ |
174) |
= |
2.3275862 |
6 |
4351 |
2562 |
- |
2552 |
= |
10 |
* |
(33 |
/ |
174) |
= |
1.89655172 |
7 |
4354 |
2589 |
- |
2567 |
= |
22 |
* |
(28 |
/ |
174) |
= |
3.54022988 |
8 |
4356 |
2575 |
- |
2586 |
= |
-11 |
* |
(24 |
/ |
174) |
= |
-1.51724137 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Manzanita Elementary
|
5 |
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 |
4349 |
2435 |
- |
2436 |
= |
-1 |
* |
(33 |
/ |
187) |
= |
-0.17647059 |
4 |
4352 |
2482 |
- |
2485 |
= |
-3 |
* |
(30 |
/ |
187) |
= |
-0.48128342 |
5 |
4353 |
2505 |
- |
2528 |
= |
-23 |
* |
(38 |
/ |
187) |
= |
-4.67379679 |
6 |
4356 |
2576 |
- |
2552 |
= |
24 |
* |
(26 |
/ |
187) |
= |
3.33689839 |
7 |
4357 |
2590 |
- |
2567 |
= |
23 |
* |
(32 |
/ |
187) |
= |
3.93582886 |
8 |
4360 |
2609 |
- |
2586 |
= |
23 |
* |
(28 |
/ |
187) |
= |
3.44385026 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Manzanita Elementary
|
5 |
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 |
4396 |
2449 |
- |
2436 |
= |
13 |
* |
(42 |
/ |
211) |
= |
2.58767772 |
4 |
4397 |
2466 |
- |
2485 |
= |
-19 |
* |
(33 |
/ |
211) |
= |
-2.97156398 |
5 |
4398 |
2519 |
- |
2528 |
= |
-9 |
* |
(30 |
/ |
211) |
= |
-1.27962085 |
6 |
4399 |
2492 |
- |
2552 |
= |
-60 |
* |
(42 |
/ |
211) |
= |
-11.94312792 |
7 |
4400 |
2591 |
- |
2567 |
= |
24 |
* |
(30 |
/ |
211) |
= |
3.41232226 |
8 |
4401 |
2587 |
- |
2586 |
= |
1 |
* |
(34 |
/ |
211) |
= |
0.16113744 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Manzanita Elementary
|
-10 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
3
|
3
|
5
|
5
|
-10
|
6.0 |
1.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 19.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -16.8
For the lines, you have the data necessary to plot the chart.