Spreadsheet and Modelling Lessons

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

download file

Excel 2007 version

download file

Excel 2003 version

click here

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

download file

Task sheet

 

download file

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

download file

Task sheet (Excel 2003)

 

click here

car calculator.xls

click here

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

 

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

 

click here

Task .doc version

 

click here

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

download file

test instructions

download file

test marksheet

download file

completed spreadsheet