Arroyo Vista Charter (Data source)
Source data for Arroyo Vista Charter
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 | 2142761 | 2453 | - | 2436 | = | 17 | * | (128 | / | 689) | = | 3.15820028 | ||
4 | 2142762 | 2485 | - | 2485 | = | 0 | * | (139 | / | 689) | = | 0.0 | ||
5 | 2142765 | 2550 | - | 2528 | = | 22 | * | (135 | / | 689) | = | 4.31059506 | ||
6 | 2142766 | 2556 | - | 2552 | = | 4 | * | (135 | / | 689) | = | 0.78374456 | ||
7 | 2142769 | 2614 | - | 2567 | = | 47 | * | (79 | / | 689) | = | 5.38896948 | ||
8 | 2142770 | 2650 | - | 2586 | = | 64 | * | (73 | / | 689) | = | 6.78084179 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Arroyo Vista Charter | 20 |
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 | 65773 | 2468 | - | 2436 | = | 32 | * | (113 | / | 661) | = | 5.47049923 | ||
4 | 65774 | 2525 | - | 2485 | = | 40 | * | (127 | / | 661) | = | 7.68532524 | ||
5 | 65776 | 2529 | - | 2528 | = | 1 | * | (140 | / | 661) | = | 0.2118003 | ||
6 | 65778 | 2576 | - | 2552 | = | 24 | * | (129 | / | 661) | = | 4.6838124 | ||
7 | 65780 | 2632 | - | 2567 | = | 65 | * | (80 | / | 661) | = | 7.86686836 | ||
8 | 65782 | 2645 | - | 2586 | = | 59 | * | (72 | / | 661) | = | 6.42662627 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Arroyo Vista Charter | 32 |
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 | 67591 | 2464 | - | 2436 | = | 28 | * | (97 | / | 645) | = | 4.21085269 | ||
4 | 67592 | 2499 | - | 2485 | = | 14 | * | (112 | / | 645) | = | 2.43100774 | ||
5 | 67595 | 2564 | - | 2528 | = | 36 | * | (132 | / | 645) | = | 7.36744183 | ||
6 | 67596 | 2572 | - | 2552 | = | 20 | * | (147 | / | 645) | = | 4.55813952 | ||
7 | 67599 | 2645 | - | 2567 | = | 78 | * | (87 | / | 645) | = | 10.52093016 | ||
8 | 67600 | 2660 | - | 2586 | = | 74 | * | (70 | / | 645) | = | 8.03100769 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Arroyo Vista Charter | 37 |
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 | 67697 | 2475 | - | 2436 | = | 39 | * | (109 | / | 629) | = | 6.75834654 | ||
4 | 67699 | 2523 | - | 2485 | = | 38 | * | (92 | / | 629) | = | 5.55802858 | ||
5 | 67701 | 2554 | - | 2528 | = | 26 | * | (122 | / | 629) | = | 5.04292526 | ||
6 | 67703 | 2605 | - | 2552 | = | 53 | * | (127 | / | 629) | = | 10.70111287 | ||
7 | 67705 | 2620 | - | 2567 | = | 53 | * | (101 | / | 629) | = | 8.51033386 | ||
8 | 67707 | 2665 | - | 2586 | = | 79 | * | (78 | / | 629) | = | 9.79650236 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Arroyo Vista Charter | 46 |
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 | 68214 | 2465 | - | 2436 | = | 29 | * | (95 | / | 606) | = | 4.5462046 | ||
4 | 68215 | 2517 | - | 2485 | = | 32 | * | (107 | / | 606) | = | 5.65016499 | ||
5 | 68216 | 2566 | - | 2528 | = | 38 | * | (99 | / | 606) | = | 6.20792077 | ||
6 | 68217 | 2582 | - | 2552 | = | 30 | * | (122 | / | 606) | = | 6.03960396 | ||
7 | 68218 | 2620 | - | 2567 | = | 53 | * | (89 | / | 606) | = | 7.78382836 | ||
8 | 68219 | 2639 | - | 2586 | = | 53 | * | (94 | / | 606) | = | 8.22112208 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Arroyo Vista Charter | 38 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
20 | 32 | 37 | 46 | 38 | 173.0 | 34.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 | 17% | 15% | 15% | 17% | 17% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Chula Vista Elementary school district County of San Diego
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation, parent education.
NOT what teachers want.
NOT what principals want.
NOT what parents want.