Scribd
Upload
4 views11 pages

Excel Function02 If 2025

The document outlines a lesson plan for teaching the IF function in MS Excel, focusing on how to make decisions based on conditions. Students will learn to identify and apply the function, including its syntax and components such as logical tests and values for true and false outcomes. The lesson includes interactive activities and a metacognitive prompt to encourage students to reflect on their understanding of formulas.

Uploaded by

timothybermins
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views11 pages

Excel Function02 If 2025

The document outlines a lesson plan for teaching the IF function in MS Excel, focusing on how to make decisions based on conditions. Students will learn to identify and apply the function, including its syntax and components such as logical tests and values for true and false outcomes. The lesson includes interactive activities and a metacognitive prompt to encourage students to reflect on their understanding of formulas.

Uploaded by

timothybermins
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Learn Like a GEM

Subject: Computer Science


Lesson: MS Excel – Functions and Formulas
Date: 15-01-2026
Do Now
Metacognition Prompt:
Silent Solo What do I already know about
formulas and conditions?

How do we normally decide if someone has passed or failed?

1. What rule are we using?


2. Can a computer make this decision automatically?
Learning Outcome To Know
By the end of this lesson Key components
students will be able to:
IF function – Used to make a decision in
LO:- Identify and apply the IF Excel: if a condition is true, do one thing; if
function in Excel to make decisions false, do another.
based on conditions. Logical test – The condition you want to
check (e.g., A1>10).
Value if True – What Excel should return
if the logical test is true.
Value if False – What Excel should return
if the logical test is false.
LO:- Identify and apply the IF function in Excel to make
I Do, We Do, You Do decisions based on conditions.

Slide 6

Slide 5

Slide 7
Slide 8
LO:- Identify and apply the IF function in Excel to make
I Do decisions based on conditions.

IF Function

Syntax:
=IF(logical_test, value_if_true, value_if_false)

Example:
Metacognitive Prompt:
=IF(A2>=50,"Pass","Fail")
“Why does Excel need both a true
and false result?”
Simple terms:
•Logical test → the question Excel asks
•Value if true → what happens if the answer is YES
•Value if false → what happens if the answer is NO
LO:- Identify and apply the IF function in Excel to make
We Do decisions based on conditions.

Marks are provided in column A.

Question: If marks are 60 or above → “Pass”, otherwise “Fail”

Build the formula step-by-step:


[Link] is the condition?
[Link] should Excel show if it’s true?
[Link] should Excel show if it’s false? Affirmative Checking

•What symbol do we use for “greater than or equal to”?

•What happens if we forget quotation marks around text?


LO:- Identify and apply the IF function in Excel to make
We Do decisions based on conditions.
Download group task Excel sheet from Padlet

[Link]/aaisha_s_tws/MyTask08
LO:- Identify and apply the IF function in Excel to make
You Do decisions based on conditions.
Group 1

How does formatting


help me read the data
more easily?

Group 3
Group 2
LO:- Identify and apply the IF function in Excel to make
Affirmative Checking decisions based on conditions.

Teacher circulates, address doubts and give feedback.


LO:- Identify and apply the IF function in Excel to make
Exit Ticket decisions based on conditions.

Answer before leaving:

1. Which part of the IF function tells Excel what to do when the condition is true?

Answer: Value_if_true
Thank you

You might also like