Friday, May 16th- 7th Grade- Spreadsheets- IF Function

Bellringer:
1. On page 4, type the middle paragraph that begins
  "An anchor is a home key that helps you..."
2. Get out of the crate your Advance Functions Notes papers.
3. You need a pencil or pen. 
TEST next Tuesday: 20 test questions from previous tests
                                    and 5 new questions. 

What are we learning? 
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations

Guided Lesson:
@ Open the PowerPoint called Excel IF statements explained

Independent Exercise
:@ Students will start the Overview of Advanced Functions Notes Worksheet by
     completing the notes (copying the information in Function, Use and Example)    
     for IF
@ Students will underline the logical test (what you are looking for) in red
                    will underline the if true statement in green and
                    will underline the if false statement in blue.
                    will highlight the =IF and () and , in yellow
@ Students will complete the Practice with IF statements on page 13.
     Remember words need to have quotation marks around them AND     
     all formulas and functions start with an equal sign.
     For example: =IF(A5="Carrot","Vegetable","Amphibian")

If Time: Open the Practice With If Functions spreadsheet.

Exit Activity 1. http://www.quia.com/rr/402638.html?AP_rand=21103945
                          You need to win a million dollars.