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 |
2229968 |
2456 |
- |
2436 |
= |
20 |
* |
(28 |
/ |
162)
|
= |
3.45679012 |
4 |
2229969 |
2494 |
- |
2485 |
= |
9 |
* |
(28 |
/ |
162)
|
= |
1.55555555 |
5 |
2229972 |
2546 |
- |
2528 |
= |
18 |
* |
(28 |
/ |
162)
|
= |
3.11111111 |
6 |
2229973 |
2554 |
- |
2552 |
= |
2 |
* |
(30 |
/ |
162)
|
= |
0.37037037 |
7 |
2229976 |
2580 |
- |
2567 |
= |
13 |
* |
(25 |
/ |
162)
|
= |
2.00617283 |
8 |
2229977 |
2617 |
- |
2586 |
= |
31 |
* |
(23 |
/ |
162)
|
= |
4.40123455 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Old Town Academy K-8 Charter
|
15 |
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 |
68399 |
2469 |
- |
2436 |
= |
33 |
* |
(30 |
/ |
169)
|
= |
5.85798814 |
4 |
68402 |
2483 |
- |
2485 |
= |
-2 |
* |
(30 |
/ |
169)
|
= |
-0.35502958 |
5 |
68403 |
2540 |
- |
2528 |
= |
12 |
* |
(29 |
/ |
169)
|
= |
2.0591716 |
6 |
68406 |
2586 |
- |
2552 |
= |
34 |
* |
(29 |
/ |
169)
|
= |
5.83431952 |
7 |
68408 |
2591 |
- |
2567 |
= |
24 |
* |
(29 |
/ |
169)
|
= |
4.11834319 |
8 |
68410 |
2667 |
- |
2586 |
= |
81 |
* |
(22 |
/ |
169)
|
= |
10.54437863 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Old Town Academy K-8 Charter
|
28 |
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 |
70223 |
2469 |
- |
2436 |
= |
33 |
* |
(29 |
/ |
167)
|
= |
5.7305389 |
4 |
70224 |
2488 |
- |
2485 |
= |
3 |
* |
(30 |
/ |
167)
|
= |
0.53892215 |
5 |
70226 |
2546 |
- |
2528 |
= |
18 |
* |
(29 |
/ |
167)
|
= |
3.12574849 |
6 |
70228 |
2579 |
- |
2552 |
= |
27 |
* |
(27 |
/ |
167)
|
= |
4.36526944 |
7 |
70230 |
2646 |
- |
2567 |
= |
79 |
* |
(25 |
/ |
167)
|
= |
11.82634724 |
8 |
70232 |
2623 |
- |
2586 |
= |
37 |
* |
(27 |
/ |
167)
|
= |
5.9820359 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Old Town Academy K-8 Charter
|
32 |
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 |
70354 |
2489 |
- |
2436 |
= |
53 |
* |
(28 |
/ |
168)
|
= |
8.8333333 |
4 |
70355 |
2528 |
- |
2485 |
= |
43 |
* |
(29 |
/ |
168)
|
= |
7.42261902 |
5 |
70358 |
2566 |
- |
2528 |
= |
38 |
* |
(26 |
/ |
168)
|
= |
5.88095235 |
6 |
70359 |
2579 |
- |
2552 |
= |
27 |
* |
(29 |
/ |
168)
|
= |
4.66071427 |
7 |
70361 |
2615 |
- |
2567 |
= |
48 |
* |
(29 |
/ |
168)
|
= |
8.28571426 |
8 |
70363 |
2657 |
- |
2586 |
= |
71 |
* |
(27 |
/ |
168)
|
= |
11.41071424 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Old Town Academy K-8 Charter
|
46 |
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 |
70872 |
2520 |
- |
2436 |
= |
84 |
* |
(27 |
/ |
163)
|
= |
13.91411036 |
4 |
70873 |
2544 |
- |
2485 |
= |
59 |
* |
(28 |
/ |
163)
|
= |
10.13496932 |
5 |
70874 |
2587 |
- |
2528 |
= |
59 |
* |
(29 |
/ |
163)
|
= |
10.49693249 |
6 |
70875 |
2553 |
- |
2552 |
= |
1 |
* |
(26 |
/ |
163)
|
= |
0.1595092 |
7 |
70876 |
2605 |
- |
2567 |
= |
38 |
* |
(29 |
/ |
163)
|
= |
6.76073618 |
8 |
70877 |
2608 |
- |
2586 |
= |
22 |
* |
(24 |
/ |
163)
|
= |
3.23926379 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Old Town Academy K-8 Charter
|
45 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
15
|
28
|
32
|
46
|
45
|
166.0 |
33.2 |
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: