Monday, April 18th- 7th Grade- Review of Functions- Built in short cuts for calculations

Archdale-Trinity Middle School Lesson Plan
Date: 04-18-2016

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- Functions- built in calculation short cuts
Standards:	SSB-1 Know the components of spreadsheets SSB-3 Know spreadsheet operations

“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 had 30 years of data and we wanted to find the highest or MAXIMUM number in the data? We could look at thousands of numbers or we could use the MAX function. http://en.wikipedia.org/wiki/Solar_maximum

Bell-Ringer/Connecting Strategy

Go to wclassroom.blogspot.com Go to My computer- student docs- Witkowski folder- Spreadsheet folder- Open up 1 Spreadsheet vocabulary

Lesson-Instructional Strategies & Procedures for Teacher and Students (Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson: Open a new Excel spreadsheet We will type out a formula =F2+F3+F4+F5 and then we type out function to see how functions are shortcuts. =Sum(F2:F5) It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses). Open the Understanding Functions Word document Open up the "Functions goes with youtube" file. Excel 2010 Tutorial- Functions https://www.youtube.com/watch?v=b3q1ch-CGto 1 min to 3 min Functions 3 mins to 4:30 mins Range 4:30 mins to 8:30 mins Practice Stop at Count function at 8:30 mins Open the Spreadsheet Vocabulary file Slides 35 through 41 (functions) Open up the 4.0 Payroll file. Class practice 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 Independent Activity: @ Spreadsheet flashcard 32 calculates averages @ Additional function practice as needed.

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 #10: http://www.quia.com/rr/363962.html Work with partners. You may use the Spreadsheet Vocabulary PowerPoint. Play until you have won a million dollars Exit Activity#11: Working in pairs and using the PINK Study Guide answer the questions. These will be the next test questions.   http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1