### Manzanita Elementary (Data source)

##### Source data for Manzanita 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 | 667323 | 2398 | - | 2436 | = | -38 | * | (48 | / | 144) | = | -12.66666665 | ||

4 | 667324 | 2453 | - | 2485 | = | -32 | * | (47 | / | 144) | = | -10.44444442 | ||

5 | 667327 | 2470 | - | 2528 | = | -58 | * | (49 | / | 144) | = | -19.73611107 | ||

Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Manzanita Elementary | -43 |

#### 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 | 21166 | 2441 | - | 2436 | = | 5 | * | (32 | / | 128) | = | 1.25 | ||

4 | 21167 | 2462 | - | 2485 | = | -23 | * | (45 | / | 128) | = | -8.0859375 | ||

5 | 21170 | 2501 | - | 2528 | = | -27 | * | (51 | / | 128) | = | -10.7578125 | ||

Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Manzanita Elementary | -18 |

#### 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 | 21533 | 2430 | - | 2436 | = | -6 | * | (33 | / | 93) | = | -2.12903225 | ||

4 | 21536 | 2482 | - | 2485 | = | -3 | * | (24 | / | 93) | = | -0.77419355 | ||

5 | 21538 | 2505 | - | 2528 | = | -23 | * | (36 | / | 93) | = | -8.9032258 | ||

Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Manzanita Elementary | -12 |

#### 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 | 21512 | 2467 | - | 2436 | = | 31 | * | (24 | / | 94) | = | 7.91489359 | ||

4 | 21515 | 2446 | - | 2485 | = | -39 | * | (41 | / | 94) | = | -17.01063827 | ||

5 | 21516 | 2510 | - | 2528 | = | -18 | * | (29 | / | 94) | = | -5.55319148 | ||

Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Manzanita Elementary | -15 |

#### 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 | 21686 | 2427 | - | 2436 | = | -9 | * | (47 | / | 123) | = | -3.43902439 | ||

4 | 21687 | 2475 | - | 2485 | = | -10 | * | (33 | / | 123) | = | -2.68292682 | ||

5 | 21688 | 2478 | - | 2528 | = | -50 | * | (43 | / | 123) | = | -17.47967475 | ||

Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Manzanita Elementary | -24 |

#### Last steps

##### Compute the average

2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|

-43 | -18 | -12 | -15 | -24 | -112.0 | -22.4 |

##### Compute the Upper Control Limit

Simply compute the standard deviation and multiply by 3 and add to the average: **13.6**

##### Compute the Lower Control Limit

Simply compute the standard deviation and multiply by 3 and subtract from the average: **-58.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 | 84% | 77% | 81% | 74% | 72% |

Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |

#### Covina-Valley Unified school district | County of Los Angeles

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

Manzanita Elementary

*math*proficiency
Zero+ meets standard.

**73% less $meal**

**60% less $meal**

**68% less $meal**

**67% less $meal**

**60% 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.

#### Elementary School (Public) schools in Covina-Valley Unified (9)

Barranca Elementary | Ben Lomond Elementary | Cypress Elementary |

Grovecenter Elementary | Manzanita Elementary | Merwin Elementary |

Mesa Elementary | Rowland Avenue Elementary | Workman Avenue Elementary |