 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-17-2014
|
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
| |
On page 88, type lines 11 and 12.
We are using our LEFT PINKY finger for the ! EXCLAMATION MARK key.
We are using our RIGHT PINKY finger for the SHIFT key
| |
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
Let’s see a simple example of an IF function- show penguin example
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
| |
No comments:
Post a Comment