Friday, December 2nd- 7th Grade- Using Functions

	Archdale-Trinity Middle School Lesson Plan
Date: 12-02-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: @ 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. We are finishing it today. 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 @Finish payroll functions.  ***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 Exit Activity #2: http://www.quia.com/rr/363962.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