Willard F. Payne Elementary (Data source)
Source data for Willard F. Payne Elementary
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 | 1042866 | 2376 | - | 2436 | = | -60 | * | (77 | / | 282) | = | -16.3829787 | ||
4 | 1042869 | 2405 | - | 2485 | = | -80 | * | (70 | / | 282) | = | -19.858156 | ||
5 | 1042870 | 2405 | - | 2528 | = | -123 | * | (67 | / | 282) | = | -29.2234042 | ||
6 | 1042873 | 2478 | - | 2552 | = | -74 | * | (68 | / | 282) | = | -17.84397157 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Willard F. Payne Elementary | -83 |
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 | 32761 | 2376 | - | 2436 | = | -60 | * | (72 | / | 287) | = | -15.0522648 | ||
4 | 32763 | 2408 | - | 2485 | = | -77 | * | (79 | / | 287) | = | -21.19512195 | ||
5 | 32765 | 2419 | - | 2528 | = | -109 | * | (73 | / | 287) | = | -27.7247386 | ||
6 | 32767 | 2419 | - | 2552 | = | -133 | * | (63 | / | 287) | = | -29.19512194 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Willard F. Payne Elementary | -93 |
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 | 33338 | 2385 | - | 2436 | = | -51 | * | (91 | / | 308) | = | -15.0681818 | ||
4 | 33340 | 2387 | - | 2485 | = | -98 | * | (75 | / | 308) | = | -23.86363631 | ||
5 | 33342 | 2438 | - | 2528 | = | -90 | * | (73 | / | 308) | = | -21.33116883 | ||
6 | 33345 | 2461 | - | 2552 | = | -91 | * | (69 | / | 308) | = | -20.38636363 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Willard F. Payne Elementary | -81 |
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 | 33359 | 2376 | - | 2436 | = | -60 | * | (50 | / | 274) | = | -10.94890506 | ||
4 | 33360 | 2386 | - | 2485 | = | -99 | * | (91 | / | 274) | = | -32.87956201 | ||
5 | 33363 | 2427 | - | 2528 | = | -101 | * | (68 | / | 274) | = | -25.06569338 | ||
6 | 33364 | 2468 | - | 2552 | = | -84 | * | (65 | / | 274) | = | -19.92700727 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Willard F. Payne Elementary | -89 |
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 | 33531 | 2397 | - | 2436 | = | -39 | * | (70 | / | 283) | = | -9.6466431 | ||
4 | 33532 | 2395 | - | 2485 | = | -90 | * | (55 | / | 283) | = | -17.49116601 | ||
5 | 33533 | 2443 | - | 2528 | = | -85 | * | (90 | / | 283) | = | -27.03180209 | ||
6 | 33534 | 2478 | - | 2552 | = | -74 | * | (68 | / | 283) | = | -17.78091869 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Willard F. Payne Elementary | -72 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-83 | -93 | -81 | -89 | -72 | -418.0 | -83.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -59.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -107.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:
2015 | 2016 | 2017 | 2018 | 2019 | |
---|---|---|---|---|---|
Percent | 96% | 91% | 94% | 93% | 93% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Mountain View Elementary school district | County of Los Angeles
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation: wealth/poverty.
NOT what teachers want.
NOT what principals want.
NOT what parents want.
Willard F. Payne Elementary math proficiency
Zero+ meets standard.
90% less $meal
85% less $meal
87% less $meal
90% less $meal
89% less $meal
• Any result above zero is proficient; below is not proficient. • There is a 99% chance that results will remain the same in coming years, which is to say, between the Upper and Lower Control Limits (the gray lines). • The houses with the % of students receiving a Free or Reduced Price Meal is a measure of wealth/poverty.