Downtown Charter Academy (Data source)
Source data for Downtown Charter 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 | 82304 | 2597 | - | 2552 | = | 45 | * | (71 | / | 251) | = | 12.72908363 | ||
7 | 82307 | 2637 | - | 2567 | = | 70 | * | (81 | / | 251) | = | 22.58964141 | ||
8 | 82308 | 2664 | - | 2586 | = | 78 | * | (99 | / | 251) | = | 30.76494018 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Downtown Charter Academy | 66 |
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 | 2267 | 2617 | - | 2552 | = | 65 | * | (95 | / | 262) | = | 23.56870224 | ||
7 | 2270 | 2666 | - | 2567 | = | 99 | * | (76 | / | 262) | = | 28.71755717 | ||
8 | 2272 | 2677 | - | 2586 | = | 91 | * | (91 | / | 262) | = | 31.6068702 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Downtown Charter Academy | 84 |
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 | 2327 | 2627 | - | 2552 | = | 75 | * | (58 | / | 221) | = | 19.68325785 | ||
7 | 2329 | 2651 | - | 2567 | = | 84 | * | (88 | / | 221) | = | 33.44796378 | ||
8 | 2332 | 2703 | - | 2586 | = | 117 | * | (75 | / | 221) | = | 39.70588226 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Downtown Charter Academy | 93 |
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 | 2320 | 2606 | - | 2552 | = | 54 | * | (103 | / | 271) | = | 20.5239852 | ||
7 | 2322 | 2631 | - | 2567 | = | 64 | * | (70 | / | 271) | = | 16.53136531 | ||
8 | 2324 | 2676 | - | 2586 | = | 90 | * | (98 | / | 271) | = | 32.54612544 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Downtown Charter Academy | 70 |
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 | 2329 | 2566 | - | 2552 | = | 14 | * | (105 | / | 299) | = | 4.91638795 | ||
7 | 2330 | 2610 | - | 2567 | = | 43 | * | (112 | / | 299) | = | 16.10702338 | ||
8 | 2331 | 2637 | - | 2586 | = | 51 | * | (82 | / | 299) | = | 13.98662204 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Downtown Charter Academy | 35 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
66 | 84 | 93 | 70 | 35 | 348.0 | 69.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 | 84% | 87% | 79% | 49% | 79% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Oakland Unified school district | County of Alameda
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.