Title: Learning about Population Information Where I Live – A Multimedia Presentation

Grade Focus: 3, 4, 5

Subject: Math

Technology Integration: Discovering the Internet, Excel

Recommended Time to Completion: 2 weeks

INTRODUCTION:

Population impacts many facets of daily life. How does population affect new businesses moving to a location? What is the relationship between the size of a city and the number of people who live there? What can be learned from information, measures, and statistics relating to a population? Do graphs help us interpret data? These questions can be answered as students perform a thorough research process on population information for their home. Note: This lesson plan was developed by a U.S. elementary teacher and thus uses U.S. counties in its examples. Please substitute appropriate resources and designations for your area and visit the Extend section to:

  • expand this lesson to a global/local resource
  • Integrate this lesson with a social studies exercise reinforcing population studies or other topics such as the environment

PREREQUISITE EXPERIENCE:

Students will need to be familiar with spreadsheet terms and concepts. They should also be familiar with using PowerPoint and how to use the Internet to conduct research.

TEACHER PREP TIME:

Familiarize yourself with population statistics resources, i.e., http://www.census.gov/ and http://factfinder.census.gov/home/saff/main.html?_lang=en. Note on the Factfinder site the top right Population Data column and its search engine. In the Population Data column's search engine, familiarize with the steps for retrieving county population statistics. In the results, not the link back to the Fact Sheet, with stats focused on the retrieved county.

Review these training videos from Nortel LearniT.

  • PowerPoint:
  • Discovering the Internet,
  • Imaging,

Locate several web sites students may be able to use to obtain accurate county population records.

  • http://www.census.gov/popest/counties/

MATERIALS:

  • Projector
  • Computer with Internet/Excel/PowerPoint

PROJECT:

Students will be working in groups of 3 to research the populations of counties in their state. Then, they will graph the results in an Excel spreadsheet. Each group will be asked to decide which of the 5 counties researched would be the best location for a new business. They will create a PowerPoint presentation to give reasons why they selected the particular county. There will be at least 6 slides in the presentation:

  1. Title with names of students in group
  2. Graph of population
  3. Graph of square miles and persons per square mile
  4. County selected
  5. Reasons for choosing the county
  6. Resources (name of web sites where students got their information)

ASSESSMENT/GRADING:

Students will complete a checklist before their presentation. They will be graded based upon a rubric.

TIME MANAGEMENT TIP:

If time is an issue, the teacher can obtain the county population numbers for the students to place into Excel before researching the counties.

Engage

  1. Brainstorm with your table group why the United States would care about the population enough to take a count. How does the size of your county compare to other counties in your area? Does that difference negatively or positively impact your county? In what ways? How does a county’s population affect new businesses moving to a location? What is the relationship between the size of a county and the number of people who live there? Share your ideas during a class discussion.
  1. How do graphs help us interpret data? Pair up with another student to answer these questions with Two Minute Talks. The instructions for the Two Minute Talks are included.
  1. If you have access to United Streaming, these videos may be used to increase your understanding of population.
  2. Los Angeles County Office of Education. 2001.
    unitedstreaming. 30 March 2008
  3. Discovery Channel School. 2006.
    unitedstreaming. 31 March 2008
    <

“Discovery Education streaming is a digital video-on-demand and online teaching service to help improve students' retention and test scores; it is aligned to U.S. state and provincial standards.” If you do not have access to United Streaming, you can sign up for a free 30 day trial at

Two Minute Talks

Purpose: To activate prior knowledge and focus student learning on the topic about to be addressed.

Description: During Two Minute Talks, students will share with a partner by brainstorming everything they already know (prior knowledge) about a skill, topic, or concept. In doing so, they are establishing a foundation of knowledge in preparation for learning new information about the skill, topic, or concept.

Procedure:

1. Group students into pairs.

2. Inform students that they will each be talking about topic X for two minutes. They will need to select which student will begin first. An easy way to do this is to say something like: "Find out whose birthday comes first in a calendar year." Then tell students that, "That person gets to go second!"

3. Using a stop watch or other timing device, tell students to begin talking.

4. At two minutes, instruct students to switch. At this point, the other partner begins talking. It is okay for the second person to repeat some of the things the first person said. However, they are encouraged to try and think of new information to share.

5. Have a few groups share some of their responses with the entire class when the activity is done.

Sample Two Minute Topics:

What are the research benefits of using the Internet?

What would happen to schools if all the computers disappeared overnight?

Name as many topics for databases that you can think of.

How would you use a PowerPoint slideshow to convince your parents to increase your allowance?

Name all of the things you can do in a word processing program.

Explore

  1. Review the population facts ideas gathered during the brainstorming.
  2. As a class do a basic population information search using the Internet (possibly projecting on a classroom screen). You might explore a different state than yours.
  3. As a class, do research to come up with a list of the names of all the counties in your state.
  4. Divide the students into groups or partners so they can begin their Internet research.
  5. As you research and collect your data, record your information into an Excel Spreadsheet. The following is just an example; you may have other population and county facts in your spreadsheet.

Recording Sheet

Name of County / Year 2000 Population / Square Miles / Persons per Square Miles
1.
2.
3.
4.
5.

For assistance with Excel:

  1. You will list the five counties you feel would be best locations for a new business. Keep in mind why these counties would be beneficial to your business.

Explain

  1. Over the next four days, you and your partner will be gathering information for your project.

Here are some suggestions to help you locate some research.

Start your exploration by creating population size-related questions you have about your community and then categorizing the questions into topics.

Find Printed Materials: Look for books and articles to start answering your questions. The local library is the best source for this task.

  1. While you are researching, keep in mind your PowerPoint final project. Look for pictures or photographs that could enhance your presentation.

Tip: When you decide what images (pictures), sounds or text that you want to use in your presentation, be sure to check for a copyright notice. Some web sites want you to use their materials for educational projects while other don’t. A good practice for you should be to look for an email on the Web page you want to use materials from and use it to send a request for permission to use it in your class presentation.

It is also important that you identify materials that you use completely in your production. This is called “making a citation” of someone else’s work. The format that is typically used is as follows:

Last Name, First Name of Author (if known). “Title of work/article/page.” Title of Complete Document (if applicable). Date last modified. URL (date visited).

Elaborate

Finish your research and create your multimedia project. A key step in your work is sharing it with others.

You will use Microsoft PowerPoint to create a slideshow with text and graphics.

The presentation should be at least 6 slides:

  1. Title Page
  2. Introduction to place and why you chose that place.

3. Place in the past

4. Place in the present

5. Impact of Change

6. Credits/Bibliography

You can refer back to the sample presentation, Teacher Example, for an example of the requirements. You can also utilize the instructions for PowerPoint below:

PowerPoint Presentations,

If you finish early, you can add animations, sound effects and transitions to their slides.

Be prepared to present your work to your class. The teacher will assign you a time for your presentation.

Instructions for PowerPoint

  • Click on the green Start icon at the bottom left hand corner on the screen.
  • Go to All Programs.
  • Go to Microsoft Office. A list of programs will pop up to the right. Click on PowerPoint.
  • You will have your first slide of your presentation on the screen.
  • The first slide has a Title and Subtitle box to type text. Click in the box to type your title which is the name of your inventor. Click in the subtitle box to type your names.
  • When you need a new slide, go to Insert in the tool bar and click on New Slide, or click on New Slide in the tool bar on the far right.
  • When you need to change the format or layout of the slide, click on Getting Started to the right of the slide. You will have a menu of options. Click on Slide Layout. You will have many choices of layouts. Click on the one you want and it will apply that design to your slide. You will have choices to add content (pictures/clip art) and text. Click on the layout you want.
  • You may want to add clip art to a slide. You will need a slide where you and add content. There are 6 icons in the blue box. Click on the picture of a person. The person is the last icon on the top row. A box will pop up that give you many choices of pictures to choose from. When you find one you want, click on it and the picture and then click on ok. It will appear on your slide. Or you can go to insert in the tool bar and click on picture. You can add clip art or a picture from a file.
  • When you want to add text, click in that box. You will have a cursor to start typing.
  • To change the background color of a slide, click on Getting Started. If you have changed the layout, it will read Slide Layout now. In the menu that comes up, click on Slide Design – Color Schemes. Your options will change. When you select a background color you want, click on the arrow on the right side of the box. If you want to change the color on all your slides, click on Apply to All Slides. If you want to change the color on only the selected slide, click on Apply to Selected Slides.
  • When you have all your slides completed, you want to set up transitions between each slide. Click on Getting Started (or Slide Layout or Slide Design). Click on Slide Transition. You will have a list of choices to select from. You will need to do this for each slide.
  • When you are ready to view your presentation, click on View in the tool bar. Then click on Slide Show. You will need to click the mouse to move from one slide to the next.

Evaluate

Work will be evaluated using the attached project rubric.

PowerPoint Presentation Rubric

Criteria / Unsatisfactory / Needs Improvement / Satisfactory / Exemplary
Research / Limited research, from limited sources / Somewhat well research from somewhat varied sources. / Well researched, from various sources / Thorough research from varied sources presenting different points of view
Storyboard / planning / Limited planning evident / Some planning evident / Planning evident / Thorough planning evident
Content / Lacks detail / Some detail / Good detail / Excellent detail
Technology Use to Demonstrate Understanding / Technology use with little purpose / Technology use with some purpose / Technology use with purpose / Intuitive technology use with specific purpose
Overall Final Project / Inconsistent and inappropriate aesthetics and technical functionality / Somewhat consistent and appropriate aesthetics and technical functionality / Consistent and appropriate aesthetics and technical functionality / Consistent, creative and appropriate aesthetics and technical functionality

Population of ______

Counties Project Checklist

Name ______

Name of Counties ______

______

Due DateDate Teacher’s

CompletedInitials

1. Select 5 Counties ______

and record information

2. Complete Slide 1______

3. Complete Slides 2-5 ______

4. Complete Slide Show______

5. Practice Presentation______

General Information:

You are expected to meet the deadlines in the Due Date column above. KEEP THIS CHECKLIST! It is to be turned in when you present your PowerPoint presentation and will be a part of your grade. Be sure to have it signed each time you complete a portion of the checklist.

Extend

Extending (general):

  1. Create a business plan for your fictional company in your home or the area you are studying.
  2. Present your information to an audience.

Global and Local Applications:

  • Consider these resources and suggestions for extending the lesson and to broaden the lesson to apply to a non-US or global/local resource. You may integrate this lesson with a social studies exercise reinforcing population studies or other topics such as the environment.

.

Local: Locate Your Country’s Population Statistics and Related Information Online

Tips for finding your country’s statistical sites:

  1. Begin with a Wikipedia search and enter your area’s name in the search box. When you find that page, you’ll likely find statistics there, plus a list of references such as the handy UK Neighbourhood Statistics page http://www.neighbourhood.statistics.gov.uk/dissemination/
  2. Wikipedia also has population comparison articles such as From there you can drill down to Liverpool or Belfast.

Go to the web site for your country as illustrated using Canada’s

  1. Statistics Canada which will drill down to more detailed statistics,
  2. e.g., by education,
  3. or population by gender and age group
  4. or where you can view a descriptive overview to find population-related elements, e.g.,
  5. or
  6. Drill down to the community level, e.g., Ottawa

Locate Population Statistics for the World’s Countries Online:

  1. UN Division of Economic and Social Affairs, Population Division home page provides a look-up capability for actual and projected population statistics at the country level (1950 through 2050) for all countries.
  2. Basic data:
  3. Detailed data (age groups, gender, change, growth, life expectancy, etc.):
  4. Use in conjunction with geographic and/or country profiles (with time expansion) (recommended for upper grades’ analysis):
  1. CIA World Fact Book https://www.cia.gov/library/publications/the-world-factbook/
  2. Population statistics for individual countries (with descriptive demographic notes) https://www.cia.gov/library/publications/the-world-factbook/fields/2119.html
  3. Links to country names drill down to detailed country profiles, including economic information related to population

Integrating With Other Topics:

Rural Population, Development, and the Environment:

Urban Population, Development, and the Environment:

Nortel LearniT Copyright 2008. All Rights Reserved.

Page 1 of 12