 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-05-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- If statements
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can understand the parts of an IF statement.
|
Students understand the parts of an IF statement.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
The exclamation mark shows strong feelings.
 | |
Bell-Ringer/Connecting Strategy
| |
We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
Your index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Open a new Spreadsheet
@ In B2 type 3 and in C2 type 5. In E5 type the formula =B2+C2
What if in B2 we change 3 to 300?
@ What if we want the spreadsheet program to do some activity if it gets a certain answer?
Let’s conduct a test.
If you are a boy stand and clap.
 http://pixabay.com/id/anak-laki-laki-bahagia-pria-147797/
If you are a girl sit and clap.
 http://commons.wikimedia.org/wiki/File:Adolf_Pirsch_Portrait_of_a_young_girl_with_her_dog_by_the_sea.jpg
Now let’s say it a different way.
The test is IF you are a boy, if yes stand and clap, if not sit and clap.
Why learn IF statements?
Besides spreadsheets, if statements are used in video games.
#2.3 If Statements in Unity - Game Designer Code - [ Ultimate GameDev Tutorials ]
1:10 to 2:06
Open the PowerPoint called Excel IF statements explained
@ How would we write the above example as an if function?
Independent Exercise:
@ =IF(Logical test is true, then, else)
@ =IF(you are a boy, stand and clap, sit and clap)
@ LISTEN before you color!
@ Students will underline the logical test (what you are looking for) in red
will underline the if true statement in green and
will underline the if false statement in blue.
will highlight the =IF and () and , in yellow
If time:
@ Students will complete the Practice with IF statements on page 13.
Remember words need to have quotation marks around them AND
all formulas and functions start with an equal sign.
For example: =IF(A5="Carrot","Vegetable","Amphibian")
@ Miss W will review more advance Spreadsheet functions like:
@ Open the Bonus this month if statement file.
@ Students will answer questions about on the spreadsheet crossword puzzle.
| |
Higher Order Thinking Questions
| |
How does an IF statement work? Why?
| |
Student Technology/Differentiation
| |
Students will use Excel to create IF statements.
| |
Closure Strategy
| |
Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data
| |
