Friday, May 8th- 7th Grade- Spreadsheet If Functions and Animation

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

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- IF functions and Animation
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)
If functions help the computer to answer true and false questions. Video games use if functions to determine what action will happen. https://www.flickr.com/photos/bochalla/14012258829/
Bell-Ringer/Connecting Strategy
.We are learning the numeric keypad. Your  index finger on the 7 Your middle finger on the 8 Your ring finger on the 9 Your ring finger on the + plus key. The daily bellringers will now be practicing the number pad http://www.typeonline.co.uk/number_pad_big_plus_lesson3.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 Lesson: @ Show students 4 part animation samples @ Show If function sample @ Show animation instructions
@ Recommend storyboards for multi-part stories Independent Exercise: @ Students will practice function skills 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
How does an IF function work in a video game?
Student Technology/Differentiation
Students will use animation 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