OCSA (Data source)
Source data for OCSA
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 |
||
| 7 | 1534651 | 2637 | - | 2567 | = | 70 | * | (181 | / | 739) | = | 17.14479025 | ||
| 8 | 1534652 | 2638 | - | 2586 | = | 52 | * | (220 | / | 739) | = | 15.48037889 | ||
| 11 | 1534655 | 2660 | - | 2628 | = | 32 | * | (338 | / | 739) | = | 14.63599456 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for OCSA | 47 | ||||||||||||
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 |
||
| 7 | 48063 | 2633 | - | 2567 | = | 66 | * | (235 | / | 858) | = | 18.07692302 | ||
| 8 | 48065 | 2652 | - | 2586 | = | 66 | * | (265 | / | 858) | = | 20.38461533 | ||
| 11 | 48066 | 2674 | - | 2628 | = | 46 | * | (358 | / | 858) | = | 19.19347318 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for OCSA | 58 | ||||||||||||
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 |
||
| 7 | 49372 | 2646 | - | 2567 | = | 79 | * | (241 | / | 921) | = | 20.67209551 | ||
| 8 | 49375 | 2654 | - | 2586 | = | 68 | * | (271 | / | 921) | = | 20.00868618 | ||
| 11 | 49376 | 2666 | - | 2628 | = | 38 | * | (409 | / | 921) | = | 16.87513572 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for OCSA | 58 | ||||||||||||
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 |
||
| 7 | 49387 | 2645 | - | 2567 | = | 78 | * | (219 | / | 817) | = | 20.90820069 | ||
| 8 | 49389 | 2655 | - | 2586 | = | 69 | * | (274 | / | 817) | = | 23.14075887 | ||
| 11 | 49391 | 2675 | - | 2628 | = | 47 | * | (324 | / | 817) | = | 18.63892287 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for OCSA | 63 | ||||||||||||
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 |
||
| 7 | 49585 | 2655 | - | 2567 | = | 88 | * | (247 | / | 903) | = | 24.07087478 | ||
| 8 | 49586 | 2660 | - | 2586 | = | 74 | * | (255 | / | 903) | = | 20.89700992 | ||
| 11 | 49587 | 2680 | - | 2628 | = | 52 | * | (401 | / | 903) | = | 23.09191581 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for OCSA | 68 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| 47 | 58 | 58 | 63 | 68 | 294.0 | 58.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average:
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average:
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 | 10% | 11% | 11% | 13% | 12% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Santa Ana Unified school district | County of Orange
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.
High Schools (Public) schools in Santa Ana Unified (6)
| Century High | Hector G. Godinez | Saddleback High |
| Santa Ana High | Segerstrom High | Valley High |