Wednesday, March 7, 2018

Thursday, March 8th- 7th Grade- Continue with Functions and Flashcards

Archdale-Trinity Middle School
Lesson Plan
 
Date: 03-08-2018


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.
number maximum of about 66
http://en.wikipedia.org/wiki/Solar_maximum
Bell-Ringer/Connecting Strategy


Go to wclassroom.blogspot.com

Open up 1Spreadsheet vocabulary
                     
      Complete Exit Activity# 10  in pairs


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

    We typed 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 (if needed)

    @ Spreadsheet flashcard 32 calculates averages

    Open the Spreadsheet Vocabulary file
    Slides 35 through 41 (functions)

    Open up the 3 Hurricanes file.
    Class practice using  functions
    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:

    @Open up the 4.0 Payroll file.


    Class practice using  functions

    @ Additional function practice as needed.
    @ Complete Car Lot Exercise (research and type)

    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:

    You may use the Spreadsheet Vocabulary PowerPoint.
    Play until you have won a million dollars

    No comments:

    Post a Comment