Sheridan Course Outlines

Land Acknowledgement

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: 63.0
Credit Value: 4.5
Credit Value Notes: N/A
Effective: Winter 2020
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A

Program(s): Adv Cert Accounting & Finance
Program Coordinator(s): N/A
Course Leader or Contact: N/A
Version: 20200106_00
Status: Approved (APPR)

Section I Notes: Students are expected to have completed ACAF70040 or equivalent before registering for this course. All graded evaluations (i.e., projects, assignments, tests, exams, etc.) must be completed according to the schedule of dates specified by the instructor. This course is offered in two formats - online (OntarioLearn) and blended (on-campus and Slate). For the blended section, there will be an on-campus session each week along with online sessions. The online portion of the blended course is offered through Sheridan's Learning and Teaching Environment (SLATE). Online learning often involves assigned weekly readings, research, assignments, quizzes, journal writing and discussion boards. Some courses may include live online class sessions that allow students and the instructor to engage and share resources as a group. A laptop computer is required for this course. Students will need reliable access to the internet. SAGE, the software vendor, has licensed the use of a student version of SAGE 50 Premium. The licence will expire 14 months after the software is activated. Students with MAC computers will require a Windows Partition. To be considered for the Advanced Certificate in Accounting and Finance (ACAF) National Examination eligibility, students must earn a minimum grade of 60% in this course and meet the additional standards of achievement as required by CPA Ontario's National Examination Policies. In addition, upon completion of this course, students will possess the advanced skills necessary to attain an independent credential via SAGE, by attempting their Applications Specialist Certification.

Section II: Course Details

Detailed Description
Students complete computerized accounting cycles for a variety of organizations using SAGE 50 Accounting Software. Exposure to components in this accounting suite include: General Journal/Ledger, Accounts Payable/Receivable, Payroll, Inventory and Order Entry. Functionality related to System Set-up, Sales Taxes, Banking, Periodic Processing and Financial Reporting are also explored. Students explore the tools and administrative functions within a SAGE 50 Accounting Database. Using simulated source documents and a step-by-step approach, students record business transactions, generate periodic processes and produce financial reports essential to decision makers. This hands-on perspective allows students to conceptualize the features of an accounting system and its inherent internal controls that maintain data integrity for audit purposes. Through interactive demonstrations, targeted weekly deliverables and a comprehensive project, a key stroke approach develops the student's ability to apply computerized accounting techniques to each step of the accounting cycle.

Program Context

Adv Cert Accounting & Finance	Program Coordinator(s): N/A
This course is part of the ACAF cluster of course offerings.

Course Critical Performance and Learning Outcomes

	Critical Performance:
	By the end of this course, students will have demonstrated the ability to generate reliable financial information in a computerized environment, by accurately converting accounting data from manual records.

Learning Outcomes:

To achieve the critical performance, students will have demonstrated the ability to:

Complete the accounting cycle of various business entities using SAGE 50 Accounting Software, including a complete set of financial statements that accurately reflect the financial position of the business in accordance with internationally recognized standards.
Perform administrative database functions to ensure routine maintenance of data stability, such as backups and adhering to internal controls, to secure data integrity for audit trails.
Set-up structural elements of a company, including a chart of accounts, vendors, customers, employees, inventory items, divisions and process adjustments, reversing and recurring entries, account reconciliations and tax summaries.
Record business transactions, in multiple currencies, to progressively build appropriate accounting records within the concepts and principles of accrual accounting.
Review sub-ledger's to distinguish how business activity is tracked, specifically by vendor and customer, in the automation of special journals for purchases/payments and sales/receipts.
Formulate methods by which errors can be detected and corrected, accounts can be reconciled and high level information can be drilled down to detailed source transactions.
Distinguish sales taxes (PST, GST & HST) and manage the requirements and obligations of businesses to account for and remit appropriate taxes generated from operational activities.
Maintain the payroll function to ensure the accurate processing of employee pay and compliance with regulatory requirements for statutory source deductions.
Produce management reports after conducting period-end functions and prepare them in spread sheet and/or word processing applications, to facilitate problem solving, decision making and the budgetary process.
Present financial statements in order to satisfy both internal and external stakeholders, including owners, managers, auditors, governments, banks and investors.

Evaluation Plan
Students demonstrate their learning in the following ways:

Evaluation Plan: IN-CLASS & ONLINE INSTRUCTION

	Module Quizzes (4 x 2.5%)	10.0%
	Weekly Assignments (10 x 2.5%)	25.0%
	Self-Study Project	25.0%
	Comprehensive Final Exam	40.0%
	Total	100.0%

Evaluation Notes and Academic Missed Work Procedure:

All graded evaluations (i.e., projects, assignments, tests, exams, etc.) must be completed according to the schedule of dates specified by the instructor.

Students unable to attend an exam or test will be allowed to defer the exam or test if such a request is made in advance of the scheduled exam or test date and the reason for absence is acceptable to the instructor.

Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:

Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) - Office of the Registrar

Not Eligible for PLAR

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.
Instruction Mode: In-class & Online Instruction
Professor: N/A
Resource(s):

	Type	Description
Required	Software	SAGE 50 Canadian Edition, Premium 2019, SAGE 50 Canadian Edition, Premium 2019. Student Version (Limited 14 Month License). Students with MAC computers will require a Windows partition. http://www.sage.com/ca/about-us/education
Required	Other	Textbook: Using Sage 50 Accounting 2019 Author: M.Purbhoo Publisher: Pearson ISBN: 9780135669143 http://catalogue.pearsoned.ca/educator/product/Using-Sage-50-Accounting-2017-Plus-Student-DVD/9780134782683.page

Applicable student group(s): CAPS Students
Course Details:

Module 1: Introduction to Sage 50 Accounting (LO's 1, 2, 7 & 10)

Getting Started

• Software Registration & Installation

• Technical Issues – Research Recommended Fixes

• Content Review – Accounting Cycle & Basic Theory

Chapter 1 - Introduction

• Managing Data Files

• Date Formats / Session Dates

• Data Back-Up & Restoration

• SAGE Interface Help Features

Chapter 2 - Sales Taxes

• Description & Administration

Module 2: General Journal & Ledger (LO's 1,3,4,6,7,9 & 10)

Chapter 3 - Muriel's Murals

• General Journal Transactions

• Adjusting/Correcting Entries

• Reporting Functions

Chapter 4 - Love it Again

• General Ledger Set-Up

• Entering Opening Balances

• Periodic Processes

2 Assignments (2.5% each), Module Quiz (2.5%)

Module 3: Accounts Payable & Receivable (LO's 1,3,4,5,6,7,9 & 10)

Chapter 5 - Groen Fields

• A/P (Purchases & Payments)

• Recurring Entries

• Adjustments & Discounts

Chapter 6 - Phoebe's Photo Studio

• A/R (Sales & Receipts)

• Recurring Entries

• Adjustments & Discounts

Chapter 7 - Air Care Services

• Sub-Ledger Set-Up

• Adding/Editing Vendors & Customers

• Linking Control Accounts

3 Assignments (2.5% each), Module Quiz (2.5%)

Project Module: Self-Study Project, Chapter #17 (LO's 1-10)

Note: the self-study project includes some learning requirements from Chapter’s 12, 13, 14 & 16, which are not assigned as part of the weekly submissions. All data and information relevant to these chapters has been provided in SLATE under the Project Module for student’s reference.

Module 4: Payroll (LO's 1,3,4,6,8,9 & 10)

Chapter 8 - Helena's Academy

• Time Sheets & Cheque Runs

• Employee Entitlements

• Statutory Remittances

Chapter 9 - Northern Lights

• Payroll Ledger Set-Up

• Entering Employee Information

• Tracking Statutory Requirements

2 Assignments (2.5% each), Module Quiz (2.5%)

Module 5: Inventory, Order Entry & Banking (LO's 1,3,4,6,7,9 & 10)

Chapter 10 - Flabuless Fitness

• Inventory Assembly

• Inventory Adjustments

• Purchase & Sales Returns

Chapter 11 - Andersson Chiropractic

• Purchase & Sales Quotes/Orders

• Purchase Pre-payments

• Sales Deposits

Chapter 15 - Tesses Tresses

• Bank Reconciliation

• Periodic Processes

• Reporting Functions

3 Assignments (2.5% each), Module Quiz (2.5%), Self-Study Project (25%), Comprehensive Final Exam (40%)

Sheridan Policies

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.

Appropriate use of generative Artificial Intelligence tools: 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.

Course Outline Changes: 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 ]