APPL70053
Access, Introduction |
|
|
|
|
Sheridan College resides on land that has been, and still is, the traditional territory of several Indigenous nations, including the Anishinaabe, the Haudenosaunee Confederacy, the Wendat, and the Mississaugas of the Credit First Nation. We recognize this territory is covered by the Dish with One Spoon treaty and the Two Row Wampum treaty, which emphasize the importance of joint stewardship, peace, and respectful relationships.
As an institution of higher learning Sheridan embraces the critical role that education must play in facilitating real transformational change. We continue our collective efforts to recognize Canada's colonial history and to take steps to meaningful Truth and Reconciliation.
|
Section I: Administrative Information
|
|
Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Winter 2021
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A |
Program(s):
Database - Introductory, Geographic Information Systems, IT Operations, Microsoft Office Applications
Program Coordinator(s):
Greg Golding
Course Leader or Contact: N/A
Version: 20210118_00
Status: Approved (APPR)
Section I Notes:
Access to course materials and assignments will be available on Sheridan's Learning and Teaching Environment (SLATE). Students will need reliable access to a computer and the internet.
|
|
|
Section II: Course Details
|
Detailed Description
Students learn how to create and maintain a relational database using Microsoft Access. Students design and modify tables, queries, forms and reports to determine and create relationships between databases. Students apply formatting techniques to enhance the appearance of forms and reports, sort, filter, link, and import and export data.
Program Context
|
Database - Introductory |
Program Coordinator(s):
N/A |
This course is a required course in the Database - Introductory Recognition of Achievement Program, offered through the Faculty of Continuing and Professional Studies.
|
Geographic Information Systems |
Program Coordinator(s):
N/A |
This course is a required course in the Geographic Information Systems Recognition of Achievement Program, offered through the Faculty of Continuing and Professional Studies.
|
IT Operations |
Program Coordinator(s):
N/A |
This course is a required course in the IT Operations Certificate Program, offered through the Faculty of Continuing and Professional Studies.
|
Microsoft Office Applications |
Program Coordinator(s):
Greg Golding |
This course is a required course in the Microsoft Office Applications Sheridan Certificate Program, offered through the Faculty of Continuing and Professional Studies.
|
|
Course Critical Performance and Learning Outcomes
|
Critical Performance: |
| By the end of this course, students will have demonstrated the ability to prepare a database with tables, queries, forms and
reports.
|
|
Learning Outcomes:
To achieve the critical performance, students will have demonstrated the ability to:
|
|
- Define the basic to intermediate features and functionality of a database management system.
- Identify the basic structure and components of a database management system.
- Demonstrate the skills required to create, format, modify and save databases with related tables, forms, queries and reports using design view and wizards.
- Design and add records to tables with various properties.
- Determine and create relationships between database tables.
- Create Custom Forms and Subforms with advanced field properties.
- Demonstrate how to backup, compact and repair a database.
- Apply formatting features such as fonts, colours, graphic images, headers, footers, objects and controls.
- Demonstrate the skills required to organize, enter, sort, filter, calculate, link, merge, import and export data.
- Apply effective file management skills when creating folders, and copying, moving, deleting and renaming files.
|
Evaluation Plan
Students demonstrate their learning in the following ways:
| Evaluation Plan: ONLINE
| Training (14 Total) | 28.0% | | Exams (14 Total) | 28.0% | | Projects (14 Total) | 44.0% | | Total | 100.0% |
Evaluation Notes and Academic Missed Work Procedure: Students are encouraged to complete all online work for assessment and preparation for the tests.
SAM 2016 Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.
SAM 2016 Online Exams: Online Exams are based on skills learned and practised in the Online Training Tutorials. If a student does not complete an online exam, they will receive a mark of zero. The actual score for each online exam is recorded.
SAM 2016 Projects: Projects are completed in the application software and submitted through SAM 2016. Projects summarize each section's skills learned. Projects are due as per the assignment schedule. A student's actual score on the assignment will be recorded.
In situations where a student knows, in advance, that s/he will not be able to submit by the scheduled due date, the student must contact the instructor, in writing, prior to the scheduled due date providing an explanation, and a request to submit the project on an alternate date. In these situations, the project must be submitted in advance of the scheduled due date.
All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.
Evaluation Plan: IN-CLASS
| Training (14 Total) | 28.0% | | Exams (14 Total) | 28.0% | | Projects (14 Total) | 44.0% | | Total | 100.0% |
Evaluation Notes and Academic Missed Work Procedure: Students are encouraged to complete all online work for assessment and preparation for the tests.
SAM 2016 Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.
SAM 2016 Online Exams: Online Exams are based on skills learned and practised in the Online Training Tutorials. If a student does not complete an online exam, they will receive a mark of zero. The actual score for each online exam is recorded.
SAM 2016 Projects: Projects are completed in the application software and submitted through SAM 2016. Projects summarize each section's skills learned. Projects are due as per the assignment schedule. A student's actual score on the assignment will be recorded.
In situations where a student knows, in advance, that s/he will not be able to submit by the scheduled due date, the student must contact the instructor, in writing, prior to the scheduled due date providing an explanation, and a request to submit the project on an alternate date. In these situations, the project must be submitted in advance of the scheduled due date.
All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.
|
Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:
|
Essential Employability
Skills
Essential Employability Skills emphasized in the course:
- Information Management - Locate, select, organize and document information using appropriate technology and information systems.
Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) - Office of the Registrar
Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous relevant work/life experience, service, self-study and training on the job. This course is eligible for challenge through the following method(s):
|
|
|
|
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.
|
It is recommended that students read the following policies in relation to course outlines:
- Academic Integrity
- Copyright
- Intellectual Property
- Respectful Behaviour
- Accessible Learning
All Sheridan policies can be viewed on the Sheridan policy website.
In alignment with Sheridan's Academic Integrity Policy, students should consult with their professors and/or refer to evaluation instructions regarding the appropriate use, or prohibition, of generative Artificial Intelligence (AI) tools for coursework. Turnitin AI detection software may be used by faculty members to screen assignment submissions or exams for unauthorized use of artificial intelligence.
The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.
|
[
Printable Version ]
|
Copyright © Sheridan College. All rights reserved. |