 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 04-02-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 use a function.
|
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
|
On page 72, type lines 10 and 11.
We are using our left INDEX finger for the $ key. DOLLAR SIGN
We are using our right PINKY finger for the SHIFT key
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Function as a shortcut example
@ Spreadsheet flashcard 32 calculates averages
Independent Exercise:
Open up the Hurricane file.
Class practice of Hurricane sheet using functions
We are going to practice inserting the following FUNCTIONS or shortcuts:
Sum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range
@Several functions examples will be completed.
***Students will open the payroll file and by using functions
find the following information:
the maximum hourly rate
the minimum hourly rate
the sum of the hourly rates
the average of the hourly rates
@ 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.
@ Students will critique Educational PowerPoint presentations.
@ Students will work in pairs to complete exit activity
|
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 #8:
Exit Activity #9:
Choose home row and easy. Turn off sound.
Exit Activity#10:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
|
. |
No comments:
Post a Comment