Tuesday, June 3rd- 8th Grade- Review Day 4

Bellringer:

1.  Pull out your REVIEW papers from the crate.

2.  Get out a pen or pencil.

3.   On page 76, type sentences 11 and 12.

What are we learning?
First of three topics (Keyboarding, Publisher, Databases) based on your study guide analysis. (See edmodo- if you do not remember your 1st item)  

Guided Lesson: 
@  Relational Database Concepts https://www.youtube.com/watch?v=NvrpuBAMddw
      Students and Classes example
@  Access Database Basics-Relationships 101  Cookie example
           https://www.youtube.com/watch?v=ByqeSP9Y2UM
@ What is your favorite movie?
     What is a database? http://www.youtube.com/watch?v=Y-bvjtYgRVU
start at 1:10 explains relationships to 5:30
@ Miss W will show you how to open a new page for a link by
     holding the CTRL button and left clicking on the mouse
     at the SAME time.
@ You can choose to start with any activity on the Review page.
@ Once you are finished, do NOT wait for Miss W to check it,
     but move on to the next item by opening a new tab.
@ Miss W will check multiple items at a time.

Independent Practice:

If Keyboarding is your 1st topic click here.

If Publisher is your 1st topic click here.
If Databases are your 1st topic click here.

Friday, May 23rd- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/05/friday-may-23rd-8th-grade-internet.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/05/friday-may-23rd-7th-grade.html

Friday, May 23rd- 7th Grade- Validated List and VLookup

Bellringer:
1. On page 22, type the first sentence and the first two bullets.
2. Students will open the Data validation file.
3. If your name is on the board, finish your study guide questions and answers.

What are we learning? 
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
 

Guided Lesson: 

@ Miss W will explain List, Validated and Non-validated functions
@ Microsoft Excel 2010 Data Validation
@ Open the Data validation file
@ The Green class tab has the name of classes
@ The Yellow period tab has the daily periods listed
@ On the Yellow tab we are going to where A1 is and we are going to call it Periods.
@ On the Green tab we are going to highlight B1:B7@ Go to the Data Ribbon Tab
@ Click on Data Validation
@ Click the drop down arrow and choose List
@ Where it says source type =Periods
@ Click OK
@ Choose different periods for your classes

http://www.youtube.com/watch?v=qfLirkaWnCY

Independent Exercise:
In pairs, one student will open the VLookup file and one student will click on
the instruction link. 
@ Open up the VLookup file. 
@ Open up this instruction link http://static.timeatlas.com/screensteps/vlookup-excel2010.pdf
@ Students will complete a VLookup function as the teacher demonstrates the process.
@ Student will write the definitions for Lookup and VLookup

Exit Activity
1. http://www.quia.com/rr/402638.html?AP_rand=21103945
                          You need to win a million dollars

Friday, May 23rd- 8th Grade- Internet Safety

Bellringer:
1. On page 22, type the first sentence and the first two bullets.
2. If your name is on the board, finish your study guide questions and answers.

Guided Lesson:
@ Students will watch the next part of Internet Safety video.
     
Independent Practice:
@ Students will review their Edmodo Internet Safety answers
     and make any appropriate changes.
Exit Activity:
Internet Safety, work individually,
must get 10 of 10 correct
http://www.quia.com/hm/40647.html

Thursday, May 22nd- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/05/thursday-may-22nd-8th-grade-creating.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/05/thursday-may-22nd-7th-grade-creating.html

Thursday, May 22nd- 7th Grade- Creating a Study Guide and Analyzing Test Results

Bellringer:
1. On page 6, type the red triangle bullets that begin:

•   Use correct fingers. 

2. Get a pen or pencil out

What are we learning? 
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
 

Guided Lesson:
@ Miss W will explain how to create the study guide and how to do the review analysis.
@ Miss W will demonstrate adding a section and a comment to a PowerPoint.
     These were the 2 most common mistakes on the About Me Project.

Guided Lesson:
@ Microsoft Excel 2010 Data Validation
@ Open the Data validation file
@ The Green class tab has the name of classes
@ The Yellow period tab has the daily periods listed
@ On the Yellow tab we are going to where A1 is and we are going to call it Periods.
@ On the Green tab we are going to highlight B1:B7
@ Go to the Data Ribbon Tab
@ Click on Data Validation
@ Click the drop down arrow and choose List
@ Where it says source type =Periods
@ Click OK
@ Choose different periods for your classes

http://www.youtube.com/watch?v=qfLirkaWnCY

Independent Exercise:
@ Students will write out the questions they missed and the complete correct answers.

@ Students will determine which topic they need to study the most
     and list their order on Edmodo
     Questions 1 - 8  Keyboarding
     Questions 9 -16 PowerPoint
     Questions 17-25 Spreadsheets

@ Write the function definition, use and examples of
List, Validated and Non-validated on your worksheet 

Exit Activity 1. http://www.quia.com/rr/402638.html?AP_rand=21103945
                          You need to win a million dollars

 

If there is time: Complete the Look up and VLookup functions

 

Thursday, May 22nd- 8th Grade- Creating a Study Guide and Analyzing Test Results

Bellringer:
1. On page 6, type the red triangle bullets that begin

•   Use correct fingers. 

2. Get a pen or pencil out.
What are we learning?
How is database information used, organized, and managed in business? 
What formatting options are available when creating databases?

Guided Practice:
Miss W will explain how to create the study guide and how to do the review analysis.

Independent Exercise:
@ Students will write out the questions they missed and the complete correct answers.

@ Students will determine which topic they need to study the most
     and list their order on Edmodo AND ON THE BACK OF THEIR SCAN CARD
     Questions 1 - 8  Keyboarding
     Questions 9 -16 Publisher
     Questions 17-25 Databases

@ Students will watch the next part of Internet Safety video.
      Which big company was hacked this week? 

Exit Activity: Internet Safety, work individually.
http://www.quia.com/hm/40647.html