### 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

### Just a coincidence? That's absurd.

It's a system that causes this pattern to repeat.

**
THIS chart shows what thefollow-the-schedule method wants.
**

NOT what teachers want.

NOT what principals want.

NOT what parents want.

*math*proficiency

**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 |