|
Auditing
Through the Computer Using ACL
Course Objective
Computer
Aided Audit Tools and Techniques (CAATS) offer auditors and Internal
Control Professionals the capability for accessing and analyzing
data on computer-based information systems, thereby realizing
the objectives of auditing in a computerized environment and meeting
the challenges of providing management with reasonable assurance
as to the secure, effective and efficient use of financial and
other equally important information assets of the organization.
This course is designed to upskill participant’s capabilities
with the use of ACL-CAATs Software in auditing through the computer.
Course Outline
. Computer
Skill for Auditors
- Hands-on Session
on Computer Operations
- Electronic File
Methods of Recording, Storage and Retrieval
- Different Types
of Files Kept in Computer and their methods of audit
- Obtaining, accessing
and managing the files to audit
- Performing the Workstation
Audit
. Introduction
to Information Technology Audit Challenges
. Overview
of Computer Database Management
. Introduction
to Windows Environment for Data Analysis
. Fundamentals
of Data Structure and File Format
. Introduction
to CAATs Environments: Exploring ACL CAATs
. ACL Fundamentals:
Projects, Input File Definitions, Expressions and Views
. Establishing
and Creating Data Directories: Importing and Linking Data Files
.
Extraction and Analysis Functions: File Stratification,
Key Field Summarization
. Working
with ACL Consolidated Data File Analysis
. Creating
Bar Charts, Obtaining Field Statistics
. Working
with Computed Fields . Data Integrity
Testing Functions
. Parallel
Testing of Various Business Operations
. Exception
Reporting: Re-calculation of COT, Interest Income,
Charges as well as recomputation
of Inventory Values
. Payroll
Audit, . Aging
of Bills and Inventory
. Gaps and
Duplicate testing in serially numbered items
. Creating
Reports: Formatting Views, Multi-line Reports and Graphing
. Development
and Writing Program Checklist
- Translating
Audit Program Steps to ACL Commands and Functions
- Simulating Data Flows and Processing
- Writing Batch Files to Capture Processes
. Automation
of Audit Procedures using ACL Audit Batches
- Understanding ACL Application
- Building Batches
- Batch Environment Settings
- Communicating Results to user group
Who
Should Attend?
The
above workshop is designed for Internal Auditors, External
Auditors, Control Executives and Professional working in Information
Security Department of his/her organization
Phase
I
Dates
Duration
Venue
Cost (N)
Jul. 16-20 5 Days
Excellence Hotel, Aguda, Ogba, Lagos
45, 500
Aug. 13-17
5 Days
Excellence Hotel, Aguda, Ogba, Lagos
45, 500
Sep. 10-14
5 Days
"
"
Phase
II
Dates
Duration
Venue
Cost (N)
Jul.
23-27 5 Days
Excellence Hotel, Aguda, Ogba, Lagos
45, 500
Aug. 20-24
5 Days
Excellence Hotel, Aguda, Ogba, Lagos
45, 500
Sep. 17-21
5 Days
"
"
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
It should
be noted however that for a complete knowledge of the programme,
the two phases are necessary. For any participant coming
for the second phase, the first phase should have been attended.
| 