Bell Ringer:
1. On page 432 type lines 3 and 42. Open up your Inns2 database.
3. Open up your Independent Practice Word Document (one with screen prints)
What are we learning?
5.01 Understand database tables used in business.
Guided Practice:
@ Miss W will show you how to use the advance filter on questions 8 and 9.
@ IMPORTANT ANNOUNCEMENT:
You MUST close the database first before you close the access file.
You must click on the inside "x" before you click on the outside "x"
If you don't close like the above instructions, it will freeze the program.
@ Open the Importing Text Files PowerPoint.
@ Student will import text data into a database using an existing file.
Independent Exercise:
@ Students will import text data into a database using their own data.
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
@ 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.
Wednesday, January 8, 2014
Tuesday, January 7, 2014
Wednesday, January 8th Short Cut Links
If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/thursday-january-9th-8th-grade.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/thursday-january-9th-7th-grade-students.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/thursday-january-9th-7th-grade-students.html
Wednesday, January 8th- 7th Grade- Finishing IF function and Starting Count functions
Bell Ringer:
1. On page 432, type lines 1 and 2.
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
What are we learning?
Guided Practice:
@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 statement
@ Students will complete the Practice with IF statements on page 13 and 14
@ If there is time: Students will start learning about the Count functions.
@ Count and Count A video http://www.youtube.com/
@ CountIF function video http://www.youtube.com/watch?v=nF29V9Cd7tA
@ Open the Runners file to practice the Count functions.
@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 432, type lines 1 and 2.
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
What are we learning?
4.3
| Know spreadsheet operations |
Guided Practice:
@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 statement
@ Students will complete the Practice with IF statements on page 13 and 14
@ If there is time: Students will start learning about the Count functions.
@ Count and Count A video http://www.youtube.com/
@ CountIF function video http://www.youtube.com/watch?v=nF29V9Cd7tA
@ Open the Runners file to practice the Count functions.
@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
Wednesday, January 8th -8th Grade- Finishing Filter Exercises
Bell Ringer:
1. On page 432 type lines 1 and 2
2. If your name is on the board, finish typing the records into the Inns2 database.
What are we learning?
5.01 Understand database tables used in business.
Guided Practice:
@ Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint
@ Open the Independent Practice: Filtering and Sorting a Database Word document that you saved to your lunch number.
Independent Exercise:
@ Look at you Inns2 database. Check to make sure the records are correct.
@ Complete the inns worksheet, you must screen print your answers.
@If there is time students will import text data into a database.
@ Open the Importing Text Files PowerPoint.
@ 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 432 type lines 1 and 2
2. If your name is on the board, finish typing the records into the Inns2 database.
What are we learning?
5.01 Understand database tables used in business.
Guided Practice:
@ Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint
@ Open the Independent Practice: Filtering and Sorting a Database Word document that you saved to your lunch number.
Independent Exercise:
@ Look at you Inns2 database. Check to make sure the records are correct.
@ Complete the inns worksheet, you must screen print your answers.
@If there is time students will import text data into a database.
@ Open the Importing Text Files PowerPoint.
@ 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
Monday, January 6, 2014
Tuesday, January 7th- Short Cut Links
If you are an 8th grade student click here http://wclassroom.blogspot.com/2014/01/tuesday-january-7th-8th-grade.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/tuesday-january-7th-7th-grade.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2014/01/tuesday-january-7th-7th-grade.html
Tuesday, January 7th- 7th Grade- Understanding the IF function
Bell Ringer:
1. On page 306, type the paragraph that begins "You can position a table..."
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
What are we learning?
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 statement
@ 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 306, type the paragraph that begins "You can position a table..."
2. You need a pencil or pen.
3. Get your Advance Functions worksheet out of the crate.
What are we learning?
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 statement
@ 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
Tuesday, January 7th- 8th Grade- Independent Filter Practice
Bell Ringer:
1. Open your Inns2 Database and finish typing the records.
What are we learning?
5.01 Understand database tables used in business.
Guided Practice:
@ Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint@ Open the Independent Practice: Filtering and Sorting a Database Word document that you saved to your lunch number.
Independent Exercise:
@ Look at you Inns2 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. Open your Inns2 Database and finish typing the records.
What are we learning?
5.01 Understand database tables used in business.
Guided Practice:
@ Miss W will show you how to screen print.
@ Open the Independent Practice: Filtering and Sorting a Database PowerPoint@ Open the Independent Practice: Filtering and Sorting a Database Word document that you saved to your lunch number.
Independent Exercise:
@ Look at you Inns2 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
Subscribe to:
Posts (Atom)