Aud 3 Audit And Information Technologies

Front 1

Database Admin

Back 1

 Maintains database
 Restricts access
 Responsible for IT internal control

Front 2

Systems Analyst

Back 2

 Recommends changes or upgrades
 Liaison between IT and users

Front 3

Librarian

Back 3

o Responsible for disc storage
o Holds system documentation

Front 4

What Generalized Audit Software does

Back 4

o Uses computer speed to quickly sort data and
files, which leads to a more efficient audit
o Compatible with different client IT systems
o Extracts evidence from client databases
o Tests data without auditor needing to spend time
learning the IT system in detail
o Client-tailored or commercially produced

Front 5

Structured Query Language (SQL)

Back 5

o Relational database
 Group of related spreadsheets
 Retrieves information through Queries

Front 6

Test Data Method

Back 6

o Auditor processes data with client’s computer
o Fake transactions are used to test program control
procedures
o Each control needs to only be tested once
o Problem
 Fake data could combine with real data

Front 7

Parallel Simulation

Back 7

o Client data is processed using Generalized Audit
Software (GAS)
o Sample size can be expanded without significantly
increasing the audit cost
o GAS output compared to client output

Front 8

Advantages of using Generalized Audit Software

Back 8

1. Independent of client's program and personnel
2. Less computer expertise is needing compared to writing original programs
3. It can run on a variety of systems

Front 9

Disadvantages of using Generalized Audit Software

Back 9

1. May only process only sequential files
2. Modifications may be necessary for specific audit
3. Audit software cannot examine items not in machine-readable from
4. It has limited application in an online, real time system

Front 10

Integrated Test Facility

Back 10

Auditor creates dummy record within client's actual system
Advantage - Actual program in operations
Disadvantage - Coordination and purge dummy transaction

Front 11

Embedded Audit Module

Back 11

Integral part of application system that is designed to identify & report actual transactions & other info that meet criteria having significance
Advantage - Permits continuous monitoring of online; realtime
Disadvantage - Audit hooks must be programmed