Thursday, March 6th- 8th Grade- Databases- Gathering Data

Bellringer:
1. Open your Typing file and on page 32 type lines 8, 9, and 10.            
    Use your right INDEX finger for the U  key exercise.

What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
Bring back signed Interim Reports by Friday for 100. 

Guided Practice:

@ Students will open in the DATABASE folder
     the 1 Database Fundamentals PowerPoint
@ Class will practice identifying tables and records, fields, and entries.
@ Class will discuss the difference between text and number data field types.
@ Finish the Review of Database Tables worksheet.

 Independent Lesson:
@ Students will start on airline database worksheet.
@ Miss W will walk through how to gather data for the first example.
@  Expedia TV ad http://www.youtube.com/watch?v=-B5hcH8Kr4U

@ Go to http://www.expedia.com/ 
     GSO- Greensboro
     RDU- Raleigh
     CLT- Charlotte      

Flight #			Airline
Departure City			Arrival City
Departure Time			Arrival Time
Length of Flight			Date Leaving
# of Stopovers			Cost of Trip

 Independent Activity:
Students will complete 4 vacation spots on the airline database worksheet.



Homework- Extra Credit for 3rd test:
Ask your parents if they have a business card or 
have one in their wallets from a business or 
have a friend with a business card or the next
time you go into a business or they go into a 
business see if they have a business card or
at home go to Google and then images and type
"business card" then print a business card.
If you give Miss W a business card sometime
this week you will get 5 points extra credit on 
the second test. MUST be appropriate for school- 
no alcohol, guns or bad words on cards.
 
Exit Activity #10: Database terms
http://quizlet.com/18461807/database-terms-flash-cards/

Wednesday, March 5th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/03/tuesday-march-4th-8th-grade-databases.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/03/tuesday-march-4th-7th-grade-literacy.html

Wednesday, March 5th- 7th Grade- Literacy Review

Bellringer:
1. 1. Open your Typing file and on page 25 type lines 8, 9, and 10.            
    Use your right MIDDLE finger for the , comma key exercise.
2. If you didn't finish brochure,
    get out your Pink Worksheet and your GREEN rubric.

What are we learning?
Literacy Techniques
Tornado Drill Safety
Review of  Assignment for Substitute Teacher
Wednesday take Interim Reports home to be signed. 
 
Guided Practice:.
@ Tornado drill this week
     - Tornado Watch- it could happen
     - Tornado Warning- funnel has been sighted-
         -go to hall and kneel with head down and hands over face.
        - keep quiet and calm.

@ Review of Tuesday's lesson for substitute teacher
    -  Need 2 helpers.
    -  Complete daily typing assignment and save. Miss will check on Wednesday.
    -  Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
    -  Choose 6 careers from the Science, Technology, Engineering and Math page.
    -  Fill in your worksheet for the following categories:

Occupation

Minimum Education

Growth Outlook

Current Workers

Salary Entry

Job Description

    - You only need to write the first sentence in the job description blank.
   -  Choose one of the 6 careers and create a PowerPoint.
      # The first slide should have your name and occupation and a picture with a citation.
      #  Look at the ENTIRE job description. Have one or more slide for each sentence.
          You may copy and paste job description sentences.
      #  You need at least 5 slides not counting the title page.
      #  Find interesting pictures about that occupation and have one picture per slide with
          the proper citations.
      #  Save to your lunch number.



Guided Practice: 
@Miss W will review the PowerPoint rubric and project requirements.
@Miss W will review the "The New Power of PowerPoint" Achieve 3000 article
    and model techniques on how to find the information. 
@ Use the crayons to highlight different items in the text.  

Independent Exercises:
@ Students need to complete PowerPoint project if name is on the board.
@ Students will complete exit activity.

Friday's Lesson:
@ Complete PowerPoint Project and then
Step 10- Revise (check spelling) Switch with another student and watch their PowerPoint
Write down items you see wrong or that could be improved.

Exit Activity:  Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html

Wednesday, March 5h- 8th Grade- Databases- Which field type should you use?

Bellringer:
1. Open your Typing file and on page 31 type lines 4, 5, and 6.            
    Use your left INDEX finger for the B  key exercise.
2. If your name is on the board, finish your first name database.

What are we learning?Understand the basics of databases.
How is database information used, organized, and managed in business?
Wednesday take Interim Reports Home to be signed. 



Guided Practice:

@ Students will open in the DATABASE folder
     the 1 Database Fundamentals PowerPoint


@ What is your favorite movie?
     We are going to look at the Internet Movie Database http://www.imdb.com/title/tt0240772/
     as we watch the following video.
@ What is a database? http://www.youtube.com/watch?v=Y-bvjtYgRVU
start at 1:10 explains relationships to 5:30
@ Class will practice identifying tables and records, fields, and entries.
@ Class will discuss the difference between text and number data field types.

 Independent Lesson:
@ Complete the IMDB worksheet
@ Continue the Review of Database Tables worksheet.
Use slide 18 to help with the field type definitions.
Please remember you only use the Numbers field if you want to calculate something.
 
@ Complete the "What is a database?" question by copying the
     ENTIRE definition from slide 1 at the beginning of the PowerPoint. 

 If time, Go to http://www.expedia.com/
Students will start on airline database worksheet.
Miss W will walk through how to gather data for the first example.
Homework- Extra Credit for 3rd test:
Ask your parents if they have a business card or 
have one in their wallets from a business or 
have a friend with a business card or the next
time you go into a business or they go into a 
business see if they have a business card or
at home go to Google and then images and type
"business card" then print a business card.
If you give Miss W a business card sometime
this week you will get 5 points extra credit on 
the second test. MUST be appropriate for school- 
no alcohol, guns or bad words on cards.
 
Exit Activity #9: Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html  

Monday, March 3rd- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/03/monday-march-3rd-8th-grade-databases.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/03/monday-march-3rd-7th-grade-literacy.html

Monday, March 3rd- 7th Grade- Literacy Review

Bellringer:
1. Open your Typing file and on page 24 type lines 4, 5, and 6.            
    Use your left RING finger for the W key exercise.

2. If you didn't finish brochure,
    get out your Pink Worksheet and your GREEN rubric.

What are we learning?
Literacy Techniques
Tornado Drill Safety
Review of  Assignment for Substitute Teacher
Wednesday from 4:00 to 6:00 is Interim Report Pick Up
 
Guided Practice:.
@ Tornado drill this week
     - Tornado Watch- it could happen
     - Tornado Warning- funnel has been sighted-
         -go to hall and kneel with head down and hands over face.
        - keep quiet and calm.

@ Review of Tuesday's lesson for substitute teacher
    -  Need 2 helpers.
    -  Complete daily typing assignment and save. Miss will check on Wednesday.
    -  Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
    -  Choose 6 careers from the Science, Technology, Engineering and Math page.
    -  Fill in your worksheet for the following categories:

Occupation

Minimum Education

Growth Outlook

Current Workers

Salary Entry

Job Description

    - You only need to write the first sentence in the job description blank.
   -  Choose one of the 6 careers and create a PowerPoint.
      # The first slide should have your name and occupation and a picture with a citation.
      #  Look at the ENTIRE job description. Have one or more slide for each sentence.
          You may copy and paste job description sentences.
      #  You need at least 5 slides not counting the title page.
      #  Find interesting pictures about that occupation and have one picture per slide with
          the proper citations.
      #  Save to your lunch number.



Guided Practice: 
@Miss W will review the PowerPoint rubric and project requirements.
@Miss W will review the "The New Power of PowerPoint" Achieve 3000 article
    and model techniques on how to find the information. 
@ Use the crayons to highlight different items in the text.  

Independent Exercises:
@ Students need to complete PowerPoint project if name is on the board.
@ Students will complete exit activity.

Friday's Lesson:
@ Complete PowerPoint Project and then
Step 10- Revise (check spelling) Switch with another student and watch their PowerPoint
Write down items you see wrong or that could be improved.

Exit Activity:  Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html

Monday, March 3rd- 8th Grade- Databases- Data Field Types

Bellringer:
1. Open your Typing file and on page 25 type lines 12, 13, and 14.            
    Use your left INDEX finger for the G  key exercise.
2. If your name is on the board, finish your first name database.

What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
Tornado Drill Safety
Review of Tuesday's Assignment for Substitute Teacher
Wednesday from 4:00 to 6:00 is Interim Report Pick Up
 
Guided Practice:.
@ Tornado drill this week
     - Tornado Watch- it could happen
     - Tornado Warning- funnel has been sighted-
         -go to hall and kneel with head down and hands over face.
        - keep quiet and calm.

@ Review of Tuesday's lesson for substitute teacher
    -  Need 2 helpers.
    -  Complete daily typing assignment and save. Miss will check on Wednesday.
    -  Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
    -  Choose 6 careers from the Science, Technology, Engineering and Math page.
    -  Fill in your worksheet for the following categories:

Occupation

Minimum Education

Growth Outlook

Current Workers

Salary Entry

Job Description

    - You only need to write the first sentence in the job description blank.
   -  Choose one of the 6 careers and create a PowerPoint.
      # The first slide should have your name and occupation and a picture with a citation.
      #  Look at the ENTIRE job description. Have one or more slide for each sentence.
          You may copy and paste job description sentences.
      #  You need at least 5 slides not counting the title page.
      #  Find interesting pictures about that occupation and have one picture per slide with
          the proper citations.
      #  Save to your lunch number.


@ Students will open in the DATABASE folder
     the 1 Database Fundamentals PowerPoint
 @ Access 2010: Table Basics http://www.youtube.com/watch?v=aURLrWusnwo   
    to minute 2:40
@Open your "First Names" database

@Class will practice deleting a record and deleting a field
@ Ask the students on your database table if they have a pet
    AND their birthday (month, day, year)
@Class will use the "new (blank) record" arrow to add a new name  
@Class will practice identifying records, fields, and entries.

 Independent Lesson:
@ Use slide 18 to help with the field type definitions:
     Date/Time, Currency, and Yes/No
@ Follow as Miss W adds Date/Time, Currency and Yes/No fields
     and add those fields to your database.
@ Complete the "What is a database?" question by copying the
     ENTIRE definition from the beginning of the PowerPoint.

Homework- Extra Credit for 2nd test:
Ask your parents if they have a business card or 
have one in their wallets from a business or 
have a friend with a business card or the next
time you go into a business or they go into a 
business see if they have a business card or
at home go to Google and then images and type
"business card" then print a business card.
If you give Miss W a business card sometime
this week you will get 5 points extra credit on 
the second test. MUST be appropriate for school- 
no alcohol, guns or bad words on cards.
 
Exit Activity #9: Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html