Desert Willow Fine Arts, Science and Technology Magnet Academy (Data source)
Source data for Desert Willow Fine Arts, Science and Technology Magnet 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 |
||
7 | 1057005 | 2448 | - | 2567 | = | -119 | * | (310 | / | 590) | = | -62.52542363 | ||
8 | 1057008 | 2487 | - | 2586 | = | -99 | * | (280 | / | 590) | = | -46.98305083 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Desert Willow Fine Arts, Science and Technology Magnet Academy | -110 |
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 |
||
7 | 33159 | 2480 | - | 2567 | = | -87 | * | (300 | / | 597) | = | -43.71859289 | ||
8 | 33160 | 2465 | - | 2586 | = | -121 | * | (297 | / | 597) | = | -60.19597988 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Desert Willow Fine Arts, Science and Technology Magnet Academy | -104 |
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 | 33732 | 2454 | - | 2552 | = | -98 | * | (58 | / | 625) | = | -9.0944 | ||
7 | 33735 | 2461 | - | 2567 | = | -106 | * | (266 | / | 625) | = | -45.1136 | ||
8 | 33737 | 2456 | - | 2586 | = | -130 | * | (301 | / | 625) | = | -62.608 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Desert Willow Fine Arts, Science and Technology Magnet Academy | -117 |
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 | 33759 | 2448 | - | 2552 | = | -104 | * | (293 | / | 834) | = | -36.53717018 | ||
7 | 33761 | 2466 | - | 2567 | = | -101 | * | (266 | / | 834) | = | -32.21342924 | ||
8 | 33763 | 2441 | - | 2586 | = | -145 | * | (275 | / | 834) | = | -47.8117506 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Desert Willow Fine Arts, Science and Technology Magnet Academy | -117 |
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 | 33934 | 2443 | - | 2552 | = | -109 | * | (294 | / | 906) | = | -35.3708609 | ||
7 | 33935 | 2445 | - | 2567 | = | -122 | * | (320 | / | 906) | = | -43.09050773 | ||
8 | 33936 | 2472 | - | 2586 | = | -114 | * | (292 | / | 906) | = | -36.74172177 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Desert Willow Fine Arts, Science and Technology Magnet Academy | -115 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-110 | -104 | -117 | -117 | -115 | -563.0 | -112.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -97.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -127.6
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 | 83% | 84% | 82% | 84% | 84% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Palmdale Elementary school district County of Los Angeles
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.
Desert Willow Fine Arts, Science and Technology Magnet Academy math proficiency
Zero+ meets standard.
70% less $meal
73% less $meal
69% less $meal
76% less $meal
72% 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.