|
Relational Database Applications CT 273 H1 Old from Fall 2006, 2003 Version Software and Text Used SAM (Skills Assessment Manager) for online Training, Objective & Hands-On Task Exams |
||
Dates |
Material Covered |
Assignments |
| August 22 | Print Course Syllabi,
Course Outline, and then go over. Go over new discipline and Internet & E-Mail Policies. Project 1 PreTest |
Have students purchase a jump drive and SAM if needed from bookstore. |
| August 24 | PreTest for course | Need textbook, jump drive, and pocket folder. |
| August 29 | Make folders on USB
drive. LEARN IT: Lecture on Project 1 SAM Training for Project 1 |
LEARN IT:
Homework-- Work through Project 1, starting with page 10, following the numbered steps (red squares with white numbers in them) all the way through the project. DO NOT print until you get to class Thursday. You MUST save your Database with the proper filename in the proper folder on your jump drive. (Drive E, Project 1 folder) |
| August 31 | PRINT as directed in
class today from project 1 Ashton James College database. You will obtain a
printout of: Client Table (student name) Trainer Table (student name) Client Trainer Query (student name) Client Form( student name) - Print Selected Record Client Amount Report (student name) Instructor will direct obtaining documentation printouts for the two tables. LEARN IT!: In the lab #1, pages AC57-58 Printouts: Item Table (Student Name) Supplier Table (Student Name) Supplier Form (Student Name) - Print Selected Record Inventory Report (Student Name) Print the documentation for both tables. Place all in your pocket folder, in the order instructed and turn in to Mrs. Lynn |
NO HOMEWORK! See you next Tuesday |
| September 5 | All folders due today
with all assignments printed and inside them. REVIEW IT! |
REMEMBER!! You must
print the documentation for all newly created tables. Here's how: 1) Have
the database open that contains the table(s) to be documented. |
| September 7 | TEST IT! SAM ProGrader Exam on Project 1 |
|
| September 12 |
LEARN IT: Lecture on Project 2 SAM Training for Project 2 |
LEARN IT:
Homework-- Work through Project 2, following the numbered steps (red squares with white numbers in them) all the way through the project. DO NOT print until you get to class Thursday. |
| September 14 | Print all Queries from
Project 2 Ashton James College Database and place in folder. Turn in
folder LEARN IT: Assignment-- |
|
| September 19 | Continue work on assignments | Turn in all work in folders. |
| September 21 | LEARN IT! Go over assigned database queries with students and allow students to redo queries and turn in. | |
| September 26 | REVIEW IT! Review Quizzes in SAM on Project 2 |
Print a study guide from the objective quiz. |
| September 28 | TEST IT! SAM Exam on Project 2 (Tasks and Objective) |
|
| October 3 | LEARN IT! Project 3 Lecture |
|
| October 5 | LEARN IT! Project 3 Training for Tasks |
|
| October 10 | LEARN IT! In the Lab Assignment Turn in folder today. |
|
| October 12 | EXPAND IT! Cases & Places Assignment Turn in folder today. |
|
| October 17 | May redo Cases &
Places #4 for re-grading. REVIEW IT! |
Print a study guide from the objective quiz. |
| October 19 | TEST IT! SAM Exam on Project 3 (Tasks and Objective) |
|
| October 24 | LEARN IT! Lecture Project 4 |
HOMEWORK: Complete the second Report using Report Wizard and have ready to turn in. |
| October 26 | Complete the Form
using Form Wizard. Turn in the Client Summary Report, the Client/Trainer Report, and the Client Update Form (selected record) in your folder. LEARN IT! SAM Training on Project 4 |
HOMEWORK: LEARN IT! In the Lab #1 Assignment (Birds2U Database) and EXPAND IT! Cases & Places #2 (InPerson Fitness Company database) Due next Tuesday, October 31. |
| October 31 | Turn in homework
assigned last week in your folder. Assignment: Cases & Places #4 - DUE
a week from today, Tuesday, November 7 |
Print a Study Guide from the Objective Quiz. |
| November 2 | TEST IT! Project 4 Exam in SAM |
|
| November 7 | Cases & Places #4
due today. LEARN IT! Lecture Project 5 |
|
| November 9 | Turn in Project 5
printouts today in folder. LEARN IT! Project 5 Training |
HOMEWORK-- LEARN IT! In the Lab #1 (Birds2U Database) EXPAND IT! Case #2 (InPerson Fitness Company Database) |
| November 14 | EXPAND IT! Case Assignment #4 |
|
| November 16 | REVIEW IT! Quizzes in SAM to prepare for exam |
Print Study Guide from objective quiz. |
| November 21 | TEST IT! Project 5 exam in SAM. |
|
| November 23 | THANKSGIVING HOLIDAY! | |
| November 28 | LEARN IT! Complete Project 6 |
Complete Project 6 to turn in next class. |
| November 30 | LEARN IT! Training on Project 6 POSTTEST |
Tasks review available in SAM over Projects 1 - 6 |
| December 7 | 10:30 - 12:30 Final Exam (SAM tasks over Projects 1 - 6) | |