By: Nicole Keith

11^th Grade US History

Topic: Indiana History

US History Standards: USH 8.9, 9.1, 9.2

ISTE Standards: I, II, III, IV (Teacher)

III, V (Students)

Many students are unaware of the population size of their own town and especially their own state. If asked, many students could not even name the top ten cities in their state in terms of rank due to population. The goal of this lesson is to assist students in learning more about their state and its importance in the scope of our nation. The teacher will give the students the names of the top ten cities in Indiana and the students will research each city’s population and inter that data into a spreadsheet for a visual representation.

Procedures:

1) Students will be taken to the computer lab.

2) Students will be instructed to open Microsoft Excel.

3) Students will be given the names of the ten most populated cities in Indiana.

4) Students will research the actual population (based on year 2000 Census data) using the Internet.

5) Students will input their data and create a bar graph.

Follow Up Questions:

1) Which city had the highest population?

2) Is there any city in the list that surprised you?

3) Is there an Indiana city not on the list that you would have expected to be?

4) How many more people live in Indianapolis than live in Terre Haute?

Rubric:

Did student list all ten cities on the spreadsheet?

10 9 8 7 6 5 4 3 2 1

Did student list the population for each city?

10 9 8 7 6 5 4 3 2 1

Did student create a graph with title, information for all ten cities, key, X axis, and Y axis components?

5 4 3 2 1