b. course contents 2016-17...i & ii audit report –language structure and complying style guide...

B. COURSE CONTENTS

2016-17

I. General Courses

Special Course on Statistics and Sampling in Audit

5 Working Days) Course contents

DAY SESSION TOPIC

Day 1

I Fundamentals of Ethics and Code of Ethics for IA& AD

II Introduction to Statistical methods and Descriptive Statistics

III & IV Elementary probabilities theory and Classification and concept of

Probability.

Day 2

I & II Advantage of Statistical Sampling. Sampling error and not – Sampling

error, Bias in Sampling

III & IV Random Sampling and Random Numbers, sample frame and Sampling

distribution.

Day 3

I & II Simple random Sampling, simple random Statistical random Sampling and

cluster sampling.

III & IV Probability proportional to size Sampling and Multistage Statistical

Sampling.

Day 4

I & II Need for Statistical Sampling in Audit, Attribute Sampling Plan for Audit.

III & IV Monetary unit Sampling and application of sampling in audit using IDEA

package.

Day 5

I & II Group Discussion and Case studies on Statistical Sampling in Audit.

III End Course Assessment Test

IV Evaluation and Valediction.

Special Course on Audit Evidence

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Concept of Audit Evidence

III & IV Techniques of Evidence gathering

Day 2 I & II Audit Evidence in Financial Audit with a case study

III & IV Audit Evidence in Performance Audit with a case study

Day 3

I & II Audit Evidence in Compliance Audit with a case study

III End Course Asessment Test

IV Evaluation and Valediction

Special Course on Audit Reporting

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Introduction to Audit Reporting and components of an audit

paragraph

III & IV Audit objectives, findings and recommendations

Day 2 I & II Characteristics of Audit Evidence, Balance and objectivity

III & IV Compliance of Audit Reporting as envisaged in ISSAI 4100

Day 3 I & II Audit Report – Language structure and complying style guide


Intensive Training Course on Civil Accounts

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Introduction to Government Accounts – Division, Classification,

Accounts in Treasuries, Public Works and Forest Divisions

III & IV

Exhibition of Government Accounts from Treasury to Monthly Civil

Accounts. Checks to be exercised by Treasury Inspection Party

Day 2

I & II

.Maintenance of Broad Sheets of Loans and Deposits, GPF and

Suspense Heads, clearance and adjustment procedure with practical

exercise

III & IV Maintenance of Broad Sheets of Remittance Heads and procedure for

reconciliation and clearance and their depiction in Finance Accounts

with practical exercises.

Day 3

I & II Accounting of Debt, Deposits and Clearance of various suspense

balances under VLC environment.

III & IV Inter-Government adjustments, Inward and Outward Accounts ,

Monthly Closing Balance statement from RBI CAS Advice

Adjustments

Day 4

I & II Preparation of Budget, Exchequer Control, issue of sanctions and

monitoring of expenditure and related matters

III & IV Improper operation of Personal Deposit Account and Central Plan

Scheme Monitoring System (CPSMS)

Day 5

I & II Government Accounts – Accrual system of Accounting and Transaction

of Government Accounts towards Accrual system of Accounting



Railway Financial Accounting System and Works Accounts –

Contract Bills

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I Revenue & Works expenditure- an overview

II Initial accounts of Revenue and works expenditure

III Revenue expenditure, Revenue allocation Register

IV

Monthly financial Reviews, reappropriation , review of

expenditure, review of works expenditure, watch over

progress of expenditure

Day 2

I Expenditure against the capital suspense grants, monthly

reviews of suspense grants

II Excheque control, expenditure and accounting on staff, fuel,

works and store

III Civil grants and allocation of expenditure amongst various

heads of account

IV Tender System- Invitation of tender to contract agreement

and Execution of contract, Condition of contract, Variation

in contract conditions and settlement of disputes

Day 3

I Contracts- Type of Contracts, Preparation of contractors

bills- Running on account bill and final bill

II Commissioning and completion of Railway projects

III Evaluation and assessment test

IV Evaluation and valediction

Seminar on Social Sector Audit


DAY SESSION TOPIC

Day 1

I & II Overview of Social Sector and new challenges in Social Sector

III & IV Strategic Planning and Planning Individual Social Sector Audit

Day 2

I & II Implementing Social Sector Audit Plan and Role of Criteria in

Social Sector Audit

III & IV Social Sector Audit in EDP Environment – Evidence Gathering

and Audit Techniques

Day 3

I & II Reporting and follow up process for Social Sector Audit

III & IV Group Discussion and Valediction

Special Course on Important Provisions of New Companies Act, 2013

(including Important Accounting Standards)

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I Fundamentals of Ethics and Code of Ethics for IA & AD

II Overview of Companies Act 2013 vis-à-vis Act 1956-Changes

in the Companies Act and new provisions

III & IV Cash Flow statement-Process of preparing Cash flow statement,

Accounting policies, utility and limitation of CFS

Day 2

I & II New concept of interest for Audit-Related Party transactions for

PSUs , Corporate Social Responsibility and Sustainability

III & IV Statutory authorities this Act- National Financial Reporting

Authority( NFRA), National Company Law Tribunal (NCLT) and

SF10

Day 3

I & II Salient features of ICAI Accounting Standards- Applicability,

Interpretation, Scope and Compliance

III & IV Framework and objectives of IFRS and underlying assumptions

Day 4

I & II Consolidated Financial Statement-ICAI’s guidance note on CFS,

Provisions of Act/Rules vis-à-vis AS-23/27 on consolidation

associates/first ventures

III & IV Board and Directors responsibility-Independent Directors, Mandatory

Committees, Key Managerial Personnel

Day 5

I & II Major changes in auditing-Statutory Auditor’s appointment,

eligibility, disqualification, increased responsibilities and penalties,

Supplementary Audit by CAG

III End Course Evaluation Test

IV Evaluation Assessment

Special Course on Performance Audit

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I & II Fundamentals of Ethics and Code of Ethics for IA& AD

III & IV Distinguished features of New Performance Audit Guidelines 2014

Day 2

I & II Audit Mandate and General principles of Performance Audit

III & IV Strategic audit planning and selection of audit topics

Day 3

I & II Planning individual Performance audit

III & IV Implementing the Performance audit

Day 4

I & II Evidence and Documentation in Performance audit

III & IV Developing Audit Conclusions from audit findings with a case

study

Day 5

I & II Reporting process and follow up of Performance audits



Special Course on Auditing of Public Private Partnership (PPP) Projects

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II

An overview of Public Private Partnership (PPP). Public Private

Partnership and Privatisation. Role of private sector partners in

PPP Projects

III & IV Procedure for Formulation and Appraisal of PPP Projects in

Infrastructure and Model Concession Agreements (MCA)

Day 2

I & II Identifying and sharing risks, Management and treatment of

various risks in infrastructure projects

III & IV Selection of PPP Project for audit and preparation of Audit Plan

with a case study. Audit methodology. Audit of Project

Formulation and Approvals.

Day 3

I & II Scope and objectives of various PPP Audit. Types of various PPP.

PPP Audit in different infrastructure sectors.

III & IV INTOSAI guidelines for the audit of PPP Projects. Documents to

be audited in a PPP Audit.

Day 4

I & II Reporting of Audit findings in PPP Audit of Infrastructure

Projects and recommendations.

III & IV Introduction to International Standards of Supreme Audit

Institutions.

Day 5

I & II Time Management : utilizing time in a useful manner and making

time a follower and not a teacher



Special Course on Common Administrative issues and writing of APARs

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II

Overview of DP’s Rules – CCS (Conduct) Rules 1964, CCS

(CCA) Rules 1965, Provisions under Constitution of India and

Principles of Natural Justice

III & IV Minor and Major Penalties under CCS (CCA (Rules)) Provisions,

procedure & decision relating to suspension

Day 2 I & II

Preliminary inquiry – identification of appropriate disciplinary

authority, authenticity of the complaint and necessary for

preliminary inquiry

III & IV Case studies relating to components, drafting & issuing charge sheet

Day 3

I & II Inquiry – Preliminary hearing, regular hearing, bringing the

documents on record, right of charged officer.

III & IV Cases where criminal prosecutions also on double jeopardy

panelled departmental action

Day 4

I & II Brief Explanation about roster system and DPC meetings about

recruitment and promotions

III & IV Nature of penalties & drafting / issue of penalty order and

processing an appeal & drafting an order on appeal

Day 5

I & II Annual Performance Appraisal Reports – writing, importance and

evaluation of such reports.



Special Course on Risk Based Audit Approach (RBAA)

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Risk Based Audit Approach – Identification and Assessment of

Risk and Risk Model

III & IV Determining Materiality and its importance in Risk Based Audit

Approach

Day 2

I & II Internal Control, Risk Analysis and Risk Based Sampling in Audit

III & IV Relevance of Statistical Sampling in Audit and Multistage

Statistical Sampling in Audit

Day 3

I & II Case Study on Audit Risk in EDP Environment Group Discussion

on High Risk Areas in Audit



Seminar on Performance Audit


DAY SESSION TOPIC

Day 1

I & II Distinguished features of Performance Audit Guidelines and

New Challenges in Performance Audit.

III & IV Strategic planning and planning individual Performance Audit

Day 2

I & II Implementing Performance Audit Plan and Role of Criteria in

Performance Audit

III & IV Performance Audit in EDP environment – Evidence gathering

and audit techniques

Day 3

I & II Reporting process and follow-up of Performance Audit

III & IV Group Discussion and Valediction

Special Course on Accrual Accounting

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Introduction to Accrual basis Accounting System

III & IV Review of present system of accounting

Day 2

I & II Role of GASAB on development of Accrual Accounting

Standards

III & IV Nature of reporting in Accrual Accounting and positive factors in

Accrual Accounting

Day 3

I & II Public Sector Financial Reporting Frame Work.



Special Course on Environment Audit

(03 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I Fundamentals of Public Sector Ethics and Code of Ethics for

IA& AD

II Introduction to Environment - Environment policies,

programmes, legislation and management

III & IV Impact of Global warming and climate change in environment

Day 2

I & II Clean Development Mechanism (CDM) for environmental

improvement

III & IV Audit process in Environment Audit including importance and

selection of Audit Criteria

Day 3

I & II Sustainable development and elated Environmental issues

III End course assessment test

IV Evaluation and valediction.

Special Course on Audit of Social Sector Audit

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Institutional Framework of Social Audit and Role of CAG in Social

Audit

III & IV Scope and objectives of Social Audit. Different Stages of Social

Audit

Day 2 I & II

Integration of social audit in NREGA. Social Audit in gram Sabha.

Post Social Audit Action.

III & IV Social Obligations of PSUs and problems faced by Social Audit.

Day3 I & II

Audit of Central/State Schemes implemented through Zila Parishads

and Panchayat Samities.

III & IV Audit of Zila Parishads and Panchayat Samiti Fund Audit.

Day 4 I & II

Audit of Works Accounts and Stores and Stock Accounts of Zila

Parishad and Panchayat Samities

III & IV Social Audit and Environment Management

Day 5

I & II Case Study and discussion, presentation by participants



Special Course on International Standards of Supreme Audit Institutions

(ISSAI)

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Introduction to ISSAI- Objectives and founding principles

III & IV Level II ISSAIs- pre-conditions for functioning of SAIs

Day 2 I & II ISSAI guidelines on Financial Audit

III & IV ISSAI guidelines on Performance Audit-

Day 3

I & II ISSAI guidelines on Compliance Audit-

III INTOSAI GOVIN Guidelines for good governance

IV End Course Assessment Test

5.00 PM Evaluation and Valediction

Special Course on Audit of VAT (5 Working days)

Course contents

DAY SESSION TOPIC

Day 1

I & II Fundamentals of Ethics and Code of Ethics for IA& AD

III & IV Measures to regulate transport of goods, seizure of goods and penalty

provisions

Day 2

I & II International experience of VAT and VAT structure in Rajasthan

III & IV Important Definitions under VAT Act, Liability, Registration and

Schedules.

Day 3

I & II Net Tax Payable & maintenance of VAT Accounts, Input Tax, Input &

Output Tax

III & IV Tax structure in India – Indirect

Tax and need for rationalization

Day 4

I & II Scrutiny and verification of returns, Assessment,

Recovery and Refunds under VAT

III & IV Provision relating to Audit of VAT, Conduct and Reporting results of

audit

Day 5

I & II Different types of VAT Fraud and its impact with a case study

III End Course Evaluation Test

III & IV Evaluation and Valediction

Special Course on Audit of CERA, GST and ACES (5 Working days)

Course contents

DAY SESSION TOPIC

Day 1

I Inauguration of the Course and Introductory talk on CERA and

GST

II Fundamentals of Public Sector Ethics and Code of Ethics for IA&

AD

III & IV Implementation and utilisation of ACES, Impact of ACES on

working of various wings of the Central Excise and Service Tax

Department.

Day 2

I & II Valuation Principals with case laws, Adjudication, Appeal, Levy

of penalties, interest, refunds.

III & IV Latest changes in Service Tax with case studies

Day 3

I & II Audit methodology, Determination of periodicity, sample

selection under Risk analysis, follow up of LARs/Processing of

DPs/ATNs, recovery at the instance of audit

III & IV Basic Concepts of GST

Day 4

I & II Implementation process and prospective of GST

III & IV CENVAT Schemes with latest studies of Case Laws.

Day 5

I & II End course assessment test and discussion

III & IV Evaluation and Valediction of the Course

Special Course on Financial Attest Audit

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Concept and overview of Financial Attest Audit Manual (FAAM).

Broad principals of Accountancy and Basics of Financial

Management

III & IV Accounting Standards as issued by the Institute of Chartered

Accountants of India and Disclosure requirement

Day 2

I & II Audit Planning and Field Audit Programmes, Audit Objectives and

approach for Financial Statement audit

III & IV Importance of materiality in audit of Financial Statements during

Financial Attest Audit

Day 3

I & II Identification and assessment and analysis of Risk in Financial Attest

Audit

III & IV Need for statistical sampling , Random Sampling, Random Number

Sampling Distribution and Analytical Review

Day 4

I & II Monetary Unit Sampling and application of sampling in Financial

Attest Audit using IDEA package

III & IV Principals of Reporting and drafting of reviews relating to Financial

Attest Audit

Day 5

I & II Case study on Railway specific Financial Attest Audit and Group

Discussion.

III End course assessment test


Special Course on CCO Based Audit (Department Centric Audit)

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II Concept and objectives of Department Centric Audit

III & IV Risk evaluation and selection of CCO/DDO units

Day 2 I & II Planning and methodology of CCO Based Audit

III & IV Broad parameters for executing CCO based audit

Day 3

I & II Reporting of Department Centric Audit



Financial Attest Audit in Railways

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1


II

Concept and overview of Financial Attest Audit Manual (FAAM).

Broad principals of Accountancy and Basics of Financial

Management

III & IV Accounting Standards as issued by the Institute of Chartered

Accountants of India and Disclosure requirement

Day 2

I & II Audit Planning and Field Audit Programmes in Railway Audit

III & IV Importance of materiality in Financial Statements of Railway

Accounts

Day 3

I & II Identification and assessment and analysis of Risk in Railway

specific audit.

III & IV Need for statistical sampling, Random Sampling, Random Number

and Sampling Distribution.

Day 4

I & II Principals of Reporting and drafting of reviews relating to Financial

Attest Audit

III & IV Monetary Unit Sampling and application of sampling in Railway

Audit using IDEA package.

Day 5

I & II Case study on Railway specific Financial Attest Audit and group

discussion.



Special Course on General Management

5 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I & II Fundamentals of Ethics and Code of Ethics for IA&AD

III & IV Organisation of IA&AD, Functions of Administration and

Office Procedure

Day 2

I & II Organisational Behaviour and Human Resource Development

III & IV Disciplinary proceedings as a tool for improvement in

management

Day 3

I & II Transparency and accountability for Good Governance i

III & IV Motivation and leadership for Government employees to

improve efficiency

Day 4

I & II Budgetary control and propriety in public expenditure –

understanding of Financial Statements

III & IV Time management and stress management for better

performance

Day 5

I & II Gender Sensitisation for improved work culture


III & IV Evaluation and Valediction of Course

Special Course on Audit of Direct Taxes (5 working days)

Course contents

DAY SESSION TOPIC

Day 1

I & II Fundamentals of Public Sector Ethics and Code of Ethics for IA&

AD

III Audit Mandate- Audit of Receipts under Section 16 of CAG’s

DPC Act. Legal approach to audit of Assessments

IV Briefs on accountal of tax collection and remittances.

Day 2

I & II Audit methodology, Determination of periodicity, sample selection

under Risk analysis, follow up of LARs/Processing of DPs/ATNs

recovery at the instance of audit

III & IV General lay out of Direct Tax Law, Distinction of legal terms in

Direct Tax Laws e.g. Income, Business Expenditure, Definition

of important terms and evaluation of their meaning – case laws

Day 3

I & II MAT Provisions, Clubbing of Income, set off of losses. Income

from capital gains/ capital losses, exemptions and deductions available

there-under;

III & IV How to read a Balance Sheet? Income not forming part of total

income. Exemptions under Chapter III, Provisions of Section 14A

Day 4

I & II Chapter VIA deductions and tax rebates with case studies

III Corporate Taxation: Theory – Definition in Corporate Taxation,

Section 115 O 115Q, 115R : Venture Capital companions,

liquidation of companies under Section 178, 179,

IV Income from business or profession including section 44, 44A,

44AA, 44AB, 44AD/AE/AF and presumptive income on non

residents – 44B, 44C

Day 5

I & II End course assessment test and discussion

III & IV Evaluation and Valediction

Special Course on Audit Quality Management Framework

3 Working Days)

Course contents

DAY SESSION TOPIC

Day 1

I Fundamentals of Sector Ethics and Code of Ethics for IA&

AD

II Introduction to Audit Quality Management Framework and its

broad parameters

III & IV Audit Management and relationship with clients – Audit

Planning and Execution, Reporting and Follow up

Day 2

I & II Human Resource Development - leadership and Direction

III & IV Capacity Building – Staffing and training of Audit Personnel

as per Auditing Standards

Day 3

I & II Continuous Improvement through Internal Audit, Internal

Quality Assurance and Peer Review



COURSE CONTENTS

Computer Course on Level 2 Group 1

Database concepts, system concepts and introduction to MS Access

(05 Working Days) DATE & DAY TOPIC

Day 1

Inauguration

Fundamentals of Public Sector Ethics for IA& AD

Introduction to RDBMS Concepts

Creating a Database -Designing the Database

-Using the Database Wizard

-Looking at Database Properties

Day 2

Creating and Modifying Tables -Creating a New Table Structure with the Table Wizard

-Creating a New Table from Scratch

-Modifying the Table Design

-Ensuring Data Validity

-Creating a New Table in Datasheet View

-Copying an Existing Table Structure

-Setting Table Properties

Relating Tables -Defining a Relationship

-Viewing and Editing Relationships

-Printing the Relationships

Day 3

Entering and Editing Data -Entering New Data

-Customizing Data Entry

-Changing the Datasheet Appearance

-Changing Table Definition in Datasheet View

-Editing Record Data

-Printing Table Data

Extracting Information with Queries -How Do Queries Work?

-Creating Select Queries

-Adding Selection Criteria

-Setting Query Properties

-Modifying a Query- Performing Calculations in a Query

Day 4

Creating Advanced Queries -Creating Special Purpose Queries -Find Duplicate query

Creating Advanced Queries

Day 5

Using the Form Wizard -Creating a New Form Design

-Modifying the Form Design

-Using the Form

-Printing the Form

Using the Report Wizard -Creating a New Report Design

-Previewing the Report

-Printing the Report

-Modifying the Report Design

-Saving the Report Design

-Using Report Snapshots End-of-Course Assessment and Evaluation & Valediction

Computer Course on SQL (05 Working Days)

DATE & DAY TOPIC

Day 1

Inauguration

Fundamentals of Public Sector Ethics for IA& AD

Introduction to RDBMS Concepts

Writing Basic SQL Statements

Day 2

Restricting and Sorting Data (Where clause, Character Strings and Dates and

Comparison Operators)

Selecting Data from Oracle Other Comparison Operators Using the (BETWEEN,IN,LIKE, IS NULL)Operator, Logical

Operators, Using the (AND,OR,NOT) Operator, Rules of Precedence,

ORDER BY Clause, Sorting in Descending Order, Sorting by Column

Alias, Sorting by Multiple Columns

Day 3

Single-Row Functions SQL Functions, Two Types of SQL Functions, Single-Row Functions,

Character Functions, Case Conversion Functions, Character

Manipulation Functions, Number Functions (ROUND, TRUNC,

MOD), Working with Dates, Arithmetic with Dates, Using Arithmetic

Operators with Dates, Date Functions, Conversion Functions

(TO_CHAR, TO_NUMBER, TO_DATE), Date Format, Special

Functions (NVL, DECODE), -Nesting Functions

Displaying Data from Multiple Tables -EQUIJOIN, NON-EQUIJOIN, OUTERJOIN, SELFJOIN Aggregating Data Using Group Functions -AVG, SUM, MIN, MAX, COUNT

-GROUP BY and HAVING Clauses

Day 4

Subqueries

Creating and Managing Tables CREATE TABLE, ALTER TABLE, DROP TABLE

Manipulating Data INSERT, UPDATE, DELETE, COMMIT, ROLLBACK

Day 5

Including Constraints

End-of-Course Assessment

Evaluation & Valediction

‘Audit in IT Environment’ (06 Working days)

P R O G R A M M E Date & Day Session Topics

Day 1 I Ice Breaking Session

Entry Knowledge Test (EKT)

II Understanding IT environment- Challenges and opportunities

III Importance of controls with specific reference to Application Controls

IV Introduction to CAATs – IDEA and Excel

Day 2 I Excel as data analytic tool- Features of Excel

(we intend to cover the aspects relating to following underlining the purpose for which these are used as Audit Tool)

Conditional formatting

Filter including Advanced filter

Pivot Table

II Hands on session

III Excel functions – User defined functions

Numeric

Text

Conditional

Date and time

Financial

Aggregation

IV Hands on Session

Day 3 I Creating Projects – Managed and External, Import of data from diverse formats –Excel, Access, csv, text ; understanding data using the field statistics, Checking validity of data through Control totals, creating current documentation of tasks performed using the history property, Project Overview

II Hands on Session

III Importing of PDF/PRN Data, Importing data using ODBC, Indexing of Data – Quick Index, Composite Index, Sorting Data

IV Hands On Session

Day 4 I Field Manipulation in IDEA – Append, Remove, Modify columns – Data types –

Virtual, Non Virtual, Editable, Enabling/Disabling deletion of non-virtual fields

Analysis Basic data analysis in IDEA – Duplicate Key Detection/Exclusion, Gap Detection, Summarization

II Hands on Session

III Data Extraction – Direct Extraction, Key value extraction, Top/Bottom Records extraction, Indexed Extraction

Working with multiple databases – Join, Visual Connector, Append, Compare

IV Hands on Session

Day 5 I Commonly used @ Functions in IDEA, introduction to #functions

II Stratification of Data, Aging analysis, Sampling

III & IV Exporting Data from IDEA to other formats, Creating and Printing Reports in IDEA

Revision & Queries

Hands on Session

Case Study – Selection of vouchers

Day 6 I , II & III Way Forward – Overview of Qlikview

IV Way Forward -Overview of Tableau