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 |
2258420 |
2377 |
- |
2436 |
= |
-59 |
* |
(36 |
/ |
232)
|
= |
-9.15517237 |
4 |
2258421 |
2464 |
- |
2485 |
= |
-21 |
* |
(42 |
/ |
232)
|
= |
-3.80172412 |
5 |
2258424 |
2494 |
- |
2528 |
= |
-34 |
* |
(36 |
/ |
232)
|
= |
-5.27586204 |
6 |
2258425 |
2456 |
- |
2552 |
= |
-96 |
* |
(31 |
/ |
232)
|
= |
-12.82758614 |
7 |
2258428 |
2470 |
- |
2567 |
= |
-97 |
* |
(51 |
/ |
232)
|
= |
-21.32327584 |
8 |
2258429 |
2506 |
- |
2586 |
= |
-80 |
* |
(36 |
/ |
232)
|
= |
-12.41379304 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Harriet Tubman Village Charter
|
-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 |
69302 |
2423 |
- |
2436 |
= |
-13 |
* |
(46 |
/ |
250)
|
= |
-2.392 |
4 |
69303 |
2448 |
- |
2485 |
= |
-37 |
* |
(36 |
/ |
250)
|
= |
-5.328 |
5 |
69306 |
2508 |
- |
2528 |
= |
-20 |
* |
(45 |
/ |
250)
|
= |
-3.6 |
6 |
69307 |
2524 |
- |
2552 |
= |
-28 |
* |
(45 |
/ |
250)
|
= |
-5.04 |
7 |
69310 |
2470 |
- |
2567 |
= |
-97 |
* |
(32 |
/ |
250)
|
= |
-12.416 |
8 |
69311 |
2493 |
- |
2586 |
= |
-93 |
* |
(46 |
/ |
250)
|
= |
-17.112 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Harriet Tubman Village Charter
|
-46 |
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 |
71134 |
2419 |
- |
2436 |
= |
-17 |
* |
(39 |
/ |
237)
|
= |
-2.79746835 |
4 |
71137 |
2451 |
- |
2485 |
= |
-34 |
* |
(46 |
/ |
237)
|
= |
-6.59915612 |
5 |
71138 |
2487 |
- |
2528 |
= |
-41 |
* |
(36 |
/ |
237)
|
= |
-6.22784809 |
6 |
71141 |
2517 |
- |
2552 |
= |
-35 |
* |
(44 |
/ |
237)
|
= |
-6.49789028 |
7 |
71143 |
2502 |
- |
2567 |
= |
-65 |
* |
(43 |
/ |
237)
|
= |
-11.79324894 |
8 |
71145 |
2475 |
- |
2586 |
= |
-111 |
* |
(29 |
/ |
237)
|
= |
-13.58227846 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Harriet Tubman Village Charter
|
-47 |
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 |
71279 |
2397 |
- |
2436 |
= |
-39 |
* |
(51 |
/ |
291)
|
= |
-6.83505151 |
4 |
71282 |
2473 |
- |
2485 |
= |
-12 |
* |
(36 |
/ |
291)
|
= |
-1.48453608 |
5 |
71283 |
2472 |
- |
2528 |
= |
-56 |
* |
(51 |
/ |
291)
|
= |
-9.81443294 |
6 |
71286 |
2462 |
- |
2552 |
= |
-90 |
* |
(50 |
/ |
291)
|
= |
-15.46391745 |
7 |
71287 |
2472 |
- |
2567 |
= |
-95 |
* |
(52 |
/ |
291)
|
= |
-16.97594501 |
8 |
71290 |
2490 |
- |
2586 |
= |
-96 |
* |
(51 |
/ |
291)
|
= |
-16.82474218 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Harriet Tubman Village Charter
|
-67 |
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 |
71770 |
2427 |
- |
2436 |
= |
-9 |
* |
(34 |
/ |
285)
|
= |
-1.07368421 |
4 |
71771 |
2447 |
- |
2485 |
= |
-38 |
* |
(50 |
/ |
285)
|
= |
-6.66666665 |
5 |
71772 |
2506 |
- |
2528 |
= |
-22 |
* |
(36 |
/ |
285)
|
= |
-2.77894736 |
6 |
71773 |
2486 |
- |
2552 |
= |
-66 |
* |
(65 |
/ |
285)
|
= |
-15.05263155 |
7 |
71774 |
2482 |
- |
2567 |
= |
-85 |
* |
(49 |
/ |
285)
|
= |
-14.61403504 |
8 |
71775 |
2482 |
- |
2586 |
= |
-104 |
* |
(51 |
/ |
285)
|
= |
-18.61052627 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Harriet Tubman Village Charter
|
-59 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-65
|
-46
|
-47
|
-67
|
-59
|
-284.0 |
-56.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average:
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average:
For the lines, you have the data necessary to plot the chart.
Very last step
The percent of students getting a Free or Reduced Price Meal comes from the following sources: