 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-22-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Functions and Vocabulary
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can explain the difference between a relative cell reference and an absolute cell reference.
|
Students use functions to get answers.
|
Literacy/Vocabulary Strategies (Word Wall)
|
What if we wanted to find the AVERAGE of a group of numbers?
What would the function look like?
https://www.flickr.com/photos/schoschie/2959139599/
|
Bell-Ringer/Connecting Strategy
|
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
All Students will go online and review their progress
by checking their grades for at least this class
@ Miss W will explain the critique or review process for the Educational PowerPoint candy challenge. Each day, students will vote on which PowerPoint they think has the best design. For you to win candy, you MUST BE SPECIFIC AND GIVE DETAILS.
An example of a bad review: I liked it.
An example of a good review: The contrasting colors made it stand out, I liked the fade out animations. I really learned about weather when they explained how snow is created.
@ Miss W will review the difference between relative cell references and absolute cell references.
A Cell reference- indicates a cell’s location and provides instructions for how cell data is copied and used in calculations. B4 is a cell reference.
A Relative cell reference- CHANGES as the formula is copied.
An Absolute cell reference- REMAINS THE SAME or static when copied to other locations.
Independent Exercise:
Introduction to Relative References Video https://www.youtube.com/watch?v=Wli4L_tECPg
@ Go to the Spreadsheet folder, then the Relative Cell Reference folder, then
Open choco nutties file
@ Create the formula making B2 an absolute cell reference, $B$2.
@@@ Students work in pairs on Exit Activity #11
|
Higher Order Thinking Questions
|
When and how should you use a function?
|
Student Technology/Differentiation
|
Students will use Excel to understand functions.
|
Closure Strategy
|
Exit Activity #10:
Work with partners.
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
Exit Activity#11:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
|
Lesson Reflections
|
No comments:
Post a Comment