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

Task sheet

Video tutorial and quiz spreadsheet

Form Controls Task

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

Task sheet (Excel 2003)

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:

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

Extension tasks are provided

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

Extension tasks are provided

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

Extension tasks are provided

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

Extension tasks are provided

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

Extension tasks are provided

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

Extension tasks are provided

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

Extension tasks are provided

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

Task .doc version

Task .docx version

Spreadsheet test

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

completed spreadsheet