ACAF70052
Accounting Software Application
Sheridan
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
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:

  1. 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.
  2. 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.
  3. 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.
  4. Record business transactions, in multiple currencies, to progressively build appropriate accounting records within the concepts and principles of accrual accounting.
  5. 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.
  6. 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.
  7. 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.
  8. Maintain the payroll function to ensure the accurate processing of employee pay and compliance with regulatory requirements for statutory source deductions.
  9. 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.
  10. 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 Project25.0%
 Comprehensive Final Exam40.0%
Total100.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):
 TypeDescription
RequiredSoftwareSAGE 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
RequiredOtherTextbook: 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

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity 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 professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting 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, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

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. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. 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.