Tuesday, September 22nd- 7th Grade- Formatting a Spreadsheet Chart

	Archdale-Trinity Middle School Lesson Plan
Date: 09-22-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Values versus Labels and Cell References
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can format a spreadsheet chart	Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)

Range, Cell Reference, Sorting, Ascending, Descending http://commons.wikimedia.org/wiki/File:Divers_ascending_at_shotline_labeled.png

Bell-Ringer/Connecting Strategy

Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder then go to the SS flashcards folder- then open 7 format table

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson: 1. Open the SS flashcard folder SS Flash cards file Open 7 Format Table    (format as table button) SS Flash cards file  (conditional formatting button) Open 13 Data Bars SS Flash cards file   (border button and percent button) Open 31 Formatting Cells @ Open 19 Hide Worksheet     - right click on tab and choose hide     - right click on tabs before and after the hidden tab and choose unhide. @ Open 16 Hide and Show Rows     -right click on row number and choose unhide. - highlight row before and row after the hidden row     and then right click and choose unhide. Go to Carmax.com and finish finding 15 cars. If time: Cell Reference and Range Activity Follow instructions to make a picture. Make cell C5 to C8 yellow Make D5 to D8 yellow Make cell F5 to F8 yellow Make cell G5 to G8 yellow Now click on C6 make it black Then F6 and make it black Cell E11 green Cell B12 B13 red Cell I11 I12 red Cell C14 red Cell D15 red Cell E16 red Cell F15 red Cell G14 red Cell H13 red SS Flash cards file Open 7 Format Table    (format as table button) SS Flash cards file  (conditional formatting button) Open 13 Data Bars SS Flash cards file   (border button and percent button) Open 31 Formatting Cells Homework: Students need to decide for which ACADEMIC topic (Typing Posture/Technique, Language Arts, Science, Social Studies, or Math) they will create a PowerPoint presentation soon. We will be using the PowerPoint you create to learn different old and new features of PowerPoint 2010.

Higher Order Thinking Questions

How do cell references help navigate a spreadsheet?

Student Technology/Differentiation

Students will Excel to understand cell references.

Closure Strategy

Exit Activity: Uses of Spreadsheets http://www.quia.com/mc/2494317.html

Lesson Reflections