Thursday, February 18, 2016

Friday, February 19th- 7th Grade- Spreadsheet What if Statements

Archdale-Trinity Middle School
Lesson Plan
 
Date: 02-19-2016



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 give an example of a "What If?" statement
Students use different features of Excel.

Literacy/Vocabulary Strategies (Word Wall)
Spreadsheet, Budget, Grades, Loans, Inventory, Ribbon, Tab, Group, Worksheet, What If Analysis
Aoo calc 3.4.1.png
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:

“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:
Start 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