Teach ICT popular software and application tasks

Go to top bar navigation
Go to left side navigation

SOFTWARE SKILLS

Software Skill Home

Excel 2007: IF...Then, Nested IFs, IF OR, IF AND

The ticks indicate the suitability of resources for each Key Stage.

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				task answers
The Lakeside Theatre Company This task provides students with a number of opportunities to practice simple and complex IF statements (subscription only)				task spreadsheet
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				task

Nested IFs, IF(OR), IF(AND)

The ticks indicate the suitability of resources for each Key Stage.

Resource	KS3	KS4	KS5	Click Here
Tests Task				task answers
Cars, nested IF				task
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)				Task sheet Video tutorial and quiz spreadsheet

Copyright © www.teach-ict.com