Windsor Middle (Data source)
Source data for Windsor 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 | 2911819 | 2481 | - | 2552 | = | -71 | * | (274 | / | 918) | = | -21.1917211 | ||
| 7 | 2911822 | 2506 | - | 2567 | = | -61 | * | (343 | / | 918) | = | -22.79193898 | ||
| 8 | 2911823 | 2547 | - | 2586 | = | -39 | * | (301 | / | 918) | = | -12.78758169 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Windsor Middle | -57 | ||||||||||||
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 | 89123 | 2462 | - | 2552 | = | -90 | * | (279 | / | 908) | = | -27.65418498 | ||
| 7 | 89124 | 2511 | - | 2567 | = | -56 | * | (291 | / | 908) | = | -17.94713654 | ||
| 8 | 89126 | 2519 | - | 2586 | = | -67 | * | (338 | / | 908) | = | -24.94052863 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Windsor Middle | -71 | ||||||||||||
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 | 91704 | 2478 | - | 2552 | = | -74 | * | (251 | / | 844) | = | -22.00710894 | ||
| 7 | 91705 | 2498 | - | 2567 | = | -69 | * | (307 | / | 844) | = | -25.09834118 | ||
| 8 | 91708 | 2534 | - | 2586 | = | -52 | * | (286 | / | 844) | = | -17.62085307 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Windsor Middle | -65 | ||||||||||||
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 | 91900 | 2479 | - | 2552 | = | -73 | * | (240 | / | 837) | = | -20.93189962 | ||
| 7 | 91902 | 2492 | - | 2567 | = | -75 | * | (283 | / | 837) | = | -25.35842288 | ||
| 8 | 91904 | 2517 | - | 2586 | = | -69 | * | (314 | / | 837) | = | -25.8853046 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Windsor Middle | -72 | ||||||||||||
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 | 92547 | 2483 | - | 2552 | = | -69 | * | (272 | / | 822) | = | -22.83211677 | ||
| 7 | 92548 | 2518 | - | 2567 | = | -49 | * | (265 | / | 822) | = | -15.79683697 | ||
| 8 | 92549 | 2544 | - | 2586 | = | -42 | * | (285 | / | 822) | = | -14.56204378 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Windsor Middle | -53 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -57 | -71 | -65 | -72 | -53 | -318.0 | -63.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -39.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -87.6
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 | 42% | 37% | 35% | 35% | 35% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Windsor Unified school district | County of Sonoma
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.
Windsor Middle math proficiency
Zero+ meets standard.
33% less $meal
30% less $meal
27% less $meal
31% less $meal
30% 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 Windsor Unified (1)
| Windsor Middle |