geographyalltheway.com

Online Geography Resources

 

Location and Climate

 
Geography Starter

Starter

 
What does this graph show?
 
Geography Activities

Activities

 

Who is doing what?

 

Australia Australia

Bolivia Bolivia

Canada Canada

Indonesia Indonesia

Nepal Nepal

Niger Niger

Norway Norway

Switzerland Switzerland

Location and Climate

B

C

D

E

F

G

H

A

 

Today's Task > Location

  1. Create a new page on the class wiki > enter the name of your new page > choose a page template to start with.
  2. Use a service such as Google Maps so that you can embed a map of the country on the wiki page.
 

Today's Task > Climate

 

Australia Australia

Bolivia Bolivia

Canada Canada

Indonesia Indonesia

Nepal Nepal

Niger Niger

Norway Norway

Switzerland Switzerland

Capital City

Canberra
La Paz
Ottawa
Jakarta
Kathmandu
Niamey
Oslo
Bern

Temperature (°C) Rainfall (mm)

Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
Temperature Precipitation
 
Using Excel to Produce a Climate Graph

Step 1:
Open Excel and in a cell near the top left type Month. Type January in the next cell, followed by February, etc.

Step 2:
Type Temperature (°C) in the cell below the word 'Month' and then enter the temperature data in the cells under each month.

Step 3:
Type Rainfall (mm) into the cell below the word 'Temperature' and then enter the rainfall data in the cells under each month.

Step 4:
Highlight all the data that you have entered and click on the Chart Wizard icon in the toolbar.

Step 5:
Choose the first type of Column graph and then carry on until you get to Step 3 of the wizard.

Step 6:
Type in the graph title e.g. Climate Graph of Anytown, then the x-axis label e.g. Months and then finally type in Rainfall (mm) for the y-axis.

Step 7:
Select the Legend tab at the top of the wizard and untick 'Show Legend'.

Step 8:
Click next and in Step 4 of the wizard choose the option ‘As new sheet’. Give it a name and click Finish.

Step 9:
The next task is to convert the temperature data to a line graph. Move your mouse over one of the temperature columns and right-click. From the option box that opens, choose ‘Chart Type’ and then ‘Line’ graph as the type of graph. The temperature data will then be plotted as a line graph.

Step 10:
The next task is to move the temperature line upwards. To do this, right-click on the line, choose ‘Format Data Series’ from the option box that appears, then select the Axis tab at the top and click on ‘Secondary axis’.

Step 11:
The final task is to add a label to the new y-axis on the right. To do this, click on the chart wizard again and move
through to Step 3. In Step 3, a new box should have appeared called ‘Secondary value (Y) axis’. Use this to enter a label for the temperature data e.g. Temperature (°C)

Step 12:
You can (after saving the graph) go back and alter any aspect of it e.g. the colours of the bars or lines, edit the title and axis labels, etc, etc.

Step 13:
IMPORTANT: Because you want to be able to compare the climate graph you have produced with the climate graph produced by the classmates the scales on the two graphs need to be the same. Right click on the rainfall axis and change the scale to have a maximum value of 400 and minimum value of -200. Right click on the temperature axis and change the scale to have a maximum of 40 and a minimum of -20.

Adding your Climate Graph to your Wiki

To add your climate graph to your wiki you will need to turn it onto an image by using the 'Print Screen' function on your computer and then pasting what has been captured into an image program such as Paint. Once you have pasted into the image program you should be able to crop your graph to size and then save it as a .jpg file.

 

Extension Task

GeoHive
Add the location of the the top 6 largest cities onto your map. You will have to make the map again in quipkmaps.com and then re-embed it into your wiki page.
 
Geography Review
Homework

Review and Homework Task

 
Add a link from your class project page to the two pages you have been responsible for producing so far.
 

 geographyalltheway.com on facebook
Instagram
Follow @gatwUpdates on twitter
flickr
Contact geographyalltheway.com
© 2006-2021 - All Rights Reserved - Author: Richard Allaway | Logout