 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 10-07-2014
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets- Test, Finish Project, Typing contest
| |
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 34, type lines 05 and 6.
Remember to use your thumb for the space bar.
We are using our left PINKY finger for the Q key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
Period 2 only: Open the Spreadsheet Vocabulary file
Slides 35 through 41 (functions)
@ 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
@Depending on time 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 work in pairs to complete exit activity
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
|
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.
|
