Learning
objective |
Activity |
Resources |
In class Tuesday October 23 |
|
- Develop assurance
objectives for risks of information systems.
- Design assurance
procedures.
- Implement assurance
procedures with software tools.
- Communicate assurance
results.
|
Debrief
Threadchic
- Hazard of relying
on an existing audit program, especially one developed for manual execution
- Importance of
well-formed audit objectives implemented with audit procedures and queries
consistent with the objectives. Consider these audit objectives:
- Verify that
payments are for actual purchases
- Verify that
invoice amounts match payment amounts
- Verift payment
for purchases
- Inspired by real-world
events
- Increasing demand
for "out-of-the-box" thinking
- Integration of
financial and IT auditing
Shift in recent years from this kind of analysis being the preserve
of IT auditors to it becoming more commonplace among auditors
- New auditing
standards giving auditors more responsibility for detecting fraud
- SOX mandate
for internal control assessments
|
Threadchic
Assertion-based auditing
standards:
- Pre-SOX: AU326
- Post-SOX:
- SAS
106
- AS
5
Analytical procedures:
- Auditing
Standard AU329
- Applications
CAATs:
- Toolbox
at Sara Lee
- SQL
at State of Minnesota
- Accounts payable
procedures
- Software tools
- p.
56
- p.
58
- p.
59
- p.
60
- p.
61
- p.
62
|
- Develop assurance
objectives for risks of information systems.
- Design assurance
procedures.
|
Consider
system development and change control pitfalls: Recognize signs of failing
projects
- System development
life cycle (SDLC) methodologies (the way organizations go about developing
information systems) range from nothing to a lot of process, e.g., the
process for the U.S.
Department of Justice. Why?
- Does the project
from hell have any similarities with CONFIRM?
- Why did CONFIRM
fail but Sabre was successful in rebuilding its reservation system?
- How do risks and
system development audits differ for systems developed iteratively (synch-and-stabilize)
and with sequential (waterfall, e.g., U.S.
Department of Justice) methodology?
- The wages
of inadequate testing can make the case for testing better than
exhortations to adhere to sound testing practices.
- Given that system
capacities are fixed, why do organizations like Comair
and Beth Deaconess
Medical Center persist in ignoring the need to increase capacity
to accommodate use?
|
System
development
- Sequential: U.S.
Dept. Justice
- Iterative: Synch-and-stabilize
- Configuration
management
- Testing
- Levels
of testing
- Wages
of inadequate testing
- Automated
testing tools
- Change management
- Hunton pp.
83-85
- Change
control
Failures (from which
we learn if we pay attention)
- Project
from hell
- CONFIRM
- Comair
- Beth
Deaconess Medical Center
Success: Sabre: 3/29/04;
5/31/04;
1: 6/7/04;
2: 6/7/04
|
- Develop assurance
objectives for risks of information systems.
- Design assurance
procedures.
- Implement assurance
procedures with software tools.
- Communicate assurance
results.
- Collaborate with
others to achieve these objectives.
|
Organofood
case
- Interview Derilo
to find out how Organofood develops and maintains its information systems
- XP
(eXtreme Programming)
- Authorization
- Answer readiness
questions for the case
- Work in teams
|
Organofood
|
|
- Develop objectives
for system development audits.
- Justify priorities
for system development audits.
- Explain objectives
and priorities convincingly to management.
- Develop rationales
for system development audits even when interest is scarce.
|
Explore
the wages of inattention to installing ES (enterprise systems)
- Early experiences
with ES: What is the predominant development flaw?
- Doomed from
the beginning: FoxMeyer ordeal
and aftermath
- Even though
FoxMeyer didn't have the transaction volume of Visa's VisaNet processing
system, could FoxMeyer's development team have profited by knowing
about how
Visa does volume testing?
- Weak earnings
associated with SAP implementations
- Grainger
- Hershey:
Wall
Street Journal; Computerworld one,
two,
three;
CIO
- Jo-Ann
Stores
- Nestlé
- Nike
- Thomas
& Betts
- Volkswagen
- Whirlpool
- How can CAAT techniques
and tools be applied to auditing ES systems like SAP? (Kennametal
example; extracting
data)
- More recent experiences
with consolidating legacy systems onto a single platform
- What did Cigna
fail to do?
- How did Celanese
manage the challanges of consolidating systems?
- When ERPs enable
more integrated views of company results, flaws in prior legacy systems
may come to light: CP
Ships Ltd.
|
- Develop assurance
objectives for risks of information systems.
- Design assurance
procedures.
- Implement assurance
procedures with software tools.
- Communicate assurance
results.
- Collaborate with
others to achieve these objectives.
|
Organofood
case
In your team, work
on an audit program for the Organofood audit that you implement by querying
the database and whose results you communicate in this report.
Name the files as
follows :
- The audit program
and results in a .htm file with the name:
11-OrganofoodAudit.htm
- .mdb files containing
queries implementing the audit program with the names:
11-OrganofoodTestdataQueries.mdb
11-OrganofoodProgLibraryQueries.mdb
|
- Organofood
- Glimpses into
development audits:
- Information
flow
- Access
control
- Lack
of integration
- System development
- Hunton pp.
69-90
- Configuration
management
- Testing
- Levels
of testing
- Wages
of inadequate testing
- Automated
testing tools
- Change management
- Hunton pp.
83-85
- Change
control
- System failure:
Project
from hell
|