Display numerical data in graphical format

Bar and column charts

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)

download file

Task (Excel 07)

click here

worldcup.xls

Create a comparative column chart

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

(subscription only)

download file

Task (Excel 07)

click here

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)

download file

Task (Excel 07)

click here

ball.jpg

Mobile phone features

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

(subscription only)

 

download file

task

Printing options, bar charts

 

Kindly contributed by Jo Wallace from City of Bath College

click here

exercise (Excel 2007)

click here

survey_test0901

 

 

Copyright © www.teach-ict.com