Christa McAuliffe Elementary (Data source)
Source data for Christa McAuliffe Elementary
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 | 2638466 | 2492 | - | 2436 | = | 56 | * | (41 | / | 188) | = | 12.21276594 | ||
| 4 | 2638467 | 2541 | - | 2485 | = | 56 | * | (50 | / | 188) | = | 14.89361698 | ||
| 5 | 2638470 | 2567 | - | 2528 | = | 39 | * | (53 | / | 188) | = | 10.99468083 | ||
| 6 | 2638471 | 2620 | - | 2552 | = | 68 | * | (17 | / | 188) | = | 6.14893611 | ||
| 7 | 2638474 | 2672 | - | 2567 | = | 105 | * | (14 | / | 188) | = | 7.81914893 | ||
| 8 | 2638475 | 2688 | - | 2586 | = | 102 | * | (13 | / | 188) | = | 7.05319147 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Christa McAuliffe Elementary | 59 | ||||||||||||
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 | 80443 | 2494 | - | 2436 | = | 58 | * | (29 | / | 171) | = | 9.83625729 | ||
| 4 | 80445 | 2555 | - | 2485 | = | 70 | * | (41 | / | 171) | = | 16.78362567 | ||
| 5 | 80448 | 2594 | - | 2528 | = | 66 | * | (47 | / | 171) | = | 18.14035087 | ||
| 6 | 80449 | 2621 | - | 2552 | = | 69 | * | (30 | / | 171) | = | 12.10526312 | ||
| 7 | 80452 | 2643 | - | 2567 | = | 76 | * | (13 | / | 171) | = | 5.77777772 | ||
| 8 | 80453 | 2709 | - | 2586 | = | 123 | * | (11 | / | 171) | = | 7.91228066 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Christa McAuliffe Elementary | 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 |
||
| 3 | 82662 | 2513 | - | 2436 | = | 77 | * | (28 | / | 177) | = | 12.18079093 | ||
| 4 | 82664 | 2547 | - | 2485 | = | 62 | * | (43 | / | 177) | = | 15.06214689 | ||
| 5 | 82667 | 2600 | - | 2528 | = | 72 | * | (40 | / | 177) | = | 16.2711864 | ||
| 6 | 82668 | 2631 | - | 2552 | = | 79 | * | (27 | / | 177) | = | 12.05084739 | ||
| 7 | 82671 | 2655 | - | 2567 | = | 88 | * | (26 | / | 177) | = | 12.92655364 | ||
| 8 | 82673 | 2653 | - | 2586 | = | 67 | * | (13 | / | 177) | = | 4.92090391 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Christa McAuliffe Elementary | 73 | ||||||||||||
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 | 82872 | 2467 | - | 2436 | = | 31 | * | (32 | / | 163) | = | 6.08588956 | ||
| 4 | 82873 | 2560 | - | 2485 | = | 75 | * | (29 | / | 163) | = | 13.34355825 | ||
| 5 | 82876 | 2567 | - | 2528 | = | 39 | * | (45 | / | 163) | = | 10.76687114 | ||
| 6 | 82877 | 2607 | - | 2552 | = | 55 | * | (11 | / | 163) | = | 3.71165641 | ||
| 7 | 82880 | 2691 | - | 2567 | = | 124 | * | (23 | / | 163) | = | 17.49693246 | ||
| 8 | 82881 | 2667 | - | 2586 | = | 81 | * | (23 | / | 163) | = | 11.42944781 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Christa McAuliffe Elementary | 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 |
||
| 3 | 83487 | 2510 | - | 2436 | = | 74 | * | (29 | / | 163) | = | 13.16564414 | ||
| 4 | 83488 | 2529 | - | 2485 | = | 44 | * | (38 | / | 163) | = | 10.2576687 | ||
| 5 | 83489 | 2584 | - | 2528 | = | 56 | * | (38 | / | 163) | = | 13.0552147 | ||
| 6 | 83490 | 2613 | - | 2552 | = | 61 | * | (19 | / | 163) | = | 7.11042944 | ||
| 7 | 83491 | 2659 | - | 2567 | = | 92 | * | (19 | / | 163) | = | 10.72392636 | ||
| 8 | 83492 | 2715 | - | 2586 | = | 129 | * | (20 | / | 163) | = | 15.82822079 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Christa McAuliffe Elementary | 70 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| 59 | 71 | 73 | 63 | 70 | 336.0 | 67.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 82.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 52.2
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 | 3% | 3% | 3% | 5% | 4% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Cupertino Union school district | County of Santa Clara
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.
Christa McAuliffe Elementary math proficiency
Zero+ meets standard.
3% less $meal
3% less $meal
3% less $meal
5% less $meal
4% 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.