Monday, October 19th- 7th Grade- Review Spreadsheet Vocabulary and Functions

	Archdale-Trinity Middle School Lesson Plan
Date: 10-19-2015

Teacher:	Witkowski
Lesson/Unit Topic:	Spreadsheets- What are functions?
Standards:	SSB-1 Know the components of Spreadsheets

“I Can…” Statement	Criteria for Success-Formative/Summative Assessments
I can explain why a function is a shortcut.	Students understand concept of functions.

Literacy/Vocabulary Strategies (Word Wall)

Intersection- where an horizontal and vertical line meet. In a spreadsheet when a horizontal row and vertical column meet. The rectangle that they meet in is called a cell. A cell is the smallest part of a spreadsheet. http://commons.wikimedia.org/wiki/File:TAR-intersection-icon.png

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: All Students will go online and review their progress by checking their grades for at least this class. Miss W will quickly review spreadsheet vocabulary. Miss W will explain why functions are called shortcuts. Independent Exercise: Open the Spreadsheet Vocabulary file Slides 31 through 34 (formatting and formulas) @ Open up the Spreadsheet Vocabulary PowerPoint file     slides 37 and 38 Understanding Functions (Shortcuts) @ Function as a shortcut example =F2+F3+F4+F5 and then we type out a function to see how functions are shortcuts. =Sum(F2:F5) @ What are functions? http://www.gcflearnfree.org/excel2010/10.2 @ Miss W will review the Function handout @ Autosum button http://www.gcflearnfree.org/excel2010/10.4 @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 @ Spreadsheet flashcard 32 calculates averages @ Additional function practice as needed.

Higher Order Thinking Questions

What are the different function definitions involved with spreadsheets?

Student Technology/Differentiation

Students will use Excel to understand cell references.

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

Lesson Reflections