 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 11-19-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheet- Typing 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 create an IF function.
|
Students can create IF functions.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
Some emoticons use parentheses. :) :(
 :) | |
Bell-Ringer/Connecting Strategy
| |
On page 88, type lines 16 and 18.
We are using our RIGHT PINKY finger for the ) RIGHT PARENTHESIS key.
We are using our LEFT PINKY finger for the SHIFT key.
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Practice:
@ Miss W will explain how to enter IF functions in spreadsheets.
@ Miss W will explain how to test to see if the IF function is working properly.
Independent Exercise:
@ Students will enter their IF functions in their 8 Practice IF statements spreadsheets.
@ Students will TEST their IF functions to see if they are working properly.
@ Students will copy definition of IF function, the use and the example on their
Overview of Advanced Function worksheet.
If time:
@ Students will answer questions about on the spreadsheet crossword puzzle.
| |
Higher Order Thinking Questions
| |
Why do you need to TEST to see if your IF function is correct?
| |
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