George T. Egling Middle (Data source)
Source data for George T. Egling Middle
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 |
||
| 4 | 168953 | 2446 | - | 2485 | = | -39 | * | (82 | / | 492) | = | -6.49999997 | ||
| 5 | 168956 | 2455 | - | 2528 | = | -73 | * | (103 | / | 492) | = | -15.28252029 | ||
| 6 | 168957 | 2485 | - | 2552 | = | -67 | * | (99 | / | 492) | = | -13.4817073 | ||
| 7 | 168960 | 2516 | - | 2567 | = | -51 | * | (114 | / | 492) | = | -11.81707317 | ||
| 8 | 168961 | 2544 | - | 2586 | = | -42 | * | (94 | / | 492) | = | -8.02439022 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for George T. Egling Middle | -55 | ||||||||||||
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 |
||
| 4 | 5064 | 2443 | - | 2485 | = | -42 | * | (104 | / | 503) | = | -8.68389661 | ||
| 5 | 5066 | 2461 | - | 2528 | = | -67 | * | (85 | / | 503) | = | -11.32206756 | ||
| 6 | 5067 | 2471 | - | 2552 | = | -81 | * | (100 | / | 503) | = | -16.10337972 | ||
| 7 | 5070 | 2511 | - | 2567 | = | -56 | * | (100 | / | 503) | = | -11.13320079 | ||
| 8 | 5071 | 2547 | - | 2586 | = | -39 | * | (114 | / | 503) | = | -8.8389662 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for George T. Egling Middle | -56 | ||||||||||||
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 |
||
| 4 | 5169 | 2461 | - | 2485 | = | -24 | * | (120 | / | 529) | = | -5.4442344 | ||
| 5 | 5171 | 2452 | - | 2528 | = | -76 | * | (108 | / | 529) | = | -15.51606804 | ||
| 6 | 5174 | 2470 | - | 2552 | = | -82 | * | (94 | / | 529) | = | -14.5708884 | ||
| 7 | 5176 | 2507 | - | 2567 | = | -60 | * | (108 | / | 529) | = | -12.2495274 | ||
| 8 | 5178 | 2532 | - | 2586 | = | -54 | * | (99 | / | 529) | = | -10.10586008 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for George T. Egling Middle | -58 | ||||||||||||
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 |
||
| 4 | 5174 | 2452 | - | 2485 | = | -33 | * | (124 | / | 541) | = | -7.56377078 | ||
| 5 | 5175 | 2469 | - | 2528 | = | -59 | * | (125 | / | 541) | = | -13.63216264 | ||
| 6 | 5178 | 2475 | - | 2552 | = | -77 | * | (100 | / | 541) | = | -14.23290199 | ||
| 7 | 5179 | 2485 | - | 2567 | = | -82 | * | (95 | / | 541) | = | -14.3992606 | ||
| 8 | 5182 | 2535 | - | 2586 | = | -51 | * | (97 | / | 541) | = | -9.14417745 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for George T. Egling Middle | -59 | ||||||||||||
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 |
||
| 4 | 5215 | 2472 | - | 2485 | = | -13 | * | (105 | / | 563) | = | -2.42451154 | ||
| 5 | 5216 | 2470 | - | 2528 | = | -58 | * | (122 | / | 563) | = | -12.5683836 | ||
| 6 | 5217 | 2493 | - | 2552 | = | -59 | * | (129 | / | 563) | = | -13.51865006 | ||
| 7 | 5218 | 2519 | - | 2567 | = | -48 | * | (104 | / | 563) | = | -8.86678507 | ||
| 8 | 5219 | 2532 | - | 2586 | = | -54 | * | (103 | / | 563) | = | -9.87921846 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for George T. Egling Middle | -47 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -55 | -56 | -58 | -59 | -47 | -275.0 | -55.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -43.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -67.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 | 75% | 75% | 71% | 73% | 72% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Colusa Unified school district | County of Colusa
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.
George T. Egling Middle math proficiency
Zero+ meets standard.
54% less $meal
54% less $meal
59% less $meal
63% less $meal
59% 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.
Intermediate/Middle Schools (Public) schools in Colusa Unified (1)
| George T. Egling Middle |