International Centre for Information Systems and Audit (iCISA)
A-52, Sector–62, Institutional Area, Noida      

Training Programme on "IT Audit and Use of CAATs”

(9 September to 13 September 2013)

Date & Date

Session I

1000 - 1130 hours

Session II

1145 – 1300 hours

Session III

1400 – 1530 hours

Session IV

1545 pm – 1700 hours

9 September 2013

Monday

Inauguration by DG(iCISA)

 

IDEA Basics – Hands on session on common imports, Summarization, Stratification, Joining, Field manipulation, Gap Detection

 

What is IT Audit

Database and Analytics

Shri Anindya Dasgupta

Director, IT Audit & Research

Shri K. Srinivasan

Principal Accountant General

Tamil Nadu &Puducherry

Shri K P Singh, Sr.AO

Shri Anurag Krishna, AAO

10 September 2013

Tuesday

SQL as CAATs

Indexed Extractions, Statistical Sampling methods

Group Task

 

Shri K P Singh, Sr.AO

Shri Anurag Krishna, AAO

Shri K P Singh, Sr.AO

Shri Anurag Krishna, AAO

Moderator :

Shri K. Srinivasan, Pr. AG

Shri Anindya Dasgupta, Director

11 September 2013

Wednesday

Using CAATs for MUS

IDEA Advanced Correlation, Trend Analysis, Macros

ODBC and Oracle data

Shri V.S. Jadon

Director

NAAA, Shimla

Shri V.S. Jadon

Director

NAAA, Shimla

Shri K P Singh, Sr.AO

Shri Anurag Krishna, AAO

12 September 2013

Thursday

Excel and Power Pivot

 

IDEA Advanced : Special functions

Shri K S Gopinath Narayan

Principal Director, IT Audit

 

Shri Manish Kumar (III)

Principal Director (DT)

O/o C&AG of India

13 September 2013

Friday

Data analytics, Discovery and Visualization

Group Task

 

Valediction

Shri Shrikant Karwa

Manager - UIDAI

Moderator :

Shri Anindya Dasgupta, Director

Ms. K Ganga, DG, ICISA

 

Tea Break: 1130 to 1145 hours                   Lunch Break: 1300 to 1400 hours                 Coffee Break: 1530 to 1545 hours