Excel Climate Graph Template

Climate graphs can be a bit fiddly to create in Excel so we’ve created an editable template for you to use. In our example, we’ve produced a climate graph for the UK based on Met Office data for 2018.

Climate graph for the UK

Climate graph for the UK

We have also included a blank template that can be edited and given to students to complete by hand.

Blank climate graph template

Blank climate graph template

Found this useful? Take out a subscription to Internet Geography Plus to support further developments on the site.

Click the image below to download the template.

Climate graph for the UK

Climate graph for the UK

 

 

 

10 amazing sites for geographical data

We’ve pulled tother a collection of fantastic websites that provide a range of geographical data. The websites are in no particular order, but each is worth exploring.

If you have any more data driven sites to recommend please leave a comment below!

Our World in Data

Our World in Data

Our World in Data

Research and interactive data visualisations to understand the world’s largest problems by Oxford University. What makes this site so good is the dialogue that accompanies the beautifully presented data. 

https://ourworldindata.org




Gap Minder Tools

Gapminder Tools

Gapminder Tools

Gapminder is an independent Swedish foundation with no political, religious or economic affiliations. Gapminder is a fact tank, not a think tank. Gapminder fights devastating misconceptions about global development. Reliable data can be presented in a range of eye-catching ways.

https://www.gapminder.org/tools

 

Office for National Statistics

Office for National Statistics

Office for National Statistics

The UK’s largest independent producer of official statistics and its recognised national statistical institute. 

https://www.ons.gov.uk

 

UN Data

UN Data

UN Data

A comprehensive collection of data from the United Nations. 

http://data.un.org/Default.aspx

 

Eurostat

Eurostat

Eurostat is the statistical office of the European Union situated in Luxembourg. Its mission is to provide high-quality statistics for Europe.

https://ec.europa.eu/eurostat/data/database

 

The World Factbook

The World Factbook provides information on the history, people and society, government, economy, energy, geography, communications, transportation, military, and transnational issues for 267 world entities.

https://www.cia.gov/library/publications/the-world-factbook/




World Health Observatory 

World Health Organisation

World Health Organisation

Global statistics based on health-related issues by the World Health Organisation

https://www.who.int/gho/en/

 

World Bank Open Data

World Bank Open Data

World Bank Open Data

A comprehensive data catalogue covering a range of development indicators. 

https://data.worldbank.org

 

Organisation for Economic Co-operation and Development

OECD Data

OECD Data

A wide range of data including agriculture, development, energy and the environment.

https://data.oecd.org/

 

Flourish Studio

Flourish Studio

Flourish Studio

Flourish studio does not provide data, but does enable you to create stunning data visualisations. Take a look at my first attempt using Flourish.

https://flourish.studio

Map your photos using Google Maps

Using Google Images and Google Maps you can easily create a map using an album of geotagged photos. Geotagged photos are those that include data on the location they were taken. Most modern mobile phones have this feature as do some digital cameras. If you are not sure a quick search on the Internet will tell you if this option is available and how to enable it.

Below is a map showing the location of a number of images taken in and around Hornsea on the Holderness Coast using an iPhone and a drone.

Looks complicated? Don’t worry, it’s not! Just follow the steps below.

To begin with, you will need to upload your geotagged photos to a new album in Google Photos. To do this login to your Google account and go to https://photos.google.com. Next create a new album by clicking +Create in the top right corner, then select Album.

Give the folder a title then upload the images you want to map.

Next, go to https://www.google.com/maps/d/ and select +Create New Map (top left corner). Your new map will open and be called Untitled map. Give your image a suitable title by clicking untitled map in the top left window.

Rename your map

Rename your map.

Click Save.

Next click Import (under the first layer which is called Untitled layer).

Click import

Click Import

Click the Photo albums tab. Next, locate the album where your photos are stored. Select all the images you want to import onto the map.

Select images you want to import

Select images you want to import

Next, click Select. The photos will then be copied onto your map.

This will create at least one layer containing your images and an icon of each image will be displayed on the map.

Imported images and new layers

Imported images and new layers

You will notice that each photograph has been given a title based on the location it was taken. You should go through these and rename them as appropriate. Once you’ve finished you can share your map with others by clicking Share > Change > On. You can then share the URL. You can also embed the map on a website by clicking the three dots next to the map title. Then select Embed on My Site.

Gapminder

Geography in Maths

Flourish with your data presentation and interrogation