Excel 2010: Charts and Graphs

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

World Cup: Create a bar chart and sort data

Students are given a set of data. They are asked to create a bar chart and undertake some basic formatting.

They are then asked to sort the data and create a second chart

(subscription only)

 

 
tick
tick

download file

task

absolute cell reference video tutorial

worldcup.xls

Disney Students: Create and format a line chart

Students are given a set of data. They are asked to create a line chart and undertake some basic formatting.

(subscription only)

 
tick
tick
tick

download file

task

absolute cell reference video tutorial

exam marks.xls

Create a comparative column chart

Students are given a set of data. They are asked to create a comparative column chart.

(subscription only)

 
tick
tick

download file

task

absolute cell reference video tutorial

temperature.xls

 

World Cup: Create a pictograph barchart

Students are given a set of data and step-by-step instructions to create a pictograph barchart

(subscription only)

tick
tick
tick

download file

task

Mobile phone features charts

Students collect data about different mobile phone features and present their findings as different charts.

(subscription only)

 
tick
tick

download file

task

My weight in space

During this task, students will use a spreadsheet to calculate what their weight would be on different planets in the solar system.

Skills covered:

  • Multiplication formula
  • Roundup function
  • Column charts
  • Pictograms

(subscription only)

tick
tick
tick

download file

task

absolute cell reference video tutorial

space weight.xls

Budget: Create and format a pie chart

Students are given a set of data. They are asked to create a pie chart and undertake some basic formatting.

(subscription only)

 
tick
tick
tick

download file

task

absolute cell reference video tutorial

budget.xls

Your Weekend: Create and format a pie chart

Students are asked to think about how they spend their time during an average weekend. They then use this information to create a pie chart to show the different proportions of time spent doing things.

(subscription only)

 
tick
tick
tick

download file

task

 

 

 

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com