State of Ohio Report Card Data Comparisons

In Kent States’ course, Computer Applications in Education, we needed to learn how to use Microsoft Access. This practice was done using data from the 2003 State of Ohio district report cards. Once the data from the report card was imported, we were to use the query function of Microsoft Access to create our own comparisons among districts. This is a helpful practice that can be used to gather data on districts for future employment considerations.

Example Query Question: How many school districts in Ohio are classified as Academic Emergency, Academic Watch, Continuous Improvement, Effective, and Excellent?

Example Query Question: What is the average salary of teachers in districts under Academic Emergency versus districts rated as Excellent?

Query Question 1: What is the average class size of districts ranked in the five rating categories?

Query Question 2: Which districts are in Query Question 3: For the districts of Lake

Cuyahoga county, and what rating do they have? County, how do they compare in terms of

terms of teacher salary?

Query Question 4: What are the top ten districts in Ohio in terms of per pupil expenditures? What counties are these districts in?

Query Question 5: Which districts in Lake County have the most honors graduates? Is the amount of per pupil expenditures a factor in the amount of honors graduates?