Regional Training Institute,Ranchi

Course Contents :

 
COURSE CONTENTS
General Courses
  • Course Title : Govt. Accounting System, Role of GASAB & transition to Accrual Accounting System
  • Date               :  02.04.2014 to 04.04.2014
  • Duration        : 3 days
  • Location       : Regional Training Institute, Ranchi
  • Programme Background: The training programme on Govt. Accounting System, Role of GASAB & transition to Accrual Accounting System is being conducted based on training needs of User Offices of RTI Ranchi.
  • Learning Objectives
  • The course aim at introducing the participants about the present system of cash basis of accounting and the proposed Accrual basis accounting.
  • At the end of the course, the participants should be able to :
  • Understand the present system of accounting
  • Understand the role of GASAB in development of accrual accounting standards
  • Understand the nature of reporting in accrual accounting.
  • Programme Content and Structure

DAY

TOPICS

Day-1

Treasury Accounts with accounting operations of RBD head, Interest Warrants, Debt and Deposit heads, High Court Judges' GPF, State Development Loans. / OB Suspense, P.L. A/c, etc.

Introduction to Accrual Accounting System – GASAB and its role on development of Government Accounting Standards for implementation of accrual accounting system

Day-2

Accounting operations of all Inter-Government transactions with monetary adjustments through RBI Advice Procedure and Cash Settlement System – Practical Exercises

Public Works Accounts and Forest Accounts with operation of Remittance Heads [ I, II and III (b) ] and Suspense Heads [STOCK, Misc. Works Advances, MPSSA, etc.], Maintenance of Remittance Broadsheets.

Day-3

Preparation of Finance and Appropriation Accounts, and understanding the New Format of Finance Accounts 

Creation and clearance of various Suspense heads in Government Accounting, Maintenance of Suspense Broadsheets, Review of Balances, and Adverse Balances.

  • Methodology: Lectures, Presentation and Interactive sessions.
  • Target Participants

Accountants/Sr.Accountants/Auditors/Sr.Auditors/AAOs/AOs/Sr.AOs.

  • Additional Information

Faculty: The faculty will be drawn from officers of the IA&AD.
-----------------------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Audit of Contracts and MOUs
2.   Date               :  09.04.2014 to 11.04.2014
3.   Duration        : 3 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme on Audit of Contracts and MOUs is being conducted based on training needs of User Offices of RTI Ranchi.
6.   Learning Objectives: The course aim at introducing the participants about the basic concept of Contract procedures in Government Department, understand the key audit issues of various stages of contract. The participants understand the various key issues to be looked into while conducting audit of contracts of railways, works etc.
7.   Programme Content and Structure


DAY

TOPIC

Day-1

Contract procedures in Government Department and Commercial Undertakings. Key points to be looked into.

Procurement, Execution and Material Management. General and Special Conditions of Contracts, pre order tie-up and MOUs

Day-2

Audit of pre-requisite earnest money/security deposit, Bank guarantee. Preparation of NIT-poor NIT, unfair conditions of contract. Inspection of work

Contract and Purchase procedure followed in Department of Railways and points to be seen in Audit. Case Studies

Day-3

Planning and Execution of Contract Audit- Key issues to be looked into in audit

Salient features of contract in Works Audit., Advance payment, measurement Book- its importance Points to be seen while auditing Works Contract and case studies discussion

8.         Methodology: Lectures, Presentation and Interactive sessions.
9.         Target Participants: AAOs/AOs/Sr.AOs
Additional Information
10.       Faculty: The faculty will be drawn from Experts of PSUs and officers of the IA&AD.
------------------------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Induction Training for Auditors
2.   Date               :  21.04.2014 to 25.04.2014
3.   Duration        : 5 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme on Induction Training for Auditors is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:The course aim at introducing the participants about the basic information about the Indian Audit & Accounts Department, its mandate and function. The participants understand the various provisions relating to Fundamental rule and Supplementary rule. They should also understand about the various types of audit and manner to conduct audit.
7.   Programme Content and Structure


DAY

TOPICS

Day-1

 

Features and functions of Supreme Audit Institutions, CAG DPC Act, 1971, INTOSAI and its function and Reporting process in IA&AD, Organizational and reporting Structure of the department.

System of Govt. Accounts, Monthly Govt. Accounts, Accounting Procedures, Principal Rules of Govt. Accounts, Treasury Accounts.

Day-2

 

Provision regarding classification in Govt. Accounts, Major, Minor and sub and detail heads of govt. account, Capital and Revenue accounts.
AC and DC Bills- their processing and time limit.

Audit Procedures-Planning, Execution, Reporting and Follow up of reports.

Day-3

 

Finance accounts and Appropriation accounts, Suspense accounts, supplementary grants and vote on accounts.

Pay and Allowance, personal pay, substantive Pay, special pay, Time scale of pay, TA, Conveyance Allowance, Increment, Service counting for increment, Honorarium, fees, cadre, deputation, Foreign service, system of correspondence, noting and drafting

Day-4

Gender Sanitization-Related concepts and jargon; Gender Equality, Gender differentiation, Gender roles, Gender discrimination, Legislative measures in India; Development of women-Indian experience, concessional provisions for women in the Central Services; prevention of harassment of women in the workplace.

Audit of Panchayati Raj Institutions and Urban Local Bodies

Day-5

Professionalism and Ethics, Communication skills and interpersonal relations.

IT environment and its importance. Test, Evaluation and Valediction

8.   Methodology: Lectures, Presentation, Interactive sessions and Course end test.
9.   Target Participants: Newly recruited Auditors
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD.
------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Workshop on Performance Audit and Thematic Audits
2.   Date               :  05.05.2014 to 09.05.2014
3.   Duration        : 5 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme on Workshop on Performance Audit and Thematic Audits is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

  • The course aim to equip the participants with various techniques involved in Performance Audit and Thematic Audit.
  • At the end of the course, the participants will be able to:
  • Know about the shift in the approach and methodology in performance audit
  • Learn about performance audit implementation plan
  • Learn about developing audit objectives and criteria
  • Learn about evidence, source of evidence and process of evidence gathering

7.   Programme Content and Structure


DAY

TOPICS

Day-1

Inauguration and Introduction about Performance Audit
Roadmap for Performance audit, Shift in approach and methodology in Performance audit

Strategic Planning-Principles and Procedures, Risk assessment for strategic planning, Hands-on exercise on Risk assessment

Day-2

Performance Audit Implementation Plan, Setting/Developing Audit Objectives, Issue analysis

Hands on exercise on audit objective/issue analysis

Day-3

Criteria, sources of criteria, Hands-on exercise on criteria, sources of criteria

Evidence and sources, Concept of study design matrix, Hands-on exercise on evidence, source of evidence and Completion of study design matrix, Preparation of audit test programmes, evidence gathering and analysis documentation of evidence

Day-4

Developing audit conclusions and recommendations, Hands-on exercise on developing audit conclusions and recommendations

Reporting process & Attributes of good performance audit reports, Follow-up procedures

Day-5

Supervision review and quality control, Quality assurance in performance audit

Human resource issues and capacity building, Potential impacts of performance audits including Hands-on-exercise

Test and Evaluation and Valediction

8.   Methodology: Lectures, Presentation, Exercises, Interactive sessions and Course end test.
9.   Target Participants: AAOs/AOs/Sr.AOs
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD particularly Group Officers.
----------------------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Office Administration and Establishment, APAR, Disciplinary Proceedings Reservation Rosters, Departmental Promotional Committee
2.   Date               :  19.05.2014 to 23.05.2014
3.   Duration        : 5 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

  • The course aims to make the  participants understand the procedures involved in the writing of APAR, promotions, preparation of post based rosters, framing of charge sheet, suspension and procedures for appeals, revision and review under CCS (CCA) Rules 1965 and CCS(Conduct) Rules.
  • At the end of the course, the participants should be able to :
  • Understand writing of APAR, and guidelines for reporting and review of APAR
  • Understand the recruitment rules of various cadres in the IA&AD. Reservation for ST/SC and OBC
  • Understand the preparation of roster for various cadres in recruitment and reservation.
  • Understand the Code of discipline for Central with servants
  • Understand CCS(Conduct) Rules, 1964 on various provisions relating to Disciplinary Proceedings 
  • Understand how to frame charge sheet and conducting departmental inquiry. Submission of inquiry report recording and evaluation of evidence during departmental inquiry.
  • Know the procedure for  appeals, revisions and reviews under CCS(CCA) Rules 1965
  • Know the elements of the administrative law and concept of their relevance to CCS(CCA) Rules 1965
  • Understand the various types of claims, Meaning of AC and DC bills

7.   Programme Content and Structure


DAY

TOPIC

Day-1

Overview of Office Administration & Establishment, Managing Work

Code of Conduct for Central Government Servants – CCS (Conduct) Rules, 1964, and various GOI Decisions there under. Gender Sensitization against sexual harassment

Day-2

Disciplinary Proceedings – Framing of Charge Sheet, Authority, various stages of conducting departmental enquiry, submission of inquiry report, Procedure for imposition of major/minor penalties.

Types of Personal Claims, AC and DC Bills – Processing and Time Limit, Record Management – Preservation and weeding out of old records.

Day-3

Appeals, Revision, Review under CCS (CCA) Rules 1965. Discussion of Case Laws

Maintenance of Service Book. Departmental Promotion Committee – size, composition, frequency of meetings, Sealed Cover Procedure, declining of promotions, etc.

Day-4

Preparation of Budget, Revised Budget Estimates and Control of Budgetary Grants, Central Government Accounts (Receipt and Payment) Rules, 1983, Duties and Responsibilities of Controlling Officers and DDOs.

Writing of Annual Performance Appraisal Report (APAR), Adverse Entry, Part Report, Gap Sheets. Standards of Financial Propriety.

Day-5

Preparation of Post-Based Rosters.

Discussion on various issues related to Administration and Establishment and Valediction

8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
9.   Target Participants: AAOs/AOs/Sr. AOs Accountants/Sr. Accountants/Auditors/Sr. Auditors/AAOs/AOs/Sr.AOs
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD.

-----------------------------------------------------------------------------------------------------------------------------------------

1.   Course Title : Various types of Suspense its operation procedure & Clearance.  Maintenance of Broad sheets, GIS, TDS Suspense A/Cs, PIL Deduction & Interest Warrant, Operation of Personal Deposit/ Ledger.
2.   Date               :  26.05.2014 to 30.05.2014
3.   Duration        : 5 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

    • The course aims to aware the participants the reasons for various types of Suspense Accounts occurring in the Government Accounts as well as operation of Personal Deposit/Ledger Accounts.
    • At the end of the course, the participant should be able to
      • Understand the implication of various types of Suspense Accounts occurring in the Government Accounts.
      • Understand how to clear various types of Suspense balances.
      • Understand the operation of personal Deposit/Ledger Accounts and its effect on improper operation of Personal Deposit/Ledger Accounts.

7.   Programme Content and Structure


DAY

TOPIC

Day-1

Introduction to Suspense A/Cs applicable in Government System of Accounting, Suspense A/Cs Meaning and variation  

Significance of Public Accounts and DDR Heads in Government Accounting and Problems in Managing Public Accounts and DDR Heads

Day-2

Operation Procedure and Clearance of 8658-Suspense Accounts
101- P.A.O Suspense, 102- O.B. Suspense, 102-Treassury Suspense & 102 Suspense Account (Civil) other Circle Accounts.

Operation Procedure and Clearance of 8658- Suspense Accounts
109- Reserve Bank Suspense (Headquarter), 110-R.B. Suspense(C.A.O), 111- D.A.A. Suspense
112-T.D.S. Suspense, 113- Provident Fund Suspense
123- All India Services Officers Group Insurance Scheme Suspense

Day-3

Maintenance of Suspense Broadsheets. Review of Balances and Adverse Balances in Public Accounts and its effect in Finance Accounts.

Accounting operations of all Inter-Government transactions with monetary adjustments through R.B.I Advice Procedure and Cash Settlement System,
PIL Deduction & Interest Warrant – Practical Exercises

Day-4

Deposit Accounts, Types of Deposits, Records maintained in the Treasury for Accounting of Deposits, Lapses of Deposit

Personal Deposits/Personal Ledger Accounts, Different Kinds of Personal Deposits, Role of AG in opening of Personal Deposit Accounts

Day-5

Accounting Procedure of Personal Deposits/Personal Ledger Accounts
Adverse Balance in Personal Deposit Accounts and clearance of Adverse Balance

Case Study on Review of Balances on Suspense Accounts

8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
9.   Target Participants: AAOs/AOs/Sr.AOs
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD.
------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Work shop on Management Development Programme
2.   Date               :  16.06.2014 to 20.06.2014
3.   Duration        : 5 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

  • The main Objectives of the Course are to discuss knowledge and skills needed to manage audit affairs covering aspects like leadership, team building, motivation and ethics, information system and interpersonal skills.
  • Finance Management is catalyst to the success of an organization. To discuss the management techniques and the skill to apply the same.

7.   Programme Content and Structure


DAY

TOPICS

Day-1

Introduction about the course,
Improving governance through Internal Audit and Internal Control

Financial Management- General Financial  Rules, Standards of Financial Propriety and Purchase Policy

Day-2

Leadership & Organisation Development
-Group Dynamics & Team Building, Conflict Management & Negotiation Skills, Leadership Styles

Macro Economics-Theory and Policy
International Trade, Impact of global economic crisis

Day-3

Leadership & Organisation Development
Changing mindset and achieving success

Government Budgeting-its concept, importance and implementation

Day-4

Personality Development
Motivation, Team Building and Communication Skills

Personality Development--Ethical Standards, -Time & Stress Management Emotional Intelligence

Day-5

Transformational Management:- a case study on Ethics, Leadership and Governance. Group Discussion and valediction

8.   Methodology: Lectures, Presentation, case studies, Exercises and Interactive sessions.
9.   Target Participants: AAOs/AOs/Sr.AOs
Additional Information
10. Faculty: The faculty will be drawn from School of Business Management, XISS and officers of the IA&AD.
------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Course on Checks and Audit exercised in Preparation of Finance & Appropriation Account in new format.
2.   Date               :  23.06.2014 to 25.06.2014
3.   Duration        :03 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

  • The course aims to aware the participants about the steps involved in preparation of Finance Accounts and Appropriation Accounts and exercise checks involved for Certification of the Accounts.
  • At the end of the course, the participants should be able to :
  • Understand how the finance and appropriation accounts are prepared and various steps involved in the preparation of final accounts and certification of the same by the AG(Audit).

7.   Programme Content and Structure


DAY

TOPIC

Day-1

Introduction to Finance and Appropriation Accounts – Role of AG(A&E) in preparing Finance Accounts and Appropriation Accounts

Structure and different data sources for Appropriation Accounts and Finance Accounts. Preparation of Appropriation Accounts, Calculation of data for all Grants, and checks exercised.

Day-2

Preparation of Finance Accounts (all Statements and Appendices) – checks to be exercised, significance, preparation of Schedules, and responsibilities

Link of Finance Accounts to Chapter-I of Audit Report

Audit and Certification of Finance Accounts

Day-3

Audit and Certification of Appropriation Accounts

Group Discussion on checks and audit of Finance & Appropriation Accounts and Valediction.

8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
9.   Target Participants: Accountants/ Sr. Accountants/Auditors/Sr. Auditors/AAOs/AOs/Sr. AOs
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD.
------------------------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Special Course on Financial Attest Audit (Finance and Appropriation Account with practical training in IDEA for VLC Data).
2.   Date               :  30.06.2014 to 10.07.2014
3.   Duration        : 10 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

  • The course aims to introduce  the participants with the different stages involved in preparation of Finance and Appropriation accounts
  • At the end of the course, the participants should be able to:
  • Understand the process of preparation of Finance & Appropriation Accounts
  • The participants will also learn about Financial Attest Audit Manual for certification of Finance and Appropriation Accounts.

7.   Programme Content and Structure


DAY

TOPICS

Day-1

Indian Financial System : Fiscal Policy, Legislative control, Federal division of powers, Budget, Accounts, Plan and non-plan expenditure, Audit, etc.

Budget Meaning – Introduction, Annual Financial Statement; Financial Year; elements of a budget

Day-2

Budget Process - Budgetary control, New Service, New Instrument of Service, Vote on account, Supplementary, Re-appropriations, Excess grants, etc.
Budget Scope - Charged and Voted, Revenue and Capital and Plan and Non-Plan.

Compilation of Accounts – Introduction - Part I Consolidated Fund, Part II Contingency Fund, Part III Public Account and Coding system

Day-3

Compilation of Accounts – Overview of compilation in AG (A&E)

Compilation of Accounts – Account Current

Day-4

Compilation of Accounts – Works and Forest

Compilation of Accounts – Loans and Deposits

Day-5

Finance Accounts – Definition, Structure of Finance Accounts, Explanation of general checks to be exercised for the preparation of Finance Accounts

Finance Accounts – Notes to Accounts in Finance Accounts, Hqrs instructions and linkage between statements

Day-6

Finance Accounts – Discussion on various statements of finance accounts

Finance Accounts - Discussion on various statements of finance accounts and exercises

Day-7

Appropriation Accounts - Original, Supplementary, Re-appropriation, New Service and New Instrument of Service and Structure of appropriation accounts

Appropriation Accounts - points to be seen during audit of Appropriation Accounts and exercise

Day-8

Introduction to Idea software
How to download Excel file to Idea Software 

Introduction to Statistical Sampling Types of Sampling What is Monetary Unit Sampling? Why Monetary Unit Sampling?

Day-9

Importing of Oracle Dump in to IDEA software

How to select Vouchers for Audit – Simple Monetary Unit Sampling Method

Day-10

How to select vouchers for Audit – Multiple Monetary Unit Sampling Method.  Hands on Session Discussion. Summing up and Valediction

8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
9.   Target Participants: AAOs/AOs/Sr.AOs
Additional Information
10. Faculty: The faculty will be drawn from officers of the IA&AD.
----------------------------------------------------------------------------------------------------------------------------------------------
1.   Course Title : Intensive Training Course on Direct Taxes.
2.   Date               :  14.07.2014 to 24.07.2014
3.   Duration        : 10 days
4.   Location       : Regional Training Institute, Ranchi
5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
6.   Learning Objectives:

    • This course is designed to give the participants a thorough understanding of the elements of Direct Lax laws that are of practical importance with respect to the direct taxation of Individuals, firms and corporations.
    •  Participants will gain an understanding of how to apply and use both the legislation and the case law in their daily tax audit. Specific emphasis will be put on the audit of corporations.
    • This course offers the opportunity to examine the leading cases and the latest developments with practitioners who are renowned in the field of Direct Taxes.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Introduction to Department Centric Audit, Audit methodologies, Determination of periodicity, Sampling
    and Risk analysis

    General layout of Direct Tax Laws Distinction of legal terms in Direct Tax Laws. e.g. Income (Concept of Income- definition in Income Tax Act, Capital & revenue income, agricultural income etc.), Wealth, business expenditure (capital and revenue expenditure alongwith relevant case laws on these subjects) etc. Definition of important terms and evaluation of their meaning- case laws.

    Day-2

    How to read a Balance Sheet? Income not forming part of total income, Exemptions under chapter III and Provisions of section 14A.

    Heads of Income and aggregation of taxable income- Income from salaries and income from house property including carry forward and set-off of losses under income from house property, Income from other sources.

    Day-3

    Clubbing of income, carry forward and set-off of losses, assessment of HUF, firms, AOP, BOI, Co-operative society and trust along with cases studies and practical Sessions

    Day-4

    Chapter VIA deductions and tax rebates-theory

    Chapter VI A deduction and Tax Theory along with case studies

    Day-5

    Income from capital gains/capital losses. Exemptions and deductions available there under along with relevant case laws and practical problems.

    Arrear and collection of tax TDS, AT, SAT, regular taxes, interest, penalty and prosecution.

    Day-6

    Corporation Taxation Theory – Definitions in corporate taxation, MAT provisions, section 115O, 115R, venture capital companies, liquidation of companies under section 178 & 179.

    Practical problems and case laws on corporate taxation covering also certain tips on reading of balance sheet, final accounts, notes on accounts and auditor reports.

    Day-7

    Non-resident taxation: DTAAs, important definitions, permanent establishment, special rates of tax and special provisions under section 93 and 94.

    Computerisation in the income tax department like processing through AST software, electronic filing of return, e-TDS/TCS,e-refunds and Refund Banker etc. and its impact on audit.

    Day-8

    Assessment procedure, search & seizure and settlement commissions, Appeals & Refunds Theory.

    Practical sessions covering comments questions, case laws on Assessment procedure, search & seizure and settlement commissions, Appeals & Refunds Theory.

    Day-9

    Income from business or profession including section 32 to 37, 40,40A,41,42,43A to 43D, 44, 44A,44AA,44AB, 44AD/AE/AF and presumptive income on non-residents- 44B to 44C, 44DA, 44DB and speculative transaction.

    Direct Tax Code
    Salient features of DTC, Comparative view of taxation in DTC and existing IT Act

    Day-10

    Follow up of LARs/Processing of DPs/ATNs/ watching the recovery at the instance of audit, audit of waiver orders/loss of revenue cases.

    Session Evaluation-MCQ Test and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from Direct Tax practitioners, Officers from Income Tax Department, Officers from Public Sector Undertakings and officers of the IA&AD.
    ------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Workshop on Evidence Gathering Techniques.
    2.   Date               :  04.08.2014 to 06.08.2014
    3.   Duration        : 3 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to provide knowledge to the participants about Audit Evidence and different techniques of evidence gathering.
    • The participants will also know the importance of audit evidence in the audit of (i) Performance Audit (ii) Financial Statements and (iii) Compliance Audit.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Inauguration
    Concept of Audit Evidence

    Evidence Gathering Techniques with exercises

    Day-2

    Evidence Gathering Techniques with exercises

    Audit Evidence in Financial Audit with exercises

    Day-3

    Audit Evidence in Performance Audit with exercises and Audit Evidence in Compliance Audit with exercises

    Invalid evidence, Closure and Summing up. Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    ---------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Workshop on Audit Reporting.
    2.   Date               :  11.08.2014 to 13.08.2014
    3.   Duration        : 3 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to introduce the participants with the key aspects of Audit Reports with reference to ISSAI guidelines.
    •  At the end of the course, the participants should be able to :
    • Learn the language and structure of the Audit Report. They will also know about the style guide issued by the C&AG of India.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Introduction to Audit Reporting

    Components of an audit paragraph
    Focuses on components of a paragraph in a report.

    Day-2

    Link between Report, Audit Objectives and Working Paper
    Emphasis is on the linkage between audit objectives identified at the planning stage and the audit report.

    Balanced and Fair Reporting
    Compliance Audit Reports- reporting requirements as envisaged in ISSAI 4100

    Day-3

    Audit Report – Language and Structure

    • sequencing audit findings and structuring an audit paragraph
    • common pitfalls in the language used in audit reports

    Style Guide for writing Reports. Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    ----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Audit of Vouchers & Monthly A/cs, Treasury Inspection, Accounting of AC/DC bills, Grants in-aid and U.Cs.
    2.   Date               :  18.08.2014 to 23.08.2014
    3.   Duration        : 6 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The participants will get an idea about what are records to be checked while

     inspecting a Treasury and conducting IT Audit of Treasuries.

    • At the end of the course, the participant should be able to:
    • Understand the objective and importance of Treasury Inspection.
    • Understand the function of Treasuries and the various records maintained in Treasuries
    • Understand the duties and responsibilities of T.O and DDOs with reference to Budget
    • Understand the maintenance of reconciliation of the cash balances with the Bank.
    • Understand the subsidiary cash book, payment register etc understand how to draft an Inspection Report.
    • Understand the IT Audit objectives, mandate, steps and process planning
    • Understand the controls of IT Environment, General controls of organizational and management controls.
    • Understand the Operational controls, physical and logical access controls.
    • Understand acquisition controls, programme change controls, business continuity and disaster recovery and audit of application control- input controls and processing control and output controls.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Overview of Functioning of Treasuries, Duties and Responsibilities of Treasury Officer and D.D.Os.

    Role of Treasury in Budgetary Control of the State, Control by Treasury Officer  with  reference to Budget of D.D.Os.  

    Day-2

    Subsidiary Cash Book and Payment  Registers in Treasury Currency Chests, Reconciliation with Banks, Role of Treasury in timely submission of Monthly Accounts to AG (A&E) Office

    Function of Treasury Section of the A.G.Office. Documents in respect of Treasury Accounts received at A.G.Office from State Treasuries, Transmission of treasury accounts from treasury section to Unit Section for preparation of Monthly Civil Accounts, Finance and Appropriation Accounts.

    Day-3

    Procedure for preparation Monthly Civil Accounts in AG(A&E) Office

    Accounting of AC/DC Bills, Grants-in-Aid and Utilization Certificates, Internal Control Mechanism in the functioning of treasuries, Records maintained in the treasury , Audit of Vouchers

    Day-4

    Objective and Importance of Treasury Inspection, Planning a Treasury Inspection

    Treasury Inspection- A general overview- Details of Focus Areas while conducting Treasury Inspection

    Day-5

    Interesting cases noticed during Inspection, Drafting Treasury Inspection Report.

    Reporting the Results of Inspection and Common Irregularities at Treasuries

    Day-6

    Case Studies of Treasury Inspection. Discussion on Various issues related to Treasury Inspection. 

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: Accountants/Sr.Accountants/Auditors/Sr.Auditors/AAOs /AOs /Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    ---------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Special Training programme on Ethics and value.
    2.   Date               :  25.08.2014 to 26.08.2014
    3.   Duration        : 02 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:
    By the end of the Session participants will be able to understand the

    • Meaning of ethics and values
    • Historical perspective on ethics and values?
    • Significance  of ethical behaviour
    • Framework of Ethical Governance
    • Some important ethical behaviour at work place
    • value and benefits of the SAI by analyzing the impact of its performance to society

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Context Setting: Background and need for ethics in Governance,

    Concept of ethics:- Traditional and Contemporary approaches

    Role of Supreme Audit Institutions ( SAIs) – Values and Benefits of SAI

    IA & AD Code of Ethics, promoting ethics through new initiatives

    Day-2

    Ethical dilemmas and Case Studies of ethical dilemma in IA &AD

    Practicum:- Experience sharing on core values and ethical dilemmas

    Confd:- Practicum:- Group presentation

    Advocating Ethics

    Evaluation and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr. AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD and other Business Schools.

    1.   Course Title : Workshop on Audit of Public Private Partnership Projects.
    2.   Date               :  01.09.2014 to 03.09.2014
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to provide participants with the knowledge of various types of PPP, appraisal and approval of such projects, scope and objectives of PPP audit, process of assessment of the documents and record of private sector partners.
    • At the end of the course, the participants should be able to :
    • Know the process of selection of PPP projects for audit and different steps involved in the audit of such projects.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Overview of Public Private Partnership-Types, Success, Objectives and Role of Private Sector. Auditing Standards & Guidelines for Audit of PPP

    Financial Powers, Procedures, Appraisal by/ Approval of PPP Appraisal Committee, Model Concession, Agreements, Institutional Arrangements in State Government, Discussion on cases

    Day-2

    Scope and Objectives of PPP Audit-Types of documents/accessing records of Private Sector Partners, Audit Planning, Process and Criteria for PPP Audit. Case discussion

    Building Capacities for Public Private Partnerships- Indian perspective and challenges

    Day-3

    ISSAI Guidelines on Privatisation. Audit of Risk in PPP. Exercises.

    Case study on Audit of Public Private Partnership in Infrastructure projects, PPP in Social Sector- Case discussion and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    -----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Workshop on Audit of Fraud.
    2.   Date               : 08.09.2014 to 10.09.2014
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the programme is to introduce the participant about the concept of fraud and the C&AG ‘s Standing Order in relation to cases of fraud and corruption.
    • At the end of the course
    • The participants will also learn about characteristic of Fraud and Corruption, Fraud Awareness, Vigilance about Fraud in the audit of Financial Statements, Performance Audit, Receipt Audit etc.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Introduction to the Fraud,
    Corruption, definition of corruption and elements of corruption.

    Standing Orders on Role of Audit in relation to cases of Fraud and Corruption:-Modus Operandi of Fraud, factors influencing Fraud & Corruption, Types.

    Day-2

    Standing Orders on Role of Audit in relation to cases of Fraud and Corruption:-Potential Fraud indicators and high risk areas in audit of Financial Statement, Performance Audit, receipt audit.

    Internal controls and Risk assessment, Audit Evidence, Documentation.

    Day-3

    Role of Auditor in Fraud and Reporting.
    Identification of red flags in Govt. Sector-Case studies

    Fraud Investigation and Forensic Test Techniques. Discussion of case studies
    Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    1.   Course Title : Workshop on ISSAI Awareness.
    2.   Date               :  22.09.2014 to 24.09.2014
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:
    (i)       The aims of the course is to introduce the participants with INTOSAI, International Standards of Supreme Audit Institutions (ISSAI) and INTOSAI guidance for good governance
    (ii)      At the end of the course, the participants should be able to:
    Learn about four levels of ISSAI, INTOSAI global Initiative and SAI India’s Initiative on the implementation of ISSAI Guidelines.
    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    Inauguration and Introduction about ISSAI. Lima Declaration

    Level Two ISSAIs-Prerequisites for the functioning of Supreme Audit Institutions
    ISSAIs in Performance Audit

    Day-2

    ISSAIs on Financial Audit

    Level III of ISSAI Guidelines and
    INTOSAI GOV 9100-9199- INTOSAI Guidance for Good Governance

    Day-3

    ISSAIs on Compliance Audit

    ISSAI-5100-5199-Guidelines on Environment Audit
    ISSAI-5300-5399-Guidelines on IT Audit
    Course in Brief and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10  Faculty: The faculty will be drawn from officers of the IA&AD.
    ------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Preparation of main and follow up reports on review of balances, preparation of adverse balances, preparation of monthly as well as accounts at a glance (Key indicator).
    2.   Date               :  07.10.2014 to 09.10.2014
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The course aims to aware the participants the reasons for preparation of Review Main and follow up Report on review of balances and adverse balances occurring in the Govt. Accounts as well as to the key indicators in the preparation of monthly accounts as well as accounts at a glance.
    • At the end of the course, the participant should be able to.
      1. Identify the reasons for preparation of Mains and follow up Reports on Review of Balances.
      2. Identify the implication of adverse balances occurring in Government Accounts.
      3. Rectify the adverse balances.
      4. Prepare the monthly accounts as well as accounts at a glance

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Inauguration and an Introduction to Government Accounts

    Significance of Public Accounts and DR Heads in Government Accounts

    Meaning, Definition of Review of Balances, Annual Review of Balances, important factors affecting accuracy of accounts

    Different kinds of Suspense & Remittance Heads

    Day-2

    Preparation of Mains and follow up Report on Review of Balances

    Preparation of Adverse balances, Implication of Adverse Balances occurring in the Government Accounts

    Day-3

    Procedure of the Preparation of Monthly Civil Accounts in A.G(A&E) Office

    Key Indicators in the preparation of the Accounts at a Glance for a financial year, Evaluation and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    ------------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Course on Works Audit including Preparation of Estimates.
    2.   Date               :  13.10.2014 to 17.10.2014
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the programme is to introduce the participant about the concept of works audit and contract audit.
    • At the end of the course the participants will also learn about various checks to be exercised while conducting works audit and contracts.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day 1

    Overview of Public Works Department and role of Audit therein, accounting system in Public Works Department and upkeep of relevant records relating to execution of work

    Points to be seen while preparing the estimate for work. Importance of PWD and PWA code

    Day 2

    Concept of Tender and Agreement, F2 Agreement, Standard Bidding Documents (SBD) and Turnkey Project

    Importance of analysis of rates and Schedule of Rates (SOR) and method of its preparation,

    Day 3

    Initial records maintained by Public Works Department, detail of Maintenance of Measurement Book and points to be seen

    Administrative Approval and Technical Sanction, Revised Estimation. Case discussion

    Day 4

    Performance audit of Road Sector Project-Points to be examined during the course of review-Case study

    CCO based Audit of Public Works Department-Points to be examined during the course of audit/review

    Day 5

    Exercise on Preparation of Objectives, Defining Criteria and Design Matrix

    ISSAI guidelines on Performance Audit and Discussion of Case Studies. Course Evaluation

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    -----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Statistics & Sampling in Audit with Risk based Audit Approach.
    2.   Date               :  17.11.2014 to 21.11.2014
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to equip the participants with the knowledge of risk model, materiality, risk assessment involved in audit.
    • At the end of the course, the participants should be able to learn about statistical sampling and techniques to be used in selection while conducting test audit.

    7.   Programme Content and Structure


    Day

    Topics

    Day-1

    Inauguration, Descriptive Statistics:
    What is data? (Qualitative vs. Quantitative data), What is an Attribute?
    Frequency distribution of data. Concept of random variable
    Measure of Central Tendency (Mean, Median and Mode): Concept, measure & applicability. Measure of Dispersion (Range, Standard Deviation & Coefficient of variation): concept, measure & applicability

    Classical definition of probability: Concepts with examples
    Probability distribution (Binomial, Poisson & Normal Distribution): Concepts & Applicability. Using Excel/IDEA package demonstrate different statistics using live data and interpret the statistics to draw conclusions about the distribution the data.
    Practical

    Day-2

    Statistical Sampling:
    What is Statistical Sampling? How it is different from judgmental and convenience sampling? Advantages of Statistical sampling. What is a Random Number Table? Its relevance in statistical sampling and concept of sampling frame.
    Different techniques of statistical sampling: Simple Random Sampling (SRS), Systematic Random Sampling: concepts, definition and applicability.
    Methodology of drawing samples using SRS & Systematic (both Linear Systematic and Circular Systematic) using a Random Number Table & n) using IDEA package.
    Estimation formulae for estimation of population average, total and proportion of an attribute and corresponding estimation of standard errors: (Only the formulae to be stated, without proof). Demonstration with various examples.

    Statistical Sampling (contd.):
    1.Probability Proportional to size (PPS) sampling: concept, definition & applicability
    2. Different techniques of drawing samples for PPS design (Cumulative Total method, Prof. Lahiri's method of drawing samples.)
    3. PPS-Systematic Sampling & its method of drawing samples.
    4. Demonstration may be given with examples
    5. Estimation formulae for estimation of population average, total and corresponding estimation of standard errors & concept of multiplier in sampling. (Only the formulae to be stated without proof)
    6 Problems on selection of samples and evaluation of few characters of interest using SRSWR, SRSWOR, Systematic, PPS, and PPS-systematic design.Practical

    Day-3

    Statistical Sampling (Contd.):
    1 Stratification in sampling, 2 Cluster sampling, 3 Stratification vs. Cluster sampling
    4 Advantages of stratification. 5 Estimation formulae under stratification.
    6 Demonstrate with examples.

    1 Multistage Statistical sampling with particular reference to two-stage sampling: concepts & applicability.
    2 Estimation formulae using two-stage design-

    • 1st stage as PPSWR and the 2nd Stage as SRSWOR
    • SRSWOR in both the stages.

    3 Selection of samples under a two-stage stratified design from a given set of data and estimation of two characteristics of the population from the selected sample. Practical

    Day-4

    Audit Sampling:
    1 What is Statistical Audit Sampling, Its advantages in Audit, The risk of statistical sampling,  Attribute vs. Variable sampling
    2 Attribute sampling plan, determination of optimum sample size along with concepts of confidence level, precision & population deviation rate.
    3 Variable Sampling plan determination of optimum sample size along with concepts of confidence level, precision & population standard deviation.
    4 Un-stratified mean per unit. 5 Stratified mean per unit.

    1 Concept of alpha & beta risk & their relevance in audit hypothesis testing.
    2 Concept of tolerable misstatement & materiality in audit hypothesis testing.
    3 Compliance test vs. Substantive test in audit
    4 Monetary Unit Sampling (MUS) & demonstration of planning and selection of samples using IDEA. Practical example of selection of samples using IDEA-MUS.

    Day-5

    Risk assessment & sampling in audit
    1 Risk based analysis & the risk model in audit.
    2 Risk perceptions as input to statistical sampling.

    Case Studies
    Discussion on risk assessment and statistical sampling with case studies.
    Test and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD and experts from outside.

    ------------------------------------------------------------------------------------------------------------------------

    1.   Course Title : Audit of Government Company with concept of Accounting Standards including Corporate Governance and Corporate Social Responsibility.
    2.   Date               :  01.12.2014 to 05.12.2014
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to equip the participants with the knowledge of concept of Government Company, introduction about the new Company Act 2013, various Accounting Standards with provisions of CSR.
    • At the end of the course, the participants should be able to learn about application of accounting standards and to apply various checks while conducting audit financial audit of government audit.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Introduction and salient features of Government Companies, types of Govt. Company, Legal mandates for Audit of Government Company under CAG DPC Act and provision in the revised Company's Act.

    Audit Objectives and Key issues to be looked into in Audit of Financial Statements and importance of Accounting Policies/Notes on Accounts

    Day-2

    General Awareness on Financial Audit Guidelines issued by ISSAI

    Introduction about Corporate Social Responsibility, Government Guidelines for Public Sector Undertaking. Planning for Audit of Corporate Social Responsibility.

    Day-3

    Corporate Governance- Its meaning, Legal Provisions and Applicability in Public Auditing

    Model of CSR, Business Ethics on CSR, Globalization and Sustainability. Social Audit

    Day-4

    Accounting Standards issued by ICAI

    Accounting Standards issued by ICAI

    Day-5

    Audit Issues-Discussion of Audit Points

    Discussion on case studies from Audit Report on Corporate Governance and valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information


    10. Faculty: The faculty will be drawn from officers of the IA&AD.

    1.   Course Title : Seminar on Audit Quality Management Framework.
    2.   Date               :  15.12.2014 to 17.12.2014
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:
    At the end of the course, the participants should be able to learn about various quality parameters as per international standards prescribed by INTOSAI as well as SAI India in forming audit comments and placing it in audit reports.
    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Introduction to Audit Quality Management Framework and its broad parameters

    Leadership and Direction-Core value and Auditing Standards, Strategic Planning, Portfolio and Risk Management.

    Day-2

    Human Resource Management-Staffing and Training of audit personnel, capacity building, personnel welfare and benefits

    Audit Management and relationship with clients-Audit Planning and Execution, Reporting and Follow up.

    Day-3

    Continuous Improvement through Internal Audit, Internal Quality Assurance and Peer Review with a case study.

    Provisions of ISSAI-40 and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    --------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Audit of Urban Local Bodies & Autonomous Bodies including concept of SRA.
    2.   Date               :  05.01.2015 to 07.01.2015
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The course aims to aware the participants about the steps involved in audit of ULB and Autonomous Bodies.
    • At the end of the course, the participants should be able to understand how the checks applied in conducting audit.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day 1

    Introduction to legal framework for the audit of Autonomous Bodies.
    Constitution and Organization of ULBs and Powers and Functions of ULBs

    Audit of Municipal Funds, Special Funds, Grants, Budget and audit points

    Day 2

    Audit of Taxation, Octroi and Cess; their accounting system and audit points.

    Salient features of Uniform format of accounts-Specific focus on Receipt & Payment Account and Income and Expenditure Account

    Day 3

    Certification of Accounts- Analysis of Balance Sheet, Preparation of SAR and Audit Issues.

    Internal Control. Duties and Powers of Auditor and Auditing Standards issued by C&AG. Adoption of Sampling Techniques in audit. Discussion on Important observations raised in Audit Reports of Different States

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    ----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Seminar on IFRS (IND AS).
    2.   Date               :  19.01.2015 to 20.01.2015
    3.   Duration        : 02 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:
    The course aims to aware the participants about the International Financial Reporting Standards proposed to be introduced in India as against the existing Accounting Standards.
    7.   Programme Content and Structure


    DAY

    TOPICS

    Day 1

    Introduction to IFRS, Difference between IFRS and Ind AS, Challenges for adoption of Ind AS
    Ind AS 101- First Time Adoption of Indian Accounting Standards. Ind AS 1-Presentation of Financial Statements.

    Major changes as compared to AS in respect of- Ind AS-2 Inventories
    Ind AS-7- Statement of Cash Flows, Ind AS-8 Accounting Policies, Changes in Accounting Estimates and Errors, Ind AS-18 Revenue, Ind AS-19 Employee Benefits

    Day 2

    Major changes as compared to AS in respect of- Ind AS-105 Non Current Assets held for Sale and Discontinued Operation, Ind AS-16 Property Plant and Equipment
    Ind AS- 17 Lease, Ind AS-11 Construction Contracts

    Major changes as compared to AS in respect of- Ind AS-23 Borrowing Costs
    Ind AS-36 Impairment of Assets, Ind AS-24 Related Party Disclosure
    Ind AS-38 Intangible Assets

    Day 3

    Ind AS-107- Financial Instrument- Disclosure, Ind AS-32- Financial Instrument-Presentation, Ind AS-39- Financial Instrument-Recognition and measurement

    Ind AS-20- Accounting of Government Grants and disclosure
    Ind AS-28- Investments in Associates, Ind AS-31- Interest in Joint Ventures

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from PSUs and Profession Chartered Accountants.
    ------------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Preparation & Maintenance of R.B.D, B.S.D.L, Treasury Bill, CAO, R.B. Suspense (DR./Cr.), I.S.S. Broad Sheet of Accounts, Advice, Bank Operation.
    2.   Date               :  02.02.2015 to 04.02.2015
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The Course aims to aware the participants regarding the functioning of the Reserve Bank of India with regard to Government Accounting as well as about the operation of Inter-State Suspense Account.
    • At the end of the Course, the participants should be able to:-
      • Define the functioning of the Reserve Bank of India relating to Government Accounting.
      • Maintain the R.B.D. Accounts in the Treasury and the Accountant General’s Office.
      • Identify the process involved in issuing of Grants-in-Aid by the Central Government to the State Government.
      • Maintain Inter-State Suspense Accounts.
      • Reconcile the R.B.D Account maintained in A.G.Office with the R.B.I.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Introduction to R.B.I, Role and function in Government Accounting

    Accounting Procedure in RBI, Hindi, Treasury Bill, Ways & Means Advances etc, Advice, Clearance Memo

    Day-2

    RBD Account maintained in Treasury, Compilation of RBD account in A.G.Office, Practical exercises

    Public Debt, Loans, Grants-in-aid from Central Government, MoF/Moa, MoHRD, MoH & FW etc, Operation of Suspense head- 110- CAO Suspense, Case Study

    Day-3

    Inter State Suspense Account, Inward Claims, Outward Claims, ISS Broadsheet of Accounts, Case Study

    Reconciliation of RBD Account with RBI, Case Study

    Evaluation and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD.
    -----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Special Course on Central Excise, Custom and Service Tax.
    2.   Date               :  09.02.2015 to 13.02.2015
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The course aims at introducing participants to the provisions of the act in assessment and collection of Central Excise, Custom and Service Tax.
    • At the end of the course, the participants should be able to:
    • Understand the various provisions of the Act. 
    • Understand the process involved in assessment and collection of tax.
    • Understand the various checks to be exercised in conducting audit.

    7.   Programme Content and Structure


    DAY

    TOPIC

    Day 1

    Concept of Department Centric Audit
    Important Registers, Records and Books of Accounts to be maintained by Excise & Service Tax Department. Case Study of non maintenance of proper records from Audit Reports

    Overview of Central Excise & Service Tax  Department and its functions
    “Trade Parlance Theory”, classification and valuation. Manufacture, excise duty and levy of excise duties under Central Excise Act

    Day 2

    Valuation under Central Excise & Service Tax Valuation rules

    Various types of Audit conducted in Central Excise. Excisable goods and manufacture.
    Case study relating to captive consumption.

    Day 3

    Provisions relating to levy, assessment and collection of Service Tax including CENVAT.

    Audit issues in respect of assessment of service Tax with special reference to relevant case laws. Penalties and appeal procedures and related audit guidelines. Issue of show cause notices, delegation of power.

    Day 4

    Provisions relating to levy, assessment and collection of Excise duty including CENVAT.

    Point of Taxation, Classification of Services relating to Service Tax

    Day 5

    Exposure to computerized modules used in CBEC.

    Discussion of Audit Points from Audit Reports

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD department, Central Revenue department and PSUs.

    ---------------------------------------------------------------------------------------------------------------------------------------------

    1.   Course Title : Audit of Panchayti Raj Institutions.
    2.   Date               :  23.02.2015 to 27.02.2015
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:
    The course aims at introducing the participants about the historical perspective of the PRIs, their constitutions, budgets and accounting systems and the various schemes executed by the PRIs. At the end of the course the participants should be able to apply audit checks while conducting the PRIs.
    7.   Programme Content and Structure


    DAY

    TOPIC

    Day-1

    Historical perspective of PRIs. Constitutions and Organization of PRIs and Power and Functions of PRIs

    Various Sources of fund/earnings of PRIs. Audit checklist of PRIs Fund/ Grant/earnings and Audit point. Audit of Loans borrowed by PRIs. Preparation of Budget and re-appropriation.

    Day-2

    Classification of accounting heads, accounting of revenues, accounting of Advances and Deposits, accounting of Properties and Stores, Establishment Accounts, office expenses and audit issues

    Procedure for works executed by PRIs, Tender/Contact process, Measurement Book,. Procedure for maintenance of Stores and Stock. Discussion of case studies

    Day-3

    Audit of Central/State schemes implemented through PRIs and relevant formats. Preparation of issue analysis and design matrix

    Group discussion on duties and powers of Auditors, Auditing Standards of PRI issued by C&AG

    Day-4

    Certification Audit, case studies on Audit of Financial Statements of PRIs

    Environment Management and Social Audit. Discussion of Important Observations raised in Audit Reports of Different States in PRI audit.

    Day-5

    Preparation of Reports, Audit observations in respect of some states: Group discussions on miscellaneous audit issues.

    Adoption of Statistical Sampling Techniques in audit of PRIs and evaluation of the course

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information
    10. Faculty: The faculty will be drawn from officers of the IA&AD department and state training institutes.
    ------------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : Seminar on Right to Information Act, Communication Policy and Gender Sensitisation.
    2.   Date               :  16.03.2015 to 18.03.2015
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The course aim to provide information to the participants about the different sections of Right to Information Act 2005 and its historical background.
    • At the end of the course, the participants should be able to:
    • Understand the historical background of Right to Information in its evolution
    • Understand the Different Section , powers and functions of Information Commission and duties and powers of Central Public Information officers (CPIOs) and APIOs
    • Gender Sensitization- Related concepts and jargon; Gender Equality, Gender differentiation, Gender roles, Gender discrimination; Legislative measures in India; Development of women –Indian experience Concessional provisions for women in the Central Services; Rule 3 of CCS (Conduct) Rules; 1964, Prevention of harassment of women in the workplace – GOI orders/guidelines.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day 1

    Overview of RTI Act 2005. Exemption from disclosure, third party information. Provisions relating to appeal and Penalties.

    Miscellaneous provisions of the Act relating to organizations to which the Act does not apply, Constitution, powers and functions of Information Commissions.

    Day 2

    Role and responsibility of public authority. Duties and functions of Public Information Officer.

    Provisions and procedure for obtaining information. Communication policy of
    IA&AD

    Day-3

    Constitutional provisions, Gender empowerment and gender in workplace.

    Gender inequalities, dos and don’t.

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information

    • Faculty: The faculty will be drawn from officers of the IA&AD department.

    ----------------------------------------------------------------------------------------------------------------------------------------------
    1.   Course Title : State Receipt Audit including Audit of VAT.
    2.   Date               :  16.03.2015 to 20.03.2015
    3.   Duration        : 05 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The course aims to make the participants understand the Value Added Tax, (VAT), various checks to be exercise in the Audit of VAT, Audit of Motor Vehicle Tax and Audit of other various types of state receipts.
    • At the end of the course, the participants will also Learn the process of audit state receipts.

    7.   Programme Content and Structure


    DAY

    TOPICS

    Day-1

    An Overview of State Receipts Audit, Audit of Land Revenue

    Audit of VAT- Tax Structure

    Day-2

    Audit of VAT- Scrutiny and assessment under VAT Act

    Cenvat Credit, case studies

    Day-3

    Audit of State Excise Receipts, Audit of Electricity Receipts, case studies

    Audit of Stamps & Registration Receipts, case studies

    Day-4

    Audit of Motor Vehicles Receipts, case studies

    Audit of Mining Receipts, case studies

    Audit of Entertainment Tax Receipts, case studies

    Day-5

    Audit of Entry Tax Receipts

    Audit of Police Receipts, Audit of Water Rate Receipts

    Audit of Interest Receipts

    Test and Evaluation and Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information

    • Faculty: The faculty will be drawn from officers of the IA&AD department.

    -----------------------------------------------------------------------------------------------------------------------------------------------

     

    1.   Course Title : Special Programme on CCO/DDO based Audit.
    2.   Date               :  23.03.2015 to 25.03.2015
    3.   Duration        : 03 days
    4.   Location       : Regional Training Institute, Ranchi
    5.   Programme Background: The training programme is being conducted based on training needs of User Office of RTI Ranchi.
    6.   Learning Objectives:

    • The aim of the course is to make the participant understand the Background, concept and objective of Department Centric/CCO based Audit and how CCO based audit addresses many of the shortcomings of DDO based audit.
    •  At the end of the course, the participants:
    • will also learn about Risk evaluation and selection of CCOs/DDO in a CCO based Audit. They will also gather knowledge about process involved in the Execution of Department Centric Audit.

    7.   Programme Content and Structure


    DAY      

    TOPICS

    Day-1

    Background, Concept and Objectives of CCO Based Audit

    Risk Evaluation and Selection of CCOs/DDO units and Planning for Department –Centric Audit

    Day-2

    Executing the work and supervising  the Department –Centric Audit

    Drafting of Audit Conclusions and Reporting

    Day-3

    Change Management, Discussion of Case study on Chief Controlling Officer Based Audit-Science and Technology Department

    Discussion on ISSAI Guidelines Discussion of Case Study and
    Valediction

    8.   Methodology: Lectures, Presentation, Exercises and Interactive sessions.
    9.   Target Participants: AAOs/AOs/Sr.AOs
    Additional Information

    • Faculty: The faculty will be drawn from officers of the IA&AD department.

    Information Technology Courses:

    1.

    Course Title

    Level – I  Basic Computer Skills Windows, MS Office (MS Word,MS Excel & MS Power Point)

    2.

    Date

    21.4.2014 to 26.4.2014, 21.7-2014 to 26.7.2014, 15.12.2014 to 20.12.2014 & 23.3.2015 to 28.5.2015

    3.

    Duration

    06 days

    4.

    Location

    Regional Training Institute, Ranchi

    5.    Programme Background:    The Training programme on “Level – I Basic Computer Skills Windows, MS Office (MS Word, MS Excel & MS Power Point)” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
    6.         Learning Objectives
    (i)            The course attempt to enable the participants to use MS Word, MS Excel and MS Power Point effectively in the department.
    (ii)           At the end of the course the participants would be able to :

    • Understand the Windows OS, Windows explorer, file and folder
        • Work in MS Word with its basic features e.g. File management, formatting, editing, page setup, working with table, Working with Charts & MAIL MERGE documents, Printing documents etc.
        • Work in MS Excel with its basic features e.g Creating a Workbook, Saving & Retrieving a Workbook, Creating and modifying worksheets, Formatting Cells - Rows, Columns, Page setup, Use Formulae in Excel with Functions  & Sorting, Sub-Totals & Creating Charts & Printing worksheets etc.
        • Work in MS  Power Point creating power point presentation, with its multiple features  such Slide layout, slide design, inserting –tables, charts and pictures, slide view & Printing of power points presentation as slides and handouts

    7.    Programme Content and Structure:


    DAYS

    TOPICS

    Day-1

    IT Awareness- Hardware, Software(System/Application), Operating Systems, Windows Environment(Start Menu, Programs, Documents, Settings, Search, Help & Support, Run, Control Panel, Desktop, Icons  etc.),  Creating folders & Files, Copying  folders and files, Recycle Bin, Internet Explorer

    Day-2

    MS-Word- creating a document, saving a document, cut, copy, paste & other commands,  Character  formatting, Paragraph formatting, Bullets & Numbering, Page Set-up, Page Border.

    Columns, Change Case, Drop Caps, Auto Text, Header  & Footer, Page Set-up, Spelling Check & Grammar, Printing
    Views- Normal,  Print layout, Outline,
    Insert - Page Break, Page Number, Symbols, Pictures, Charts, Word Arts, Track Change

    Day-3

    Tables : Insert Table, Data Entry, Modify Table, Table Formatting, Convert Table to Text & Text to Table, Sorting data, Use of Formulae, MAIL MERGE

    Practice Session on  MS Word

    Day-4

    Introduction to MS Excel, Creating a Workbook, Saving & Retrieving a Workbook, Creating and modifying worksheets, Formatting Cells - Rows, Columns, Worksheets, Inserting – Rows, Columns, Worksheets, Page setup, Printing worksheets

    Using Formulae in Excel with Functions

    Day-5

    Using Formulae in Excel with Functions…contd.

    Sorting, Sub-Totals, Creating Charts

    Day-6

    Practice Session on Excel

    Introduction to MS  PowerPoint
    Slide layout, slide design, inserting –tables, charts and pictures, slide show.

    8          Methodology          : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.         Target Participants:         Group ‘B’ & ‘C’ officers/Officials
    Additional Information
    10        Faculty:       The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officers from the IA & AD
    ------------------------------------------------------------------------------------------------------------------------------------------------

    1.

    Course Title

    Computer Hardware, Peripherals, Maintenance and Basics of Network

    2.

    Date

    5.5.2014  to 8.5.2014

    3.

    Duration

    04 days

    4.

    Location

    Regional Training Institute, Ranchi

    5.    Programme Background:            The Training programme on “Computer Hardware, Peripherals, Maintenance and Basics of Network” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
    6.      Learning Objectives
                (i)       The course attempt to enable the participants to demystify the Computer Hardware, Peripherals, Maintenance and Basics of Network for departmental use. 
                (ii)      At the end of the course the participants would be aware of the following:

    • Computer Hardware, the CPU and its technology,  Memory, Add-In Adapter Cards, SMPS and its voltage details with trouble shooting, Peripheral Hardware, its Installation & identifying common problems.
    • PC assembly, Disassembly & Installation
    • POST-definition-Definition of IPL Hardware, Error codes, Auto codes, video codes, Fault finding in Secondary Storage Devices
    • Serial and parallel testing ports, cable connection Modems, Software/Hardware Diagnostics, Trouble shooting  faults, Preventive maintenance(software updates, update anti viruses, anti spy ware definition regularly. Disk defrags), ESD Protection and safety.
    • Local Area Networks- Servers and Nodes, LAN Protocols and Topology, LAN cabling, LAN installation, LAN Administration

    7.   Programme Content and Structure:


    DAYS

    TOPICS

    Day-1

    Computer Hardware, the CPU and its technology,  Memory(FDD,HDD,CD/DVD/RW, Removable storage, Disks, names, purposes and characteristics of Motherboard, Add-In Adapter Cards, SMPS and  its voltage details with trouble shooting. Peripheral Hardware- Monitor and its types, Pixels and Resolution, Keyboard & its types, Mouse, CD ROM/RW, DVD, Floppy. Form factor-ATX/BTX, micro ATX/NLX. Installation, identifying common problems.

    Day-2

    Components: Integrated I/O, Memory Slots, Processor sockets, External Cache memory, Bus architecture, Bus slots, PATA/SATA/SCSi Ports: serial, parallel, VGA, Universal Serial Bus (USB), PS/2, Keyboard, Game, Sound and Fire Wire (IEEE 1394). Installation, identifying common problems and trouble shooting.

    Peripheral Devices: Printers, Scanners, Modem, projectors, Connector type: VGA,DVI/HDMi, S-Video, Component/RGB, Settings thereto
    Installation, identifying common problems and troubleshooting

    Day-3

    PC assembly, Disassembly & Installation:  Mother Board- Configuration, Slot details, serial port & parallel port, Installation of other devices-CMOS- definition in BIOS, BOOT, Introduction to Primary and secondary memory, OS, Hard disk detection, Password setting,

    POST-definition-Definition of IPL Hardware, Error codes, Auto codes, video codes, Fault finding in Secondary Storage Devices

    Day-4

    Serial and parallel testing ports, cable connection Modems, Software/Hardware Diagnostics, Trouble shooting  faults, Preventive maintenance(software updates, update anti viruses, anti spy ware definition regularly. Disk defrags), ESD Protection and safety
    Local Area Networks- Servers and Nodes, LAN Protocols and Topology, LAN cabling, LAN installation, LAN Administration.

    8    Methodology          : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.   Target Participants:         Group ‘B’ & ‘C’ officers/Officials of the user of the RTI/Ranchi.
    Additional Information
    10           Faculty:         The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officers from the IA & AD and outside qualified faculty from NIC, MECON Ltd., JAPIT & XISS etc.
    ---------------------------------------------------------------------------------------------------------------------------------------------


    1.

    Course Title

    Level-I - IT Audit

    2.

    Date

    1.4.2014 To 5.4.2014, 15.9.2014 To 19.9.2014
    19.1.2015 To 23.1.2015

    3.

    Duration

    05 days

    4.

    Location

    Regional Training Institute, Ranchi

    5.       Programme Background:          The Training programme on “Level-I - IT Audit” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
    6.       Learning Objectives
               (i)       The course attempt to enable the participants to use Level-I - IT Audit  effectively in the department.
    (ii)        At the end of the course the participants would be aware of the following:

        • IT Audit, its Need & Planning, Impact of IT on controls, Audit Objectives and Approach
        • Introduction to CoBIT
        • IT Controls, Controls in Computerized Environment along with Case study
        • Introduction of Computer Assisted Audit Techniques: Introduction to CAATs & Overview of IDEA

    7.    Programme Content and Structure:


    DAYS

    TOPICS

    Day-1

    Define IT Audit, Need for IT Audit, Impact of IT on controls, Planning an IT Audit, Audit Objectives and Approach

    Introduction  to CoBIT

    Day-2

    IT Control, Controls in Computerized Environment. The impact of various factors in IT Audit.

    General Controls, Organization, Planning & Management Controls, Case study

    Day-3

    Project Management, IT Operations Management, Change Management, case study

    Access controls, Networks controls and  Security,
    Audit of Access controls, Network controls and Security, Case study

    Day-4

    IT Acquisition Control, Service Level Management Controls, Audit of Service Level Management Controls,
    Disaster Recovery Controls, Audit of Disaster Recovery Controls, Case study

    System Development Controls, Environment and End User Computing Controls
    Acquisition and Delivery Controls, Case study

    Day-5

    Application Controls , Input Controls ,Audit of Input Controls, Processing and Output Controls, Audit of Processing and Output Controls, Case study

    Computer Assisted Audit Techniques: Introduction to CAATs
    Overview of IDEA and Evaluation

    8     Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.    Target Participants:           Group ‘B’ & ‘C’ officers/Officials of the user of the RTI/Ranchi
    Additional Information


    10   Faculty:         The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officers from the IA & AD and outside qualified faculty from Central PSUs

    1.

    Course Title

    Level -II -Database Concepts, System Concept and introduction to MS Access

    2.

    Date

    19.5.2014 to 24.5.2014, 1.9.2014 to 6.9.2014, 1.12.2014 to 6.12.2014

    3.

    Duration

    06 days

    4.

    Location

    Regional Training Institute, Ranchi

    5.    Programme Background:            The Training programme on “Level -II -Database Concepts, System Concept and introduction to MS Access” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.

     

    6.    Learning Objectives
    (i)         The course attempt to enable the participants to aware the concepts of Database Concepts, System Concept and introduction to MS Access.
    (ii)        At the end of the course the participants would be aware of the following:

    • Database Concepts
    • Working with Tables followed by practical exercise
    • Working with different type of Query followed by practical exercise.
    • Working with Forms & Reports

    7.   Programme Content and Structure:


    DAYS

    TOPICS

    Day-1

    MS ACCESS- Concepts of DBMS, RDBMS, MS ACCESS as RDBMS- Concept of Data bases and table in MS ACCESS

    Creating Tables and working with Tables & Types of Data with practical exercise

    Day-2

    Working with external data, importing and linking external data, Setting up a query, Query criteria, Key words & wild card in a query-practical exercises

    Working with Query(Select Query & use of operator) & Adding calculation to Query

    Day-3

    Practice session on above

    Summary Query, Parameter Query, Crosstab Query with practical exercise

    Day-4

    Action Query- Make table Query, Append Query, Delete Query, and Update Query & Joining of tables with practical exercise.

    MS ACCESS – Functions

    Day-5

    Practice session on Functions

    Working with Forms &Reports

    Day-6

    Working with Forms &Reports contd.

    Assessment

    8    Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.   Target Participants:           Group ‘B’ & ‘C’ officers/Officials
    10  Additional Information


    Faculty:    The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officials from the IA & AD

    1.

    Course Title

    Special Course on MS Office Advance Excel

    2.

    Date

    26.5.2014 to 29.5.2014, 5.1.2015 to 8.1.2015

    3.

    Duration

    04 days

    4.

    Location

    Regional Training Institute, Ranchi

    5          Programme Background:            The training programme on “Special Course on MS Office Advance Excel” is being conducted based on projected training requirements of User Offices of RTI, Ranchi. As discussed in the RAC Meeting of RTI, Ranchi the course has been designed as per Training Need Analysis.
    6          Learning Objectives         

    • The course will enable the participants to work on MS Excel Software.
    • At the end of the course the participants should be able to :
        • Work in MS Excel with its basic features
        • Use Conditional Formatting, use of Data Validation, use Formulae in Excel with Functions & Sorting, Sub-Totals & Creating Charts & Pivot Chart etc.
        • Work with Macros & Dynamic Linking between MS Excel & Oracle Database through ODBC connectivity.

    7.         Programme Content and Structure

    DAYS

    TOPICS

    Day-1

    Introduction to MS Excel-Familiarization with Tool Bar, Formula Bar, Status Bar, Create/Save/Close/Open Workbook, Concept of Workbook/Worksheet/Cell, Making Long Text entry, Formatting cell and Exercises
    Auto Correct Option, Auto Complete Option, Auto Calculate Features, Importing External Data, Sorting, Filter, Subtotals, Page Break, Hyperlink  and Exercises

    Day-2

    More Formatting Techniques: Creating Style, Applying style, Changing the formatting of a style, Removing a style from cells, Deleting a style.
    Conditional Formatting: Using conditional formatting, Changing conditional formatting, Deleting conditional formatting, Finding cells with conditional formatting

    Use of Data Validation with practical exercises

    Day-3

    Formula, Calculation and Functions and Exercises
    Chart& Pivot Chart and its manipulation and Exercises

    Day-4

    Working with Macros: Recording of a Macro, Executing of Macro, Editing a Macro and Assigning a Macro to a command button.
    Dynamic Linking between MS Excel & Oracle Database through ODBC connectivity

    8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials
    Additional Information
    10        Faculty:         The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officers and outside qualified faculty.
    --------------------------------------------------------------------------------------------------------------------


    1.

    Course Title

    Information System backup policy and recovery

    2.

    Date

    9.6.2014 to 12.6.2014

    3.

    Duration

    04 days

    4.

    Location

    Regional Training Institute, Ranchi

    5.      Programme Background:            The Training programme on “Information System backup policy and recovery” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
    6.      Learning Objectives
    (i)     The course attempt to enable the participants to aware the concepts of Information System backup policy and recovery.
     (ii)    At the end of the course the participants would be aware of the following:

    • Introduction to Information System Security-Concept Approach and Method- Backup policy as a Security policy.
    • Use of System tools-viz. Backup, Disk Clean Up, Disk fragmentation, System Information and System Restore etc. in Windows environment
    • Password Management, Password Recovery tools, Network Management & Security thereto, Network Management tools, Types of Domain, Domain Security Management and IT ACT

    7.         Programme Content and Structure:


    DAYS

    TOPICS

    Day-1

    Introduction to Information System Security-Concept Approach and Method

    Information System Security-Concept Approach and Method - Backup policy as a Security policy

    Day-2

    Use of windows  System tools-Backup, Disk Clean Up, Disk fragmentation, Files & Settings Transfer Wizard, Scheduled Tasks, System Information and System Restore. Practice Session

    Day-3

    Recovery of deleted files, Password Management, Password Recovery tools, Network Management & Security thereto, Network Management tools.

    How to create data  back up and restore in Windows environment, Creating  a backup of Oracle Data and restoration of the same

    Day-4

    Types of Domain, Domain Security Management. IT ACT

    8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test.
    9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials
    10        Additional Information
    Faculty:       The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officials from the IA & AD and outside qualified faculty from NIC, JAPIT & XISS etc.
    1. Course Title         : Level II -IT Audit (Advance)
    2. Date           : 16.6.2014 to 26.6.2014, 17/11/2014 to 27.11.2014 & 02/02/2015 to 12.2.2015
    3. Duration   :10 days.
    4. Location   :Regional Training Institute, Ranchi.
    5. Programme Background         : The Training programme on “Level Level II -IT Audit (Advance)” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
    6. Learning Objectives
          (i)         The course will give participants more exposure to IT Audit, COBIT, IT controls, use of CAATs(IDEA)  for data downloading and data analysis. The participants will be able to carry out IT Audit more effectively understanding the important business models, contracts, SLAs, e-Governance and Data Downloading & analysis of data by using IDEA.
          (ii)        At the end of the course the participants should be able to :

    • Understand the IT Audit, its objective, Mandate, Steps and IT Audit process and planning.
    • Understand the IT Controls in IT Environment
    • Familiar with RDBMS Management System and Clint connectivity, Data downloading
    • Understand the Application Controls.
    • Familiar with  the importance of e-Governance
    • Data Downloading, Use of CAATs (IDEA) for data downloading and data analyzing.

    7.         Programme Content and Structure:


    DAYS

    TOPICS

     Day-1

    Define IT Audit, Need for IT Audit, Impact of IT on controls, Planning an IT Audit. Audit Objectives and Approach

    Introduction to CoBIT. Executive Summary, Framework Management Guidelines, Control Objectives, Audit Guidelines

    Day-2

    General Controls. Audit Organization, Planning & Management Controls & Service Level Management Controls Audit of Service Level Management Controls

    General Controls. Environment and End User Computing Controls
    Access Controls, Network controls,
    Audit of Physical Access Controls, Network controls and audit IT Security

    Day-3

    General Controls. System Development Controls, Audit of System Development Controls. Disaster Recovery Controls, Audit of Disaster Recovery Control,  Project Management, IT Operation Management

    General Controls. Acquisition of and Delivery Controls, Audit of Acquisition of and Delivery Controls

    Day-4

    Application Controls. Input Controls, Audit of Input Controls, Processing and Output Controls, Audit of Processing and Output Controls

    E-Governance and Audit thereof

    Day-5

    Changing mind set for achieving success with interpersonal competence and preparing for paradigm shift with positive thinking

    RDBMS Management System and Clint connectivity, Data downloading

    Day-6

    Introduction and Overview of Computer Assisted Audit Technique (CAAT) and IDEA, Essentials of Data Downloading, Use of IDEA  in data downloading
    Exercises in Data Downloading using IDEA

    Using of IDEA for Data Extraction (Direct, Indirect, Key Value extraction, Top record extraction)  and Group records with Exercise

    Day-7

    Using of IDEA for Data Analysis- Groping of Records, Field Manipulation/Joining of Databases, Using of IDEA for Data Analysis-Duplicate Key detection, Gap detection

    Using of IDEA for Data Analysis-Stratification, Summarisation, Viewing the result with Graph, Aging, with Exercise

    Day-8

    Using of IDEA for Data Analysis- Sampling  (Systematic, Random, and stratified random) with exercise

    Using functions for data analysis in IDEA

    Day-9

    Evidence collection and evaluation, Documentation, Design a Report, Printing a report with exercise

    Housekeeping function – Backup, deleting,  copying, moving, refreshing the database

    Day-10

    Case Studies with Practical Exercises, Evaluation and Valediction

    8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
    9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials.
    10        Additional Information
    Faculty:          The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officials from the IA & AD and outside qualified faculty from NIC, JAPIT & XISS etc.
    ------------------------------------------------------------------------------------------------------------------------------------------------
    1. Course Title         : Oracle 11G and DBA functions Workshops
    2. Date           :                       7-7-2014 to 12-7-2014
    3. Duration   :           6 days.
    4. Location   :           Regional Training Institute, Ranchi.
    5. Programme Background         : As per headquarters’ instruction “Oracle 11g/10g and DBA functions” scheduled to be held from 7.7.2014 to 12.7.2014 by M/s. J. K Technosoft the empanelled vendor of office of the Comptroller & Auditor General of India.
    6. Learning Objectives
     (i)        The course will enable the participants to be well verse in the area of VLC, GPF Accounts maintenance and pension finalization cases which were technically up-graded to higher platform with Oracle 11g(GPF & VLC), Oracle 10g(Pension application) and Linux OS.
    (ii)        At the end of the course the participants should be able to :

        • Understand the various features of “Oracle 11g”, its installations, creations of database instance etc.
        • Configure the Oracle Network Environment, Management the database, performing backup & recovery etc.
        • Monitor and Tuning RMAN, Use Flashback Technology, Manage Memory and manage Performance by SQL Tuning etc.
        • Managing Resource database and resource, Space in Blocks & in segment and duplicating a Database etc.

        7. Programme Content and Structure.


        DAYS

        TOPICS

        Day-1

        Exploring the Oracle Database Architecture ;

        • Oracle Database Architecture Overview; Oracle ASM Architecture Overview; Process Architecture;Memory structures ;Logical and physical storage structures ; ASM storage components

        Installing Oracle Software

        • Tasks of an Oracle Database Administrator ;Tools Used to Administer an Oracle Database ;Installation: System Requirements;Oracle Universal Installer (OUI);Installing Oracle Grid Infrastructure;Installing Oracle Database Software;Silent Install

        Creating an Oracle Database

        • Planning the Database ;Using the DBCA to Create a Database;Password Management;Creating a Database Design Template;Using the DBCA to Delete a Database

        Managing the Oracle Database Instance

        • Start and stop the Oracle database and components ;Use Oracle Enterprise Manager ;Access a database with SQLPlus ;Modify database installation parameters ;Describe the stages of database startup ;Describe database shutdown options  ;View the alert log ;Access dynamic performance views

        Manage the ASM Instance

        • Set up initialization parameter files for ASM instance ;Start up and shut down ASM instances ;Administer ASM disk groups

        Configuring the Oracle Network Environment

        • Use Enterprise Manager to create and configure the Listener ;Enable Oracle Restart to monitor the listener ;Use tnsping to test Oracle Net connectivity; Identify when to use shared servers and when to use dedicated servers

        Managing Database Storage Structures

        • Storage Structures ;How Table Data Is Stored ;Anatomy of a Database Block; Space Management in Tablespaces ;Tablespaces in the Preconfigured Database; Actions with Tablespaces; Oracle Managed Files (OMF)

        Day 2

        Administering User Security

        • Database User Accounts ;Predefined Administrative Accounts ;Benefits of Roles ;Predefined Roles ;Implementing Profiles

        Managing Data Concurrency

        • Data Concurrency ;Enqueue Mechanism;Resolving Lock Conflicts ;Deadlocks

        Managing Undo Data

        • Data Manipulation ;Transactions and Undo Data ;Undo Data Versus Redo Data; Configuring Undo Retention

        Implementing Oracle Database Auditing

        • Describe DBA responsibilities for security ;Enable standard database auditing
        • Specify audit options ;Review audit information ;Maintain the audit trail

        Database Maintenance

        • Manage optimizer statistics ;Manage the Automatic Workload Repository (AWR) ;Use the Automatic Database Diagnostic Monitor (ADDM) ;Describe and use the advisory framework ;Set alert thresholds  ;Use server-generated alerts;Use automated tasks

        Performance Management

        • Performance Monitoring ;Managing Memory Components ;Enabling Automatic Memory Management (AMM) ;Automatic Shared Memory Advisor  ; Using Memory Advisors ;Dynamic Performance Statistics ;Troubleshooting and Tuning Views ;Invalid and Unusable Objects

        Day 3

        Backup and Recovery Concepts

        • Part of Your Job ;Statement Failure ;User Error ;Understanding Instance Recovery ;Phases of Instance Recovery ;Using the MTTR Advisor ; Media Failure ; Archive Log Files

        Performing Database Backups

        • Backup Solutions: Overview ;Oracle Secure Backup ;User-Managed Backup ; Terminology ;Recovery Manager (RMAN) ; Configuring Backup Settings ; Backing Up the Control File to a Trace File ;Monitoring the Flash Recovery Area

        Performing Database Recovery

        • Opening a Database ;Data Recovery Advisor ;Loss of a Control File ;Loss of a Redo Log File ;Data Recovery Advisor ;Data Failures Listing Data Failures Data Recovery Advisor Views

        Moving Data

        • Describe ways to move data ;Create and use directory objects ;Use SQL*Loader to move data ;Use external tables to move data ;General architecture of Oracle Data Pump ;Use Data Pump export and import to move data

        Working with Support

        • Use the Enterprise Manager Support Workbench ;Work with Oracle Support; Log service requests (SR) ;Manage patches

        Core Concepts and Tools of the Oracle Database

        • The Oracle Database Architecture: Overview ;ASM Storage Concepts ; Connecting to the Database and the ASM Instance; DBA Tools Overview

        Day 4

        Configuring for Recoverability

        • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology ; Using the Recovery Manager (RMAN) ;Configuring your Database for B&R Operations ;Configuring Archive log Mode ;Configuring Backup Retention ; Configuring and Using a Flash Recovery Area (FRA)

        Using the RMAN Recovery Catalog

        • Tracking and Storing Backup Information ;Setting up a Recovery Catalog ; Recording Backups ;Using RMAN Stored Scripts ;Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog) ;

        Configuring Backup Settings

        • Configuring and Managing Persistent Settings for RMAN;Configuring Autobackup of Control File ;Backup optimization ;Advanced Configuration Settings: Compressing Backups ;Configuring Backup and Restore for Very Large Files (Multisection)

        Creating Backups with RMAN

        RMAN backup types ;Creating and Using the following: Backup Sets and Image Copies ;- Whole Database Backup ;- Fast Incremental Backup ;- Configure Backup Destinations ;- Duplexed Backup Sets ;- Archival Backups

        Restore and Recovery Task

        • Restoring and Recovering;Causes of File Loss ;Automatic Tempfile Recovery ;Recovering from the Loss of a Redo Log Group ;Recovering from a Lost Index Tablespace ;Re-creating a Password Authentication File ;Complete and Incomplete Recovery ;Other Recovery Operations

        Using RMAN to Perform Recovery

        • Complete Recovery after Loss of a Critical or Noncritical Data File ;Recovering Image Copies and Switching Files ;Restore and Recovery of a Database in NOARCHIVELOG Mode ;Incomplete Recovery ;Performing Recovery with a Backup Control File ;Restoring from Autobackup: Server Parameter File and Control File; Restoring and Recovering the Database on a New Host

        Day 5

        Monitoring and Tuning RMAN

        • Monitoring RMAN Jobs ;Balance Between Speed of Backup Versus Speed of Recovery ;RMAN Multiplexing ;Synchronous and Asynchronous I/O ;Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

        Diagnosing the Database

        • Data Recovery Advisor (DRA) ;Block Corruption ;Automatic Diagnostic Repository (ADR) ;Health Monitor ;The ADR Command-Line Tool, ADRCI

        Using Flashback Technology I

        • Flashback Technology: Overview and Setup ;Using Flashback Technology to Query Data ;Flashback Table ;Flashback Transaction Query ;Performing Flashback Transaction Backout

        Using Flashback Technology II

        • Oracle Total Recall; Flashback Drop and the Recycle Bin

        Performing Flashback Database

        • Configuring Flashback Database ;Performing Flashback Database Operations ; Monitoring Flashback Database

        Managing Memory

        • Oracle Memory Structures ;Oracle Database Memory Parameters ;Using Automatic Memory Management ;Automatic Shared Memory Management ;Using Memory Advisors ;Using Data Dictionary Views

        Day 6

        Managing Database Performance

        • Tuning Activities ;Using Statistic Preferences ;Optimizer Statistics Collection; Monitor the Performance of Sessions and Services ;Automatic Workload Repository (AWR) ;Describing the Benefits of Database Replay

        Managing Performance by SQL Tuning

        • SQL Tuning and SQL Advisors ;Using SQL Tuning Advisor ;SQL Access Advisor ;SQL Performance Analyzer Overview

        Managing Resources

        • Database Resource Manager: Overview and Concepts ;Accessing and Creating Resource Plans ;Creating Consumer Group ;Specifying Resource Plan Directives, including: - Limiting CPU Utilization at the Database Level.

        Automating Tasks with the Scheduler

        • Simplifying Management Tasks;Creating a Job, Program, and Schedule;Using Time-Based, Event-Based, and Complex Schedules;Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups; Multi-Destination Jobs

        Managing Space in Blocks

        • Free Space Management  ;Monitoring Space ;Compressing Data

        Managing Space in Segments

        • Segment Creation on Demand ;Additional Automatic Space-Saving Functionality;Shrinking Segments  ;Segment Advisor ;Managing Resumable Space Allocation

        Managing Space for the Database

        • Using 4 KB-Sector Disks ;Transporting Tablespaces;Transporting Databases ; Duplicating a Database ;Purpose and Methods of Cloning a Database ;Using RMAN to Create a Duplicate Database ;Cloning a Database from a Backup ; Duplicate a Database Based on a Running Instance ;Targetless Duplicating a Database

        Duplicating a Database

        • Purpose and Methods of Cloning a Database ;Using RMAN to Create a Duplicate Database ;Cloning a Database from a Backup ;Duplicate a Database Based on a Running Instance ;Targetless Duplicating a Database       Valediction

        8          Methodology           : Lectures, Presentations, Interactive sessions by the trainer of M/s. J. K Technosoft
        9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials
        Additional Information:-
        10        Faculty:- The trainer from M/s. J. K Technosoft an empanelled vendor of office of the Comptroller & Auditor General of India
        ------------------------------------------------------------------------------------------------------------------------------


        1

        Course Title

        CAAT – SQL

        2

        Date

        4.8.2014 to 8.8.2014

        3

        Duration

        05 days

        4

        Location

        Regional Training Institute, Ranchi

        5          Programme Background:            The training programme on “CAAT – SQL” is being conducted based on projected training requirements of User Offices of RTI, Ranchi. As discussed in the RAC Meeting of RTI, Ranchi the course has been designed as per Training Need Analysis.
        6          Learning Objectives         

        • The course will enable the participants to use SQL as CAAT.
        • At the end of the course the participants should be able to :
          • Describe the various features of RDBMS – “Oracle”.
          • Use SQL – Commands/Functions, Constraints and set security measures in day to day work in  RDBMS – Oracle based software like VLC etc..
          • Use SQL command in querying the data.
          • Perform analytic activity over data

        7.         Programme Content and Structure

        DAYS

        TOPICS

        Day-1

        Introduction to RDBMS, System Concept, MY-SQL, ORACLE, MS-ACCESS, Understanding tables, Relation between tables, constraints, Data  Type, Syntax, Expression. Computer Assisted Audit Technique, use of SQL, Data downloading

        Day-2

        QUERY(Insert, Update, Select, Delete)

        CLAUSES ( where, Like, Top, And & Or, Distinct, IN, Between, Order by, Group by, Count, Having)

        Day-3

        SQL – FUNCTIONS (Count, Max, Min, AVG, Sum, SQRT, Rand, Concat, Numeric AND String).

        SQL- FUNCTIONS Practice session.

        Day-4

        Sub Query. Query using JOINS ( Equi Joins, Outer Joins & Self Joins)

        Day-5

        JOINS, Union, Intersection and Minus Query

        8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
        9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials of the user of the RTI/Ranchi and outside qualified faculty from NIC, JAPIT & XISS etc.
        10        Additional Information
        Faculty:  The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officials from the IA & AD.
        --------------------------------------------------------------------------------------------------------------------------------------

        1.

        Course Title

        IT Audit using VLC Data

        2.

        Date

        18.8.2014 to 23.8.2014

        3.

        Duration

        06 days

        4.

        Location

        Regional Training Institute, Ranchi

        5           Programme Background:            The training programme on “Use of VLC Software for Audit” is being conducted based on projected training requirements of User Offices of RTI, Ranchi. As discussed in the RAC Meeting of RTI, Ranchi the course has been designed as per Training Need Analysis.
        6          Learning Objectives                 :

        • The course will enable the participants to use MS Access as CAAT for analytic data.
        • At the end of the course the participants should be able to :
          • Familiar the Government Account and VLC Software.
          • Familiar with accounting documents and relevant fields in VLC Software.
          • Familiar with various Modules of VLC Software and identify analytic data.
          • Understand & use of Oracle SQL command in querying the VLC data.
          • Understand & use of IDEA in extracting and analyzing the VLC data.

        7.         Programme Content and Structure:


        DAYS

        TOPICS

        Day-1

        Overview to Government Accounting System & VLC

        Database Concepts, Introduction of VLC in A&E offices

        Day-2

        Structure of VLC Database

        Data Analysis using Microsoft Access and CAAT

        Day-3

        Data Analysis /Queries relating to Treasuries Module

        Data Analysis /Queries relating to Compilation Module

        Day-4

        Data Analysis /Queries relating to Works & Forest

        Data Analysis /Queries relating to Account Current

        Day-5

        Queries relating to Book Section and Civil Accounts

        Queries relating to Finance Accounts

        Day-6

        Queries relating to Appropriation Accounts
        Importing and sampling in IDEA and Evaluation

        8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
        9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials
        10        Additional Information
        Faculty:          The faculty will be drawn from resource pool comprising of Group ‘A’ Group and ‘B’ officials from the IA & AD
        --------------------------------------------------------------------------------------------------------------------


        1.

        Course Title

        Audit in IT Environment and ERP

        2.

        Date

        25.8.2014 to 29.8.2014

        3.

        Duration

        05 days

        4.

        Location

        Regional Training Institute, Ranchi

        5           Programme Background:            The training programme on “Audit in IT Environment and ERP” has been included in the ACTP 2014-15 based on projected training requirements of User Offices of RTI, Ranchi in the RAC Meeting of RTI, Ranchi.
        6          Learning Objectives:
        The course will enable the participants to be able to audit in IT as well as in ERP Environment.

            • At the end of the course the participants should be able to :
        • Understand the Basics of IT Audit & Importance of Various Controls in IT audit
        • Understand the CAAT and data analysis in MS Excel and MS ACCESS
        • Data analysis in IDEA
        • Understand the SAP ERP and its basics(Overview, History, Architecture etc.) and work in ERP environment

        7.         Programme Content and Structure:


        Day

        TOPIC

        Day 1

        Basics of IT Audit & Importance of Various Controls in IT audit

        Introduction and  Overview of CAAT
        Analysis of Data Using MS Excel & MS ACCESS

        Day 2

        Introduction to IDEA, Importing files, Data extraction(Direct, Indexed, Key Value, Top Record), Stratification, Summarization

        Using  of IDEA for Data Analysis-
        Viewing the result graph, ageing, Field Manipulation, Joining Databases, Identifying duplicate Invoices, Gap Detection, Duplicate  in Invoice Number

        Day 3

        Introduction to SAP, Business without ERP ;Overall Picture ; Why Enterprise Architecture: Enterprise Structure – Integrating Business; Enterprise Architecture; Why Now? ; Enterprise Architecture; Benefits History of SAP; Steps to Strategic Business; Evolution of SAP;

        SAP R/3 Architecture
         3 Tier/Client/Server Architecture ; Overview of presentation & database servers ; SAP R/3 conceptual areas; Systems in R/3; Clients in R/3;• R/3 Technology environment; Platforms and databases supported by R/3; Client Server Benefit SAP R/3 modules

        Day 4

        SAP Modules
        • SAP R/3 Application Modules; Module functionalities and navigation
        :Module FI – Financial Accounting
        Module CO – Controlling
        Module SD – Sales and Distribution

        Module functionalities and navigation:
        Module on Module MM – Material management
        Module PP – Production Planning
         Module QM – Quality Management
        Module QM – Quality Management
        Module PS: Project Systems
        Module HR: Human Resources

        Day 5

        SAP Audit Trail
        Objectives of Audit Trail
        •Deductive fraud auditing –vendor fraud; Introduction to audit trail analysis;Role-based access control in SAP R/3;Audit trails in SAP R/3;•Fraud detection methodology

        Standard Reports Analysis
        - Z and Y Reports in SAP; Standard Tables and Data Extraction Exercise;- Export and Import of Data; Exporting SAP Data/ Reports into Excel.

        8          Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
        9.         Target Participants:           Group ‘B’ & ‘C’ officers/Officials of the user of the RTI/Ranchi having attended Level II IT courses
        10        Additional Information


        Faculty:          The faculty will be drawn from resource pool comprising of Group ‘A’ and ‘B’ officials from the IA & AD for the first two days and for subsequent 3 days on ERP the trainer may be from Outside.

        1.

        Course Title

        Internet, E-mail and Networking

        2.

        Date

        13.10.2014  to 16.10.2014, 9.3.2015 to 12.3.2015

        3.

        Duration

        04 days

        4.

        Location

        Regional Training Institute, Ranchi

        5.   Programme Background:            The Training programme on “Internet, E-mail and Networking” is being conducted based on projected training requirements of field office of RTI/Ranchi. The course has been discussed in the RAC meeting.
        6.   Learning Objectives
              (i)         The course attempt to enable the participants to aware the concepts of Internet, E-mail and Networking and its uses in the Department.
              (ii)        At the end of the course the participants would be aware of the following:

        • Introduction to Network, internet, use of search engines such as Google etc
        • Hardware & software requirement to connect to the internet; Types of Network, Client-server Model,  Addressing in internet (DNS, Domain and its type), DNS Server and the internet, Intranet etc.
        • Internet Security-Threats, Firewall, Internet Security Management Concepts, Information Privacy, Copyright issues, Basics of Asymmetric Cryptosystems etc.

        7.      Programme Content and Structure:


        DAYS

        TOPICS

        Day-1

        Introduction to network- Features of internet and its application, How the internet works, Network & internet. Owner of the Internet,  E-mail, Web page, Web site, Web servers and its application, web browser- Text based & Graphical

        Hardware & software requirement to connect to the internet, Modem and its configuration, ISP,  Protocol and Configuration for TCP/IP
        Finding service provider, Making connection with the servers, Internet addressing-Domains and sub domains, IP address and DNS, Creating an e-mail account.

        Day-2

        Network- Types of Network, Client-server Model,  Addressing in internet (DNS, Domain and its type), DNS Server and the internet, Intranet
        Web Browsers, Internet Explorer and others, Surfing the web with web browsers, Use of search engines such as Google etc.

        Internet Security-Threats, Firewall, Internet Security Management Concepts, Information Privacy, Copyright issues, Basics of Asymmetric Cryptosystems

        Day-3

        E-mail - Working with e-mail via  Outlook express and other mail programmes, sending,  receiving, reading, replying, forwarding mail to multiple recipients, sending files via e-mail, saving addresses, attaching signature, creation & managing an address book, Adding, modifying and deleting address to it, Import/Export the address book, Finding internet e-mail address (Yahoo, Hotmail, Rediffmail, Gmail)

        Telnet, Introduction to USENET, Newsreaders, Introduction to Video conferencing

        Day-4

        File types used on internet and downloading software. Downloading and installing application exercises

        Current trends on internet:- Facebook, Blogs, Twitter, Internet phone, Video Conference etc.

        8       Methodology           : Lectures, Presentations, Interactive sessions followed by practices and feed back through course end test
        9.      Target Participants:           Group ‘B’ & ‘C’ officers/Officials.
        10     Additional Information
        Faculty:       The faculty will be drawn from resource pool comprising of Group ‘A’ and Group ‘B’ officials from the IA & AD