Wednesday, December 13th- 7th Grade- Reviewing Charts, Formatting and Functions

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

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)
Exporting an item means to send it out of the country. http://en.wikipedia.org/wiki/Tobacco_in_the_American_Colonies
Bell-Ringer/Connecting Strategy
1. Go to wclassroom.blogspot.com 2. Go to Applications, Microsoft Folder and Spreadsheet folder      Open a New Spreadsheet
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 Tobacco Export exercise. Independent Exercise: @ Students will create a spreadsheet, format the data, create a chart and find the functions for the Colonial Tobacco Export exercise. http://en.wikipedia.org/wiki/Economy_of_Cuba
Higher Order Thinking Questions
How can a spreadsheet help you?
Student Technology/Differentiation
Students will use Excel to create and format spreadsheets and chart data.
Closure Strategy
Exit Activity 11:   https://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1 Hints: do NOT include these in your spreadsheet numbers--- commas and dollar signs copy formulas and automatically adjusts to correct cell range- relative cell referencing not Paul Bunyan, but a guide- legend * - / +  --- mathematical operators  selected group--- cell range another place that displays the active cell's info.--- entry bar active cell in a spreadsheet has this around it---border allows you to quickly fill in days of week---autofill  turn sideways!--- landscape