Formulae and Functions: tasks
Basic formula tasks
Basic Excel FormulaA paper based task. Could be used as a starter or gentle reminder about spreadsheet formula (subscription only) 
task 
Teddy Tots Greetings CardsSkills covered:
(subscription only) 

Design a spreadsheetA paper based exercise which could be given to students to check their understanding of spreadsheets during a lesson or as a piece of homework. Students are asked to design a simple spreadsheet for a school fete. (subscription only) 
task 
Design a spreadsheetA paper based exercise which could be given to students to check their understanding of spreadsheets during a lesson or as a piece of homework. Students are asked to design a simple spreadsheet to hold teacher's marks. (subscription only) 
task 
Absolute cell reference tasks
Absolute cell references 1Use this task sheet to give your students further practice at writing an absolute cell reference (subscription only) 
task 
Absolute cell reference 2Use this task sheet to give your students further practice at writing an absolute cell reference (subscription only) 
task 
Absolute Cell References 3Use this task sheet to give your students further practice at writing an absolute cell reference 
(2003 & 2007) 
Percentages and absolute cell reference task
Car Sales  comparison and percentagesSkills covered:
(subscription only) 
IF...Then tasks
IF..Then workbookA stepbystep guide for writing if...then formulae (subscription only) 
task 
Schools tests taskA practical task for learning to write if..then formulae


Budget taskA practical task for learning to write if..then formulae 

Concert taskA practical task for learning to write if..then formulae


Discounts taskA practical task for learning to write if..then formulae 
task answers 
VLOOKUP Tasks
Walkthrough 1A stepbystep guide for setting up VLOOKUP functions (subscription only) 

Walkthrough 2A stepbystep guide for setting up VLOOKUP functions (subscription only)


ClassA practical task for learning to set up a VLOOKUP function 
class.xls 
JobsA practical task for learning to set up a VLOOKUP function

jobs.xls 
MagazinesA practical task for learning to set up a VLOOKUP function 
magazines.xls magazines answers 
FuelA practical task for learning to set up a VLOOKUP function 
fuel.xls fuel answers.xls 
CatsA practical task for learning to set up a VLOOKUP function 
cats.xls cats answers 
ZonesA practical task for learning to set up a VLOOKUP function 
zones.xls 
General spreadsheet practice tasks
BurgersThis exercise gives students a precreated spreadsheet and asks they to use it to calculate the nutritional values of a range of foods from a leading burger manufacturer. This could be used as part of a lesson about spreadsheets or could be left for a cover lesson.

task (2003) spreadsheet 
The DiscoThis exercise asks students to use Excel to calcualate the cost of setting up a disco. It starts with simple formulas and then leads them to absolute cell references and IF..Then functions. This could be used as part of a lesson about spreadsheets or could be left for a cover lesson if your students are reasonably confident with using Excel.

task (2003) task (2007) spreadsheet

Supermarket ComparisonsThis exercise gives students a small list of groceries from four large supermarkets. They are asked to use Excel to calculate total costs, average, minimum and maximum. They are also asked to perform simple formatting on the spreadsheet. This could be used as part of a lesson about spreadsheets or could be left for a cover lesson. 
task (2003) 
SkiingAnother chance for students to practice their spreadsheet skills

task spreadsheet 
RingtonesThis exercise gives students a chance to practice further Excel skills. 
task (2003) spreadsheet 
Starters and plenaries
10 questionsA lesson starter activity The rest of the class can ask up to a maximum of 10 questions to guess what they are. The volunteer can only answer 'yes' or 'no'


30 secondsLesson starter Students are shown a number of terms for exactly 30 seconds. They need to memorise as many as possible. After 30 seconds, the terms are hidden and they need to write down as many terms as they can remember along with at least one fact about that term.


321Display this on the whiteboard as students are walking through the door. They can work individually or in pairs to come up with the answers. Good for differentiation as all students should be able to get at least one of the six points.


Acting upA fun starter activity. Students are given a character card. They then have to explain a term related to this topic whilst staying in character.


CountdownStudents are given a set of jumbled up words related to this topic. They have to unscramble each of the words within 30 seconds. 

PostitsStarter task A fun kinesthetic activity where students work in teams to solve a puzzle. 

Teach me aboutLesson starter 

Word tennisStarter task Students work in groups of three with two 'serving' words related to the topic. The observer monitors for words which are 'out'


Draw me a pictureStarter or plenary Students are given a selection of key terms and are asked to illustrate one of them in a diagram.


Give me tenA starter or plenary task


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


Lucky dip questionsStarter or plenary task Every student is given a number at the start of the activity. This is used to help pick who will ask and answer questions about what has been learned during the lesson.


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


Pass the buckAn excellent starter or plenary for involving all students and getting them to identify a large number of facts about the current topic 

Pick meThis provides a differentiated starter or plenary activity. Students are given a question and work in groups to come up with an answer. The group must ensure that all members are able to articulate the answer.


Teacher talkaboutStarter or plenary task The class 'test' the teacher on their knowledge of key words related to this topic


Word associationA starter or plenary task. Students are asked to write down all of the words they associate with this topic. They then work with a partner to categorise them.


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


Call my bluffA plenary activity based on the popular game show, ‘Call My Bluff’ 

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

I predictThis task acts as the plenary from one lesson and the starter for the next lesson


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


MastermindA plenary activity which is loosely based on the game show 'Mastermind'


New wordsA plenary task Students have to identify three new words/terms that they learned during this lesson and then explain their meaning


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. 

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

TabooA plenary activity. This task follows the traditional Taboo game. Students work in teams with one student from each team having their back to the board. A word is displayed on the board and teams take it in turns to describe the word to the student without actually mentioning the word itself.


Text meA plenary activity where students are asked to write a text message to explain what they have learned during the lesson


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


Word buildingPlenary task Students work in groups to construct a sentence about today’s lesson

