Course on “I.T. Audit and Use of CAATs
for Railway Audit Offices”
(3rd to 7th
November, 2009)
|
Date |
Session 1 10: 00 am - 11:15
am |
Session 2 11:30 am – 12:45
pm |
Session 3 2:00 pm – 3:15
pm |
Session 4 3:30 pm – 4:45
pm |
|
03.11.09 Tuesday |
Inauguration, CAATs,
Overview of IDEA Sh.S.Murali Krishnan, AAO (ITA) / Sh. Anurag |
Data import from Excel, ASCII, Dbase
file. Solution to tricky problems Sh.K.P.Singh, AO(ITA)/Sh.S.Murali
Krishnan,AAO (ITA) |
||
|
04.11.09 Wednesday |
IT Audit & Evaluating
Controls in an IT Environement Sh. N.Nagarajan, Prl. Director IS/IT Audit |
Profiling and analyzing data
stratification, summarizations, fielf manipulations.Gap detection and sampling Sh.S.Murali Krishnan,AAO
(ITA)/ Sh.K.P.Singh,AO(ITA)/ |
||
|
05.11.09 Thursday |
Method of ODBC connectivity from
different platform to IDEA, Practical hand on Exercise related to
connectivity Sh.S.Murali Krishnan, AAO(ITA) /Sh.K.P.Singh,AO(ITA) |
Addressing Data Integrity of
database, Use of Index, Sort, Display, Extract, Search, Find and Go To
features of IDEA Sh.K.P.Singh,AO(ITA)/Sh. Anurag |
||
|
06.11.09 Friday |
Practical scenario addressing to
Data Import of Excel, ASCII, Dbase, Pdf and Print
Report files explanations to IDEA relevant Exercises Sh.S.Murali Krishnan,AAO(ITA)
/Sh.S.C.Naithani,Sr.Auditor(ITA) |
SQL and Access as a data analysis tool Sh.K.P.Singh, AO(ITA)/Sh.S.C.Naithani,
Sr.Auditor(ITA) |
||
|
07.11.09 Saturday |
Reporting Issues in IT Audit Sh. N.N. Subramaniam, SAO from
Railway wing followed by valediction. |
|
||
TEA BREAK: 11:15 – 11:30 am LUNCH BREAK: 12:45 – 2:00 pm COFFEE BREAK: 3:15 – 3:30 pm