Tuesday, October 27th- 7th Grade- Spreadsheets- freeze panes and review

	Archdale-Trinity Middle School Lesson Plan
Date: 10-26-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Formatting Spreadsheets
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can format spreadsheets.

Literacy/Vocabulary Strategies (Word Wall)
The Entry bar or formula bar shows the active cell’s information. It is sometimes called the formula bar because you can see the formula when you click on the active cell Look at the black border around the active cell D8. The #####  in cell reference C3 means the cell is too small to show the number, widen the cell. Look at how the values (numbers) are aligned to the right margin. Look at how the labels (words) are aligned to the left margin. http://spreadsheets.about.com/od/excelformulas/ss/2011-01-16-excel-formulas-overview.htm
Bell-Ringer/Connecting Strategy
Go to wclassroom.blogspot.com Get out a pen or pencil
Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice: To freeze rows: Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3. ... Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. ... The rows will be frozen in place, as indicated by the gray line.   @ Miss W will redemonstrate how to create an accounting border.      An accounting border has a single line on top and a double line on bottom Independent Exercise:
@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.   An example of a bad review:  I liked it.   An example of a good review:  The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created. @ Students will work in pairs to complete the Spreadsheet Review Worksheet. @ Students will complete a 2nd PowerPoint Critique.
Closure Strategy
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
Lesson Reflections