Lincoln Middle (Data source)
Source data for Lincoln Middle
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 |
||
6 | 11294 | 2578 | - | 2552 | = | 26 | * | (245 | / | 875) | = | 7.28 | ||
7 | 11295 | 2604 | - | 2567 | = | 37 | * | (307 | / | 875) | = | 12.98171425 | ||
8 | 11298 | 2618 | - | 2586 | = | 32 | * | (323 | / | 875) | = | 11.81257142 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Lincoln Middle | 32 |
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 |
||
6 | 319 | 2582 | - | 2552 | = | 30 | * | (284 | / | 866) | = | 9.83833716 | ||
7 | 321 | 2625 | - | 2567 | = | 58 | * | (260 | / | 866) | = | 17.41339487 | ||
8 | 323 | 2628 | - | 2586 | = | 42 | * | (322 | / | 866) | = | 15.61662816 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Lincoln Middle | 43 |
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 | 334 | 2581 | - | 2552 | = | 29 | * | (262 | / | 812) | = | 9.35714284 | ||
7 | 335 | 2609 | - | 2567 | = | 42 | * | (284 | / | 812) | = | 14.68965515 | ||
8 | 338 | 2643 | - | 2586 | = | 57 | * | (266 | / | 812) | = | 18.67241374 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Lincoln Middle | 43 |
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 | 355 | 2575 | - | 2552 | = | 23 | * | (285 | / | 853) | = | 7.68464242 | ||
7 | 357 | 2607 | - | 2567 | = | 40 | * | (278 | / | 853) | = | 13.03634232 | ||
8 | 359 | 2642 | - | 2586 | = | 56 | * | (290 | / | 853) | = | 19.03868697 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Lincoln Middle | 40 |
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 | 385 | 2579 | - | 2552 | = | 27 | * | (288 | / | 848) | = | 9.16981131 | ||
7 | 386 | 2602 | - | 2567 | = | 35 | * | (290 | / | 848) | = | 11.96933962 | ||
8 | 387 | 2645 | - | 2586 | = | 59 | * | (270 | / | 848) | = | 18.78537733 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Lincoln Middle | 40 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
32 | 43 | 43 | 40 | 40 | 198.0 | 39.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 51.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 27.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 | 15% | 13% | 14% | 17% | 15% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Alameda Unified school district | County of Alameda
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.
Lincoln Middle math proficiency
Zero+ meets standard.
12% less $meal
10% less $meal
10% less $meal
15% less $meal
14% 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.
Intermediate/Middle Schools (Public) schools in Alameda Unified (2)
Lincoln Middle | Will C. Wood Middle |