Stanley G. Oswalt Academy (Data source)
Source data for Stanley G. Oswalt 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 |
||
| 3 | 1187317 | 2440 | - | 2436 | = | 4 | * | (103 | / | 704) | = | 0.58522727 | ||
| 4 | 1187320 | 2473 | - | 2485 | = | -12 | * | (124 | / | 704) | = | -2.11363636 | ||
| 5 | 1187321 | 2509 | - | 2528 | = | -19 | * | (118 | / | 704) | = | -3.18465908 | ||
| 6 | 1187324 | 2556 | - | 2552 | = | 4 | * | (120 | / | 704) | = | 0.68181818 | ||
| 7 | 1187325 | 2605 | - | 2567 | = | 38 | * | (114 | / | 704) | = | 6.15340908 | ||
| 8 | 1187328 | 2618 | - | 2586 | = | 32 | * | (125 | / | 704) | = | 5.68181818 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Stanley G. Oswalt Academy | 8 | ||||||||||||
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 | 36955 | 2467 | - | 2436 | = | 31 | * | (109 | / | 744) | = | 4.54166666 | ||
| 4 | 36958 | 2477 | - | 2485 | = | -8 | * | (131 | / | 744) | = | -1.40860214 | ||
| 5 | 36960 | 2510 | - | 2528 | = | -18 | * | (133 | / | 744) | = | -3.21774192 | ||
| 6 | 36962 | 2563 | - | 2552 | = | 11 | * | (128 | / | 744) | = | 1.89247311 | ||
| 7 | 36964 | 2592 | - | 2567 | = | 25 | * | (125 | / | 744) | = | 4.2002688 | ||
| 8 | 36966 | 2642 | - | 2586 | = | 56 | * | (118 | / | 744) | = | 8.8817204 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Stanley G. Oswalt Academy | 15 | ||||||||||||
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 | 37735 | 2468 | - | 2436 | = | 32 | * | (109 | / | 719) | = | 4.85118218 | ||
| 4 | 37738 | 2505 | - | 2485 | = | 20 | * | (108 | / | 719) | = | 3.00417246 | ||
| 5 | 37740 | 2521 | - | 2528 | = | -7 | * | (128 | / | 719) | = | -1.24617524 | ||
| 6 | 37741 | 2529 | - | 2552 | = | -23 | * | (137 | / | 719) | = | -4.38247566 | ||
| 7 | 37743 | 2581 | - | 2567 | = | 14 | * | (125 | / | 719) | = | 2.43393602 | ||
| 8 | 37745 | 2618 | - | 2586 | = | 32 | * | (112 | / | 719) | = | 4.98470096 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Stanley G. Oswalt Academy | 10 | ||||||||||||
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 | 37678 | 2453 | - | 2436 | = | 17 | * | (117 | / | 742) | = | 2.68059298 | ||
| 4 | 37680 | 2496 | - | 2485 | = | 11 | * | (121 | / | 742) | = | 1.79380054 | ||
| 5 | 37682 | 2530 | - | 2528 | = | 2 | * | (116 | / | 742) | = | 0.31266846 | ||
| 6 | 37684 | 2541 | - | 2552 | = | -11 | * | (131 | / | 742) | = | -1.94204852 | ||
| 7 | 37686 | 2577 | - | 2567 | = | 10 | * | (133 | / | 742) | = | 1.79245283 | ||
| 8 | 37688 | 2600 | - | 2586 | = | 14 | * | (124 | / | 742) | = | 2.33962263 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Stanley G. Oswalt Academy | 7 | ||||||||||||
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 | 37891 | 2463 | - | 2436 | = | 27 | * | (111 | / | 733) | = | 4.08867666 | ||
| 4 | 37892 | 2488 | - | 2485 | = | 3 | * | (121 | / | 733) | = | 0.4952251 | ||
| 5 | 37893 | 2521 | - | 2528 | = | -7 | * | (115 | / | 733) | = | -1.09822647 | ||
| 6 | 37894 | 2549 | - | 2552 | = | -3 | * | (121 | / | 733) | = | -0.4952251 | ||
| 7 | 37895 | 2559 | - | 2567 | = | -8 | * | (135 | / | 733) | = | -1.47339699 | ||
| 8 | 37896 | 2585 | - | 2586 | = | -1 | * | (130 | / | 733) | = | -0.17735334 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Stanley G. Oswalt Academy | 1 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| 8 | 15 | 10 | 7 | 1 | 41.0 | 8.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 23.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -6.8
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 | 31% | 36% | 40% | 47% | 49% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Rowland 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.
Stanley G. Oswalt Academy math proficiency
Zero+ meets standard.
21% less $meal
26% less $meal
28% less $meal
38% less $meal
39% 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.