Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
Responsive image

Lesson 6 - Conditional Formatting

Overview
Flight Path
Learning Objectives
0 results forGuest
IDSkill_name
 6 I can use 2+ parameter functions: IF, COUNTIF
 7 I can use conditional formatting

🏁 Learning Objective 18 :- I can use 2+ parameter functions: IF, COUNTIF


Starter - IF Stamenets Quiz

modelling

Click here to open the 'TV Quiz'.

Fill in as many answers as you can.

You have 5 minutes to complete as many questions as you can


IF Statements

An IF Statement is a 2+ parameter functions. Below is an example of an IF statement that checks if two cells, 'C21 and C23 are equal. If they are, it sets the value to 'Correct', if not it sets it to 'Incorrect'

modelling

If you look in your TV quiz and click on a cell that says 'Correct', you can see an example of an IF statement in the formula bar.

Extension

  • Make a new worksheet in your main workbooks spreadsheet and call it 'Plotter Quiz'.
  • See if you can create your own quiz question about Harry Potter

    • Update your objectives

    control

    🏁 Learning Objective 19 :- I can use conditional formatting


    Task - Conditional Formatting

    modelling

    Click here to open the step by step instructions to learn how to use conditional formatting.

    You have 15 minutes


    Extension

    Attempt the tasks for Hogwarts 2

    Update your objectives

    control

    Extension Task - Football Table

    Task - IF Statements


    Follow the step by step instructions below to practice using IF Statements.

    You have 15 minutes

    control
    0 results forGuest
    Recent Comments

    Teacher Date: 2025-04-22


    Guest