### Excel 2003: Charts and Graphs

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

#### KS5

##### School tests

This task provides a step-by-step list of instructions for the tasks that students need to follow.

They then use formatting techniques to improve the look of the worksheet.

They will then use their spreadsheet to create two different types of charts.

Encourage students to be independent by using the video tutorials to support them when they are unsure of how to do something.

school tests.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)

##### 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)

worldcup.xls

##### 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)

space weight.xls