Monday, January 13th- 8th Grade- Finish Review

Bell Ringer:
1. Type lines 3 and 4.
2. Get ALL of your papers out of your folder.
3. If you have a flash drive you may save the study PowerPoints. 

What are we learning? 
5.01 Understand database tables used in business.
 
Guided Practice:
@ IMPORTANT ANNOUNCEMENT:
     You MUST close the database first before you close the access file.
     You must click on the inside "x" before you click on the outside "x"
     If you don't close like the above instructions, it will freeze the program.

@  Miss W will explain review process.
Monday - Review items you don't remember first!!!
Tuesday- 1st Period tests  during 1st and 2nd period
Wednesday- 2nd period tests during 1st and 2nd 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.

Independent Exercise:
You may do the review in any order.
Review as much as possible.

Typing Review:
____ Review keyboard and typing packet notes in your folder.

Database Review:
____Review notes in your folder in the crate
Review the following PowerPoints in the Database folder:
____ Database Fundamentals
____Data Types and Field Properties                             
____Field Property- Input Mask
____Database Test Review
____Worksheet steps to create a database
____Steps to Create a Database with lookup type and zip code
____Queries prework
____Guided Practice Filtering and Sorting a Database page 58
____Independent Practice Filtering and Sorting a Database
____Importing Text files
____parts of a database http://quizlet.com/920767/cai-501-database-fundamentals-flash-cards/ 
____math operators http://quizlet.com/920857/cai-502-database-objects-flash-cards/
____db basics http://quizlet.com/8214113/ca-i-obj-501-database-terms-part-1-flash-cards/
          scatter and/or space race                                               
____mix of database terms  http://quizlet.com/3976216/ms-wrights-bct-obj-6-flash-cards/
____ http://www.quia.com/rr/956502.html _____http://www.quia.com/mc/1412062.html
_____http://www.quia.com/mc/483616.html

Publisher Review:
____Review notes in your folder.

Review the following PowerPoints in the Publisher folder:
____Design Principles
____3.02 Publications
____Target Audience
____Publisher basics web site http://quizlet.com/10493861/cai-obj-302-business-publications-flash-cards/
___ http://quizlet.com/11124058/scatter
___ http://www.quia.com/hm/819282.html
___ http://www.quia.com/jg/2333348list.html
____ http://www.studystack.com/hangman-1140615
____ http://www.quia.com/jg/2301851.html  
____http://www.quia.com/rr/531753.html
____ Ribbon  http://www.quia.com/mc/320506.html

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

Friday, January 10th- Short Cut Links

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

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

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

Friday, January 10th- 8th Grade- Begin Review

Bell Ringer:
1. Type lines 1 and 2.

What are we learning? 
5.01 Understand database tables used in business.
 
Guided Practice:
@ IMPORTANT ANNOUNCEMENT:
     You MUST close the database first before you close the access file.
     You must click on the inside "x" before you click on the outside "x"
     If you don't close like the above instructions, it will freeze the program.

@  Miss W will explain review process.
Friday (Today)- Review
Monday - Review
Tuesday- 1st Period tests  during 1st and 2nd period
Wednesday- 2nd period tests during 1st and 2nd 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.

Independent Exercise:

You may do the review in any order.
You have today and Monday to review as much as possible.

Typing Review:
____ Review keyboard and typing packet notes in your folder.

Database Review:
____Review notes in your folder in the crate
Review the following PowerPoints in the Database folder:
____ Database Fundamentals
____Data Types and Field Properties                             
____Field Property- Input Mask
____Database Test Review
____Worksheet steps to create a database
____Steps to Create a Database with lookup type and zip code
____Queries prework
____Guided Practice Filtering and Sorting a Database page 58
____Independent Practice Filtering and Sorting a Database
____Importing Text files
____parts of a database http://quizlet.com/920767/cai-501-database-fundamentals-flash-cards/ 
____math operators http://quizlet.com/920857/cai-502-database-objects-flash-cards/
____db basics http://quizlet.com/8214113/ca-i-obj-501-database-terms-part-1-flash-cards/
          scatter and/or space race                                               
____mix of database terms  http://quizlet.com/3976216/ms-wrights-bct-obj-6-flash-cards/
____ http://www.quia.com/rr/956502.html
_____http://www.quia.com/mc/1412062.html
_____http://www.quia.com/mc/483616.html

Publisher Review:
____Review notes in your folder.

Review the following PowerPoints in the Publisher folder:
____Design Principles
____3.02 Publications
____Target Audience
____Publisher basics web site http://quizlet.com/10493861/cai-obj-302-business-publications-flash-cards/
___ http://quizlet.com/11124058/scatter
___ http://www.quia.com/hm/819282.html
___ http://www.quia.com/jg/2333348list.html
____ http://www.studystack.com/hangman-1140615
____ http://www.quia.com/jg/2301851.html  
____http://www.quia.com/rr/531753.html
____ Ribbon  http://www.quia.com/mc/320506.html

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

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

Thursday, January 9th- 8th Grade- Importing Data to a Database

Bell Ringer:
1. On page 432 type lines 3 and 42. Open up your Inns2 database.
3. Open up your Independent Practice Word Document (one with screen prints)
What are we learning? 
5.01 Understand database tables used in business.
 
Guided Practice:
@ Miss W will show you how to use the advance filter on questions 8 and 9.
@ IMPORTANT ANNOUNCEMENT:
     You MUST close the database first before you close the access file.
     You must click on the inside "x" before you click on the outside "x"
     If you don't close like the above instructions, it will freeze the program.
@ Open the Importing Text Files PowerPoint.
@ Student will import text data into a database using an existing file.
Independent Exercise:
@ Students will import text data into a database using their own data.
 
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

@ 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. 

Wednesday, January 8th Short Cut Links

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

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