If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/monday-january-6-8th-grade-database.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/monday-january-6th-7th-grade.html
Friday, January 3, 2014
Monday, January 6th- 7th Grade- Spreadsheets Advanced Functions
Bell Ringer:
1. On page 334, type lines 3 and 4.
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
4. Open up your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
Guided Practice:
@ Miss W will review more advance Spreadsheet functions like:
the IF function http://www.youtube.com/watch?v=bQJaWE7qsWw
@ Open a new Spreadsheet
@ Open the PowerPoint called Excel IF statements explained
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
completing the notes (copying the Function, Use and Example)
for IF
@ Students will complete the Practice with IF statements on page 13
@Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/rr/958087.html
1. On page 334, type lines 3 and 4.
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
4. Open up your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
4.3
| Know spreadsheet operations |
Guided Practice:
@ Miss W will review more advance Spreadsheet functions like:
the IF function http://www.youtube.com/watch?v=bQJaWE7qsWw
@ Open a new Spreadsheet
@ Open the PowerPoint called Excel IF statements explained
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
completing the notes (copying the Function, Use and Example)
for IF
@ Students will complete the Practice with IF statements on page 13
@Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/rr/958087.html
Monday, January 6- 8th Grade- Database Filters Practice
Bell Ringer:
1. On page 334, type lines 3 and 4.
2. Open your Income database.3. Write down the questions and correct answers (in pink)
for the items you missed in your Prequery worksheet packet
3. Open your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
5.01 Understand database tables used in business.
Guided Practice:
@ Look to make sure that you Income database is correct
@Turn to page 58 in your Determining Sort Order Worksheet packet
@ Go to My Computer then Student Docs then Miss Witkowski's folder
then Databases and then open the Guided Practice Filtering and Sorting a Database
@ Miss W will walk you through several examples.
@ Income is a small database, you can see the answers HOWEVER
you will need to show how you reached your answers so please pay attention!
@ Miss W will show you how to screen print.
Independent Exercise:
@ Open up your Inn or B&B database. Check to make sure the records are correct.@ Complete the B&B worksheet, you must screen print your answers.
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
1. On page 334, type lines 3 and 4.
2. Open your Income database.3. Write down the questions and correct answers (in pink)
for the items you missed in your Prequery worksheet packet
3. Open your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
5.01 Understand database tables used in business.
Guided Practice:
@ Look to make sure that you Income database is correct
@Turn to page 58 in your Determining Sort Order Worksheet packet
@ Go to My Computer then Student Docs then Miss Witkowski's folder
then Databases and then open the Guided Practice Filtering and Sorting a Database
@ Miss W will walk you through several examples.
@ Income is a small database, you can see the answers HOWEVER
you will need to show how you reached your answers so please pay attention!
@ Miss W will show you how to screen print.
Independent Exercise:
@ Open up your Inn or B&B database. Check to make sure the records are correct.@ Complete the B&B worksheet, you must screen print your answers.
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
Thursday, January 2, 2014
Friday, January 3rd Short Cut Links
If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/friday-january-3rd-8th-grade-sorting.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/friday-jan-3rd-7th-grade-overview-of.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/friday-jan-3rd-7th-grade-overview-of.html
Friday, January 3rd- 7th Grade- Overview of Advanced Spreadsheet Functions
Bell Ringer:
1. On page 334, type lines 1 and 2.
2. You need a pencil or pen.3. Open up your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
Guided Practice:
@ Miss W will review the spreadsheet functions (shortcuts) we already covered:
Sum, Min, Max, Average, and Count
@ Miss W will start to explain more advance Spreadsheet functions like:
Date, Now (Ctrl ;), Days360
@ Open a new Spreadsheet
@ In cell B7 insert the Now function
@ In cell B10 insert the Date function and enter 2014 for year, 1 for month and 17 for the day.
@ We are now going to see how many days until the next Student Day Off.
@ In cell D12 insert the Days360 function Start date is B7 and End Date is B10
@ This will give you how many days before your next Student Day Off.
@ Lets find how many days until your birthday. :)
@ Change the number in B10 to your birthday.
@ Change the number in B10 to 2014 for year, 6 for month and 6 for the day.
@ This number is how many days are left until summer vacation!!!
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
completing the notes (copying the Function, Use and Example)
for Date, Now and Days360
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/rr/958087.html
1. On page 334, type lines 1 and 2.
2. You need a pencil or pen.3. Open up your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
4.3
|
Know spreadsheet operations |
Guided Practice:
@ Miss W will review the spreadsheet functions (shortcuts) we already covered:
Sum, Min, Max, Average, and Count
@ Miss W will start to explain more advance Spreadsheet functions like:
Date, Now (Ctrl ;), Days360
@ Open a new Spreadsheet
@ In cell B7 insert the Now function
@ In cell B10 insert the Date function and enter 2014 for year, 1 for month and 17 for the day.
@ We are now going to see how many days until the next Student Day Off.
@ In cell D12 insert the Days360 function Start date is B7 and End Date is B10
@ This will give you how many days before your next Student Day Off.
@ Lets find how many days until your birthday. :)
@ Change the number in B10 to your birthday.
@ Change the number in B10 to 2014 for year, 6 for month and 6 for the day.
@ This number is how many days are left until summer vacation!!!
Independent Exercise:
@ WRITE your NAME on the top of the Advanced Functions Notes Worksheet.
@ Students will start the Overview of Advanced Functions Notes Worksheet by
completing the notes (copying the Function, Use and Example)
for Date, Now and Days360
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/rr/958087.html
Friday, January 3rd- 8th Grade- Sorting and Filtering a Database
Bell Ringer:
1. On page 334, type lines 1 and 2.
2. Open your Income database.
3. Write down the questions and correct answers (in pink)
for the items you missed in your Prequery worksheet packet
3. Open your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
5.01 Understand database tables used in business.
Guided Practice:
@ Look to make sure that you Income database is correct
@Turn to page 58 in your Determining Sort Order Worksheet packet
@ Go to My Computer then Student Docs then Miss Witkowski's folder
then Databases and then open the Guided Practice Filtering and Sorting a Database
@ Miss W will walk you through several examples.
@ Income is a small database, you can see the answers HOWEVER
you will need to show how you reached your answers so please pay attention!
Independent Exercise:
@ Open up your Inn or B&B database. Check to make sure the records are correct.
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
1. On page 334, type lines 1 and 2.
2. Open your Income database.
3. Write down the questions and correct answers (in pink)
for the items you missed in your Prequery worksheet packet
3. Open your Alice animation.
What are we learning?
1.5 Digital Lifestyles- coding
5.01 Understand database tables used in business.
Guided Practice:
@ Look to make sure that you Income database is correct
@Turn to page 58 in your Determining Sort Order Worksheet packet
@ Go to My Computer then Student Docs then Miss Witkowski's folder
then Databases and then open the Guided Practice Filtering and Sorting a Database
@ Miss W will walk you through several examples.
@ Income is a small database, you can see the answers HOWEVER
you will need to show how you reached your answers so please pay attention!
Independent Exercise:
@ Open up your Inn or B&B database. Check to make sure the records are correct.
@ Once you finish your animation, CHECK YOUR SPELLING
THEN you can add enhancements to your animation or you can assist other students.
@ Students will create animation based on their storyboards.
@ Movies are PG-13, no killing people, no bad language, etc.
Exit Activities
http://www.quia.com/mc/483616.html
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
Wednesday, January 1, 2014
Thursday, Jan 2 Short Cut Links
If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/thursday-jan-2-8th-grade-finish-and.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/bell-ringer-1.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/bell-ringer-1.html
Subscribe to:
Posts (Atom)