Wednesday, October 4th- 7th Grade- Formatting Tables

Archdale-Trinity Middle School Lesson Plan
Date: 10-04-2017

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

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

Literacy/Vocabulary Strategies (Word Wall)

Tab, Pie graph, Worksheets http://commons.wikimedia.org/wiki/File:Population_of_Provinces_and_Territories_of_Canada_Pie_Chart.png

Bell-Ringer/Connecting Strategy

1. Go to wclassroom 2. Open your 1 Spreadsheet Vocabulary PowerPoint

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

Guided Lesson: @ What if you make a mistake choosing the chart? Open up 9 Chart Types and Styles     --click on the chart     --On the Design tab, click on the Change Chart button --Select a column chart    --On the Design tab, click on the Chart Styles arrow and find the orange/black choice. @Open the "car lot" file found in the Witkowski folder. Independent Activity: 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 Car lot exercise-   1*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder and save to your lunch number 2*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. 3*Students will go to http://www.carmax.com and find cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet. 4* Students will write information on their car lot worksheet.

Higher Order Thinking Questions

Which tab will be used for the different formatting activity and why?

Student Technology/Differentiation

Students will use http://www.carmax.com to research different car statistics.

Closure Strategy

Exit Activity 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html Exit Activity #2: http://www.quia.com/rr/363962.html We have not covered some questions 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