Course Announcement for EDP Courses

Annexure 1

Announcement of training programme

  1. Course Title: IT Audit
  2. Date: 09.04.18 to 13.04.18
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)Trainees will be able to evaluate IT Controls, use IDEA for IT Audit and use of SAP in Audit Environment.

II)Programme Content and Structure

  • Introduction, definition of important terms, General and Application controls, IT Audit, CAATs - IDEA, Audit of SDLC, Audit of IT Security, Audit of BCP/DRP, Audit in SAP Environment.

III)Methodology: Lectures, presentations and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department/ retired audit personnel/external experts besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (17-18): The course was rated 8.6 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 16.04.18 to 21.04.18
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai

Feedback on previous Course (2017-18): The course was rated 8.9 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: IDEA
  2. Date: 14.05.18 to 18.05.18
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)To familiarize participants of the latest features added to IDEA, Computer Assisted Audit Technique widely used in the department for data analysis and IT Audits

II)Programme Content and Structure

  • Overview of IDEA, Importing of data from various data sources - Excel, Access, Text, ODBC, PDF etc, Record Extraction, Properties, Summarisation, Stratification, Sampling, IDEA Functions, Duplicate Key Detection, Gap Detection, Exporting Data to other formats, Creating Reports

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course: The course was rated 8.7 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Oracle Backend – SQL
  2. Date: 28.05.18 to 01.06.18
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)The training programme aims at fine tuning the skills of the participants in writing backend sql queries that will help them download and analyse data in Oracle

II)Programme Content and Structure

  • Introduction to Oracle, Basic Database Concepts, Data types, Command Categories - DDL, DML, TCL, DCL, Constraints, Operators and functions, Set Operators, Joins, Views, Synonyms, Sequence, Index, Queries and Subqueries

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course: The course was rated 8.7 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 25.06.18 to 30.06.18
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (2017-18): The course was rated 8.5 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Qlikview Software
  2. Date: 16.07.18 to 20.07.18
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To familiarize participants with the utility and working and various features of Qlikview, business intelligence software recently introduced in the department for data analysis

II)Programme Content and Structure

  • Introduction, Documents and Sheets in Qlikview, Imporing data into Qlikview, Sheet Objects - List Box, Statistics Box, Line charts, Bar Charts, Combo charts, Table Box etc, Scripting basics, Creating a system sheet, system table

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  2. Feedback on previous Course (2017-18): The course was rated 8.8 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 30.07.18 to 04.08.18
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (2017-18): The course was rated 8.8 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: IDEA
  2. Date: 08.10.18 to 12.10.18
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)To familiarize participants of the latest features added to IDEA, Computer Assisted Audit Technique widely used in the department for data analysis and IT Audits

II)Programme Content and Structure

  • Overview of IDEA, Importing of data from various data sources - Excel, Access, Text, ODBC, PDF etc, Record Extraction, Properties, Summarisation, Stratification, Sampling, IDEA Functions, Duplicate Key Detection, Gap Detection, Exporting Data to other formats, Creating Reports

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course: The course was rated 8.3 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 22.10.18 to 27.10.18
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (2017-18): The course was rated 8.7 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 26.11.18 to 01.12.18
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (2017-18): The course was rated 9.1 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: INTOSAI IT Audit Guidelines
  2. Date: 18.12.18 to 19.12.18
  3. Duration:2 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)This training programme intends to acquaint participants to the newly published IT Audit guidelines of the Working Group on IT Audit of the INTOSAI

II)Programme Content and Structure

  • Introduction, IT Audit Process, Audit Documentation, Use of Audit Matrix, IT Governance, Internal Control, Investment Decisions, Risk assessment, Development and Acquisition, IT Operations, Outsourcing, Business Continuity Plan, Disaster Recovery Plan, Information Security, Application Controls

III)Methodology: Lectures, presentations and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course: The course was rated 8.6 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: IT Audit (Level- 2a)
  2. Date: 07.01.19 to 11.01.19
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)This programme intends to introduce participants to the concept of Relational Database Management Systems with specific reference to MS Access

II)Programme Content and Structure

  • Database concepts, Introduction to MS Access, Objects of MS Access - Tables, Queries, Forms and Reports

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai

Feedback on previous Course: The course was rated 8.1 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: IDEA
  2. Date: 28.01.19 to 01.02.19
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)To familiarize participants of the latest features added to IDEA, Computer Assisted Audit Technique widely used in the department for data analysis and IT Audits

II)Programme Content and Structure

  • Overview of IDEA, Importing of data from various data sources - Excel, Access, Text, ODBC, PDF etc, Record Extraction, Properties, Summarisation, Stratification, Sampling, IDEA Functions, Duplicate Key Detection, Gap Detection, Exporting Data to other formats, Creating Reports

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course: The course was rated 8.2 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Audit in IT Environment
  2. Date: 11.02.19 to 16.02.19
  3. Duration: 6 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: This programme is being conducted as per instructions of Hqrs office
  6. Learning Objectives

I)To enable participants to have an understanding of the Challenges and Opportunities of auditing in IT Environment and also to use IT tools such as MS Excel & IDEA for data analysis

II)Programme Content and Structure

  • Overview of Audit in IT Environment, Database concepts, important features of MS Excel - Conditional Foramatting, Subtotals, Pivot Table, Functions, Important features of IDEA - Data import, Properties, Summarisation, Stratification, Duplicate/Gap detection, functions, Extraction, Export, Creating Reports, Overview of Qlikview and Tableau

III)Methodology: Lectures, presentations hands on with exercises and case studies

IV)Target Participants

Supervisior to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department
    and retired audit personnel besides Core Faculty of RTI Mumbai
  1. Feedback on previous Course (2017-18): The course was rated 8.7 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Hardware / Software Troubleshooting
  2. Date: 25.02.19 to 01.03.19
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)To help participants gain knowledge to troubleshoot routine problems regarding IT Hardware and operating system software

II)Programme Content and Structure

  • Introduction to computers, Hardware maintenance, Operating Systems, Drivers, Installation of OS and drivers, Networking concepts and devices, TCPIP fundamentals, PC assembling and troubleshooting

III)Methodology: Lectures, presentations, hands on.

IV)Target Participants

DEO to Sr.AO

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department/ retired audit personnel/external experts besides Core Faculty of RTI Mumbai.
  1. Feedback on previous Course (2016-17): The course was rated 8.8 on a scale of zero to ten by the participants.

Annexure 1

Announcement of training programme

  1. Course Title: Advanced MS Access
  2. Date: 11.03.19 to 15.03.19
  3. Duration:5 days
  4. Location: Regional Training Institute, Mumbai
  5. Programme Background: The training programme is being conducted based on requisition by User offices of RTI, Mumbai.
  6. Learning Objectives

I)To introduce participants with the advanced features of MS Access so that they can put to use these features to automate the applications on MS Access

II)Programme Content and Structure

  • Overview of MS Access, Working with Forms and Controls, Program Constructs, Data Source for forms, Visual Basic Editor

III)Methodology: Lectures, presentations hands on with exercises.

IV)Target Participants

Group B Officials from Audit Offices

Additional Information

  1. Faculty: The faculty will be drawn from Group B officers of the department/ retired audit personnel/external experts besides Core Faculty of RTI Mumbai.
  1. Feedback on previous Course (2016-17): The course was rated 6.9 on a scale of zero to ten by the participants.

1