Reservations may be
made for Individual Webinars at a cost of US$ 59 each
This webinar
series is designed t
o
bring you a structured learning curriculum for CaseWare IDEA version
10 andisconducted in conjunction with
AuditNet®. You
may register for the series by registering below and will be
automatically registered on each of the weeks
individually. Please ensure that you log on to the individual modules to
attend on the email reminder you will be sent. For payment, please contact us if you do not use paypal. Where more than
1 delegate are booked on courses a 10% discount will be granted. If more
than 7 are booked on a course a flat fee will be applied. Please contact
us for pricing at
info@rcascarino.com.
Webinar Leader
Richard Cascarino, CIA, CISM, CFE, CRMA is a consultant and lecturer with over
28 years experience in IT Risk, Audit, Governance, Forensic, Internal
and IT auditing education and author of the
books Internal Auditing-an
Integrated Approach, Auditor’s Guide to IT Auditing,
Corporate Fraud and Internal Control and the forthcoming book
Internal Auditor's Guide to Data Analytics. He is also a
contributing author to the Governance section of Finance: The
Ultimate Resource and is a frequent speaker at IIA and ISACA
courses and conferences.
He is a Past President of the IIA – South Africa and founded the African
Region of the IIA Inc.
About the Series
The IDEA Series is a series of 12 x 2-hour webinars.
Who should attend
The series is aimed primarily at auditors, both
internal and external, who are beginning their career in Computer
Auditing or who wish to understand how to use IDEA. The series builds
rapidly to shorten the time period to productivity and effectiveness.
Cost $59 (2.0 CPE) each or the complete series
of 12 for $599 (24.0 CPE)
CPE Credit Policy and Attendance
Report
CPE Credit Policy:
Participation and attendance reporting is the basis for determining
whether Continuing Professional Education (CPE) credits will be issued
for participation in AuditNet® webinars.
Pursuant to National Association of State Boards of Accountancy (NASBA)
rules, AuditNet® is required to maintain records showing an individual’s
attendance and participation in an online webinar. During the
presentation, periodic online questions and answers will be used to
assess continuous participation and to evaluate the program's
effectiveness.
Participation and Attendance Reporting Requirements:
Registration is on a per-person basis. To qualify for CPE credit, you
must be registered for the webinar as an individual and login
individually, except as provided below for participants attending in a
conference setting.
Click Here to:
Register for
the whole series or Click on the individual webiners to register
separately. Click below to pay for the whole series or under each
webinar to pay separately.
This
first course will get you off to a quick start in utilizing IDEA. While
basic techniques and data importing are covered, practical knowledge
that can be used immediately will also be included.
The
specific learning topics are:
Use
basic IDEA functions and features including creating and using a
project file
Learn
to define IDEA Audit Objectives
Assess what data is needed for reports and preparing a data request
Date: April 15 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
This
course will teach you to import, combine, and define various types of
data into IDEA SoftwareTM and understand the difference
between the tables and implications for the import process.
The
specific learning topics are:
Importing a number of different data types and formats
Access the Import
Assistant Select the File to Import
File Type
Specify Record
Length
Specify Field
Delineators
Field Details
Create Fields
Import Criteria
Date:
April 29 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
This
course covers the major functions which are in everyday use by the
auditor in any use of IDEA and which form the basis of advanced audit
techniques.
The
specific learning topics are::
Summarizing the
Data
Stratifying the
Data
Viewing the Results
Graph
Creating a Pivot
Table
Joining Databases
Reviewing the
History
Using Display All
Records Containing
Performing a Record
Extraction
Identifying
Duplicate Invoices
Identifying Gaps in
an Invoice Number Sequence
Performing a Key
Value Extraction
Performing a Record
Extraction Using an @Function
Date:
May 6 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500))
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
In today's environment the audit department is frequently judged on the
quality of its primary output, the Audit Report and this can affect the
perception of the professionalism of the whole department. In many cases
the effectiveness of the audit itself can be affected by the
non-acceptability of the Audit Report. As such, it is critical that the
report is perceived to be professional and communicate the desired
message in a clear, concise and unambiguous way. This course covers the
formation of professional reports using IDEA. ;
The
specific learning topics are:
Designing a Report
Report Assistant
Headings Step
Define Breaks Step
Report Breaks Step
Grand Totals Step
Header/Footer Step
Date: April 29, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
In some
cases the only source of data is an already printed report of an
electronic version of such a report. This course covers the importation
of such data into an analyzable form.
The
specific learning topics are:
Examine the Data
and its Layout
Select a Sample
Line and an Anchor Line
Define a Trap
Define Field
Anchors
Save the Layer
Scan for Errors
Preview the
Database
Create an Append
Layer
Rearrange the Field
Order
Saving the Template
Date: June 10, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / Nonee
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
The
power of IDEA lies in the ability to interrogate large volumes of data.
In some cases, the computer is used only to narrow the field of records
the auditor may wish to perform more detailed testing upon. Under these
circumstances, the auditor may choose to use statistical sampling
techniques.
The
specific learning topics are::
Stat
versus non-stat sampling
Variable vs Attribute sampling
Monetary unit sampling
Learn
to use Field Statistics, within IDEA
Random selection of records for examination
Date: July 8, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / Nonee
Basic Delivery Method: Group Internet Based
IDEA’s
Advanced Statistical Methods can be used by analysts as a component of a
continuous monitoring set of routines. Depending on the nature of the
functional area the analysis may take a variety of forms.
The
specific learning topics are::
Correlation Analysis
Trend Analysis
Time Series Analysis
Date: July 22, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / Nonee
Basic Delivery Method: Group Internet Based
Basic
concepts of script writing and benefits of automating your data projects
will be covered in this IDEA course. IDEA includes a development tool
known as IDEAScript for creating macros to extend the functionality of
IDEA. IDEAScript can be recorded, written from scratch, or a combination
of both.
Developing scripts and implementing best practices will show you how to
increase the efficiency of your data analytics projects by analyzing
transaction sets on a regular basis. And by facilitating the running of
pre-prepared scripts by less experienced auditors..
The
specific learning topics are:
Understand IDEA scripts and the value of automating data work
Record, create, and edit macros with
IDEAScript
(a customizable VBA-compatible scripting tool) and Visual Script
Learn and document best practices for script development
Date: Aug 5
2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
IDEA
provides @Functions for performing operations such as date arithmetic,
financial and statistical calculations as well as text searches. In
addition, the auditor can also create custom functions.
The
specific learning topics are:
The
use of standard IDEA @Functions
Using
@Functions in the Equation Editor
Tailoring your own @Functions
Date: Aug 19, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
Advanced concepts of script writing and benefits of automating your
data projects will be covered in this IDEA course. IDEA includes a
development tool known as IDEAScript for creating macros to extend the
functionality of IDEA. IDEAScript can be recorded, written from scratch,
or a combination of both.
Developing scripts and implementing best practices will show you how
to increase the efficiency of your data analytics projects by analyzing
transaction sets on a regular basis. And by facilitating the running of
pre-prepared scripts by less experienced auditors.
The specific learning topics are:
Continuation from the Basic Script Writing class learning advanced
techniques
Understand IDEA scripts and the value of automating data work
Record, create, and edit macros with IDEAScript (a customizable
VBA-compatible scripting tool) and Visual Script
Learn and document best practices for script development
Date: September 9, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
Advanced concepts of script writing and benefits of automating your
data projects will be covered in this IDEA course. IDEA includes a
development tool known as IDEAScript for creating macros to extend the
functionality of IDEA. IDEAScript can be recorded, written from scratch,
or a combination of both.
Developing scripts and implementing best practices will show you how
to increase the efficiency of your data analytics projects by analyzing
transaction sets on a regular basis. And by facilitating the running of
pre-prepared scripts by less experienced auditors.
The specific learning topics are:
Continuation from the Basic Script Writing class learning advanced
techniques
Understand IDEA scripts and the value of automating data work
Record, create, and edit macros with IDEAScript (a customizable
VBA-compatible scripting tool) and Visual Script
Learn and document best practices for script development
Date: Sept 30, 2016
Time: 11:00 AM- 1:00 PM
(Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized
Knowledge and Applications
Cost: $59
Payment
Who should attend
The series is aimed primarily at auditors, both internal and external, who are
beginning their career in Computer Auditing or who wish to understand the complexities and
vulnerabilities of computer systems. The series
builds rapidly to shorten the time period to productivity and
effectiveness.