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 |
1796947 |
2454 |
- |
2436 |
= |
18 |
* |
(135 |
/ |
558)
|
= |
4.35483869 |
4 |
1796948 |
2490 |
- |
2485 |
= |
5 |
* |
(139 |
/ |
558)
|
= |
1.24551971 |
5 |
1796951 |
2520 |
- |
2528 |
= |
-8 |
* |
(143 |
/ |
558)
|
= |
-2.05017921 |
6 |
1796952 |
2555 |
- |
2552 |
= |
3 |
* |
(141 |
/ |
558)
|
= |
0.75806452 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Helen Carr Castello Elementary
|
4 |
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 |
55721 |
2454 |
- |
2436 |
= |
18 |
* |
(141 |
/ |
554)
|
= |
4.58122743 |
4 |
55722 |
2510 |
- |
2485 |
= |
25 |
* |
(136 |
/ |
554)
|
= |
6.1371841 |
5 |
55725 |
2509 |
- |
2528 |
= |
-19 |
* |
(139 |
/ |
554)
|
= |
-4.76714801 |
6 |
55726 |
2558 |
- |
2552 |
= |
6 |
* |
(138 |
/ |
554)
|
= |
1.49458483 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Helen Carr Castello Elementary
|
7 |
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 |
57345 |
2451 |
- |
2436 |
= |
15 |
* |
(122 |
/ |
552)
|
= |
3.31521738 |
4 |
57347 |
2503 |
- |
2485 |
= |
18 |
* |
(145 |
/ |
552)
|
= |
4.72826086 |
5 |
57349 |
2539 |
- |
2528 |
= |
11 |
* |
(146 |
/ |
552)
|
= |
2.90942028 |
6 |
57351 |
2554 |
- |
2552 |
= |
2 |
* |
(139 |
/ |
552)
|
= |
0.50362319 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Helen Carr Castello Elementary
|
11 |
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 |
57456 |
2475 |
- |
2436 |
= |
39 |
* |
(123 |
/ |
542)
|
= |
8.85055349 |
4 |
57458 |
2496 |
- |
2485 |
= |
11 |
* |
(124 |
/ |
542)
|
= |
2.51660516 |
5 |
57460 |
2539 |
- |
2528 |
= |
11 |
* |
(146 |
/ |
542)
|
= |
2.96309962 |
6 |
57462 |
2578 |
- |
2552 |
= |
26 |
* |
(149 |
/ |
542)
|
= |
7.14760147 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Helen Carr Castello Elementary
|
21 |
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 |
57710 |
2451 |
- |
2436 |
= |
15 |
* |
(115 |
/ |
522)
|
= |
3.3045977 |
4 |
57711 |
2497 |
- |
2485 |
= |
12 |
* |
(125 |
/ |
522)
|
= |
2.87356321 |
5 |
57712 |
2526 |
- |
2528 |
= |
-2 |
* |
(129 |
/ |
522)
|
= |
-0.49425287 |
6 |
57713 |
2572 |
- |
2552 |
= |
20 |
* |
(153 |
/ |
522)
|
= |
5.86206896 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Helen Carr Castello Elementary
|
12 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
4
|
7
|
11
|
21
|
12
|
55.0 |
11.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 29.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: