SMS315 - Systems Studies II

Outline info
Semester
School
Last revision date 2017-11-20 15:22:51.163
Last review date 2017-11-20 15:22:52.858


Subject Title
Systems Studies II

Subject Description
This course continues the study of the tools and techniques of computer systems studies. SMS315 involves using an accounting software package to record accounting transactions and generating financial statements from the accounting software package.  Furthermore, the course introduces the students to contemporary information systems concepts.

Pre-requisites: ACC220 and SMS216 or SMS213
Co-requisite: EAC150
Equivalency: SMS311

Credit Status
For information regarding exemptions for courses included in CPA’s Advanced Certificate in Accounting & Finance (ACAF) program please see https://www.gocpaontario.ca/Content/Attachments/Seneca%20College.pdf

Learning Outcomes
Upon successful completion of this subject the student will be able to:

A.   Set up and use an accounting software to process accounting transactions. This can be demonstrated by:
a) Explaining the use of the toolbars and icons
b) Completing account maintenance activities
c) Using the enquiry function to locate selected information
d) Using the report generator of the accounting software to prepare customized reports for analyses
e) Using the export functions of the accounting software to export data to Excel files
f) Processing transactions of major accounting cycles such as
1.transactions relating to the sales (revenue) cycle
2.transactions relating to the purchase (expenditures) cycle
3.transactions relating to the payroll cycle
g) Competing month-end and year end closing procedures, including adjusting entries and setting up a new accounting fiscal year
h) Printing financial reports from the sample companies (data files)
i) Applying features of the accounting software to implement effective and efficient internal controls.
j) Setting up a new company

B. Demonstrate their understanding of contemporary information systems: in
a) Discussing the concepts of information systems.
b) Discussing the foundation of computer systems.


Students are required to use critical thinking and problem solving skills, in addition to the technical skills using an accounting software, to complete the tests.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

Prerequisite(s)
ACC 220 and SMS216 or SMS213

Topic Outline

WEEK LAB TOPICS CHAPTER
1   Introduction
Installation and Backup / Restoring
App B and App A
2   System Manager Ch 1
3   GL Set up
Chart of Accounts
Ch 2
Ch 3
4   GL Opening Balances
GL Daily Transactions
GL Display Account Transactions
Ch 4
Ch 6
Ch 7
5   Bank and Tax services Ch 9
6   Test #1 (90 minutes)
 
Accounts Payable set up
Ch 1, 2, 4, 6 and 7
 
 
Ch 10
7   A/P Vendor Maintenance
 
A/P Opening Balances & Current Year Transactions
Ch 11
 
Ch 12
8   A/P Adjustments
 
A/P Payment Entry
Ch 13
 
Ch 14
9   Test #2 (90 minutes)

Account Receivable Setup
 
Ch 9 to 14

Ch 16
10    AR Customer Maintenance
 
AR Opening Balances & Current Year Transactions
 
A/R Adjustment Processing
 
Ch 17

Ch 18

Ch 19
11   A/R Receipts Processing
 
A/R Periodic Batch Processing
 
A/R Periodic Processing / Month End
Ch 20
 
Ch 21
 
Ch 22
12   A/P Periodic Processing / Month End
 
Bank Reconciliation (Ex 15-8 and Ex 22-8)
 
G/L Month End Procedures
Ch 15
 
Ch 15 and Ch 22
 
Ch 8
13   Comprehensive Test #3 (120 minutes) Ch 1 to 22, except Ch 5
14 - EXAM WEEK    -
Subject to change, please check the posting on BlackBoard regularly.

Mode of Instruction
Weekly:  One lab period for hands-on practice assignments and lab tests. 

Note:     The lab period is not sufficient to complete the required computer practice exercises. 
              Students are expected to use the open computer labs or use their own resources for additional computer time.

Prescribed Texts
Text: Using Sage 300 -- ERP 2014
Author: Christine Heaney

Publisher: Pearson Education Canada
ISBN: 9780134063973

Reference Material
Seneca Libraries. Guide to Research and Citation: MLA Style. Latest Edition,. Toronto: Seneca College,.

Required Supplies
(Minimum) 2 Gb USB Flash Memory

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
OR
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.


Modes of Evaluation

Topic Test 1#*   30%
Topic Test #2*   30%
Comprehensive Test #3*   40 %
TOTAL 100%

* There is NO final examination in this subject.

Dates of tests are indicated in the weekly calendar.  There are no make-up tests, so special arrangements, if warranted, must be arranged with the professor before the scheduled date.

Term tests and Lab Tests

Evaluations are set at Level 2 (Comprehension) and Level 3 (Application) of Bloom’s Taxonomy to challenge a student’s problem solving and critical thinking skills, as well as when and how to use the most appropriate software function in a given situation. The evaluations shall consist of some non-directive questions, using a problem solving approach.

Test dates are noted in the “Detailed Course Outline”, subject to change as deemed necessary by the Professor.  There is no makeup test. If you have a medical reason immediate prior to or on the date of the test, you will need to present a medical document, in a prescribed format, to the Professor. Please remember this information will be validated and if found to be false, this will be deemed as an act of Academic Dishonesty.  

NOTE:  Assuming SeneLAB Tools is used in the computer labs:

SeneLAB Tools, a software application developed by Seneca College, is used to administer tests in the business computer labs.  The student will ensure that;
1.        he/she can properly download and upload files using SeneLAB Tools,
2.        he/she has uploaded (submitted) his/her answer(s), as required, using SeneLAB Tools, and
3.        the files (answers) uploaded are not corrupted.
  •  No assistance will be available in this respect during a test.
  • If the files (answers) that a student uploads are not as required or corrupted, the test will not be marked resulting in a zero and there is no make-up test.

It is required that test files are uploaded on time at the end of a test.  Late submissions will not be accepted.

Program Coordinator
Cynthia Duncan

Approved by: Academic Program Manager - Business Studies Danielle Mercier