|
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
|
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
|
|
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.
|