Absolute and relative cell referencing:

Starters

Consider all reason

Starter task

Students are given an open ended statement related to the topic.  In pairs, they identify as many reasons as possible in order to provide an answer to the statement

(subscription only)

 

download file

 

Teach me about ...

Lesson starter

Students become the teacher! One student is tasked with preparing a five minute revision starter about this topic for the beginning of the following lesson.

(subscription only)

 

download file

 

Starter cube activity

(subscription only)

download file

 

Give me ten

A starter or plenary task
Students work in pairs to come up with ten words related to this project before joining up with another pair to expand their list.

(subscription only)

 

download file

 

Just a minute

Starter or plenary task

Students are asked to talk to a partner about this topic for 60 seconds whilst abiding by a set of rules

(subscription only)

 

download file

 

Teacher talkabout

Starter or plenary task

The class 'test' the teacher on their knowledge of key words related to this topic

(subscription only)

 

download file

 

One, two, three

Can be used either as a starter or a plenary task.

Students are given a sheet to complete firstly on their own, then with a partner and then joining up with another pair

(subscription only)

download file

 

4-4-2

A plenary activity where students are asked to summarise the lesson and pick out the main key words related to the topic.

(subscription only)

download file

 

Corkboard

A great plenary idea both for AFL and for getting feedback from every student

(subscription only)

download file

 

Lesson summary

This plenary provides students with an opportunity to evaluate the lesson and their learning and an AFL opportunity for the teacher.

(subscription only)

download file

 

Pyramid

A plenary activity.

Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson

(subscription only)

download file

 

Text me

A plenary activity.

Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson

(subscription only)

download file

 

Tweet it

A plenary activity

Students write a ‘Tweet’ message to sum up what they have learned during the lesson

(subscription only)

download file

 

One word

A plenary task.

Students have to sum up today's lesson in just one sentence. They must include a given word within that sentence.

(subscription only)

 

download file

 

 

Written Tasks

Theory Notes Task

Students read the theory notes on the mini website and then answer the questions on the sheet.

Answers supplied

(subscription only)

download file

task

download file

answers

100 words

Students have exactly 100 words to summarise the key points about this topic

(subscription only)

download file

 

Construct an answer

Students are given an exam style question to answer. They are also given a set of key words to incorporate into their answer.

(subscription only)

download file

 

Pros and cons

Students are asked to identify the pros and cons for the main factors related to this topic.

(subscription only)

download file

 

Word cloud

Students write a set of notes about this topic and then use them as the basis to create a word cloud. Their work can be used to create a classroom display.

(subscription only)

download file

 

 

Practical Tasks

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

download filedownload file

Excel 2003

 

Tasksheet 2: Sales commission

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

download filedownload file

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

download filedownload file

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)

download file

Task

click here

car sales.xls

click here

car sales answers.xls

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)

download file
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)

download file
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)

download file
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

absolute cell reference video tutorial

Task