Resource

KS3

KS4

KS5

Click Here

Tasksheet 1

This workbook provides a step-by-step guide to understanding absolute cell references.

It provides plenty of screen prints which the students can use as a reference point.

Also contains practice tasks

Task

Tasksheet 2: Sales commission

This provides a brief overview of absolute cell references and then gives students an opportunity to write their own formula.

Task

Tasksheet 3: Experimental data

Students enter data from an experiment.

They write their own absolute cell reference formula to work out the variables in the experiement

Task

Tasksheet 4: Car sales

This task sheet assumes familiarity with absolute cell references and if..then.

The spreadsheet contains instructions to give students a chance to check their skills in using both absolute cell references and if..then functions.

(task sheet: subscription only)

Concerts

Students are given a spreadsheet and have to use an absolute cell reference in order to work out the commission made on ticket sales.

(subscription only)

Ice Cream Task

This provides a formatted spreadsheet which requires an absolute cell reference to be written in order to calculate total ice cream sales

(subscription only)

Mobile phones task

Use this task sheet provides students with another opportuntiy to practice writing a formula which contains an absolute cell reference.

(subscription only)

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