Thursday, January 9th- 7th Grade- Students will use a IF function

Bell Ringer:
1. On page 432, type lines 3 and 4.  
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.

What are we learning? 

4.3	Know spreadsheet operations

Guided Practice:
@Open the PowerPoint called Excel IF statements explained
 
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.@ Students will complete the Practice with IF statements on page 13 and 14

@ If there is time: Students will start learning about the Count functions.
@ Count and Count A   video http://www.youtube.com/watch?v=4igXvy7JTcU
@ CountIF function       video http://www.youtube.com/watch?v=nF29V9Cd7tA
@ Open the Runners file to practice the Count functions.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
     completing the notes (copying the Function, Use and Example)    
     for Count, CountA, and CountIF functions
@Once you finish your animation, CHECK YOUR SPELLING THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.

Exit Activities
http://www.quia.com/rr/958087.html