Abraham Lincoln Elementary (Data source)
Source data for Abraham Lincoln 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 | 2638834 | 2521 | - | 2436 | = | 85 | * | (126 | / | 428) | = | 25.02336446 | ||
4 | 2638835 | 2567 | - | 2485 | = | 82 | * | (132 | / | 428) | = | 25.28971955 | ||
5 | 2638838 | 2609 | - | 2528 | = | 81 | * | (170 | / | 428) | = | 32.17289714 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Abraham Lincoln Elementary | 82 |
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 | 80458 | 2521 | - | 2436 | = | 85 | * | (116 | / | 377) | = | 26.1538461 | ||
4 | 80459 | 2576 | - | 2485 | = | 91 | * | (130 | / | 377) | = | 31.37931033 | ||
5 | 80461 | 2612 | - | 2528 | = | 84 | * | (131 | / | 377) | = | 29.1883289 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Abraham Lincoln Elementary | 87 |
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 | 82676 | 2510 | - | 2436 | = | 74 | * | (122 | / | 362) | = | 24.93922648 | ||
4 | 82678 | 2570 | - | 2485 | = | 85 | * | (113 | / | 362) | = | 26.53314916 | ||
5 | 82681 | 2612 | - | 2528 | = | 84 | * | (127 | / | 362) | = | 29.46961324 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Abraham Lincoln Elementary | 81 |
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 | 82886 | 2518 | - | 2436 | = | 82 | * | (87 | / | 317) | = | 22.50473182 | ||
4 | 82887 | 2573 | - | 2485 | = | 88 | * | (114 | / | 317) | = | 31.64668769 | ||
5 | 82890 | 2607 | - | 2528 | = | 79 | * | (116 | / | 317) | = | 28.90851732 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Abraham Lincoln Elementary | 83 |
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 | 83498 | 2530 | - | 2436 | = | 94 | * | (118 | / | 333) | = | 33.30930928 | ||
4 | 83499 | 2582 | - | 2485 | = | 97 | * | (95 | / | 333) | = | 27.67267265 | ||
5 | 83500 | 2606 | - | 2528 | = | 78 | * | (120 | / | 333) | = | 28.10810808 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Abraham Lincoln Elementary | 89 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
82 | 87 | 81 | 83 | 89 | 422.0 | 84.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 93.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 75.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 | 1% | 1% | 2% | 4% | 3% |
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, parent education.
NOT what teachers want.
NOT what principals want.
NOT what parents want.
Abraham Lincoln Elementary math proficiency
Zero+ meets standard.
1% less $meal
1% less $meal
1% less $meal
4% less $meal
3% 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.