Thursday, May 7th- 7th Grade- Typing IF Statements

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

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.  :) :(  :) https://openclipart.org/detail/200138/primary_kopete_emoticons-by-dannya
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 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: @ 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.
ACHIEVE @ Click on https://portal.achieve3000.com/ Your user name is your lunch number. Your password is your birthday. Go to the email section and click on article titled "Using Workplace Technology" The article is about how you will always be learning new technology as you get older. If you miss a question, hit the retry button On the first attempt: 100 to 75 is an “A”  100 74 to 65 is a “B”      88                     64 to 55 is a “C”       78                     54 to 45 is a “D”       70
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 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