Locust Elem School Home Search

Address Grades Stdnt-Teacher Ratio Diversity Score
(40 max)		 Expected Test Scores Adjusted Test Scores* Difference (Avg is 0)
539 Locust St Marengo, IL 60152 PK - 03 14.5 20.0 49.6 47.0 -2.6

48 Homes For Sale, 48 Matches

Homes For-Sale in Locust Elem School Boundaries
Photo (click to view) Beds Price Days on
3
$219,900
0
4
$289,900
1
3
$359,900
3
3
$154,900
3
4
$449,900
5
3
$159,900
6
3
$279,900
6
3
$200,000
10
7
$187,750
14
2
$139,900
14
5
$315,000
17
2
$237,500
18
3
$215,000
18
2
$142,900
19
3
$169,900
20
3
$229,999
23
3
$165,000
30
3
$266,000
32
5
$499,900
32
4
$315,000
39
4
$399,900
41
6
$229,900
41
3
$140,000
42
2
$180,000
44
3
$229,900
48
4
$550,000
50
2
$139,900
54
4
$249,900
56
2
$200,000
59
2
$200,000
59
4
$224,500
64
3
$154,000
65
3
$229,900
65
3
$169,900
65
3
$69,900
65
3
$234,500
85
4
$289,000
94
2
$159,900
99
3
$299,900
100
2
$50,000
102
2
$82,900
102
4
$234,900
119
3
$99,800
121
2
$87,000
127
3
$175,000
137
2
$56,000
197
2
$139,900
206
3
$129,900
217
Locust Elem School Agent

Carrie McCormick

Phone: 312-961-4612
Email: Carrie@atproperties.com
Contact Me

SchoolSparrow Adjusted Scores

This table shows our adjusted scores and corresponding rating for each grade at the school, and for the school overall. As described below, we take the raw data from the US Department of Education and put the data in a format that can be input into our ratings algorithm. The first adjustmet we make is to account for the LEP/CWD (English Language Learners and Children with Disabilities) test takers at each school. We make an adjustment to the overall score of the school based on the performance of these student populations (described in detail below). We then plot these overall adjusted scores against the percentage of children that are considered economically disadvantaged for every school in each metro area. This plot reveals a trendline that in all cases shows a high correlation between parent income and test scores. For each school, we use the equation of the trendline to find the average or expected score for each school. Schools are then graded by the extent to which they have a departure from the trendline. Schools that are on or around the trendline get roughly a "C" grade. As their actual scores move up from the trendline, their score goes up, and conversely, the score goes down as they move south of the trendline.

It is important to note that we have not yet calculated LEP/CWD adjustments on each grade, we've made these adjustments only on the overall score for the school. That's why you may see individual grade scores that seem low, but an overall score that is high. The letter grade for each school grade is calculated utilizing the trendline equation for that grade for each metro area.

The diversity score is calculated based on the representation of different races at each school. If only one race has at least 10% represenation at the school, the score is 0. If two races have 10% represenation, the score is 10. 3 races: 20. 4 races: 30. If 3 races have at least 15% representation: 30. 4 races at 15% represenation: 40. 3 races at 20% representation: 40 diversity points. Soon we will make an adjustment to the diveristy score for large urban cities, giving the highest points to schools where the demographics closely mirror the actual demographics of the school district.


SchoolSparrow Adjusted Scores
Year Expected Score
Adjusted for Income		 Diversity
Score		 Trending 3rd Gr
Actual		 3rd Gr
Score		 4th Gr
Actual		 4th Gr
Score		 5th Gr
Actual		 5th Gr
Score		 6th Gr
Actual		 6th Gr
Score		 7th Gr
Actual		 7th Gr
Score		 8th Gr
Actual		 8th Gr
Score		 HS Gr
Actual*		 HS Gr
Score*		 Overall
Actual*		 Overall
Score*
1617 37.9 15.0 No data 27.0 D
1718 43.1 20.0 26.4% 42.0 C
1819 49.6 20.0 23.2% 47.0 B 47.0 C


Raw Data from the US Department of Education

This table shows the data as it was extracted from a spreadsheet provided by the US Department of Education. The spreadsheet from the Dept of Education literally has hundreds of columns, but for our purposes, we've extracted only the columns in this table. Here we save the data in its raw form, before we make any adjustments. The adjustments are necessary to convert the data to a format that can be plugged into our rating algorithm. For example, many of the data points are actually ranges of numbers. Sometimes there is a prefix to the number. "LE" means less than or equal to "LT" is less than, "GT" is greater than, and "GE" is greater than or equal to. Typically these prefixes are associated with small populations of students. Sometimes you will see a date as an attribute, this because sometimes excel interprets a range of values as a date. So "19-Nov" is equivalent to "11-19".

It is important to note that this data does not look at socio-economics. We handle that later. This data is used to make adjustments to account for LEP and CWD test takers.

Raw Data from the US Dept of Education
Grade 3 Grade 4 Grade 5 Grade 6 Grade 7 Grade 8 Grade HS Grade All # Students LEP All # LEP CWD All # CWD LEP HS # LEP HS CWD HS # CWD HS
45-49 PS 45-49 94 LT50 15 LT50 9 0 0


NCES Standardized Test Scores

One of the ways that we create a more fair rating system is by accounting for the LEP/CWD students at a school. These are the English Language Learners and Children with Disabilities. On average, these populations of students don't test as well as students that are native English speakers and typically functioning. As a result, schools that have higher than average concentrations of these students are unfairly given low marks, while schools with less than average populations of these students are elevated, not because the school is better, but simply because they have low populations of these students.

The values in this table are derived from the raw data provided by the US Department of Education. When there is a range of values, we average the range. When there is a "LT10" or "LE10" or "GT50" we drop the letters and use the number. Importantly, this is where we calculate the overall adjusted test scores for each school. We do this by subtracting the # LEP and # CWD columns from the # Students column to get the New Total. Then we calculate the total number of students deemed proficient (Grade All / 100 * # Students). Then we calculate the number of students deemed proficient for both CWD and LEP students (LEP All / 100 * #LEP and CWD All / 100 * #CWD) and subtract these values from the total number of students deemed proficent. This number is then divided by the New Total to get our Adjusted Score. Our Adjusted Score is the performance of kids who are NOT classified as LEP/CWD.

These numbers aren't perfect because there are some assumptions, namely we assume the highest possible values when a column is "LT10" for example, we take the average of a range of values, and we assume there is no double counting, meaning there are no students that are both LEP and CWD. We've looked at the extremes in terms of these assumptions, and one thing is clear, making these assumptions paints a more accurate picture than doing nothing at all, which is exactly what the other guys are doing.



NCES Standardized Test Scores
School Year Overall Overall Adjusted* 3rd Grade 4th Grade 5th Grade 6th Grade 7th Grade 8th Grade High School
2016-17 27.0 27.0
2017-18 37.0 42.0
2018-19 47.0 47.0 47.0
* test results for LEP (limited english proficiency) and CWD (children with disabilities) are factored out of the adjusted results.