Course Schedule

 

Training Program on IDEA for  participants from Nepal  at iCISA NOIDA

 (7-18 September 2009)


First week

 

Day

Session I

(10.00 AM to 11.15 AM)

Session II

(11.30 To 1.00 PM)

Session III

(2.00 PM to 3.30 PM)

Session IV

( 3.45 PM to 5.00 M)

7/09/09 Monday

Over view of IDEA

 

Ms Ritika Bhatia

What’s on the IDEA Screen, Application windows and toolbars

 

Ms Ritika Bhatia

Basics of Data structures

S Murali Krishnan AAO/IT Audit wing

 

Getting started: Import Assistant, viewing the field statistics, history logs 

S Murali Krishnan AAO/IT Audit wing

 

8/09/09 Tuesday

Essentials of Data Downloading

(Exercise 1)

Ms Ritika Bhatia

 

 

Getting started:Record Extraction, Field summarisation, File stratification  

KP Singh AO.IT Audit wing

 

Use of IDEA features followed by Exercise (Exercise 2)

KP Singh AO.IT Audit wing

 

9/09/09 Wednesday

Use of IDEA features followed by Exercise to practice IDEA features useful in conduct of Financial Audit.

(Exercise 4)

S Murali Krishnan AAO/IT Audit wing

 

Exercise related with downloading of MS ACCESS database file, creation of virtual fields, duplicate records’ detection and record extraction. (Exercise 3)

Ms Ritika Bhatia

10/09/09

Thursday

Exercise 5 : Use of IDEA in Financial Audit

Sh R K Goel, Director

11/09/09

Friday

Exercise 6 : Use of IDEA in Value For Money Audit

Sh R K Goel, Director

 

Tea break: 11:15 – 11:30 AM               Lunch break: 1.00 PM –2.00 PM

Tea break: 03:15 –03:30  PM

 

 

 

 

 

 



Second week

 

Day

Session I

(10.00 AM to 11.15 AM)

Session II

(11.30 To 1.00 PM)

Session III

(2.00 PM to 3.30 PM)

Session IV

( 3.45 PM to 5.00 M)

14/09/09 Monday

Exercise 7 : Use of IDEA in Accounts Receivable Audit

S Murali Krishnan AAO/IT Audit wing

 

15/09/09 Tuesday

Case studies- Live Audit Cases

IT Audit of Transport Department,DTO Aizwal

S Murali Krishnan AAO/IT Audit wing

 

Case studies- Live Audit Cases

IT Audit of inventory management Railways

KP Singh AO.IT Audit wing

 

16/09/09 Wednesday

Exercise 8 : Use of IDEA in Accounts Payable Audit and Fraud Investigation

KP Singh AO/IT Audit wing

17/09/09

Thursday

Import of Oracle Data/SQL server data using ODBC connectivity

SC Naithani/IT Audit wing

 

Use of MS Excel/MS Access in data analysis including import of external data

SC Naithani/IT Audit wing

18/09/09

Friday

Exercise 9 : Use of IDEA in Inventory Audit

KP Singh AO/IT Audit wing

Test followed by Further hands on sessions

Valediction

 

Tea break: 11:15 – 11:30 AM               Lunch break: 1.00 PM –2.00 PM

Tea break: 03:15 –03:30  PM