PACE UNIVERSITY

 

ACC664: computer assisted audit techniques

 

Fall 2002

 

Course Outline

 

Instructor: ††††††††††† Kaustav Sen

Office:††††††††††† 484 W, One Pace Plaza, NY 10038

Telephone:††††††††††† (212) 346 1989

Email:†† ††††††††††† ksen@fsmail.pace.edu

Course URL:††††††††††† http://blackboard.pace.edu/

Office Hours:††††††††††† Monday †††††††† 11.30 am - 2.30 pm

Friday†††† ††††††††††† 4.00 pm - 5.30 pm

Prerequisites:††††††††††† ACC 661

 

Description

 

This course covers topics on computer assisted audit techniques (CAATs) and issues related to computerized auditing. Students will gain awareness of the CAATs techniques including data retrieval and manipulation techniques, parallel simulation, integrated test facility and program documentation and maintenance issues. Additionally, the course will demonstrate application of CAATs to auditing of ERP systems, in particular SAP R/3.

 

Objectives

 

After completing the course, students should be able to:

  1. Understand how to audit various computer environments.
  2. Assess general and application controls in various computer environments.
  3. Understand and apply Computer Assisted Audit Techniques.
  4. Demonstrate proficiency in the use of computer audit software.
  5. Understand the specific issues involved in the audit of a SAP R/3 system.

 

Course Materials

 

ACL Workbook

CAATs and Other BEASTs by David G. Coderre, published by ACL

SAP R/3 A Technical and Risk Management Reference Guide, published by ISACA

 

Software: ACL, SAP R/3

 

Course Delivery

 

Due to the small class size, this course is being offered as a tutorial. It will have features of both an in-class traditional course and an on-line distance learning course. A combination of this type allows us to retain the advantages that both forms offer: opportunity to interact face to face as well as allow the flexibility of course delivery offered by the internet technology. It is important to realize that unlike a traditional course, because there will be fewer lectures, you have to take the initiative to read more on your own rather than learn by listening to lectures.

 

Grading

 

The overall course grade is determined out of 100 points distributed as follows:

 

††††††††††† Assignments†††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† 20

††††††††††† Final exam††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† 30

††††††††††† Project ††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† ††50

††††††††††† Total††† ††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† 100

 

The expected grade distribution for this course is:

††††††††††† A- and higher†††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† > 90

††††††††††† B- to B+†††††††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† 80-90

††††††††††† C- to C+†††††††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† 70-80

††††††††††† D to D+†††††††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† 65-70

††††††††††† F††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††† ††††††††††† < 65

 

Internet Requirements

 

As a major portion of this class will require on-line access and communication, it is recommended that you have access to the Internet on a regular basis. The course materials will be available on the Blackboard website for this course. All announcements will be posted there as well. All assignments should be turned in electronically using the digital drop-box feature in Blackboard. All communication will done using email. Blackboard uses your Pace email to communicate. Please make sure you either check your Pace email account regularly or have set it up to forward messages to another email that you access on a regular basis. You will not be able to operate in this class without email and Internet access.††† ††

 

Students with Disabilities

 

Please contact the Coordinator of Services for Students with Disabilities in New York at 212-346-1526 if you have a disability for which you need an academic accommodation.

 

Make-up exams

 

No make-ups for midterms and finals will be allowed except in cases of genuine medical or other emergencies. In the event of such an emergency, you should contact me at your earliest opportunity to arrange a make-up.

 

Academic Dishonesty (Cheating)

 

The Pace University policy with regard to academic dishonesty (cheating) is described in the catalog, and provides penalties for students who either cheat on exams and papers, or help others cheat, ranging from reduction in grade to expulsion from the university. Anyone who either cheats on an exam, or helps another to cheat on an exam in this course will get a failing grade.

 

 


 

Class schedule

 

WeekMeet in-class††††††††††† Topics ††††††††††††††††††††††† ††††††††††††††††††††††† †††††††††††††††††††††††

 

1††††††††† Yes (09-11)††††††††††† Introduction

††††††††††††††††††††††† ††††††††††† Generalized Audit Software††††††††† ††††††††††††††††††††††† †††††††††††††††††††††††

††††††††††††††††††††††† ††††††††††† CAATs: introduction and role††††††††††† †††††††††††††††††††††††

 

2                    No (09-13)††††††††††† Fraud basics†† ††††††††††† ††††††††††† ††††††††††† ††††††††††† †††††††††††

 

3††††††††† Yes (09-20)††††††††††† ACL

††††††††††††††††††††††† †††††††††††

4. ††††††† No (09-27)††††††††††† Fraud in functional areas††††††††††††††† †††††††††††††††††††††††

 

5. ††††††† Yes (10-04)††††††††††† Data: types and layouts††††††††††††† †††††††††††††††††††††††

††††††††††††††††††††††† †††††††††††

6. ††††††† No (10-11)††††††††††† Data: retrieval and manipulation

††††††††††††††††††††††† ††††††††††† Test data preparation†††††† ††††††††††††††††††††††† †††††††††††

††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† †††††††††††††††††††††††

7. ††††††† Yes (10-18)††††††††††† Strategic Risk Mgt ††††† ††††††††††††††††††††††† †††††††††††††††††††††††

ERP Audit Approach ††††††††††† ††††††††††† ††††††††††† ††††††††††† †††††††††††

8. ††††††† No (10-25)††††††††††† Audit Programs and ICQs

  Revenue

  Expenditure

  Inventory

††††††††††††††††††††††† †††††††††††

9. ††††††† No (11-01)††††††††††† CAATs: basic analysis††††††††††††††††††††††† †††††††††††

 

10. ††††† Yes (11-08)††††††††††† CAATs: detailed analysis†††††††††††† †††††††††††††††††††††††

††††††††††††††††††††††† ††††††††††††††††††††††† ††††††††††††††††††††††† †††††††††††

11.              No (11-15)††††††††††† CAATs: advanced analysis ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† ††††††††††† †††††††††††

12. ††††† Yes (11-22)††††††††††† Digital Analysis

  Benfordís Law†††††††† †††††††† †††††††† †††††††† ††††††††

  Digital Tests †††††††† †††††††† †††††††† †††††††† ††††††††

  Cases and Applications †††††††† †††††††† †††††††† ††††††††

 

13. ††††† Yes(12-04)††††††††††† Computer Audit Strategies

††††††††††††††††††††††† ††††††††††† Additional Topics

 

14.†††††† Yes (12-11)††††††††††† Exam