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 |
2381320 |
2496 |
- |
2436 |
= |
60 |
* |
(83 |
/ |
412)
|
= |
12.0873786 |
| 4 |
2381323 |
2518 |
- |
2485 |
= |
33 |
* |
(69 |
/ |
412)
|
= |
5.52669902 |
| 5 |
2381324 |
2566 |
- |
2528 |
= |
38 |
* |
(71 |
/ |
412)
|
= |
6.54854369 |
| 6 |
2381327 |
2613 |
- |
2552 |
= |
61 |
* |
(66 |
/ |
412)
|
= |
9.77184461 |
| 7 |
2381328 |
2618 |
- |
2567 |
= |
51 |
* |
(66 |
/ |
412)
|
= |
8.16990287 |
| 8 |
2381331 |
2634 |
- |
2586 |
= |
48 |
* |
(57 |
/ |
412)
|
= |
6.64077667 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Lilienthal (Claire) Elementary
|
49 |
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 |
72719 |
2495 |
- |
2436 |
= |
59 |
* |
(77 |
/ |
420)
|
= |
10.81666665 |
| 4 |
72721 |
2521 |
- |
2485 |
= |
36 |
* |
(81 |
/ |
420)
|
= |
6.94285711 |
| 5 |
72724 |
2573 |
- |
2528 |
= |
45 |
* |
(67 |
/ |
420)
|
= |
7.17857141 |
| 6 |
72726 |
2620 |
- |
2552 |
= |
68 |
* |
(64 |
/ |
420)
|
= |
10.36190474 |
| 7 |
72728 |
2619 |
- |
2567 |
= |
52 |
* |
(66 |
/ |
420)
|
= |
8.17142856 |
| 8 |
72729 |
2634 |
- |
2586 |
= |
48 |
* |
(65 |
/ |
420)
|
= |
7.42857139 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Lilienthal (Claire) Elementary
|
51 |
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 |
74692 |
2508 |
- |
2436 |
= |
72 |
* |
(80 |
/ |
426)
|
= |
13.52112674 |
| 4 |
74693 |
2535 |
- |
2485 |
= |
50 |
* |
(74 |
/ |
426)
|
= |
8.685446 |
| 5 |
74696 |
2560 |
- |
2528 |
= |
32 |
* |
(75 |
/ |
426)
|
= |
5.63380282 |
| 6 |
74698 |
2606 |
- |
2552 |
= |
54 |
* |
(66 |
/ |
426)
|
= |
8.36619716 |
| 7 |
74699 |
2648 |
- |
2567 |
= |
81 |
* |
(65 |
/ |
426)
|
= |
12.35915488 |
| 8 |
74701 |
2623 |
- |
2586 |
= |
37 |
* |
(66 |
/ |
426)
|
= |
5.73239435 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Lilienthal (Claire) Elementary
|
54 |
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 |
74866 |
2499 |
- |
2436 |
= |
63 |
* |
(75 |
/ |
417)
|
= |
11.33093525 |
| 4 |
74868 |
2570 |
- |
2485 |
= |
85 |
* |
(74 |
/ |
417)
|
= |
15.08393281 |
| 5 |
74869 |
2563 |
- |
2528 |
= |
35 |
* |
(68 |
/ |
417)
|
= |
5.70743404 |
| 6 |
74871 |
2631 |
- |
2552 |
= |
79 |
* |
(70 |
/ |
417)
|
= |
13.26139085 |
| 7 |
74874 |
2630 |
- |
2567 |
= |
63 |
* |
(66 |
/ |
417)
|
= |
9.971223 |
| 8 |
74875 |
2652 |
- |
2586 |
= |
66 |
* |
(64 |
/ |
417)
|
= |
10.12949639 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Lilienthal (Claire) Elementary
|
65 |
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 |
75394 |
2489 |
- |
2436 |
= |
53 |
* |
(78 |
/ |
430)
|
= |
9.61395344 |
| 4 |
75395 |
2544 |
- |
2485 |
= |
59 |
* |
(75 |
/ |
430)
|
= |
10.29069764 |
| 5 |
75396 |
2594 |
- |
2528 |
= |
66 |
* |
(74 |
/ |
430)
|
= |
11.35813952 |
| 6 |
75397 |
2628 |
- |
2552 |
= |
76 |
* |
(67 |
/ |
430)
|
= |
11.84186043 |
| 7 |
75398 |
2651 |
- |
2567 |
= |
84 |
* |
(70 |
/ |
430)
|
= |
13.67441855 |
| 8 |
75399 |
2632 |
- |
2586 |
= |
46 |
* |
(66 |
/ |
430)
|
= |
7.06046511 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Lilienthal (Claire) Elementary
|
64 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
49
|
51
|
54
|
65
|
64
|
283.0 |
56.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 77.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 35.6
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:
