Monday, April 25th- 7th Grade- Spreadsheets- creating a spreadsheet, using function, making a chart

Archdale-Trinity Middle School Lesson Plan
Date: 04-25-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 Applications then Microsoft Office then MS Excel
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. 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 #10: http://www.quia.com/rr/363962.html Work with partners. You may use the Spreadsheet Vocabulary PowerPoint. Play until you have won a million dollars Exit Activity#11: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1