Course on IDEA for Railway Audit Offices
(08th June to 12th
June 2009)
|
Day & Date |
Session I
|
Session II
|
Session III I |
Session IV
|
|
8
June 2009 Monday |
Inauguration
by Director
General (IT Audit) Overview of the features of IDEA Software;
IDEA installation procedures; Pre requisites for use of IDEA; IDEA environment
settings. IT Audit
team Lead by Shri
KP Singh |
Practical hands-on training on navigation in
different menu of IDEA. IT Audit team Lead
by Shri KP
Singh |
||
|
9
June 2009 Tuesday |
Data Import of commonly encountered files of -
Excel, ASCII, Dbase file. Solution to various tricky problems. IT Audit
team Lead by Shri
S. Muralikrishnan |
Case identifications and presentation by participants
and hands on training solutions illustrating real scenarios. IT Audit
team Lead by Shri
S. Muralikrishnan |
||
|
10
June 2009 Wednesday |
Profiling and analyzing data stratification,
summarizations, field manipulations. Gap detection, and sampling. IT Audit
team Lead by Shri KP Singh |
Method of ODBC connectivity from different
platforms to IDEA. Practical hands on
Exercise related to connectivity. IT Audit
team Lead by Shri
KP Singh |
||
|
11
June 2009 Thursday |
Addressing Data Integrity of database, Use of
Index, Sort, Display, Extract, Search Find, and Go To features of IDEA. IT Audit
team Lead by Shri
S. Muralikrishnan |
Practical scenario addressing to Data Import of
Excel, ASCII, Dbase, Pdf and Print Report files explanations
to IDEA relevant Exercises IT Audit
team Lead by Shri
S. Muralikrishnan |
||
|
12
June 2009 Friday |
Joining of databases, Sampling and use of @
functions IT Audit
team Lead by Shri
KP Singh |
Practical exercise and doubts clearance IT Audit team Lead by Shri KP Singh |
Valediction By Director
General (IT Audit) |
|