Archdale-Trinity Middle School
Lesson Plan
| |
Date: 05-01-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 create and change a chart.
|
Students use different features of Excel.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Tab, Pie graph, Worksheets
 |
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:
@ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010
“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of worksheets and tabs (slide 10)
Students will complete WHAT IF activity (slides 11-12)
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
|
No comments:
Post a Comment