Friday, March 14- 8th Grade- Database- Entering Data

Bellringer:
1. Open your Typing file and on page 43 type lines 4, 5 and 6.            
    Use your right LITTLE finger for the P  key 
2. If your expedia.com worksheet is not finished, finish it (see board)
3. Pull out your Career worksheet
    if you do not have the Career WORKSHEET finished
    Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
     and choose 6 careers from the Science, Technology, Engineering and Math page.

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

Guided Practice:
@ Miss W will walk through how to create a vacation database
     by right clicking on the database name to the left and using the Design view.
@ Students will sign into glogster to see if you remember your id.
 

7th grade log-ins:  students first initial and last name followed by atms13.  No spaces, dashes, etc.  passwords are student birthdays again with no slashes, spaces, or dashes in the mmddyyyy format.  EXAMPLE:  uid:  cmoseratms13    pw:  07132000

8th grade log-ins:  students first initial and last name followed by atms14.   No spaces, dashes, etc.  passwords are student birthdays again with no slashes, spaces, or dashes in the mmddyyyy format. EXAMPLE:  uid:  tmoseratms14  pw:  01011999

 http://edu.glogster.com/  Do NOT create a new id if you can not log in! We have a list with ids on it.

Independent Exercise:
@ Students will create and then enter their vacation information into a vacation database.
@ If it does not let type in the data, it means you have the field type wrong.

Exit Activity:
1. http://www.quia.com/mc/1412062.html
2. Pull up your Career PowerPoint, all 6 slides must be finished with animations and transitions.

Thursday, March 13- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/03/thursday-march-13th-8th-grade-creating.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/03/thursday-march-13-7th-grade-spreadsheets.html

Thursday, March 13- 7th Grade- Spreadsheets

Bellringer:
1. Open your Typing file and on page 37 type lines 5 and 6.            
    Use your right  LITTLE finger for the apostrophe '   key exercise.
2. If you do not have the Career WORKSHEET finished
    Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
     and choose 6 careers from the Science, Technology, Engineering and Math page.

What are we learning?
4.1 Know the components of Spreadsheets
Bring back signed Interim Reports today for 95 and by Friday for 90. 
Guided Lesson- What if Analysis:
* Open Spreadsheet Vocabulary PowerPoint and go to slide
* 
 
Independent Activity: If time: Car lot exercise-  
1*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business.
2*Students will go to http://www.carmax.com and find 3 cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet.
3*Open the "car lot" file found in the student docs, Witkowski folder, Spreadsheet folder
and save to your lunch number.

Exit Activity:
Open your Career PowerPoint if your name is on the board and
complete the first three slides.

Thursday, March 13th- 8th Grade- Creating a Database

Bellringer:
1. Open your Typing file and on page 38 type lines 8, 9 and 10.            
    Use your left  LITTLE finger for the left shift key   key AND
your right  LITTLE finger for the quotation mark key   exercise.
2. If your expedia.com worksheet is not finished, finish it (see board)
3. Pull out your Career worksheet
    if you do not have the Career WORKSHEET finished
    Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
     and choose 6 careers from the Science, Technology, Engineering and Math page.

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

Guided Practice:
@ Miss W will walk through how to create a vacation database
     by right clicking on the database name to the left and using the Design view.

Independent Exercise:
@ Students will create and then enter their vacation information into a vacation database.
@ If it does not let type in the data, it means you have the field type wrong.

Exit Activity:
1. http://www.quia.com/mc/1412062.html
2. Pull up your Career PowerPoint, the first 3 slides must be finished.

Wednesday, March 11th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/03/bellringer-1.html

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

Wednesday, March 11th- 7th Grade- Spreadsheets- What if analysis

Bellringer:
1. Open your Typing file and on page 32 type lines 9 and 10.            
    Use your right INDEX finger for the U  key exercise.
2. On page 32 type line 14.            
    Use your left LITTLE finger for the LEFT shift  key exercise.
3. Pull out your Career worksheet
    if you do not have the Career WORKSHEET finished
    Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
     and choose 6 careers from the Science, Technology, Engineering and Math page.

What are we learning?
4.1 Know the components of Spreadsheets
Bring back signed Interim Reports by Wednesday for 100.  last day for 100

Guided Lesson- What if Analysis:
* Open Spreadsheet Vocabulary PowerPoint and go to slide 10
* Students will open an new Excel file and type the 4 formulas on the green paper.
* Students will practice What if Analysis by changing the values in B7 and C7.
* Miss W. will explain the dream car spreadsheet activity.
 
Independent Activity: If time: Car lot exercise-  
1*Students will gather data to create a spreadsheet of dream cars that they would have in their own car lot business.
2*Students will go to http://www.carmax.com and find 3 cars and write the information (year, make(brand), model(name), miles, and price) on their worksheet.

Wednesday, March 12th- 8th Grade- Determining a field type and creating a Vacation database

Bellringer:
1. Open your Typing file and on page 37 type lines 5 and 6.            
    Use your right  LITTLE finger for the apostrophe '   key exercise.
2. If your expedia.com worksheet is not finished, finish it (see board)
3. Pull out your Career worksheet
    if you do not have the Career WORKSHEET finished
    Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
     and choose 6 careers from the Science, Technology, Engineering and Math page.

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 Wednesday for 100.  last day for 100

Guided Practice:
@ Students will work in pairs to decide the right field types needed for the vacation
     database. Look on slide 18 on 1 Fundamentals of Databases PowerPoint.
@ Miss W will walk through how to create a vacation database
     by right clicking on the database name to the left and using the Design view.

Independent Exercise:
@ Students will enter their vacation information into their vacation database.
@ If it does not let type in the data, it means you have the field type wrong.

Exit Activity:
http://www.quia.com/mc/1412062.html