Absolute and relative cell referencing:
Starters
Consider all reasonStarter 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) |
|
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) |
|
Starter cube activity(subscription only) |
|
Give me tenA starter or plenary task (subscription only) |
|
Just a minuteStarter 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) |
|
Teacher talkaboutStarter or plenary task The class 'test' the teacher on their knowledge of key words related to this topic (subscription only) |
|
One, two, threeCan 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) |
|
4-4-2A plenary activity where students are asked to summarise the lesson and pick out the main key words related to the topic. (subscription only) |
|
CorkboardA great plenary idea both for AFL and for getting feedback from every student (subscription only) |
|
Lesson summaryThis plenary provides students with an opportunity to evaluate the lesson and their learning and an AFL opportunity for the teacher. (subscription only) |
|
PyramidA plenary activity. Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson (subscription only) |
|
Text meA plenary activity. Students are asked to complete a self assessment sheet to indicate what they have learned during this lesson (subscription only) |
|
Tweet itA plenary activity Students write a ‘Tweet’ message to sum up what they have learned during the lesson (subscription only) |
|
One wordA 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) |
|
Written Tasks
Theory Notes TaskStudents read the theory notes on the mini website and then answer the questions on the sheet. Answers supplied (subscription only) |
task answers |
100 wordsStudents have exactly 100 words to summarise the key points about this topic (subscription only) |
|
Construct an answerStudents are given an exam style question to answer. They are also given a set of key words to incorporate into their answer. (subscription only) |
|
Pros and consStudents are asked to identify the pros and cons for the main factors related to this topic. (subscription only) |
|
Word cloudStudents 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) |
|
Practical Tasks
Tasksheet 1This 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 |
Excel 2003
|
Tasksheet 2: Sales commissionThis provides a brief overview of absolute cell references and then gives students an opportunity to write their own formula. |
Task
|
Tasksheet 3: Experimental dataStudents 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 salesThis 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) |
Task car sales.xls car sales answers.xls |
ConcertsStudents 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 TaskThis 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 taskUse this task sheet provides students with another opportuntiy to practice writing a formula which contains an absolute cell reference. (subscription only) |
|
Absolutely RelativeThis spreadsheet exercise provides students with an opportunity to practise:
Extension tasks are provided Contributed by Jon Bridgeman of Finham Park School |