Wednesday, January 8th- 7th Grade- Finishing IF function and Starting Count functions

Bell Ringer:
1. On page 432, 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:
@Open the PowerPoint called Excel IF statements explained
 
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 IF statement
@ 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.

@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

Wednesday, January 8th -8th Grade- Finishing Filter Exercises

Bell Ringer:
1. On page 432 type lines 1 and 2
2. If your name is on the board, finish typing the records into the Inns2 database.

What are we learning? 
5.01 Understand database tables used in business.
 
Guided Practice:
@  Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint
@ Open the Independent Practice: Filtering and Sorting a Database Word document that  you saved to your lunch number.

Independent Exercise:
@ Look at you Inns2 database. Check to make sure the records are correct.
@ Complete the inns worksheet, you must screen print your answers.
@If there is time students will import text data into a database.
@ Open the Importing Text Files PowerPoint.

@ 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/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name

Tuesday, January 7th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/tuesday-january-7th-8th-grade.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/tuesday-january-7th-7th-grade.html

Tuesday, January 7th- 7th Grade- Understanding the IF function

Bell Ringer:
1. On page 306, type the paragraph that begins "You can position a table..." 
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 review more advance Spreadsheet functions like:
     the IF function    http://www.youtube.com/watch?v=bQJaWE7qsWw
@ Open a new Spreadsheet
@ Open the PowerPoint called Excel IF statements explained
 
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 IF statement
@ Students will complete the Practice with IF statements on page 13 
@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

Tuesday, January 7th- 8th Grade- Independent Filter Practice

Bell Ringer:
1. Open your Inns2 Database and finish typing the records.

What are we learning? 
5.01 Understand database tables used in business.
 
Guided Practice:
@  Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint@ Open the Independent Practice: Filtering and Sorting a Database Word document that  you saved to your lunch number.

Independent Exercise:
@ Look at you Inns2 database. Check to make sure the records are correct.
@ Complete the B&B worksheet, you must screen print your answers.
@ 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/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name

Monday, January 6th Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/monday-january-6-8th-grade-database.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/monday-january-6th-7th-grade.html

Monday, January 6th- 7th Grade- Spreadsheets Advanced Functions

Bell Ringer:
1. On page 334, type lines 3 and 4.
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
4. 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 more advance Spreadsheet functions like:
     the IF function    http://www.youtube.com/watch?v=bQJaWE7qsWw
@ Open a new Spreadsheet
@ Open the PowerPoint called Excel IF statements explained
 
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 IF
@ Students will complete the Practice with IF statements on page 13 
@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