Wednesday, April 30, 2014

Thursday, May 1st- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/thursday-may-1st-8th-grade-databases.html

If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/04/thursday-may-1st-7th-grade-spreadsheets.html

Thursday, May 1st- 7th Grade- Spreadsheets- Vocabulary Test

Bellringer:
1.  On page 389, type the paragraph that starts "The SUM function..."

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 Today! All work due by end of class Today.
 Final review for test.


 Independent Exercise:
@
Working by yourself WITHOUT using the PINK Study Guide answer the questions.
These are the test questions.

  http://www.quia.com/hm/174125.html?AP_rand=19139139&playHTML=1 
 @ You must show Miss W your grade.  


@ If there is time, we will begin the English Tobacco Imports
     From America Spreadsheet exercises.
 


Thursday, May 1st- 8th Grade- Databases- Data Type and Field Property Test

Bellringer:
1. On page 287 type lines 1 and 2. 
that begin "A faster way of doing this is..."

2. If your name is on the board complete the missing work. 


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


Guided Lesson:

Test Today! All work due by end of class Today.
@ Final test review.
 
 Independent Exercise:
@ Students will take Data type and field property test.

@ Students will write the entire question and correct answer for the
     Sort worksheet items that they missed. 

@If time: Students will complete page 53 on Criteria Statements.

Term
Definition
Filter
A tool used to search for specific information within a database.
       Filter by selection
Filters for the field or entry that has been selected
       Filter/Advanced Filter Sort
Filters according to specific criteria assigned by the user
Sort
Arranging information in some form of logical order; alphabetical, chronological (by time), numerical.
Criteria
A condition that must be met or not met in a search.


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

Tuesday, April 29, 2014

Wednesday, April 30th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/wednesday-april-30th-database-test.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/04/wednesday-april-30th-7th-grade.html

Wednesday, April 30th- 7th Grade- Spreadsheet- Test Review Voki

Bellringer:
1.  On page 385, type the paragraph that starts "Another simple formula..."

2.  If you did not finish the crossword puzzle, get out your Chart Component Notes.
3. Sign into Edmodo.

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 This Thursday! All work due by end of class Thursday.
@ Instructions for review Voki.
@ Remember to bring a book or homework for after the test tomorrow.
 
 Independent Exercise:
@ Students will create a voki about one of the pink study guide test words.
@ Do NOT say the name of your chart component in your voki,
     just say the definition,we are going to guess.
@ Example
http://www.voki.com/pickup.php?scid=9046863&height=267&width=200


Voki note:
While they recommend having an email you can click no thanks and it will give you a link for your voki.


Exit Activity2:
Working by yourself WITHOUT 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 70% correct.
http://www.quia.com/quiz/2055803.html?AP_rand=106361813

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

Wednesday, April 30th- 8th Grade- Database- Test Review Voki

Bellringer:
1. On page 423 type the last 3 sentences
that begin "A faster way of doing this is..."

2. If your name is on the board complete the missing work. 
3. Everyone should sign into Edmodo.

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


Guided Lesson:

Test This Thursday! All work due by end of class Thursday.
@ Instructions for review Voki.
@ Remember to bring a book or homework for after the test tomorrow.
 
 Independent Exercise:
@ Students will create a voki about one of the 10 test words.
@ Do NOT say the name of your word in your voki, just say the definition,     

we are going to guess.
@ Example
http://www.voki.com/pickup.php?scid=9046863&height=267&width=200


Voki note:
While they recommend having an email you can click no thanks and it will give you a link for your voki.
@ Students will write the entire question and correct answer for the
     Sort worksheet items that they missed.  

Term
Definition
Filter
A tool used to search for specific information within a database.
       Filter by selection
Filters for the field or entry that has been selected
       Filter/Advanced Filter Sort
Filters according to specific criteria assigned by the user
Sort
Arranging information in some form of logical order; alphabetical, chronological (by time), numerical.
Criteria
A condition that must be met or not met in a search.


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

Monday, April 28, 2014

Tuesday, April 29th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/tuesday-april-29th-8th-grade-databases.html

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

Tuesday, April 29th- 7th Grade- Spreadsheets- Embedded versus Linked Charts

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. On page 383, type the paragraph that starts "Another simple formula..."

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 this Thursday! All work due by end of class Thursday.

Open the 4.02 Chart Components PowerPoint
@ Students will embed and link a chart . http://www.gcflearnfree.org/word2013/word-2013-embedding-an-excel-chart

Independent Exercise:
@ Students will look at the Chart Components PowerPoint to Label the Chart Parts. http://compappssh.wikispaces.com/file/view/Notes.pdf

@ Students will write out the embedded chart and linked chart definitions.
@ Students will complete the Graph and Chart Terminology Crossword Puzzle

Exit Activity2:
Working by yourself WITHOUT 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 70% correct.
http://www.quia.com/quiz/2055803.html?AP_rand=106361813

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

Tuesday, April 29th- 8th Grade- Databases- Ascending vs Descending Sorts

Bellringer:
1. On page 423 type the 1st 2 sentences
that begins "If you were searching a database..."

2. If your name is on the board complete:
    your Queries Prework PowerPoint.
3.    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 Music database.


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


Guided Lesson:

Test This Thursday! All work due by end of class Thursday.
@ Instructions for worksheets.

Independent Exercise: 
@ Students will carefully complete pages 48 through 52.
If you make a mistake, you will need to write the entire question and correct answer. 

Term
Definition
Filter
A tool used to search for specific information within a database.
       Filter by selection
Filters for the field or entry that has been selected
       Filter/Advanced Filter Sort
Filters according to specific criteria assigned by the user
Sort
Arranging information in some form of logical order; alphabetical, chronological (by time), numerical.
Criteria
A condition that must be met or not met in a search.


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

Sunday, April 27, 2014

Monday, April 28th- Short Cut Links

If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/04/monday-april-28th-8th-grade-databases.html

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

Monday, April 28th- 7th Grade- Spreadsheets- Autofill and Relative Cell Referencing

Bellringer:
1. Get out of the crate your Chart Component Notes.
2. On page 382, type the paragraph that starts "Another simple formula..."

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 this 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.
@ Working With Cell References in Excel 2010 http://www.gcflearnfree.org/excel2010/9.4
@ Open the 4.02 Chart Components PowerPoint

Independent Exercise:
@ Students will use
the Autofill feature (allows you to quickly fill in days of week or formulas) and
Relative Cell Referencing (copy formulas and automatically adjusts to correct cell range)

with the Blooming Bells Nursery file.  

Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- choco nutties file


Examples of Relative and Absolute References http://www.youtube.com/watch?v=PFOe0TKnAuE

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then
RELATIVE CELL REFERENCE folderthen- blooming bells nursery file

Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then
RELATIVE CELL REFERENCE folder
then- rose variety file


@ Students will look at the Chart Components PowerPoint to Label the Chart Parts. 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 1 term:
Chart Wizard: An on-screen guide that helps you prepare a chart


Exit Activity2:
Working by yourself 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 70% correct. http://www.quia.com/quiz/2055803.html?AP_rand=106361813

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