| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.

View
 

Population Project- 7th

Page history last edited by katieverlin 5 years, 11 months ago

Population Density and Growth Project

7th Grade

Classwork:

We will begin this project researching data and calculating density with a partner.  For this part of the project, you may work with a partner of your choice.
1. Open up the map Pop Density Prefectures Comparison.pdf

2. Choose 5 Japan Prefectures that you think are the most densely populated.  Write these down in your spiral notebook.

3. Using the data on this document, Japan Prefectures - Population and Land Area write down the exact population and land area for your 5 prefectures.

4. Calculate the exact population density for these 5 prefectures.
5. Rank them in order according to your estimate, putting the most dense prefectures first, and write them down on your list.

6. While you are waiting for everyone to complete the classwork, you can browse these websites just for fun! 

 


 Just for fun!

1.  Learn to pronounce the Japan Prefectures that you picked!

 

 

2.  Study each of the maps below.  With your partner, write down a fact or two from the map that you find interesting. 

    1. Time Population Density Map - USA 
    2. USA Density Map  
    3. World Population Density Map  
    4. World Population Density by Country 

 

3.  Japan: Please read about prefectures and study the maps below.

    1. Japan's Prefectures 1 
    2. Japan's Prefectures 2
    3.  Maps of Japan (scroll down to the population density section)
    4. Population Density Map of Japan 
    5. Population Density Ranking of Japan's Prefectures 
    6. Interesting Site about the population of Japan

 

The following project must be done INDEPENDENTLY.

 

Objective: This integrated project uses technology and math concepts to connect to the 7th grade social studies curriculum.  Students will use GoogleDocs to compute data and create charts analyzing population density for Japanese Prefectures.  They will also research and analyze population growth data for another country in Asia.

 

Grading Rubric:  Please check the rubric as you work on your project!7_populationgrowth_density_rubric.doc

 

1.  COPY the "Japan Prefectures Population Land Data" sheet from the  Japan Prefectures Population to create your own Google Spreadsheet.

    1. Name the sheet Your FirstNameLastInitial, Population Project  example:   KatieV Population Project
    2. Create a Command for Column E to find the population density of each prefecture.  To do that consult the Google Spreadsheet Command Document. spreadsheet_commands_googledocs.doc
    3. Copy the command for the entire column.  For instructions, please use the Google Spreadsheet Command Document from above.
    4. In Cell E1, name the Column "Density"
    5. Create a Command for Column F to find the Density rounded to the nearest whole number.  Use the spreadsheet command guide to help you.
    6. Copy the command for the entire column.
    7. In Cell F1, name the Column "Density (Rounded)" 

 

2.  Make a chart showing the prefecture and the population density of Japan. 

    1. Highlight Column A and Column F (Click on the top of Column A, then press Command as you click at the top of Column E)
    2. Click on "Insert- Chart"
    3. Choose a chart that best represents your data.
    4. Edit your chart so it looks nice and is informative.  (Be sure to add a title to your chart.)
    5. Add your chart to your wiki page.
    6. Share it with me at kverlin@woodlawnschool.org
    7. Share it with Ms. Robinson.

 

3)  Population GrowthCreate a Population Growth chart

     Create a new sheet in the same Google Doc.

  1. Add a new sheet into your Population Project GDoc
  2. Rename it Population Growth.

 

     Find Your Data: 

  1. Use this website to find your data:  http://www.populstat.info/
  2. Select ASIA on the LEFT of the page.
  3. Scroll down to find your country.  You may pick from 
    1. Japan
    2. Laos
    3. Cambodia
    4. Vietnam
    5. China
    6. Indonesia
    7. Cambodia
    8. The Philippines
    9. Thailand
    10. Burma. 
  4. Select of the whole country.  If you do not see population data with corresponding years then you have not selected of the whole country and you will need to try again.

 

Record Your Data:

Option 1
Manually select and type in data points (recommended for PC users) 
Option 2
Copy the entire data set 
  1. Pick 20 years with data points.  These years need to be about 10 years apart.  Please make these years evenly spaced out.  You must end in the 2000's.  If there is not enough data to end in the 2000's going 10 years apart, you may go 5 years apart.
  2. On the Population Growth sheet that you created in your GDoc, name two columns Year and Population.
  3. Record the YEARs you picked and the POPULATION onto this page.
 
  1. Copy the entire data set into your GDoc.

  2. Copy the data into two columns.

  3. Reformat the zeros using Command+F

  4. Delete any rows missing population data.

  5. Reformat the years to get rid of c's. 

 

 

 

  • Do NOT use ESTIMATED data.  Your data set will end in 2000 or 2001.
  • That data is listed as 310,0  this means 310,000.  YOU will need to add the zeros to your data set.  You can do this manually or with command+F on your computer.

 

Insert a Chart:

Once your data is entered and formatted you will need to insert a chart showing the population growth.

  1. INSERT - CHART, pick  SCATTER PLOT or Area Graph
  2. Your chart needs to show POPULATION GROWTH over TIME.  So time (the years) needs to be on the x-axis! 
  3. Move the chart to it's own sheet and rename this sheet your Your Name and Your Country's Name.  (Click on the word CHART on your chart and select MOVE TO OWN SHEET.)
  4. Add a title to your chart and format it.  Make sure the years are visible on the chart and that the x- and y- axes are labeled.
  5. Add this chart to your wiki page.

 

Questions to Answer:

Answer these questions on your wiki page below your charts.  If you have forgotten what line of best fit or linear means, it is your responsibility to look it up.  Do not ask another student.

  1. Look at the line of best fit.  Is it linear?
  2. Write an explanation of why you think your graph looks the way it does. 

 

We will share and compare with other groups.


Optional:

Create an extra graph of the Population Growth of the USA and add it to your wiki page.

 

 

 


** Optional:  Choose one of these population density items and create a chart in Google Documents. 

Compare the population density of cities in Japan with cities in the United States

  • Find the most densely populated city in Japan.
  • Find the most densely populated city in the United States.
  • Find the population density of the city that you live in.

 

  1. Add a new sheet into your Population Density Project GDoc, rename it.
  2. Record this information onto your Google Doc and then create a chart the best visually represents the differences. 
  3. Upload it to your wiki page. 

 

More Resources of Interest:

 

 

Comments (0)

You don't have permission to comment on this page.