APPL70070
Computerized Accounting Processes |
|
|
|
I: Administrative Information II: Course Details
III: Topical Outline(s) Printable Version |
|
Section I: Administrative Information
|
|
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2013
Prerequisites:
(ACCG70016)
Corequisites:
N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A |
Program(s):
Accounting
Program Coordinator(s):
Multiple Coordinators
Course Leader or Contact: Multiple Course Leaders
Version: 1.0
Status: Approved - Under Rev (AREV)
Typical Instructional Format
Distance Education
|
42.0 |
Total hours: |
42.0 |
Courses may be offered in other formats.
Section I Notes:
All Students: This course is delivered using Sheridan's web-based
learning management system SLATE. SAGE, the software vendor, has
licensed the use of a student version of Simply Accounting Premium
2011, for 14 months.
This course is offered both in a classroom version and an online
version Continuing Education: In the classroom version students
attend regularly scheduled traditional classes (3 hours face-to-
face), in a lab classroom, using Sheridan's computers. OPTIONAL; it
is advantageous for student's to have access to their own computer
for the completion of assignments, however, 'open access' labs are
available on campus. In the on-line version students complete the
course, off-campus, submitting all assigned work electronically.
Students are required to have access to a computer and reliable
internet service, as well as basic knowledge using a PC with a
Microsoft Operating System, a Web Browser and MS Word/Excel. To be
successful in an on-line environment, students require self-
discipline to work independently.
|
|
|
Section II: Course Details
|
Detailed Description
Students complete computerized accounting cycles for a variety of
organizations using SAGE, Simply Accounting. Exposure to components
in this accounting suite include; General Ledger, Accounts Payable,
Accounts Receivable, Payroll and Inventory. Functionality related to
System Set-up, Sales Taxes, Banking, Periodic Processing and
Financial Reporting are also explored.
Students are introduced to the tools and administrative functions
within a Simply 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 processes of an accounting
system and its inherent internal controls that maintain data
integrity for audit purposes.
Through interactive discussions, case studies and targeted
deliverables, a key stroke approach develops the student¿s ability
to apply computerized accounting techniques to each step of the
accounting cycle.
Program Context
|
Accounting |
Program Coordinator: Multiple |
This is a core course in the
Accounting, Bookkeeping and
Tax Certificate(s) offered
through the Faculty of
Continuing and Professional
Studies.
|
Course Critical Performance and Learning Outcomes
|
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
Simply Accounting, including a complete set of financial statements
that accurately reflect the financial position of the business in
accordance with Canadian generally accepted accounting principles
(GAAP).
2. Utilize a reliable database by performing administrative functions
to ensure the routine maintenance of data stability, such as backups
and adhering to internal controls, in order 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 and process
adjustments, reversing and recurring entries, account reconciliations
and tax summaries.
4. Record a multitude of business transactions 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
both payment processes (cash disbursements) and billing processes
(cash receipts).
6. Formulate methods by which errors can be located and corrected,
accounts can be reconciled and high level information can be drilled
down to locate detailed source transactions.
7. Distinguish sales taxes (specifically 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 and timely
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 and decision making.
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:
|
In-Class & On-Line Delivery
Quizzes 10%
Assignments 20%
Project (Modules 2,3,4) 30%
Comprehensive Final 40%
Total 100%
Notes: Instructor will provide students with written details of the
evaluation plan, within their class.
|
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
|
|
Critical Thinking & Problem Solving
|
|
Interpersonal
|
|
Numeracy |
|
Information
Management |
|
Personal
|
Notes: N/A
Prior Learning Assessment and Recognition
PLAR Contact: Registrar's Office
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
|
|
|
|
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.
Effective term: Fall 2013
Professor: Multiple Professors
Textbook(s): Textbook: Using SAGE Simply Accounting Premium 2011, M. Purbhoo
(Pearson Publishing)
Software: Simply Accounting Premium 2011, Student Edition (Limited
License)
Applicable student group(s): On-line and In-Class students in the Faculty of Continuing and
Professional Studies.
Course Details:Module 1: Introduction to Simply Accounting (LO's 1,2,7 & 10)
Getting Started
Text Preface - Software Installation
Technical Issues - Recommended Fixes
Content Review - Accounting Cycle & Basic Theory
Chapter 1 - Introduction
- DVD Data Files
- Date Formats
- Data Back Up
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 Entries
- Reporting Functions
Chapter 4 - Toss for Tots
- General Ledger Set-up
- Chart of Accounts
- Linking Control Accounts
Module 3: Accounts Payable & Receivable (LO's 1,3,4,5,6,7,9 & 10)
Chapter 5 - Chai Tea Room
- A/P (Purchases & Payments)
- Recurring Entries
- Adjustments & Discounts
Chapter 6 - Air Care Services
- A/R (Sales & Deposits)
- Recurring Entries
- Adjustments & Discounts
Chapter 7 - Dorfmann Design
- Sub-Ledger Set-up
- Adding/Editing Suppliers & Customers
- Reporting Functions
Module 4: Payroll (LO's 1,3,4,6,8,9 & 10)
Chapter 8 - Helena's Academy
- Payroll Journal Transactions
- Adjusting Entries
- Reporting Functions
Chapter 9 - Lime Light Laundry
- Payroll Ledger Set-up
- Entering Employee Information
- Tracking Statutory Requirements
Module 5: Inventory & Banking (LO's 1,3,4,6,7,9 & 10)
Chapter 10 - Adrienne Aesthetics
- Inventory Purchase & Sales
- Inventory Adjustments
- Purchase & Sales Returns
Chapter 15 - Tesses Tresses
- Bank Reconciliation
- Period-end Procedures
- Reporting Functions
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.
|
|
[
Printable Version ]
|
Copyright © Sheridan College. All rights reserved. |