Students conduct a classroom-wide geographic literacy survey, chart the results on a graph, and then compare those results to the answers that young adults (18 to 24 years old) gave in a national geographic survey in 2006.
· Demonstrate knowledge of physical and human characteristics of given places around the world
· Collect, organize, and analyze survey data
· Create a bar chart to display that data, using Microsoft Excel
· Present those findings to a larger group
National Geography Standards
Standard 4: The physical and human characteristics of places.
Standard 3: Students apply digital tools to gather, evaluate, and use information.
· Computer with Microsoft Excel
· Geographic Survey (one copy per learner)
Ask students if they have ever seen the television program called “Are You Smarter Than a 5th Grader?” Let students tell what they know about the program. Then, say: “In a recent national survey among young adults, only 31% correctly estimated the population of the United States. Do you think our class is smarter than the adults in the survey? Let’s find out.”
Write the following chart on the chalkboard:
Population Range Number Answered % Answered
a) 10 million to 50 million
b) 150 million to 350 million
c) 500 million to 750 million
d) 1 billion to 2 billion
Next, tell students that the correct answer is (b) 150 million to 350 million. (Note: If you have a computer available, you can check the exact population of the United States at any given moment athttp://www.census.gov/population/www/popclockus.html) What percent of the students in the class got the correct answer? Ask: “How does our class compare to the national average of young adults?”
Finally, tell students that they are going to conduct a classroom-wide survey of six geography questions, chart the results on a graph, and then compare those results to the national survey of young adults.
Duplicate the Reproducible Geographic Survey (printed at the bottom of this Blog) and distribute one copy to each student in the class. Tell students that they do not have to put their names on the paper. The purpose of the survey is to determine how much the class as a whole knows about world, rather than to “test” individual students. Allow sufficient time for students to complete the survey.
While students our completing the survey, put the following chart on the chalkboard. Then, tally the results of the classroom survey by a show of hands to each answer for each question.
Number % Answered Adults Answered
Question 1 Answered Correctly Correctly
(b) South Africa
(b) Mandarin Chinese
(a) China and Russia
(b) United States and Mexico
(c) North Korea and South Korea
(d) Syria and Lebanon
(a) Honolulu, United States
(b) Manila, Philippines
(c) Tokyo, Japan
(d) Mexico City, Mexico
(a) Less than half the size of U.S.
(b) About the same size as U.S.
(c) About double the size of U.S.
(d) More than four times the size of U.S.
(b) North America
(c) South America
Tell students that they are now going create a bar chart that visually shows the results of each survey question and compares the results to each questions with those of the adults. To create a simple chart, follow these directions.
1. Open Microsoft Office Excel.
2. In Column B1, type the word Adults; in C1, type Our Class.
3. In Column B2, type the percent of Adults who answered this question correctly. (For example, for Question 1, 25% of adults answered the question correctly. Put 25% in B2.) In Column C2, type the percent of students in the classroom that got this answer correct, e.g., 62%
4. In Column A2, type the answer to the survey question. For example, type: Question 1: Correct Answer: Indonesia
NOTE: You may want to create a bar chart for each question. If not skip a row and enter information in the same Worksheet for the next survey question.
5. Highlight A1 through C2.
6. Point to and click Insert on the Main Menu. Then, drag down and highlight Chart Wizard.
7. Under Chart type, click: Bar. Then, click Next.
8. Next to Series in: Click Rows. Click Next.
9. In the Chart title box, write the name of your school.
10. Click the Legend tab. Then click the Placement button for where you want the Legend to appear, e.g., Left.
11. Click the Data Labels tab. Under Label Contains, click Value. Click Next.
12. Under Place chart, click As new sheet.
13. Click Finish.
1. Right click the Legend text box and Title text box and click Format Legend. Highlight the type and change the font, font style, and size, as desired.
2. Right click one of the bars in the bar chart and click Format Data Point. Change the color or the Fill Effects of your bars.
3. Click the Text Box icon on the drawing toolbar and insert a text box in each bar. Insert copy and format the copy as desired.
National Geographic-Roper Survey of Geographic Literacy
Correct Answer Answered Correctly
Question 1: Indonesia 25%
Question 2: Mandarin Chinese 18%
Question 3: North Korea and South Korea 37%
Question 4: Mexico City, Mexico 62%
Question 5: More than 4 times the size 39%
Question 6: South America 59%
Reproducible Geographic Survey
Conducted by __________________
Age__________ Grade __________
Question 1 of 6
In which of these countries is a majority of the population Muslim?
Choose Your Answer
_____ (a) Indonesia
_____ (b) South Africa
_____ (c) Armenia
_____ (d) India
Question 2 of 6
Which language is spoken by the most people in the world as their primary language?
Choose Your Answer
_____ Mandarin Chinese
Question 3 of 6
The most heavily fortified border in the world exists between which two countries?
Choose Your Answer
_____ China and Russia
_____ United States and Mexico
_____ North Korea and South Korea
_____ Syria and Lebanon
Question 4 of 6
Which city would be least likely to be threatened by a tsunami?
_____ Honolulu, United States
_____ Manila, Philippines
_____ Tokyo, Japan
_____ Mexico City, Mexico
Question 5 of 6
How does the size of the population of China compare to the population of the United States?
_____ China’s population is less than half the size of the population of the United States.
_____ China’s population is about the same size as the population of the United States.
_____ China’s population is about double the size of the population of the United States.
_____ China’s population is more than four times the size of the population of the United States.
Question 6 of 6
On which continent is the Amazon rain forest?
_____ North America
_____ South America
Have students prepare a report of their findings to present to another class or during a Parent conference.
Survey Variations: (1) Allow students to select 10 WorldTeaser Challenge questions around which to develop their survey. (2) Conduct a school-wide survey and chart the results by grade.
Next Week: Jumpstart Your Grammar Lessons with Idioms
Source: WorldTeasers: World Culture and Geography — An educational game designed to help upper elementary grade students supersize their global knowledge with fascinating, intriguing, and amusing trivia about countries and their culture. Grades 4 +.Available at SchooDoodle.com.
Filed under: Uncategorized on April 17th, 2008