Wednesday, May 3rd- 7th Grade- Sorting and Ranges

Archdale-Trinity Middle School Lesson Plan
Date: 05-03-2017

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

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can find and use different features of Excel. TEST NEXT Week	Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)

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

Bell-Ringer/Connecting Strategy

1. Go to Computer- then your LUNCH number- then open Copy of Car Lot 2. Go to Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 1 Spreadsheet Vocabulary file.

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

Guided Lesson: Open the Spreadsheet Vocabulary file Slides 19 through 24   (Range, Cell Reference, Sorting)   @Practice ascending and descending order Independent Exercise: Open your "car lot" file and type in cars 02 through 10 Open the Spreadsheet Vocabulary file Slides 25 through 30   (PEMDAS)   Do the PEMDAS activity- Slide 26 (order of operations in a spreadsheet formula) Skill 1 ascending order (Home tab) Skill 16- Hide and Show Columns (Right click) Skill 21- hide gridlines (Page layout tab) Skill 4- sparklines(insert),  Skill 20- icon sets (under conditional formatting) Skill 2- color scales (under conditional formatting) 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 click on F6 and make it black Cell E11 green Cell B12 to B13 red Cell I11 to  I12 red Cell C14 red Cell D15 red Cell E16 red Cell F15 red Cell G14 red Cell H13 red

Higher Order Thinking Questions

How do cell references help navigate a spreadsheet?

Student Technology/Differentiation

Students will use Excel to understand cell references.

Closure Strategy

Exit Activity: Uses of Spreadsheets http://www.quia.com/mc/2494317.html Exit Activity #10: http://www.quia.com/rr/363962.html We have not covered one question yet. Built in calculations are called functions. Horizontal is like laying down flat on the ground. Vertical is up and down You may use the Spreadsheet Vocabulary PowerPoint. Play until you have won a million dollars