The Funding of Public Education in Chicago

Professor Robert J. Lemke
Department of Economics and Business
Lake Forest College
Fall 2006

Syllabus

Assignments

2003-04 Common Core Data

Each year, National Center for Education Statistics compiles data on all schools and school districts, called the Common Core of Data. Here is an Excel file of an edited version for 2003-04 district data that has 155 variables and 13,857 observations. Here is the corresponding codebook.

2001-02 ISBE Data

Each year, the Illinois State Board of Education provides some of the data it uses to produce school and district report cards. The most comprehensive set of data it has released so far has been for the 2001-02 school year. I have taken this data and made 11 different data sets with it. Each of these 11 data sets is an Excel file with variable names listed in the top row. In order to know the meaning of each variable, one must read the on-line codebook. Each of the data sets is briefly described and linked below. In a few cases, schools or entire districts have been dropped due to missing data. To download any of the Excel files, right click on the link, and "Save Target As". You might also be able to left clik on the link and "Save As" from a pop-up menu.

  1. districts.xls: One observation for each district in Illinois. (37 variables; 888 observations; 362kb)

  2. elemdists.xls: One observation for each elementary district in Illinois. (37 variables; 382 observations; 151kb)

  3. highschldists.xls: One observation for each high school district in Illinois. (37 variables; 100 observations; 50kb)

  4. unitdists.xls: One observation for each unit district in Illinois. (37 variables; 406 observations; 174kb)

  5. schools.xls: One observation for each school in Illinois. (51 variables; 3777 observations; 1924kb)

  6. elemschls.xls: One observation for each elementary school in Illinois. (47 variables; 2550 observations; 1166kb)

  7. chicago_elemschls.xls: One observation for each elementary school in Chicago. (16 variables; 479 observations; 108kb)

  8. nonchicago_elemschls.xls: One observation for each elementary school in Illinois not in Chicago. (47 variables; 2071 observations; 941kb)

  9. highschls.xls: One observation for each high school in Illinois. (51 variables; 629 observations; 326kb)

  10. chicago_highschls.xls: One observation for each high school in Chicago. (18 variables; 68 observations; 27kb)

  11. nonchicago_highschls.xls: One observation for each high school in Illinois not in Chicago. (51 variables; 561 observations; 302kb)

Resources

Summer Assignments

  1. Before our first class meeting (12:30 - 1:20, 510 Young Hall, Sunday, August 20), read Smashed: Story of a Drunken Girlhood, Little Men, and, if you have never read it, Little Women.

  2. Chicago Public Radio aired a 23-part series on education in Chicago. The website is: http://www.wbez.org/programs/specials/chicagomatters/cm06_education/cm06_audio.asp. Please listen to the episodes that aired on April 17, 18, 19, 24, 25, 27, 28 and on May 3, 4, 15, 18.

  3. Type a one-page (max) response to the following claim: Chicago Public Schools should equalize per pupil spending across each of its almost 600 schools. Please email this to me by August 14. It will not be graded, but I would like to have a sample of your writing (and thinking) before the semester officially begins.

Exams

The midterm will take place during class on October 12. If you miss the midterm due to sickness, you must contact me immediately to reschedule the exam. If you will be away from campus on the 12th for a College-sanctioned event, you should see me at least by October 5th to schedule a time to take the exam. The final will be from 8:30 to 11:30 on Wednesday, December 13.

Personal Papers

You will write 4 one-page papers on your own educational experience. Use one-inch margins, double spacing, and 11 point Times Roman font for the first two papers. Style details are left to you on the last two papers.

  1. College Choice: Write a one-page description of why you chose Lake Forest College. In saying why you chose Lake Forest College, you should mention the other colleges you were considering, what characteristics of colleges were important to you, and how you ended up choosing Lake Forest College over the others. Due: August 31.

  2. High School Experience: Write a one-page description of some way in which your high school education could have been improved. Be specific and include funding and enforcement provisions if applicable. That is, what resources would have been needed to make the improvement, and who (e.g., a government -- federal, state, or local; a person -- an administrator, teacher, parent, or student; etc.) should have implemented this policy and been responsible to make sure it was improving your education. Due: September 7.

  3. Letter of Recommendation: Think ahead three years. You are a senior at Lake Forest College who is applying to graduate school. Acting as a professor at Lake Forest College, write a letter of recommendation on your behalf for admittance to graduate school. Due: September 14.

  4. Letter to the Editor: Write a one-page letter to the editor of the Stentor on any academic issue facing Lake Forest College that is important to you. (We will not be submitting them to the Stentor, unless you choose to do so on your own.) Due: September 21.

Summary Papers

Each summary paper should be three to five pages with one-inch margins, double spaced, and 12 point Times Roman font. Be sure to include a title, and center your page numbers at the bottom of each page. Include references, which can extend to a sixth page.

  1. Philosophy of Education: Write a paper expressing your philosophy of education. When appropriate, refer to the ideas of De Tocquiville, Dewey, Locke, Mill, Plato, Woolf, or others. You can also appeal to your own experiences and background. Much of your grade will be determined by the consistency with which you make your arguments. Due: October 5

  2. Book Review: Write a New York Times-type book review of a non-required book on education. You must tell me which book you plan on reading and reviewing by October 12. In liew of a book review, you can read an academic journal ariticle, and write a referee report on the article. (Referee reports tend to be more argumentative and detail oriented in nature.) Due: November 2.

Policy Report

Write a 15 to 25 page policy report on any current policy relating to public education. For example, you might write on any part of No Child Left Behid, the ISAT, high-stakes testing, the current system for funding public schools, Title IX funding, busing, or teacher certification. Write about something you are interested in. Refer to the literature, laws, or government programs/policies whenever possible. This paper will require research/reading in addition to what has been assigned in class. One place to start is with the resources listed under "Other Materials". You might also refer to your own experiences in schools and to your observation of schools in Chicago, Evanston, Lake Forest, and Waukegan.

The purpose of the report is to inform readers of the current status of some education issue. The report should highlight problems or shortcomings of the current system (or defend the current system against common attacks). Possible solutions or at least possible adjustments to the current system should be proposed and defended. Each student will present his or her report to the class in a 30 minute PowerPoint presentation after Thanksgiving. A rubric for grading policy reports will be available on November 2. The report should have the same style as the Summary Papers. Include an unnumbered title page. The report must use quantitative data and contain some tables and/or graphs displaying the data. Include all tables and graphs at the end of the report. Number tables and graphs sequentially, and include a title for each. Your grade will be determined in large part by how well you explain the issue at hand, interpret and present statistical evidence, and argue for a policy remedy. Due: Tuesday, November 28.