Tuesday, December 13th- 7th Grade- Spreadsheet formatting

Archdale-Trinity Middle School Lesson Plan
Date: 12-13-2016

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)
Spreadsheets can take numerical data and turn it into picture data like graphs/charts.  http://en.wikipedia.org/wiki/History_of_the_United_States_(1776%E2%80%9389)
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com Go to My computer- student docs- Witkowski folder Spreadsheet folder- Open up  4.02 Chart Components
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: Miss W will review embedding versus linking Copy paste Excel chart into PowerPoint: Embedding vs Linking Chart https://www.youtube.com/watch?v=lRS05dW7I-g @ Students will follow instructions and complete the Colonial Population exercise. 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: Working in pairs and using the PINK Study Guide answer the questions. http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1