 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 12-05-2016
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- What is a function
| |
Standards:
|
SSB-1 Know the components of Spreadsheets
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can use a function.
Test on Tuesday |
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
|
Go to wclassroom.blogspot.com
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Independent Exercise:
@ Jeopardy Game if time
@ Open up your car lot file.
Look at the board and add the words (labels) sum, max, min and average.
Insert the functions sum, max, min and average.
Remember you will need to use the correct range.
|
Higher Order Thinking Questions
|
When and how should you use a function?
|
Student Technology/Differentiation
|
Students will use Excel to understand functions.
|
Closure Strategy
|
Remember:
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars
|
No comments:
Post a Comment