Monday, May 11th- 7th Grade- Spreadsheets- Merging Cells and Formatting

	Archdale-Trinity Middle School Lesson Plan
Date: 05-11-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 format spreadsheets	Students can format spreadsheets

Literacy/Vocabulary Strategies (Word Wall)
You can merge and center titles in Excel. When you merge cells you take several small cells and make one large cell. http://geekdrop.com/content/center-text-across-selected-cells-without-merging-cells-in-ms-excel
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 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 Lesson: @ Signed interim reports due @ Miss W will show students how to format a spreadsheet
Independent Exercise: @ Students will practice formatting skills If time: 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