|
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2014
Prerequisites:
N/A
Corequisites:
N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A |
Course
Name (short): Database Management
School: Business
Program(s):
Office Admin - Executive
Program Coordinator(s):
Lisa Mendez
Course Leader or Contact: Kellie Hayward
Originator: Linda Sutherland
Designate: Linda Sutherland
Version: 2.0
Status: Approved - Under Rev (AREV)
Calendar Description
Students learn the fundamental concepts of planning and designing a
relational database. Students learn to design, create and customize
basic to advanced tables, queries, forms and reports. Students utilize
tools to analyze and maintain a database for optimum performance.
Typical Instructional Format
Lecture
|
42.0 |
Total hours: |
42.0 |
Courses may be offered in other formats.
Section I Notes:
N/A
|
Detailed Description
Students learn the fundamental concepts of planning and designing a
relational database. Students design, create and customize basic to
advanced tables, queries, forms and reports. Students use advanced
features to design and build relationships, validate data, create
indices, create calculated fields and logical functions. Maintenance
of databases are explored by students through compact, repair and
backup functions. Students learn advanced tools to analyze, sort,
filter, link, merge, import and export data.
Program Context
|
Office Admin - Executive |
Program Coordinator: Lisa Mendez |
This is a required course of
the Office Administration
Executive program. Students
establish foundation skills
and knowledge required in
future core courses. The
skills and knowledge
acquired and refined in this
course are essential to
perform effectively in the
workplace.
|
Course Critical Performance and Learning Outcomes
|
Critical Performance
By the end of this course, students will have demonstrated the ability
to design, create and maintain a relational database system using
database software.
Learning Outcomes
To achieve the critical performance, students will have demonstrated
the ability to:
1. Design database tables including necessary properties in
design and datasheet view.
2. Build one-to-one, one-to-many many-to-many relationships, and
indices.
3. Generate Select and Action queries with logical operators and
calculated fields.
4. Create customized reports, subreports and labels.
5. Integrate data through linking, merging, importing, exporting and
summarizing functions.
6. Produce customized forms, main forms, subforms and splitforms.
7. Apply advanced features such as validation rules, text/input
masks and lookup fields.
8. Maintain a database through compact, repair, backup and
restore functions.
9. Create customized embedded charts.
10. Publish database reports in PDF or XPS file formats.
|
Evaluation Plan
Students demonstrate their learning in the following ways:
|
25% Practical Skills Test 1
25% Practical Skills Test 2
10% Online Tutorials
10% Online Quizzes
30% Projects
100% Total
|
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:
|
Essential Employability
Skills
Essential Employability Skills emphasized in the course:
|
Communication
|
X
|
Critical Thinking & Problem Solving
|
|
Interpersonal
|
X
|
Numeracy |
X
|
Information
Management |
X
|
Personal
|
Notes: N/A
Prior Learning Assessment and Recognition
PLAR Contact: Reg.Off. Share Space
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 2014
Professor: Multiple Professors
Textbook(s): On-line tutorials and assessments: A Skills Assessment Manager (SAM)
PIN is required in order to complete Tutorials, Exams and Projects.
Purchasing instructions will be provided in class.
E-book: New Perspectives on Microsoft Access 2013, Custom e-book
access. Purchasing instructions will be provided in class.
RESOURCES:
Cengage Learning Student Textbook Companion Site Cengage Learning
Skills Assessment Manager (SAM 2013) - http://sam.cengage.com//
Applicable student group(s): Office Administration Executive Year 1 Students
Course Details:ORIENTATION
Introduction to course
Use of SLATE
Introduction to Skills Assessment Manager (SAM 2013)
Course assignments and deadlines
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Practice Training Session, Exam, Project
MODULE 1: CREATING A BASIC ACCESS DATABASE (TABLE/FIELD
DESIGN)
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #1A and B (3.75%)
MODULE 2: BUILDING A DATABASE AND DEFINING TABLE RELATIONSHIPS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #2A and B (3.75%)
MODULE 3: MAINTAINING AND QUERYING A DATABASE
Assessment and Activities:
Skills Assessment Manager (SAM2013)
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #3A and B (3.75%)
MODULE 4: CREATING FORMS AND REPORTS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #4A and B (3.75%)
Test #1 - Creating basic tables, queries, forms and reports (25%)
MODULE 5: CREATING ADVANCED QUERIES AND ENHANCING TABLE DESIGN
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #5A and B (3.75%)
MODULE 6: USING FORMS TOOLS AND CREATING CUSTOM FORMS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #6A and B (3.75%)
MODULE 7: CREATING CUSTOM REPORTS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #7A and B (3.75%)
MODULE 8: SHARING, INTEGRATING AND ANALYZING DATA
Assessment and Activities:
Skills Assessment Manager (SAM2013)
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #8A and B (3.75%)
Test #2 - Enhancing and Customizing queries, forms and reports (25%)
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.
|