 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 09-23-2014
|
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 18, type lines 13 and 4.
Remember to use your thumb for the space bar.
We are using our left MIDDLE finger for the C key.
|
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 (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:
@ Complete the Home Tab Ribbon Worksheet by using your mouse.
@ You may work in pairs.
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.
|
No comments:
Post a Comment