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 |
321428 |
2413 |
- |
2436 |
= |
-23 |
* |
(80 |
/ |
536)
|
= |
-3.43283581 |
| 4 |
321429 |
2465 |
- |
2485 |
= |
-20 |
* |
(97 |
/ |
536)
|
= |
-3.61940298 |
| 5 |
321432 |
2514 |
- |
2528 |
= |
-14 |
* |
(96 |
/ |
536)
|
= |
-2.50746268 |
| 6 |
321433 |
2525 |
- |
2552 |
= |
-27 |
* |
(94 |
/ |
536)
|
= |
-4.73507462 |
| 7 |
321436 |
2520 |
- |
2567 |
= |
-47 |
* |
(88 |
/ |
536)
|
= |
-7.71641789 |
| 8 |
321437 |
2537 |
- |
2586 |
= |
-49 |
* |
(81 |
/ |
536)
|
= |
-7.4048507 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Bullard Talent
|
-29 |
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 |
9590 |
2445 |
- |
2436 |
= |
9 |
* |
(69 |
/ |
539)
|
= |
1.15213358 |
| 4 |
9591 |
2471 |
- |
2485 |
= |
-14 |
* |
(98 |
/ |
539)
|
= |
-2.54545453 |
| 5 |
9593 |
2521 |
- |
2528 |
= |
-7 |
* |
(96 |
/ |
539)
|
= |
-1.24675324 |
| 6 |
9596 |
2537 |
- |
2552 |
= |
-15 |
* |
(97 |
/ |
539)
|
= |
-2.69944341 |
| 7 |
9598 |
2532 |
- |
2567 |
= |
-35 |
* |
(92 |
/ |
539)
|
= |
-5.97402596 |
| 8 |
9599 |
2542 |
- |
2586 |
= |
-44 |
* |
(87 |
/ |
539)
|
= |
-7.10204079 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Bullard Talent
|
-18 |
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 |
9918 |
2468 |
- |
2436 |
= |
32 |
* |
(72 |
/ |
541)
|
= |
4.25878003 |
| 4 |
9920 |
2486 |
- |
2485 |
= |
1 |
* |
(97 |
/ |
541)
|
= |
0.1792976 |
| 5 |
9921 |
2500 |
- |
2528 |
= |
-28 |
* |
(99 |
/ |
541)
|
= |
-5.12384471 |
| 6 |
9924 |
2529 |
- |
2552 |
= |
-23 |
* |
(96 |
/ |
541)
|
= |
-4.08133086 |
| 7 |
9926 |
2531 |
- |
2567 |
= |
-36 |
* |
(93 |
/ |
541)
|
= |
-6.18853972 |
| 8 |
9928 |
2540 |
- |
2586 |
= |
-46 |
* |
(84 |
/ |
541)
|
= |
-7.14232901 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Bullard Talent
|
-18 |
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 |
9935 |
2485 |
- |
2436 |
= |
49 |
* |
(71 |
/ |
534)
|
= |
6.51498125 |
| 4 |
9937 |
2498 |
- |
2485 |
= |
13 |
* |
(96 |
/ |
534)
|
= |
2.33707864 |
| 5 |
9939 |
2502 |
- |
2528 |
= |
-26 |
* |
(98 |
/ |
534)
|
= |
-4.77153557 |
| 6 |
9941 |
2529 |
- |
2552 |
= |
-23 |
* |
(98 |
/ |
534)
|
= |
-4.22097378 |
| 7 |
9943 |
2526 |
- |
2567 |
= |
-41 |
* |
(84 |
/ |
534)
|
= |
-6.44943817 |
| 8 |
9945 |
2539 |
- |
2586 |
= |
-47 |
* |
(87 |
/ |
534)
|
= |
-7.65730336 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Bullard Talent
|
-14 |
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 |
10018 |
2483 |
- |
2436 |
= |
47 |
* |
(68 |
/ |
540)
|
= |
5.91851848 |
| 4 |
10019 |
2501 |
- |
2485 |
= |
16 |
* |
(98 |
/ |
540)
|
= |
2.9037037 |
| 5 |
10020 |
2525 |
- |
2528 |
= |
-3 |
* |
(95 |
/ |
540)
|
= |
-0.52777778 |
| 6 |
10021 |
2550 |
- |
2552 |
= |
-2 |
* |
(98 |
/ |
540)
|
= |
-0.36296296 |
| 7 |
10022 |
2546 |
- |
2567 |
= |
-21 |
* |
(97 |
/ |
540)
|
= |
-3.77222221 |
| 8 |
10023 |
2554 |
- |
2586 |
= |
-32 |
* |
(84 |
/ |
540)
|
= |
-4.97777776 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Bullard Talent
|
-1 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-29
|
-18
|
-18
|
-14
|
-1
|
-80.0 |
-16.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 14.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -46.0
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:
