Wednesday, May 6th- 7th Grade- Writing IF functions

	Archdale-Trinity Middle School Lesson Plan
Date: 05-06-2015

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. http://commons.wikimedia.org/wiki/File:IF-THEN-ELSE-END_flowchart.png
Bell-Ringer/Connecting Strategy
We are learning the numeric keypad. Your  index finger on the 1 Your middle finger on the 2 Your ring finger on the 3 Your ring finger on the . period key. The daily bellringers will now be practicing the number pad http://www.typeonline.co.uk/number_pad_lesson2.html Choose exercise 1 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: @ Miss W will review IF statements @ LISTEN before you color! @ Students will highlight the =IF and () and , in yellow                 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.                     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 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 http://www.quia.com/rr/85219.html 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