Friday, September 18th- 7th Grade- Gathering Data for Spreadsheet

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

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 find and use different features of Excel.	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 Computer- Student Docs- Witkowski folder- Spreadsheet folder- open 1 Spreadsheet Vocabulary file. 2. Go to wclassroom.blogspot.com 3. Finish your quizlet.com test correction sentences and answers.    Sign in, then click on your Test 1 Study Set then click on EDIT

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

Guided Lesson: 1. Open the Spreadsheet Vocabulary file @ 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 1xCar lot file and save to your lunch number Independent Activity: Car lot exercise-   1*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business. 2*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. 3* Students will enter information into their car lot file. If time: 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 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

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

Student Technology/Differentiation

Students continue to create a car lot spreadsheet.

Closure Strategy

Exit Activity #1:  Ribbon Vocabulary words review words and definitions here http://quizlet.com/3089570/flashcards then play activity here http://quizlet.com/3089570/scatter Exit Activity #2: Uses of Spreadsheets http://www.quia.com/mc/2494317.html

Lesson Reflections