 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-18-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Writing IF functions
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can write an IF function.
|
Students can write IF functions.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
The IF function helps the computer answer true or false questions.
 | |
Bell-Ringer/Connecting Strategy
| |
On page 88, type lines 14 and 15.
We are using our RIGHT PINKY finger for the 0 key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Miss W will review IF statements
@ Miss W will review more advance Spreadsheet functions like:
@ Open the Bonus this month if statement file.
Independent Exercise:
@ 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")
@ Students are WRITING the if statements on their paper.
If we have time-
@ Students will enter the if statements in our spreadsheet.
@ Students will answer questions about on the spreadsheet crossword puzzle.
| |
Higher Order Thinking Questions
| |
How does an IF function work? Why?
| |
Student Technology/Differentiation
| |
Students will use Excel to create IF functions.
| |
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