Thursday, May 15th- 7th Grade- Spreadsheets- Advance Functions

Bellringer:
1. On page 3, type the bottom paragraph that begins
  "The A S D F J K L ; keys are called the home keys." 
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:
@ Signed interim reports due Today for a 85 on Friday it will be 80.
@ Open a new Spreadsheet
@ In B2 type 3 and in C2 type 5. In E5 type the formula =B2+C2
     What if in B2 we change 3 to 300?
@ Open the PowerPoint called Excel IF statements explained
@ Miss W will review more advance Spreadsheet functions like:
     the IF function    http://www.youtube.com/watch?v=bQJaWE7qsWw
@ Open the Bonus this month if statement file.

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")

Exit Activity 1. . http://www.quia.com/hm/466156.html?AP_rand=1338928476 
                            You need to get 11 out of 13 correct.