Sunday, November 20, 2016

Monday, November 21- 7th Grade- Create and Change a Chart, start Spreadsheet Car Lot Project

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


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 create and change a chart.
Students use different features of Excel.


Literacy/Vocabulary Strategies (Word Wall)
Tab, Pie graph, Worksheets
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:

 Students will learn about bar, line and pie graphs (slides 13-17)
 Open the 1 Spreadsheet Vocabulary file
Go through Slide 20   Parts of a Spreadsheet  In the Witkowski folder then the Spreadsheet folder
@ Go to the SS flash card folder and open up 23 change color of tabs
This is an example of a workbook with 12 worksheets.
@  Open up 22 Pie Chart.
     This is an example of the Insert tab and then the Design tab (chart layouts)
@ 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:
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.
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

 
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
 Must complete in 45 seconds or less
 
Exit Activity #9:  Ribbon Vocabulary words
review words and definitions here http://quizlet.com/3089570/flashcards
then play activity here http://quizlet.com/3089570/scatter

No comments:

Post a Comment