Sunday, October 5, 2014

Monday, Oct 6th- 7th Grade- Spreadsheets- Functions

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 10-06-2014



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.
I can bring back signed Interim Reports on Tuesday for a 95.
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.
number maximum of about 66
http://en.wikipedia.org/wiki/Solar_maximum
Bell-Ringer/Connecting Strategy
On page 32, type lines 13 and 14.
Remember to use your thumb for the space bar.
We are using our left PINKY finger for the LEFT SHIFT key.
Remember to capitalize the names and cities.
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
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 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

Independent Activity:
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.


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.  






No comments:

Post a Comment