Instructor: Dr. DAT- DAO NGUYEN Office: JH 3221 (Juniper Hall / College of Business Building) Office Hours: Tuesday from 5:30 PM to 6:30 PM or by appointment e-mail: datdao.nguyen@csun.edu Web page: http://www.csun.edu/~dn58412/
Class Number Time Location 13435 Tuesday 7:00 PM - 9:45 PM JH 2212 from OCT 25 o DEC 13
This graduate course provides a survey on business contexts - specifically major business processes/ accounting cycles - and methodologies for developing effective, efficient information systems for the business. The course intends to equip accounting professionals / business managers with the knowledge on Systems Development Life Cycle so that they understand the works of their IS counter-parts in providing information systems for the core activities in their companies. The IS professionals also benefit from the course with the knowledge on business contexts and user requirements of the systems to be developed. Ultimately, the course provides a common ground for the co-operations among systems stakeholders to warrant an effective and efficient information system to capture, process, and report quality information for business decision makings.
On completion of this course, students will be able to understand and apply the following key concepts/issues in Accounting Information Systems:
In today’s business environment, an accounting professional is no longer a conservative person sitting in the back office and trying to keep accounts balanced. A modern accounting professional becomes a critical source of internal and external business information to other managers for making effective, efficient decisions at all corporate levels to gain competitive advantage for their business. Consequently, the accounting professional should understand information requirements of the core business processes and how to implement an information system (IS) with cutting-edge information technologies (IT) to record, process, and report quality business data. As a business manager, an accountant should not simply get output from an information system, but he/she must also understand how data have been processed properly without errors and frauds. A professional equipped with solid knowledge on a modern accounting information system will be a key player to work effectively with other managers and field specialists in the process of defining selecting, and deploying appropriate information systems for the business.
This course provides graduate students with an understanding of requirements, design, and control of major business processes/accounting cycles integrated in an enterprise system. Topics include Systems Analysis and Design methodologies and techniques for Accounting Information System (AIS) development, issues in control and audit of systems fraud and abuse, and controls for systems reliability.
Required class work includes individual Class Journal reports and assignments on Systems Modeling with Microsoft Access, Excel, and Quickbook Accounting.
Owen (2015). Using Quickbooks Accountant 2014. Cengage Learning. (ISBN: 9781285183428) [The text should have a trial version of Quickbooks Accountant 2014 on CD.]
Additional materials will be posted / distributed in class.
An USB thumb-drive to save your class hands-on (large Excel, Access, and Accounting data files)
Three blank CD's (or DVD's as needed) to save and submit your assignments
Adamski, Finnegan & Scolland (2014). New Perspectives Microsoft Access
2013 Comprehensive. Course Technology. ISBN 978-1-285-09920-1
Parson et al. (2014). New Perspectives Microsoft Excel 2013 Comprehensive. Course Technology. ISBN 978-0-285-16933-0
Due to the accelerate format of the class, there are 7 in-class meetings and 1 compreshensive exam session. Students are responsible for reading class materials on their own. A typical meeting includes a brief review of major / difficult topics in the assigned lecture materials then most of the class time will be hands-on AIS modeling with Microsoft Acess Excel, and Quickbook Accounting.
The Comprehensive Exam part on Accounting Information Systems at the end of the course is not part of the class work, but it will contribute credit to the Comprehensive Exam Requirement of the MSA degree.
Conceptual Foundations of Accounting Information Systems @ 10/25, 11/01
Additional Materials :
- Owen's Quickbooks Accountant: Chapters 1-5 (Getting used with Quickbooks functionality and data file)- Homework for practice only - NOT FOR GRADE
- Gelinas Text: CentralRisk (former Millennium) Insurance Company (p.136) - Preprare Data Flow Diagram (Hand-drawing Gane & Sarson Notations: Table of Entities, Context Diagram, Level-0 DFD, Level-1 DFD's) - Submit with Class Journal Packet
- Access 2010 Database Sample for hands-on in class : BrokerHouse2010 and BrokerHouse2010 Play List
Instruction for download DB: (Don't open it in browser.) Use Firefox: Right click link > Save Link As ... > Save as type : All Files
JOURNAL PACKET 1 (Lecture 1-4) due on 11/08
AIS Applications & Hands-on with Microsoft Excel / Access / Quickbook Accounting @ 11/08, 11/15
Additional Materials:
ACCESS ASSIGNMENT (Posted on Moodle): Assign 11/08, Due 11/15
- Gelinas Text: Ch.12- Case A: PureProduct (former Bondstreet) Company (p.490) : Do Problems P 12-1, 12-2 (p.491): Logical DFD (Gane & Sarson Notattions: Table of Entities, Context Diagram, Level-0 DFD, Level-1 DFD's), Control Matrix for DFD- Submit with Class Journal Packet
JOURNAL PACKET 2 (Lectures 5-8) due 11/22
Accounting Information Systems Development Process @ 11/22
Additional Materials:
EXCEL ASSIGNMENT (To be posted on Moodle): Assign 11/22, Due 11/29
Control and Audit of Accounting Information Systems @ 11/29
Additional Materials:
QUICKBOOK ASSIGNMENT (Posted on Moodle): Due 12/06
JOURNAL PACKET 3 (Lectures 9-10) due 12/06
Make-up and Class Briefing @ 12/06
COMPREHENSIVE EXAM @ 12/13 from 7:00 PM to 8:15 PM in JH 2129 (College Lab).