Wednesday, November 30, 2016

Thursday, December 1st- 7th Grade- What is a function?

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-01-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.
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?
GUIMark: 4.45 fps average
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:

@ Function as a shortcut example
@ What are functions? http://www.gcflearnfree.org/excel2010/10.2  until 2:54
@ Autosum button http://www.gcflearnfree.org/excel2010/10.4 examples of functions
@ 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.



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 1: Uses of Spreadsheets http://www.quia.com/mc/2494317.html


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