Friday, January 3rd- 7th Grade- Overview of Advanced Spreadsheet Functions

Bell Ringer:
1. On page 334, type lines 1 and 2.
2. You need a pencil or pen.3. Open up your Alice animation.

What are we learning? 
1.5 Digital Lifestyles- coding

4.3	Know spreadsheet operations

Guided Practice:
@ Miss W will review the spreadsheet functions (shortcuts) we already covered:
     Sum, Min, Max, Average, and Count
@ Miss W will start to explain more advance Spreadsheet functions like:
     Date, Now (Ctrl ;), Days360
@ Open a new Spreadsheet
@ In cell B7 insert the Now function
@ In cell B10 insert the Date function and enter 2014 for year, 1 for month and 17 for the day.
@ We are now going to see how many days until the next Student Day Off.
@ In cell D12 insert the Days360 function Start date is B7 and End Date is B10
@ This will give you how many days before your next Student Day Off.
@ Lets find how many days until your birthday. :)
@ Change the number in B10 to your birthday.
@ Change the number in B10 to 2014 for year, 6 for month and 6 for the day.
@ This number is how many days are left until summer vacation!!!
 
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
     completing the notes (copying the Function, Use and Example)    
     for Date, Now and Days360
@ 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