Sunday, November 27, 2016

Monday, November 28th- 7th Grade- Formatting a Chart

Archdale-Trinity Middle School
Lesson Plan
 
Date: 11-28-2016


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
File:Divers ascending at
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:
 
Miss W will review slides 1 - 17 and explain the new slides.
 
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.

If absent on Friday: Go to Carmax.com and finish finding 15 cars.
Open your Car Lot file and key in the first 7 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
 
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

No comments:

Post a Comment