Monday, April 28th- 8th Grade- Databases- Lookup data type and zip code input mask

Bellringer:
1. On page 420 type the top paragraph
that begins "For a search in a random database..."
2. Open and complete your Queries Prework PowerPoint.
3. Complete any missing work on the board:
   Go to achieve 3000. Go to your mailbox.
Click to view the article A Critter Count. Students will read carefully.
The first attempt at the activity questions will be a daily grade. .
4. Finish the database vocabulary CrossWord puzzle.

What are we learning? Understand the basics of databases.
How is database information used, organized, and managed in business?

Guided Lesson:
Test This Thursday!
*Go to database http://www.kidsbiology.com/animals-for-children.php

1. When the animal database "offers you choices" to click on such as bats, bears, butterflies what type of data type is it? (Not text) 

2. When you click and find the definition of the animal, what data type is the definition?

   (Not text)

@ Open Steps to Create a Database powerpoint.
@ Review ascending and descending order by writing examples on worksheet.
     Ascending is A to Z order or small numbers to larger numbers.
     Descending is Z to A order or large numbers to small numbers.

Independent Exercise: 
@ Students will create a database with a lookup data type and a zip code input mask.@ Students will carefully complete pages 48 and 49. If you make a mistake, you will need
     to write the entire question and correct answer. 
 

Exit Activity#1: Database Vocabulary Review: http://www.quia.com/mc/483616.html 

Friday, April 25th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/friday-april-25th-8th-grade-database.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/04/friday-april-25th-7th-grade.html

Friday, April 25th- 7th Grade- Spreadsheets- Tick Marks

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. On page 380, type the paragraph that starts "To add, subtract, multiply..."

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:
@ Test next Thursday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.
@ Open the 4.02 Chart Components PowerPoint
@ Excel tick marks and gridlines 2010   http://www.youtube.com/watch?v=m9fbZ0DEDbY
     until 2:20
@ Open the Tick Marks file
@ Highlight the data and choose a "format as table" option
@ Highlight the data and create a line chart (choose the first choice)
@ We will be right clicking on certain items
@ Make minor tick marks on the vertical and horizontal axes
@ Change the color of the tick marks to red
@ Change gridlines to green
@ Change the plot area to light aqua
@ Change the chart area to any color other than light aqua
@ Go to the Chart Tools Tab and then the Layout tab and add the title "ATMS"
@ On the Layout Tab add data labels
@ In the Tick Marks file what is one of the data series?

Independent Exercise:
@ Students will take notes about Chart Components from 7. Tick Mark to 11 Axis Titles. http://compappssh.wikispaces.com/file/view/Notes.pdf

Exit Activity#1:
Click on the link Characteristics related to chart options   http://www.quia.com/mc/2016566.html
We have not discussed 2 terms:
Data series: A group of related information in a column or row of a worksheet that will be plotted on a chart
Chart Wizard: An on-screen guide that helps you prepare a chart

Exit Activity#2:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  
http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1

Exit Activity#3:
You need to get at least 50% correct. http://www.quia.com/quiz/2055803.html?AP_rand=106361813

Exit Activity#4:
http://www.purposegames.com/game/excel-chart-elements-quiz

Friday, April 25th- 8th Grade- Database- Zip Code Input Mask

Bellringer:
1. On page 419 type the bottom 2nd paragraph
that begins "So far, you've entered data into..."
2. Complete any missing work on the board,
Field trip students go to achieve 3000. Go to your mailbox.
Click to view the article A Critter Count. Students will read carefully.
The first attempt at the activity questions will be a daily grade. .
Reward on Friday: For all students, who get 70 or better!
3. Finish the database vocabulary crossword puzzle.

What are we learning? Understand the basics of databases.
How is database information used, organized, and managed in business?

Guided Lesson:
Test Next Thursday!
Open Steps to Create a Database powerpoint.
Review ascending and descending order by writing examples on worksheet.
Ascending is A to Z order or small numbers to larger numbers.
Descending is Z to A order or large numbers to small numbers.

Independent Exercise: 
@ Students will create a database with a lookup data type and a zip code input mask.
@ Students will complete Queries Prework PowerPoint.
@ Students will carefully complete pages 48 and 49. If you make a mistake, you will need
to write the entire question and correct answer.

Reading Reward Activity:
All students, who made a 70 or higher, will play a fun review game outside.
All students, who made 69 or less, will work on reading improvement worksheets.

Exit Activity#1:
*Go to database http://www.kidsbiology.com/animals-for-children.php
*Click the categories until you find an interesting animal. 

*Look on your puzzle word definitions or Database powerpoints,
  and the answer the following questions:

1. When the animal database "offers you choices" to click on such as bats, bears, butterflies what type of data type is it? (Not text) 

2. When you click and find the definition of the animal, what data type is the definition?

   (Not text)
 

 Exit Activity#2: Database Vocabulary Review: http://www.quia.com/mc/483616.html 

Thursday, April 24th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/thursday-april-24th-8th-grade-text.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/04/thursday-april-24th-7th-grade.html

Thursday, April 24th- 7th Grade- Spreadsheet- Chart components

Bellringer:
1. Open your Population file. The one with the continents.
2. On page 374 type the paragraph that starts "You can sort your data..."

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:
@ Test next Thursday! You can practice the questions online at home or take home a pink study guide and/or the Review for Test Spreadsheet Vocabulary PowerPoint.
@ PowerPoint winners will be announced.
@ Miss W will review the chart tools tab      
http://www.youtube.com/watch?v=igmsvkkUWqw
     and how to use the Layout Tab to add a picture and shapes to your chart,
     and how to use the Format Tab to add a border and shape fill to your chart.
    
@ Open the 4.02 Chart Components PowerPoint

Independent Exercise:
@ Students will take notes about Chart Components. http://compappssh.wikispaces.com/file/view/Notes.pdf

Exit Activity#1:
Click on the link Characteristics related to chart options   http://www.quia.com/mc/2016566.html
We have not discussed 2 terms:
Data series: A group of related information in a column or row of a worksheet that will be plotted on a chart
Chart Wizard: An on-screen guide that helps you prepare a chart

Exit Activity#2:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.  
http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1

Exit Activity#3:
You need to get at least 50% correct. http://www.quia.com/quiz/2055803.html?AP_rand=106361813

Exit Activity#4:
http://www.purposegames.com/game/excel-chart-elements-quiz

Thursday, April 24th- 8th Grade- Text-Based Reading about Databases

Bellringer:
1. On page 419 type the bottom 1st paragraph
that begins "So far, you've entered data into..."
2. Complete any missing work on the board.

What are we learning? Understand the basics of databases.
How is database information used, organized, and managed in business?

Guided Lesson:
Test Next Thursday!@ Students will review for text-based reading assignment.
Synonym- words with same meaning, an example is cold and freezing.

Infer- educated guess from the clues, an example is there were no other students in the classroom so the student inferred they were in the media center or lab.  

Opinion- is NOT a fact, for example, in the student's opinion Halo is the best video game.
A fact would be "Halo is a first person shooter game for Microsoft's Xbox and Xbox 360."

Category - is a group, for example, the student liked reading books in the fantasy category.
Independent Exercise:
@ Go to achieve 3000. Go to your mailbox.
Click to view the article A Critter Count
Students will read carefully.
The first attempt at the activity questions will be a daily grade.

DIFFERENT THOUGHT QUESTION: How does the ISIS database help save animals? Write 2 to 3 sentences.
Reward on Friday: For all students, who get 70 or better!
 
@ Finish the database vocabulary crossword puzzle.    
Exit Activity#1:

*Go to database http://www.kidsbiology.com/animals-for-children.php

*Click the categories until you find an interesting animal. 

*Look on your puzzle word definitions or Database powerpoints,
  and the answer the following questions:

1. When the animal database "offers you choices" to click on such as bats, bears, butterflies what type of data type is it? (Not text) 

 

2. When you click and find the definition of the animal, what data type is the definition?
   (Not text)

 

 Exit Activity#2: Database Vocabulary Review: http://www.quia.com/mc/483616.html