APPL15963
Computer Applications- Database Management
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version   Public
 
Section I: Administrative Information
  Credit Value: 1.0
Credit Value Notes: N/A
Effective: Fall 2004
Prerequisites: N/A
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Course Name (short): Comp Applns: Database Mgmt
School:
All Sheridan Schools
Program(s): Computer Foundations
Program Coordinator(s): Lisa Koster
Course Leader or Contact: Tba
Originator: Anna Anderson
Designate: Adele Dodge
Version:
1.0
Status: Approved (APPR)

Calendar Description
This is a skills oriented course that provides hands-on training in the operation of database management software at the introductory to intermediate level.

Typical Instructional Format

Lab
14.0
Total hours: 14.0

Courses may be offered in other formats.

Section I Notes: Computer Foundations, Instructor Martha Gingerich

 
 
Section II: Course Details

Detailed Description
This course is a skills oriented course that provides hands-on training in the operation of database management software at the introductory and intermediate level. Emphasis is placed on using the computer as a tool in a professional setting. Hands on experience with microcomputers will be acquired using a popular database management software package.

Program Context

 
Computer Foundations Program Coordinator: Lisa Koster
This course is a required component of the Computer Foundations Program as it provides the student with computer knowledge and skills required to excel in their chosen field. To gain this knowledge, the student will create professional reports, using tables and simple queries. The computer skills acquired in this course will also be applied in subsequent courses to produce assigned reports.


Course Learning Outcomes
Learning outcomes identify the critical performances, and the knowledge, skills and attitudes that successful students will have reliably demonstrated through the learning experiences and evaluation in the course. Successful students will have demonstrated the following:

 
 
            Knowledge
			
- basic microcomputer components, operations and terminology
- the use and general functions of database management software
- software in the production of databases
- the Windows environment 
- packages such as Microsoft Access
 
            Skills
			
- operate networked micro computing systems with reasonable skill 
- engage in simple computer related discussions with others
- apply skills and knowledge learned in this course to other computer 
  applications encountered in a professional environment
- use current software as an effective communication tool
 
            Attitudes
			
- willingness to participate and learn from lab and independent study
- responsibility in meeting test and assignment deadlines
- responsibility by monitoring their progress in the course and 
  testing their degree of comprehension of course material by doing 
  assigned exercises and tutorials
- appreciation for the use of technology in a professional environment
- willingness to explore the computing environment
- confidence in using computers for professional applications
Evaluation Plan
Students demonstrate their learning in the following ways:

 
MEASURES OF PROGRESS:
There will be two scheduled tests and four in-class assignments to 
evaluate progress in this course.
 
EVALUATION DETAILS:
The two practical tests are comprehensive, hands-on exercises of up to 
50 minutes duration, designed to measure your competency with respect 
to all topic objectives combined. 

The competency tests must be written on the scheduled date or a mark 
of zero will be assigned. In exceptional circumstances the instructor 
may make special arrangements; however, it is the responsibility of 
the student to provide documentation to the instructor.

Practical Test #1 (30%)
Microsoft Access 2000; 50 minutes duration; issued during week 7; 
students must complete the test independently and without 
collaboration.

Practical Test #2 (30%)
Microsoft Access 2000 (continued from above); 50 minutes duration; 
issued during week 14; students must complete the test independently 
and without collaboration.

Assignments: (10% each)
The assignments are to be submitted as specified by the instructor.

Students will be responsible for attending the practical tests on the 
scheduled dates. If there are exceptional circumstances and the 
student cannot attend the practical tests on the scheduled dates it is 
the sole responsibility of the student to provide documentation to the 
instructor who may make alternate arrangements.  There is a late 
penalty for submitting assignments past the due date.  Late 
assignments will be deducted by 10% per day and will not be accepted 
more than one week past due.
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Generic Skills
Generic Skills emphasized in the course:

  communication - written   communication - oral X communication - visual
  analytical   creative thinking   decision making
  interpersonal   numeracy X organizational
  problem solving X technological   other (see below)

Notes: N/A

General Education
This General Education course relates to the following themes as specified by the Ministry of Training, Colleges and Universities.

  asthetic appreciation   social understanding
  civic life   understanding science
  cultural understanding   understanding technology
  personal development   work and the economy

Prior Learning Assessment and Recognition
PLAR Contact: Lisa Koster

Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous life and work experiences. This course is eligible for challenge through the following method(s):

Challenge Exam Portfolio Interview Other Not Eligible for PLAR
X        

Notes: N/A

 
 
Section III: Topical Outline
Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Effective term: Fall 2004
Professor: Tba
Textbook(s):
Microsoft Access 2002 Introductory Edition. ITP Nelson. 
ISBN = 0-7600-7089-X
Other materials:  Floppy diskettes

Applicable student group(s): Students in the Computer Foundations program. Instructor Martha Gingerich.
Course Details:
The following schedule is an approximate guide only to the timelines 
of the delivery of the course.  Actual sequence may vary depending on 
weather conditions, illness, system reliability etc. 

Week 1. Getting started with the College computers (network 
environment, logon, etc.) Getting Started with Access: start Access; 
view the Access window:  title bar, menu bar, status bar, table 
datasheet toolbar, formatting toolbar; open an existing database; 
examine the database window; overview of database objects:  tables, 
queries, forms, reports, macros, modules, command buttons; open a 
database object (table, query, etc.); navigate a database table:  
mouse, navigation buttons, scroll bars; save changes to database; save 
data; close a database; exit Access

Week 2. Open an existing database.  Print a table.  Create and 
print a query. Use the query wizard. Sort a query. Print the query 
results. Create and print a form. Use the form wizard. Get 
help in Access. Create and print a report using the wizard. 
Compact and repair a database. Back up and restore a 
database. Complete the appropriate Cases as assigned by the 
instructor.

Week 3. Design a database and understand data redundancy at a 
basic level. Understand field data types and sizes. Create a table 
(without the wizard). Define fields. Save a tables design. 
Populate and add records to a table.

Week 4. Modify the structure of an existing table. Delete adding 
and moving fields. Change a field's properties. Copy records from 
other databases. Update a database.

Week 5. Complete the Cases as assigned by the instructor.

Week 6. Review and additional Cases

Week 7. Midterm test.

Week 8. Learn how to design queries. Explore the query window. 
Create and run simple queries. Relationships? one to many, many 
to many, one to one. Referential integrity. Sort data and use 
filters.

Week 9. Build queries. Using exact matches and comparison operators 
to specify query criteria. Using multiple criteria in queries. 
Creating calculated fields. Using functions in a query.

Week 10. Continue with queries by doing tutorials and cases as 
specified by the instructor.

Week 11. Create a form using a wizard. Modify a form's 
appearance. Navigate the form. Find records by using a form. 
Print records in form view.

Week 12. Create a form with a Main form and a Subform. Create a 
report using the wizard. Enhance reports by adding pictures.

Week 13.Complete the appropriate tutorials and Cases as assigned by 
the instructor. Review of the work covered thus far.

Week 14 Final Exam


Academic Honesty
The principle of academic honesty requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the faculty member, or otherwise submitting work that is not the student's own violates this principle and will not be tolerated. Instances of academic dishonesty, including assisting another student to cheat, will be penalized as detailed in the Student Handbook.

Students who have any questions regarding whether or not specific circumstances involve a breach of academic honesty are advised to discuss them with the faculty member prior to submitting the assignment in question.

Discrimination and Harassment
Sheridan is committed to provide a learning environment that respects the dignity, self esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination are available in the Student Handbook.
 
[ Printable Version ]

Copyright © Sheridan College. All rights reserved.