ACCG3009
Accounting Information Systems 1
Sheridan College Logo
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2003
Prerequisites: N/A
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Program(s): Business Admin - Accounting
Program Coordinator(s): Multiple Coordinators
Course Leader or Contact: Barbara Eddy
Version:
9.0
Status: Approved (APPR)

Section I Notes: Instructional Format: Where a mobile class is not available, the course will be scheduled as 1 Hour in Lab; 2 Hours in Class

 
 
Section II: Course Details

Detailed Description
This course introduces the students to the concepts of MIS, Management Information Systems, focusing on AIS, Accounting Information Systems, and the use of databases for management decision-making. Practical experience will be gained from learning Access2000 and planning a database for a business organization. Lecture, lab, and independent study components characterize the learning.

Program Context

 
Business Admin - Accounting Program Coordinator: Multiple
This course is a core component of the third year of the Accounting Program. Program Coordinators: Donna P. Grace (Davis) Alison Feierabend (Trafalgar)


Course Learning Outcomes
Learning outcomes identify the critical performances, and the knowledge, skills and attitudes that successful students will have reliably demonstrated through the learning experiences and evaluation in the course. Successful students will have demonstrated the following:

 
 
            Knowledge
			
- an understanding of what MIS (Management Information Systems)/AIS 
  (Accounting Information Systems) are and their importance importance 
  to the organization
- ability to identify the six (6)stragegic information processing 
  systems and how they relate to management decision making
- knowledge of the steps and information processes involved in the   
  revenue and expense cycles
- ability to describe how a DBMS (Database Management System)is 
  structured and how it functions
- identification of the 5 moral dimensions of the Information Age and 
  descibe some pressing ethical issues in key information technology  
  trends
 
            Skills
			
- ability to flowchart simple information retrieval and dissemination 
  processes
- use of Access2000 to create a database and its components: tables, 
  queries, forms and reports
- ability to link two or more tables in a one-to-one or one-to-many 
  relationship
- import data from other Microsoft software, principally Excel and 
  Word
- devising solutions to a business problem using a database to manage 
  an aspect of an organization's information needs
 
            Attitudes
			
- Commitment to thorough problem analysis processes and the 
  development of actionable business solutions.
- Responsibility in attending, participating, and learning in the 
  classroom, in meeting test and assignment due dates, and fulfilling 
  the objectives of the independent study component of the course.
- Respect and cooperation towards instructors and other students in 
  the course.
- Commitment to the production of high quality computer generated 
  assignments.
Evaluation Plan
Students demonstrate their learning in the following ways:

 
Tests: Three tests @ 25% each                    75%
Flowcharting Assignment:                         10%
Database Assigment:                              15%
_____________________________________________________

Please Note:

While every attempt will be made to keep this schedule, weather 
college closures and other unforseen events may necessitate 
modifications.  At least one week's advanced warning will be profided 
of the new date and time and this information will be posted in 
Disucssions for this course in WebCT.  The instructor reserves the 
right to set the date upon consultation with students attending the 
next available class.  Any conflicts arising from the new date can be 
discussed on an individual basis with the instructor.  

No supplemental testz will be provided unless the request is 
accompanied with a valid medical or legal certificate.  Late 
assignments are penalized by 20% per day, weekends included.

Full participation and attendance is recommended for this course.  
Students who miss a class are reaponsible for any information 
discussed, assigned or distributed in that class period.

Mid-term and Final Term Tests and the term project due dates will be 
assigned at the beginning of the semester.  The instructor reserves 
the right to have unannounced (spot) quizzes and assignments to a 
maximum value of 15%.

Full participation and attendance is recommended for this course.  
Students who miss a class are responsible for any information 
discussed, assigned, or distributed in that class period.
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Generic Skills
Generic Skills emphasized in the course:

X communication - written   communication - oral   communication - visual
  analytical   creative thinking X decision making
X interpersonal X numeracy   organizational
X problem solving   technological X other (see below)

Notes: Computer literacy, Critical thinking.

General Education
This General Education course relates to the following themes as specified by the Ministry of Training, Colleges and Universities.

  asthetic appreciation   social understanding
  civic life   understanding science
  cultural understanding   understanding technology
  personal development   work and the economy

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):

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 2003
Professor: Multiple Professors
Textbook(s):
AIS Lecture Text:  Core Concepts of Accounting Information Systems, 
8th Edition by Stephen A. Moscove, Mark G. Simkin, Nancy A. Bagranoff

ISBN 0471072907

Lab Text:  Essentials, Access 2000 Basic, Prentice Hall, New Jersey 
, 2000, by Robert Ferrett, John Preston, Sally Preston,

Applicable student group(s): Business Administration - Accounting
Course Details:
Topical Outline

Week One:    Introduction to Accounting
             Information Systems (AIS)
             Technology
           
             Reading:
             
             Web CT material and a handout: Ch.2 The Technology of     
             Accounting Information Systems

Week Two:    Documenting AIS
             Document Flowcharts

             Reading:
           
             Handout: Chapter Three
             Documenting Accounting Information Systems
 
Week Three:  Documenting AIS
             Data Flow Diagrams

             Reading:
             
             Chapter Three - as above

Week Four:   Transactions Processing Cycles
             The Revenue Cycle
             The Expenditure Cycle

             Reading:

             Web Notes: See lesson notes in WebCT

             Assignments Due:  

             Flow Chart Assignment

Week Five:   Review

             Test 1 on material from weeks 1 through 5

             
Week Six:    Computer Crime and Ethics

             Reading:

             Handouts and Web Materials


Week Seven:  Overview of Systems Development

             Reading:  Handout and Web Materials


Week Eight:  Access 2002
             Introduction
             Tables

             Reading:  Tutorials 1 & 2
             Pages 1.03 - 1.26 and 2.01-2.34


Week Nine:   Access 2002
             Querying A Database

             Reading: 
             Tutorial 3, Pages 3.01 - 3.41

Week Ten:    Access 2002
             Creating Forms
             Creating Simple Reports
             
             Reading:

             Tutorial Four
             Pages 4.01 - 4.34
             Web Materials

             Test 2


Week Eleven: Creating a Relational Database
             Establishing relationships between tables using REA
             Model

             Reading:

             Appendix RD 1 - RD 21
             Material on WebCT

Week Twelve: Access 2002
             Creating advanced queries
             Creating advanced forms

             Reading:

             Tutorial Five
             Pages 5.03 - 5.58

Week 
Thirteen     Access 2002
             Creating Custom Reports

             Reading:  

             Tutorial Six
             Pages 6.01 - 6.47

             Database Assignment Due

Week
Fourteen:    Review
             Final Test on Material from weeks 7-13

             Test 3


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.