Friday, May 1st- 7th Grade- Spreadsheets- Putting it all together- Colonial Population Exercise

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

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheet- Social Studies and Spreadsheets
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 a spreadsheet, use functions and format my data.	Students can create a spreadsheet, use functions and format their data.

Literacy/Vocabulary Strategies (Word Wall)
Space one time before the parenthesis, do not space after it. Example: "And remember that life's A Great Balancing Act. And will you succeed? Yes! You will, indeed! (98 and ¾ percent guaranteed) KID, YOU'LL MOVE MOUNTAINS!" (Dr. Seuss, Oh, The Places You'll Go! 1990) http://commons.wikimedia.org/wiki/File:Parenthesis1.jpg
Bell-Ringer/Connecting Strategy
On page 92, type lines 14 and 16. We are using our  RIGHT INDEX finger for the 6 key.
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: @ Students will follow instructions and complete the Colonial Population exercise. http://en.wikipedia.org/wiki/History_of_the_United_States_(1776%E2%80%9389) Independent Exercise: @ Students will create a spreadsheet, format the data, create a chart and find the functions for the Colonial Population exercise.
Higher Order Thinking Questions
How do you create a spreadsheet?
Student Technology/Differentiation
Students will use Excel to create spreadsheets.
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