Arroyo Elementary (Data source)
Source data for Arroyo 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 | 1091433 | 2365 | - | 2436 | = | -71 | * | (95 | / | 342) | = | -19.72222217 | ||
4 | 1091436 | 2400 | - | 2485 | = | -85 | * | (87 | / | 342) | = | -21.62280694 | ||
5 | 1091437 | 2411 | - | 2528 | = | -117 | * | (75 | / | 342) | = | -25.65789467 | ||
6 | 1091440 | 2465 | - | 2552 | = | -87 | * | (85 | / | 342) | = | -21.62280696 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Arroyo Elementary | -89 |
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 | 34160 | 2376 | - | 2436 | = | -60 | * | (96 | / | 338) | = | -17.04142008 | ||
4 | 34162 | 2414 | - | 2485 | = | -71 | * | (95 | / | 338) | = | -19.95562125 | ||
5 | 34164 | 2429 | - | 2528 | = | -99 | * | (81 | / | 338) | = | -23.72485203 | ||
6 | 34165 | 2439 | - | 2552 | = | -113 | * | (66 | / | 338) | = | -22.06508874 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Arroyo Elementary | -83 |
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 | 34771 | 2360 | - | 2436 | = | -76 | * | (77 | / | 334) | = | -17.52095807 | ||
4 | 34773 | 2401 | - | 2485 | = | -84 | * | (97 | / | 334) | = | -24.39520952 | ||
5 | 34775 | 2438 | - | 2528 | = | -90 | * | (90 | / | 334) | = | -24.25149693 | ||
6 | 34778 | 2410 | - | 2552 | = | -142 | * | (70 | / | 334) | = | -29.760479 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Arroyo Elementary | -96 |
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 | 34781 | 2387 | - | 2436 | = | -49 | * | (81 | / | 320) | = | -12.403125 | ||
4 | 34783 | 2424 | - | 2485 | = | -61 | * | (67 | / | 320) | = | -12.771875 | ||
5 | 34785 | 2427 | - | 2528 | = | -101 | * | (90 | / | 320) | = | -28.40625 | ||
6 | 34787 | 2468 | - | 2552 | = | -84 | * | (82 | / | 320) | = | -21.525 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Arroyo Elementary | -75 |
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 | 34957 | 2391 | - | 2436 | = | -45 | * | (75 | / | 286) | = | -11.80069929 | ||
4 | 34958 | 2435 | - | 2485 | = | -50 | * | (68 | / | 286) | = | -11.88811185 | ||
5 | 34959 | 2409 | - | 2528 | = | -119 | * | (67 | / | 286) | = | -27.87762235 | ||
6 | 34960 | 2455 | - | 2552 | = | -97 | * | (76 | / | 286) | = | -25.77622371 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Arroyo Elementary | -77 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-89 | -83 | -96 | -75 | -77 | -420.0 | -84.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -60.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -108.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:
2015 | 2016 | 2017 | 2018 | 2019 | |
---|---|---|---|---|---|
Percent | 94% | 95% | 95% | 94% | 95% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Pomona Unified school district County of Los Angeles
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation, parent education.
NOT what teachers want.
NOT what principals want.
NOT what parents want.
Arroyo Elementary math proficiency
Zero+ meets standard.
86% less $meal
88% less $meal
84% less $meal
86% less $meal
87% 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.