 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-15-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
|
1. Go to Computer then Student Docs then Witkowski folder then Spreadsheet folder then 1 Spreadsheet Vocabulary.
2. Go to wclassroom.blogspot.com
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Practice:
@ Navigating Excel 2010 http://www.gcflearnfree.org/excel2010
“Spreadsheet Vocabulary PowerPoint Presentation”
describing uses of worksheets and tabs (slides 10 - 12 )
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:
@ Complete the Excel Ribbon and Tab worksheet
If time: 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 Uses of Spreadsheets http://www.quia.com/mc/2494317.html
|
Lesson Reflections
|
No comments:
Post a Comment