2/1/10

Objective: apply database technology (120.23.c.5)

Lecture: Database Reports --- editing field size in design view

Warmup: Create a new Word document; name it Warmup 2-1-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. To put a database in alphabetical order, use the S____ command.
2. Asking the database a question by entering certain criteria is called a Q_______.

Assignment:
1. Go to QuizStar and take Database Quiz 2. You will have three opportunities to make a 100 on this daily grade. Some of the questions have more than one correct answer; read the instructions carefully.
2. Do Applicants and Listings, Part 3. All data MUST be spelled accurately in order for the filter/query to work and the report to be correct. Print off all the reports and place on my laptop.

1/29/10

Objective: apply database technology (120.23.c.5)

Lecture: Database Reports, review

Warmup: Open Warmup 1-25-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. A printout of only a specific portion of the database is called a _________.
2. To filter a database, choose Advanced, and then F___________ by F_______.
3. Would you use a text box or a label to insert your name in your database report?
****Proofread your warmups, print, and turn in on my laptop.

Assignment:
1. Do Students and Classes, Part 3. All data MUST be spelled accurately in order for the filter to work and the report to be correct. Print off the two reports and place on my laptop.

1/28/10

Objective: apply database technology (120.23.c.5)

Lecture: VENN Diagrams, Boolean Search Terms, Database Reports

Guided Practice: Students, Part 3

Warmup: Open Warmup 1-25-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. How many minor violations equal a Saturday SAC?
2. What are the three Boolean search terms?
3. ______________ and _____________ narrows a search.
4. ______________broadens a search.

Assignment:
1. Do Students, Part 3. All data MUST be spelled accurately in order for the filter to work and the report to be correct. Print off the two reports and place on my laptop.

1/27/10

Objective: apply database technology (120.23.c.5)

Lecture: minor violations = 4 = Saturday SAC

Warmup: Open Warmup 1-25-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. Which view would you use to add or delete a field?
2. Which button would you use to sort a field?

Assignment:
1. Do Classes and Listings Database, part 2

1/26/10

Objective: apply database technology (120.23.c.5)

Lecture: Guided Practice: Students 2; sorting, adding/deleting data

Warmup: Open Warmup 1-25-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. What are the two views in Access?
2. Which view opens automatically when you create a new database?
3. Which view do you use to set up a table (create the fieldnames)?
4. Which view do you use to enter data in a database?

Assignment:
1. Do Students Database, part 2

1/25/10

Objective: apply database technology (120.23.c.5)

Warmup: Create a new Word document; name it Warmup 1-25-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. When you first create a new database, what do you click on in order to save it into your network folder?
2. If you have no fields that require a unique entry, take off the primary ___________ in order to prevent problems with data entry.

Assignment:
1. Do Listings Database, part 1

1/22/10

Objective: apply database technology (120.23.c.5)

Warmup: Open Warmup 1-19-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. What are the two fastest ways to move from one field to the next when entering data in a database?
2. What are the four data types that we have used?
3. Proofread your warmups for complete sentences with complete ideas. Make sure your heading is in the header. Print and turn in on my laptop.

Assignment:
1. Finish all previously assigned databases: Students, Classes, & Applicants.

1/21/10

Objective: apply database technology (120.23.c.5)

Lecture: announce pop quiz; review DB

Warmup: Open Warmup 1-19-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. In a database, what holds all the information about one item or person?
2. In a database, what holds all the same type of information, for example everyone's first name?

Assignment:
1. In Quizstar, do Database Quiz 1. You will have three 'trys' to make a 100. Review missed questions before attempting to take the quiz again. Some of the questions have more than one correct answer -- Read the instructions for each question!!
2. Finish Classes Part 1.
3. Do Applicants Part 1.

1/20/10

Objective: apply database technology (120.23.c.5)

Lecture: review records & fields

Warmup: Open Warmup 1-19-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. When is the whole database saved?
2. When are the objects (tables, forms, queries, reports) within the database saved?
3. What symbol in a database is used to designate a field which is unique?

Assignment:
1. Finish Students Part 1.
2. Do Classes Part 1.

1/19/10

Objective: apply database technology

Lecture and Guided Practice: Students Part 1 (Review saving procedures, Database Management System, Objects, ((Tables, Reports, Forms, Queries)) Records, Fields, Types of Data, Design View, Table/Datasheet View

Warmup: Create a new Word document in Word, name it Warmup 1-19-10. Answer all questions as complete sentences with complete ideas. Delete the questions.
1. What is the name of the new unit?
2. What type of program is used to store and organize related data?
3. Which MicroSoft Office program will we be using to learn/do databases?
4. Create a new folder called "Database".

Assignment:
1. Do Students Part 1.

Animated PowerPoint Project

Objective: apply presentation technology

Notice: Last project of the semester; no warmups during this project

Lecture: Custom animation, motion paths, copy pages, examples

Assignment: We will be working on a custom animation project. Read all the instructions and the rubric before starting. Due Monday. Volunteers will be presenting through semester exam week.