Western Center Academy (Data source)
Source data for Western Center Academy
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 | 1682378 | 2618 | - | 2552 | = | 66 | * | (127 | / | 382) | = | 21.94240831 | ||
| 7 | 1682379 | 2619 | - | 2567 | = | 52 | * | (135 | / | 382) | = | 18.37696333 | ||
| 8 | 1682382 | 2600 | - | 2586 | = | 14 | * | (120 | / | 382) | = | 4.39790575 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Western Center Academy | 45 | ||||||||||||
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 | 52483 | 2580 | - | 2552 | = | 28 | * | (123 | / | 403) | = | 8.5459057 | ||
| 7 | 52484 | 2629 | - | 2567 | = | 62 | * | (128 | / | 403) | = | 19.69230769 | ||
| 8 | 52487 | 2647 | - | 2586 | = | 61 | * | (126 | / | 403) | = | 19.07196025 | ||
| 11 | 52488 | 2743 | - | 2628 | = | 115 | * | (26 | / | 403) | = | 7.41935484 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Western Center Academy | 55 | ||||||||||||
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 | 53982 | 2584 | - | 2552 | = | 32 | * | (126 | / | 446) | = | 9.04035872 | ||
| 7 | 53984 | 2599 | - | 2567 | = | 32 | * | (134 | / | 446) | = | 9.61434976 | ||
| 8 | 53985 | 2653 | - | 2586 | = | 67 | * | (126 | / | 446) | = | 18.92825107 | ||
| 11 | 53988 | 2689 | - | 2628 | = | 61 | * | (60 | / | 446) | = | 8.20627797 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Western Center Academy | 46 | ||||||||||||
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 | 54080 | 2595 | - | 2552 | = | 43 | * | (126 | / | 460) | = | 11.77826085 | ||
| 7 | 54083 | 2602 | - | 2567 | = | 35 | * | (132 | / | 460) | = | 10.04347824 | ||
| 8 | 54084 | 2634 | - | 2586 | = | 48 | * | (133 | / | 460) | = | 13.87826083 | ||
| 11 | 54087 | 2646 | - | 2628 | = | 18 | * | (69 | / | 460) | = | 2.7 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Western Center Academy | 38 | ||||||||||||
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 | 54320 | 2592 | - | 2552 | = | 40 | * | (127 | / | 450) | = | 11.28888888 | ||
| 7 | 54321 | 2617 | - | 2567 | = | 50 | * | (136 | / | 450) | = | 15.1111111 | ||
| 8 | 54322 | 2635 | - | 2586 | = | 49 | * | (131 | / | 450) | = | 14.26444444 | ||
| 11 | 54323 | 2698 | - | 2628 | = | 70 | * | (56 | / | 450) | = | 8.71111108 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Western Center Academy | 49 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| 45 | 55 | 46 | 38 | 49 | 233.0 | 46.6 |
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 | 24% | 28% | 28% | 34% | 29% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Hemet Unified school district | County of Riverside
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.