 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-25-2014
|
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
 |
Bell-Ringer/Connecting Strategy
|
On page 21, type lines 9 and 10.
Remember to use your thumb for the space bar.
We are using our RIGHT PINKY finger for the RIGHT SHIFT key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
1. Open the Spreadsheet Vocabulary file
Slides 18 through 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 your lunch number file.
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 #6:
Exit Activity #7:
Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html
Exit Activity #8:
October Game- Choose home row and easy. Turn off sound.
Exit Activity #9: Ribbon Vocabulary words
|
No comments:
Post a Comment