Database Queries- reportcard.mdb

 

 

 

 

 

How many Ohio schools are rated in each category, per category?

 

 

 

16 districts are rated academic emergency

52 are rated academic watch

277 are rated continuous improvement

178 are rated effective

85 are rated excellent

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What is the average teacher salary of a school rated Academic Emergency vs. a school rated Excellent?

 

 

 

Academic Emergency: $43,716.25

Excellent: $48363.31

 

 

 

 

What is the average teacher experience for academic emergency vs. excellent rated districts?

 

 

 

Academic Emergency: 13.3 Years

Excellent:13.9 Years

 

 

What is the average class size vs. teacher salary?

 

 

Average class size vs. teacher salary, 10-20 students, whole numbers only

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What is the average graduation rate for academic emergency vs. excellent schools?

 

 

Selection of results from the query

 

 

 

 

 

 

 

 

 

What are the top 5 paying Ohio school districts?

 

1.Cuyahoga Heights Local

2.Orange

3. Mayfield

4. Shaker Heights

5. Beachwood

 

Same query but with teacher experience average for each district.

 

 

 

 

 

 

 

 

 

 

 

 

 

What is the best paying district in Portage County?

 

 

Aurora is the best paying school district in Portage County, Ohio