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 |
2006023 |
2379 |
- |
2436 |
= |
-57 |
* |
(2554 |
/ |
14537) |
= |
-10.01430828 |
4 |
2006026 |
2417 |
- |
2485 |
= |
-68 |
* |
(2474 |
/ |
14537) |
= |
-11.57267656 |
5 |
2006027 |
2444 |
- |
2528 |
= |
-84 |
* |
(2423 |
/ |
14537) |
= |
-14.000963 |
6 |
2006030 |
2466 |
- |
2552 |
= |
-86 |
* |
(2467 |
/ |
14537) |
= |
-14.59462054 |
7 |
2006031 |
2483 |
- |
2567 |
= |
-84 |
* |
(2275 |
/ |
14537) |
= |
-13.14576598 |
8 |
2006034 |
2500 |
- |
2586 |
= |
-86 |
* |
(2344 |
/ |
14537) |
= |
-13.86696009 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Ontario-Montclair
|
-77 |
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 |
61707 |
2393 |
- |
2436 |
= |
-43 |
* |
(2068 |
/ |
14040) |
= |
-6.33361822 |
4 |
61709 |
2424 |
- |
2485 |
= |
-61 |
* |
(2521 |
/ |
14040) |
= |
-10.95306264 |
5 |
61711 |
2448 |
- |
2528 |
= |
-80 |
* |
(2452 |
/ |
14040) |
= |
-13.97150992 |
6 |
61712 |
2475 |
- |
2552 |
= |
-77 |
* |
(2367 |
/ |
14040) |
= |
-12.98141021 |
7 |
61715 |
2491 |
- |
2567 |
= |
-76 |
* |
(2373 |
/ |
14040) |
= |
-12.84529914 |
8 |
61716 |
2510 |
- |
2586 |
= |
-76 |
* |
(2257 |
/ |
14040) |
= |
-12.21737886 |
11 |
61719 |
0 |
- |
2628 |
= |
|
* |
(2 |
/ |
14040) |
= |
|
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Ontario-Montclair
|
-69 |
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 |
63489 |
2407 |
- |
2436 |
= |
-29 |
* |
(2457 |
/ |
14034) |
= |
-5.07716972 |
4 |
63491 |
2438 |
- |
2485 |
= |
-47 |
* |
(2051 |
/ |
14034) |
= |
-6.86881857 |
5 |
63492 |
2462 |
- |
2528 |
= |
-66 |
* |
(2467 |
/ |
14034) |
= |
-11.60196662 |
6 |
63495 |
2481 |
- |
2552 |
= |
-71 |
* |
(2435 |
/ |
14034) |
= |
-12.31901092 |
7 |
63497 |
2495 |
- |
2567 |
= |
-72 |
* |
(2289 |
/ |
14034) |
= |
-11.74348008 |
8 |
63498 |
2519 |
- |
2586 |
= |
-67 |
* |
(2335 |
/ |
14034) |
= |
-11.14757015 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Ontario-Montclair
|
-59 |
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 |
63590 |
2412 |
- |
2436 |
= |
-24 |
* |
(2320 |
/ |
13733) |
= |
-4.05446734 |
4 |
63591 |
2450 |
- |
2485 |
= |
-35 |
* |
(2389 |
/ |
13733) |
= |
-6.08861866 |
5 |
63594 |
2473 |
- |
2528 |
= |
-55 |
* |
(2044 |
/ |
13733) |
= |
-8.18612102 |
6 |
63595 |
2488 |
- |
2552 |
= |
-64 |
* |
(2423 |
/ |
13733) |
= |
-11.29192454 |
7 |
63598 |
2501 |
- |
2567 |
= |
-66 |
* |
(2300 |
/ |
13733) |
= |
-11.05366634 |
8 |
63599 |
2532 |
- |
2586 |
= |
-54 |
* |
(2257 |
/ |
13733) |
= |
-8.87482705 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Ontario-Montclair
|
-50 |
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 |
63852 |
2417 |
- |
2436 |
= |
-19 |
* |
(2189 |
/ |
13508) |
= |
-3.07899022 |
4 |
63853 |
2458 |
- |
2485 |
= |
-27 |
* |
(2307 |
/ |
13508) |
= |
-4.61126739 |
5 |
63854 |
2489 |
- |
2528 |
= |
-39 |
* |
(2407 |
/ |
13508) |
= |
-6.94943734 |
6 |
63855 |
2502 |
- |
2552 |
= |
-50 |
* |
(2016 |
/ |
13508) |
= |
-7.46224455 |
7 |
63856 |
2510 |
- |
2567 |
= |
-57 |
* |
(2301 |
/ |
13508) |
= |
-9.7095795 |
8 |
63857 |
2532 |
- |
2586 |
= |
-54 |
* |
(2288 |
/ |
13508) |
= |
-9.14657978 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Ontario-Montclair
|
-41 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-77
|
-69
|
-59
|
-50
|
-41
|
-296.0 |
-59.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -17.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -101.2
For the lines, you have the data necessary to plot the chart.