##### 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. (subscription only)

Skills covered:

Multiplication formula, roundup function, column charts, pictograms.

Activity: 1 lesson

Excel 2007 version

Excel 2003 version

space weight.xls

##### Create a Multiple Choice Quiz

During this task, students will learn how to write nested if functions in order to create a multiple choice quiz which provides feedback based on the input answer.

The task sheet, quiz template and video tutorial are provided. (subscription only)

This task is probably better suited to higher ability students

Skills covered:

Nested if functions. Suitable for Excel 2003 and 2007

Activity: 1 lesson

This task shows students how to set up basic form controls on a spreadsheet. (subscription only)

Skills covered: combo boxes and spinners

This task is probably better suited for the end of KS3 or KS4.

Activity: 1 lesson

car calculator.xls

worked example

##### Measuring BMI

An excellent single lesson to run with students and get them all involved in the task.

Skills covered: formula, sorting, conditional formatting

Activity: 1 lesson

##### Online auctions

This spreadsheet exercise provides students with an opportunity to practise:

• basic formatting and cell alignment
• inserting new columns and rows
• MIN, MAX and AVERAGE formulae

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### Absolutely Relative

This spreadsheet exercise provides students with an opportunity to practise:

• relative cell references
• absolute cell references

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### Count IFULA

This spreadsheet exercise provides students with an opportunity to practise:

• IF formula
• COUNTIF formula
• COUNTA formula
• COUNT formula
• RANK formula

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### INTeresting T-shirts

This spreadsheet exercise provides students with an opportunity to practise:

• INT function
• percentage calculations

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### TEXT Me

This spreadsheet exercise provides students with an opportunity to practise:

• PROPER function
• FIND function
• LEN function
• LEFT function
• RIGHT function

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### Hogwarts 1 and 2

This spreadsheet exercise provides students with an opportunity to practise:

• setting up validation

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### SORT it ahht

This spreadsheet exercise provides students with an opportunity to practise:

• autofilter
• customising filter searches
• sorting data in a table
• recording macros
• assigning macros

Contributed by Jon Bridgeman of Finham Park School

Activity: 30 mins

##### Champions Football League

This is an excellent resource which asks students to set up a spreadsheet and undertake a number of tasks related to the Champion's football league.

It has been written for Key Skills Level 3 ICT students. However, it could also be used to help teach or reinforce skills at KS4 level.

Please note that the task has been written specifically for Excel 2007 and it is not compatible for earlier versions.

Contributed by Jonathan Heaton

Activity:1 - 2 Lessons

A test which should take most of an ICT lesson.

A good way to check the level of your students' skills

test instructions

test marksheet