Wednesday, May 13th- 7th Grade- Spreadsheet Review

	Archdale-Trinity Middle School Lesson Plan
Date: 5-13-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- Review
Standards:	SSB-1 Know the components of Spreadsheets SSB-2 Creation and Formatting of Spreadsheets SSB-3 Know spreadsheet operations

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can do well on the spreadsheet review. Review Test on Tuesday.	Students do well on the spreadsheet review.

Literacy/Vocabulary Strategies (Word Wall)
What if the tax rate was .08, would you need to type the formula again? What do all formulas begin with?  What does the * do? Is “cost of car” a label or a value?  Name a value? B6 has a dark border around the cell. What is B6 called?   What do rows have in front of them? Are columns vertical or horizontal? What is B4 called?  Begins with a “c” http://spreadsheets.about.com/od/exceltips/qt/what_if_tip.htm
Bell-Ringer/Connecting Strategy
We are learning the numeric keypad. In our fourth lesson we will cover the operator keys of the /-*-- row . The right middle finger will control the / key. The right ring finger will control the * key. The right little finger will control the - key. The daily bellringers will now be practicing the number pad http://www.typeonline.co.uk/number_pad_big_plus_lesson4.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: In the 7th Grade Review folder- Open the 1 Spreadsheet Review for the end of the semester file. Fill in the blanks on your spreadsheet review worksheet. ___________________________________________________________________________ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Play the SCATTER GAMES on the quizlet sites ____SCATTER http://quizlet.com/4256873/spreadsheet-vocabulary-flash-cards/ ____SCATTER http://quizlet.com/5002039/spreadsheet-terms-flash-cards/ ____SCATTER http://quizlet.com/834955/cai-401-ss-components-flash-cards/ ____Get 100% _http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg3.htm ____SCATTER http://quizlet.com/3972846/ms-wrights-bct-obj-5-flash-cards/ _____ Hangman game get 22 out of 25 correct  http://www.quia.com/hm/174125.html   ____SCATTER http://quizlet.com/10716938/cai-obj-401-business-spreadsheets-flash-cards/ ___ match words to definitions http://www.quia.com/mc/1799176.html?AP_rand=23603320 ___ match words to definitions for the link below _http://www.quia.com/mc/2016566.html?AP_rand=1926551694 ___ You can use notes. You must get 100% for the link below. http://www.quia.com/quiz/2055803.html?AP_rand=1395669365 ___WIN a million dollars http://www.quia.com/rr/363962.html
Higher Order Thinking Questions
Explain why sometimes absolute cell referencing is needed.
Student Technology/Differentiation
Students will use online sites to review spreadsheet concepts.
Closure Strategy
Exit Activity 12: 10 Steps of a Presentation Do NOT look at the PowerPoint http://www.quia.com/pp/279397.html?AP_rand=520216192