Vanguard Preparatory (Data source)
Source data for Vanguard Preparatory
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 | 2102992 | 2440 | - | 2436 | = | 4 | * | (120 | / | 884) | = | 0.54298642 | ||
| 4 | 2102995 | 2439 | - | 2485 | = | -46 | * | (128 | / | 884) | = | -6.66063348 | ||
| 5 | 2102996 | 2479 | - | 2528 | = | -49 | * | (126 | / | 884) | = | -6.98416286 | ||
| 6 | 2102999 | 2507 | - | 2552 | = | -45 | * | (153 | / | 884) | = | -7.78846154 | ||
| 7 | 2103000 | 2520 | - | 2567 | = | -47 | * | (179 | / | 884) | = | -9.51696829 | ||
| 8 | 2103003 | 2533 | - | 2586 | = | -53 | * | (178 | / | 884) | = | -10.6719457 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Vanguard Preparatory | -41 | ||||||||||||
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 | 64600 | 2449 | - | 2436 | = | 13 | * | (119 | / | 834) | = | 1.85491606 | ||
| 4 | 64603 | 2463 | - | 2485 | = | -22 | * | (127 | / | 834) | = | -3.35011989 | ||
| 5 | 64604 | 2486 | - | 2528 | = | -42 | * | (126 | / | 834) | = | -6.34532371 | ||
| 6 | 64606 | 2509 | - | 2552 | = | -43 | * | (121 | / | 834) | = | -6.23860908 | ||
| 7 | 64609 | 2518 | - | 2567 | = | -49 | * | (173 | / | 834) | = | -10.16426855 | ||
| 8 | 64610 | 2527 | - | 2586 | = | -59 | * | (168 | / | 834) | = | -11.88489203 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Vanguard Preparatory | -36 | ||||||||||||
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 | 66417 | 2443 | - | 2436 | = | 7 | * | (118 | / | 828) | = | 0.99758454 | ||
| 4 | 66418 | 2471 | - | 2485 | = | -14 | * | (128 | / | 828) | = | -2.16425119 | ||
| 5 | 66420 | 2493 | - | 2528 | = | -35 | * | (126 | / | 828) | = | -5.32608696 | ||
| 6 | 66423 | 2479 | - | 2552 | = | -73 | * | (127 | / | 828) | = | -11.19685987 | ||
| 7 | 66425 | 2532 | - | 2567 | = | -35 | * | (160 | / | 828) | = | -6.76328499 | ||
| 8 | 66426 | 2514 | - | 2586 | = | -72 | * | (169 | / | 828) | = | -14.69565216 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Vanguard Preparatory | -39 | ||||||||||||
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 | 66489 | 2440 | - | 2436 | = | 4 | * | (118 | / | 813) | = | 0.5805658 | ||
| 4 | 66490 | 2474 | - | 2485 | = | -11 | * | (125 | / | 813) | = | -1.69126691 | ||
| 5 | 66492 | 2491 | - | 2528 | = | -37 | * | (126 | / | 813) | = | -5.73431731 | ||
| 6 | 66495 | 2515 | - | 2552 | = | -37 | * | (126 | / | 813) | = | -5.73431731 | ||
| 7 | 66496 | 2485 | - | 2567 | = | -82 | * | (175 | / | 813) | = | -17.65067646 | ||
| 8 | 66498 | 2512 | - | 2586 | = | -74 | * | (143 | / | 813) | = | -13.01599009 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Vanguard Preparatory | -43 | ||||||||||||
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 | 66914 | 2445 | - | 2436 | = | 9 | * | (119 | / | 846) | = | 1.26595744 | ||
| 4 | 66915 | 2465 | - | 2485 | = | -20 | * | (129 | / | 846) | = | -3.04964538 | ||
| 5 | 66916 | 2493 | - | 2528 | = | -35 | * | (128 | / | 846) | = | -5.29550826 | ||
| 6 | 66917 | 2516 | - | 2552 | = | -36 | * | (127 | / | 846) | = | -5.40425531 | ||
| 7 | 66918 | 2520 | - | 2567 | = | -47 | * | (175 | / | 846) | = | -9.72222218 | ||
| 8 | 66919 | 2481 | - | 2586 | = | -105 | * | (168 | / | 846) | = | -20.8510638 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Vanguard Preparatory | -43 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -41 | -36 | -39 | -43 | -43 | -202.0 | -40.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -34.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -46.4
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 | 52% | 55% | 55% | 59% | 65% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Apple Valley Unified school district | County of San Bernardino
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.
Vanguard Preparatory math proficiency
Zero+ meets standard.
44% less $meal
46% less $meal
43% less $meal
51% less $meal
50% 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.