Beech Avenue Elementary (Data source)
Source data for Beech Avenue 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 | 1984216 | 2415 | - | 2436 | = | -21 | * | (120 | / | 478) | = | -5.27196653 | ||
4 | 1984217 | 2420 | - | 2485 | = | -65 | * | (134 | / | 478) | = | -18.22175732 | ||
5 | 1984220 | 2464 | - | 2528 | = | -64 | * | (121 | / | 478) | = | -16.2008368 | ||
6 | 1984221 | 2498 | - | 2552 | = | -54 | * | (103 | / | 478) | = | -11.63598323 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Beech Avenue Elementary | -51 |
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 | 61033 | 2429 | - | 2436 | = | -7 | * | (117 | / | 483) | = | -1.69565217 | ||
4 | 61035 | 2461 | - | 2485 | = | -24 | * | (114 | / | 483) | = | -5.66459626 | ||
5 | 61037 | 2440 | - | 2528 | = | -88 | * | (129 | / | 483) | = | -23.50310556 | ||
6 | 61038 | 2499 | - | 2552 | = | -53 | * | (123 | / | 483) | = | -13.49689441 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Beech Avenue Elementary | -44 |
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 | 62794 | 2439 | - | 2436 | = | 3 | * | (118 | / | 488) | = | 0.72540983 | ||
4 | 62797 | 2446 | - | 2485 | = | -39 | * | (113 | / | 488) | = | -9.0307377 | ||
5 | 62798 | 2466 | - | 2528 | = | -62 | * | (118 | / | 488) | = | -14.99180324 | ||
6 | 62800 | 2475 | - | 2552 | = | -77 | * | (139 | / | 488) | = | -21.93237701 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Beech Avenue Elementary | -45 |
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 | 62875 | 2451 | - | 2436 | = | 15 | * | (106 | / | 472) | = | 3.36864407 | ||
4 | 62877 | 2462 | - | 2485 | = | -23 | * | (127 | / | 472) | = | -6.18855931 | ||
5 | 62879 | 2491 | - | 2528 | = | -37 | * | (115 | / | 472) | = | -9.01483048 | ||
6 | 62881 | 2500 | - | 2552 | = | -52 | * | (124 | / | 472) | = | -13.66101693 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Beech Avenue Elementary | -25 |
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 | 63144 | 2461 | - | 2436 | = | 25 | * | (113 | / | 462) | = | 6.1147186 | ||
4 | 63145 | 2470 | - | 2485 | = | -15 | * | (104 | / | 462) | = | -3.37662338 | ||
5 | 63146 | 2491 | - | 2528 | = | -37 | * | (128 | / | 462) | = | -10.25108225 | ||
6 | 63147 | 2512 | - | 2552 | = | -40 | * | (117 | / | 462) | = | -10.12987012 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Beech Avenue Elementary | -18 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-51 | -44 | -45 | -25 | -18 | -183.0 | -36.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 5.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -78.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 | 93% | 87% | 86% | 91% | 93% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Fontana Unified school district County of San Bernardino
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.
Beech Avenue Elementary math proficiency
Zero+ meets standard.
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
83% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
79% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
75% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
84% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
83% 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.