Resource

KS3

KS4

KS5

Click Here

IF...Then Workbook

Explains step-by-step how to set up an IF...Then function.

Students are then given 4 further tasks to practice this skill

School Tests Task

Budget Task

Concert Task

Discounts Task

The Lakeside Theatre Company

This task provides students with a number of opportunities to practice simple and complex IF statements

(subscription only)

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

Resource

KS3

KS4

KS5

Click Here

Nested IF, IF (Or), IF (AND) Workbook

This workbook goes through how to set up Nested IFs, IF (OR) and IF (AND) Functions.

There are 9 practice tasks to ensure that students become confident with these skills

Tests Task

Cars, nested IF

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.

This task is probably better suited to higher ability students

(subscription only)