 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 03-04-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets
| |
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)
|
Spreadsheet, Budget, Grades, Loans, Inventory, Ribbon, Tab, Group, Worksheet, What If Analysis
 |
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 Practice:
Who uses spreadsheets? Uses of spreadsheets http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg9.htm
Charades- each group of three will have 3 minutes to come up with a
way to act out one of the people below using spreadsheets.
They can say anything but the name of the person.
For example: They can not say "Look at me, I'm an accountant."
Accountants, Teachers,
Engineers, Sales people,
Scientists, Supermarkets,
Market Researchers.
@ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010
“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of worksheets and tabs (slide 10)
What if Analysis:
* Open Spreadsheet Vocabulary PowerPoint and go to slide 11 to 12.
* Students will open an new Excel file and type the 4 formulas on the green paper.
* Students will practice What if Analysis by changing the values in B7 and C7.
Independent Exercise:
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*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder
and save to your lunch number
.
Homework:
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
|
What is What If analysis?
|
Student Technology/Differentiation
|
Students will use an Excel file to understand what is What if analysis
|
Closure Strategy
|
Exit Activity #6:
Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp
Exit Activity #7:
Choose home row and easy. Turn off sound.
|
.PNG){kind=link}