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 |
963700 |
2467 |
- |
2436 |
= |
31 |
* |
(122 |
/ |
322)
|
= |
11.7453416 |
4 |
963701 |
2508 |
- |
2485 |
= |
23 |
* |
(105 |
/ |
322)
|
= |
7.49999999 |
5 |
963704 |
2534 |
- |
2528 |
= |
6 |
* |
(95 |
/ |
322)
|
= |
1.77018633 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Third Street Elementary
|
21 |
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 |
30494 |
2473 |
- |
2436 |
= |
37 |
* |
(92 |
/ |
285)
|
= |
11.94385963 |
4 |
30497 |
2521 |
- |
2485 |
= |
36 |
* |
(98 |
/ |
285)
|
= |
12.37894736 |
5 |
30498 |
2527 |
- |
2528 |
= |
-1 |
* |
(95 |
/ |
285)
|
= |
-0.33333333 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Third Street Elementary
|
24 |
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 |
31059 |
2490 |
- |
2436 |
= |
54 |
* |
(114 |
/ |
285)
|
= |
21.6 |
4 |
31061 |
2511 |
- |
2485 |
= |
26 |
* |
(75 |
/ |
285)
|
= |
6.84210524 |
5 |
31064 |
2519 |
- |
2528 |
= |
-9 |
* |
(96 |
/ |
285)
|
= |
-3.03157895 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Third Street Elementary
|
25 |
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 |
31107 |
2483 |
- |
2436 |
= |
47 |
* |
(83 |
/ |
245)
|
= |
15.92244897 |
4 |
31109 |
2533 |
- |
2485 |
= |
48 |
* |
(93 |
/ |
245)
|
= |
18.22040813 |
5 |
31111 |
2516 |
- |
2528 |
= |
-12 |
* |
(69 |
/ |
245)
|
= |
-3.37959184 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Third Street Elementary
|
31 |
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 |
31282 |
2473 |
- |
2436 |
= |
37 |
* |
(82 |
/ |
230)
|
= |
13.19130434 |
4 |
31283 |
2527 |
- |
2485 |
= |
42 |
* |
(73 |
/ |
230)
|
= |
13.33043477 |
5 |
31284 |
2567 |
- |
2528 |
= |
39 |
* |
(75 |
/ |
230)
|
= |
12.71739128 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Third Street Elementary
|
39 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
21
|
24
|
25
|
31
|
39
|
140.0 |
28.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 49.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 7.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: