Friday, January 10th- 7th Grade- Count Functions and Validation of Data

Bell Ringer:
1. Type lines 1 and 2.  
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:
@  Miss W will explain review process.
Friday (Today)- Count functions
Monday - Review
Tuesday-  6th Period tests  during 6th and 7th period
Wednesday- 7th period tests during 6th and 7th period
Thursday- Show animations and/or play Microsoft game
Friday (1/17), Monday (1/20), and Tuesday (1/21) No school for students.
Wednesday 2nd semester begins.

@ Students will learn 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.
 
@ Microsoft Excel 2010 Data Validation
http://www.youtube.com/watch?v=qfLirkaWnCY

Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will finish 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