### Berryessa Union Elementary school district (Data source)

#### County of Santa Clara

##### Source data for Berryessa Union 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 | 2621911 | 2447 | - | 2436 | = | 11 | * | (812 | / | 5194) | = | 1.71967654 | ||

4 | 2621912 | 2487 | - | 2485 | = | 2 | * | (822 | / | 5194) | = | 0.31651906 | ||

5 | 2621915 | 2506 | - | 2528 | = | -22 | * | (873 | / | 5194) | = | -3.69772814 | ||

6 | 2621916 | 2530 | - | 2552 | = | -22 | * | (908 | / | 5194) | = | -3.84597611 | ||

7 | 2621919 | 2568 | - | 2567 | = | 1 | * | (865 | / | 5194) | = | 0.16653831 | ||

8 | 2621920 | 2582 | - | 2586 | = | -4 | * | (914 | / | 5194) | = | -0.7038891 | ||

Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Berryessa Union Elementary | -6 |

#### 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 | 80001 | 2460 | - | 2436 | = | 24 | * | (762 | / | 4959) | = | 3.68784029 | ||

4 | 80003 | 2490 | - | 2485 | = | 5 | * | (785 | / | 4959) | = | 0.79149022 | ||

5 | 80005 | 2526 | - | 2528 | = | -2 | * | (813 | / | 4959) | = | -0.32788869 | ||

6 | 80008 | 2536 | - | 2552 | = | -16 | * | (849 | / | 4959) | = | -2.73926194 | ||

7 | 80010 | 2578 | - | 2567 | = | 11 | * | (889 | / | 4959) | = | 1.97197015 | ||

8 | 80012 | 2593 | - | 2586 | = | 7 | * | (861 | / | 4959) | = | 1.215366 | ||

Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Berryessa Union Elementary | 5 |

#### 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 | 82191 | 2466 | - | 2436 | = | 30 | * | (799 | / | 4880) | = | 4.91188524 | ||

4 | 82192 | 2503 | - | 2485 | = | 18 | * | (752 | / | 4880) | = | 2.77377048 | ||

5 | 82195 | 2524 | - | 2528 | = | -4 | * | (774 | / | 4880) | = | -0.63442623 | ||

6 | 82196 | 2547 | - | 2552 | = | -5 | * | (800 | / | 4880) | = | -0.81967213 | ||

7 | 82198 | 2574 | - | 2567 | = | 7 | * | (866 | / | 4880) | = | 1.24221311 | ||

8 | 82201 | 2590 | - | 2586 | = | 4 | * | (889 | / | 4880) | = | 0.72868852 | ||

Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Berryessa Union Elementary | 8 |

#### 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 | 82392 | 2473 | - | 2436 | = | 37 | * | (731 | / | 4709) | = | 5.74368231 | ||

4 | 82394 | 2502 | - | 2485 | = | 17 | * | (788 | / | 4709) | = | 2.84476533 | ||

5 | 82396 | 2530 | - | 2528 | = | 2 | * | (753 | / | 4709) | = | 0.31981312 | ||

6 | 82398 | 2540 | - | 2552 | = | -12 | * | (779 | / | 4709) | = | -1.98513485 | ||

7 | 82400 | 2579 | - | 2567 | = | 12 | * | (820 | / | 4709) | = | 2.08961562 | ||

8 | 82402 | 2586 | - | 2586 | = | 0 | * | (838 | / | 4709) | = | 0.0 | ||

Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Berryessa Union Elementary | 9 |

#### 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 | 83011 | 2474 | - | 2436 | = | 38 | * | (701 | / | 4549) | = | 5.85579248 | ||

4 | 83012 | 2514 | - | 2485 | = | 29 | * | (718 | / | 4549) | = | 4.57726972 | ||

5 | 83013 | 2538 | - | 2528 | = | 10 | * | (794 | / | 4549) | = | 1.74543855 | ||

6 | 83014 | 2544 | - | 2552 | = | -8 | * | (761 | / | 4549) | = | -1.33831611 | ||

7 | 83015 | 2572 | - | 2567 | = | 5 | * | (752 | / | 4549) | = | 0.82655529 | ||

8 | 83016 | 2597 | - | 2586 | = | 11 | * | (823 | / | 4549) | = | 1.99010771 | ||

Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Berryessa Union Elementary | 14 |

#### Last steps

##### Compute the average

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

-6 | 5 | 8 | 9 | 14 | 30.0 | 6.0 |

##### Compute the Upper Control Limit

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

##### Compute the Lower Control Limit

Simply compute the standard deviation and multiply by 3 and subtract from the average: **-15.0**

##### For the lines, you have the data necessary to plot the chart.

### THIS chart shows what the school system "wants"

NOT what school board members want.

NOT what superintendents want.

Berryessa Union Elementary

*math*proficiency
Zero+ meets standard.

• 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).

### Students would perform better the more years in school IF the follow-the-schedule method wanted that.

But that's not what it "wants"...and it's not a coincidence this pattern repeats (repeatedly).

#### The system (the follow-the-schedule method) "wants" schools to perform poorer, relative to grade level, the more years students spend in public school.

• Any result above zero is proficient; below is not proficient.

Berryessa Union Elementary

*math*proficiency
Zero+ meets standard.

#### Schools in Berryessa Union Elementary

##### Elementary School (Public) (10)

##### Intermediate/Middle Schools (Public) (3)

Morrill Middle | Piedmont Middle | Sierramont Middle |

##### Alternative Schools of Choice (1)

Berryessa Union Elementary |