Hilmar Middle (Data source)
Source data for Hilmar 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 |
||
| 6 | 1300299 | 2463 | - | 2552 | = | -89 | * | (184 | / | 534) | = | -30.66666663 | ||
| 7 | 1300300 | 2495 | - | 2567 | = | -72 | * | (174 | / | 534) | = | -23.46067411 | ||
| 8 | 1300302 | 2491 | - | 2586 | = | -95 | * | (176 | / | 534) | = | -31.31086133 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Hilmar Middle | -85 | ||||||||||||
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 |
||
| 6 | 40787 | 2467 | - | 2552 | = | -85 | * | (188 | / | 552) | = | -28.94927535 | ||
| 7 | 40788 | 2510 | - | 2567 | = | -57 | * | (184 | / | 552) | = | -18.99999998 | ||
| 8 | 40790 | 2505 | - | 2586 | = | -81 | * | (180 | / | 552) | = | -26.41304344 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Hilmar Middle | -74 | ||||||||||||
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 |
||
| 6 | 41790 | 2456 | - | 2552 | = | -96 | * | (190 | / | 567) | = | -32.1693121 | ||
| 7 | 41792 | 2482 | - | 2567 | = | -85 | * | (187 | / | 567) | = | -28.03350966 | ||
| 8 | 41794 | 2496 | - | 2586 | = | -90 | * | (190 | / | 567) | = | -30.15873009 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Hilmar Middle | -90 | ||||||||||||
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 |
||
| 6 | 41823 | 2451 | - | 2552 | = | -101 | * | (194 | / | 576) | = | -34.01736106 | ||
| 7 | 41824 | 2485 | - | 2567 | = | -82 | * | (188 | / | 576) | = | -26.76388882 | ||
| 8 | 41827 | 2497 | - | 2586 | = | -89 | * | (194 | / | 576) | = | -29.9756944 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Hilmar Middle | -91 | ||||||||||||
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 |
||
| 6 | 41968 | 2467 | - | 2552 | = | -85 | * | (160 | / | 538) | = | -25.27881037 | ||
| 7 | 41969 | 2486 | - | 2567 | = | -81 | * | (191 | / | 538) | = | -28.75650555 | ||
| 8 | 41970 | 2519 | - | 2586 | = | -67 | * | (187 | / | 538) | = | -23.28810408 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Hilmar Middle | -77 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -85 | -74 | -90 | -91 | -77 | -417.0 | -83.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -62.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -104.4
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 | 59% | 58% | 56% | 59% | 59% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Hilmar Unified school district County of Merced
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.
Hilmar Middle math proficiency
Zero+ meets standard.
45% less $meal
44% less $meal
43% less $meal
49% less $meal
50% 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 Hilmar Unified (1)
| Hilmar Middle |