IAAD KMS
Sitemap
| Date | Session | Topic | Faculty | PPTs | Study Materials |
| 01-11-2021 | I | Introduction to Database, Types of Databases, RDBMS Concepts | Puneet kumar Sharma,Core Faculty, RTI, Jaipur | ||
| 01-11-2021 | II | Writing Basic SQL Statements,Restricting and Sorting Data (Where clause, Character Strings and Dates and Comparison Operators) | Puneet kumar Sharma,Core Faculty, RTI, Jaipur | ||
| 01-11-2021 | III | Types of Procurement –(i) Open/Limited/Direct Negotiation Tender; (ii) Single Stage vs Two Stage, Single Packet vs Two Packet system. (iii) Expression of Interest (EOI), Request for Qualification (RFQ) and Request for Proposal (RFP) | Rakesh Vijayvergia, Core Faculty, RTI, Jaipur | ||
| 01-11-2021 | IV | Types of Procurement –(i) Open/Limited/Direct Negotiation Tender; (ii) Single Stage vs Two Stage, Single Packet vs Two Packet system. (iii) Expression of Interest (EOI), Request for Qualification (RFQ) and Request for Proposal (RFP) | Rakesh Vijayvergia, Core Faculty, RTI, Jaipur | ||
| 02-11-2021 | I | Selecting Data from Oracle Other Comparison Operators Using the (BETWEEN,IN,LIKE, IS NULL)Operator, Logical Operators, Using the (AND,OR,NOT) Operator | Puneet kumar Sharma,Core Faculty, RTI, Jaipur | ||
| 02-11-2021 | II | Rules of Precedence, ORDER BY Clause, Sorting in Descending Order, Sorting by Column Alias, Sorting by Multiple Columns | Puneet kumar Sharma,Core Faculty, RTI, Jaipur | ||
| 02-11-2021 | III | Terms and Conditions of Contract: (i) General Conditions of Contract (GCC) and Special Conditions of Contract (SCC); (ii) Significant clauses in contract- Performance Security, Term, Termination, Dispute Resolution, Force Majeure, Payment schedule, default, deliverables, etc.; New Procurement Processes- Hybrid Annuity, Swiss Challenge, Revenue Share models. |
Rakesh Vijayvergia, Core Faculty, RTI, Jaipur | ||
| 02-11-2021 | IV | Terms and Conditions of Contract: (i) General Conditions of Contract (GCC) and Special Conditions of Contract (SCC); (ii) Significant clauses in contract- Performance Security, Term, Termination, Dispute Resolution, Force Majeure, Payment schedule, default, deliverables, etc.; New Procurement Processes- Hybrid Annuity, Swiss Challenge, Revenue Share models. |
Rakesh Vijayvergia, Core Faculty, RTI, Jaipur | ||
| 03-11-2021 | I | Single Row Functions SQL Functions Two Types of SQL Functions Single Row Functions Character Functions Case Conversion Functions Character Manipulation Functions, Number Functions (ROUND, TRUNC MOD) | Puneet kumar Sharma,Core Faculty, RTI, Jaipur | Single Row Function | |
| 03-11-2021 | II | Working with Dates Arithmetic with Dates Using Arithmetic Operators with Dates Date Functions Conversion Functions (TO_CHAR TO_NUMBER TO_DATE) Date Format, Special Functions (NVL DECODE)Nesting Functions | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | Working with Dates | |
| 03-11-2021 | III | Project appraisal techniques; Financial analysis, Sensitivity analysis | Dr. Hoshiyar Singh, Financial Advisor | ||
| 03-11-2021 | IV | Project appraisal techniques; Financial analysis, Sensitivity analysis | Dr. Hoshiyar Singh, Financial Advisor | ||
| 05-11-2021 | I | Functioning of Overseas Audit Offices | Sh. Ramavatar Sharma, AG | ||
| 05-11-2021 | II | Displaying Data from Multiple Tables EQUIJOIN, NONEQUIJOINOUTERJOIN SELFJOIN Aggregating Data Using Group Functions AVG SUM MIN MAX, COUNT GROUP BY and HAVING Clauses | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | ||
| 05-11-2021 | III | Subqueries | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | Subqueries | |
| 05-11-2021 | IV | Specific clauses in contract: Price variation, Penalty clauses, Blacklisting of a contractor/firms | Rakesh Vijayvergia, Core Faculty, RTI, Jaipur | ||
| 06-11-2021 | I | Creating and Managing Tables CREATE TABLE ALTER TABLE DROP TABLE | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | DDL | |
| 06-11-2021 | II | Manipulating Data INSERT UPDATE DELETE COMMIT ROLLBACK | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | DML | |
| 06-11-2021 | III | E-Tendering / E-Procurement (i) Tendering, Forward and Reverse Auctions. (ii) Manual tendering vs Online tendering/auction |
Yogender Bagda, SPFC, GoR | ||
| 06-11-2021 | IV | Weekly test | |||
| 08-11-2021 | I | An overview of PPP and Privatization, Requisites for the success of PPP Projects, Objectives of PPP- Contractual Relationship, Sharing of Responsibilities, Risk Transfer and Flexible Ownership; Role of Pvt. Sector Partner in PPP projects-Strengths & Weaknesses | Chetan Prakash Mandawaria, Jt. Director | ||
| 08-11-2021 | II | Institutional arrangements for Appraisal and approval of PPP Project; A study on Organisational structure for Appraisal and Approval of PPP projects; Financial Powers of PPP Appraisal Committee; Procedure for Formulation & Appraisal of PPP Projects; Appraisal by/ Approval of PPP Appraisal Committee |
Chetan Prakash Mandawaria, Jt. Director | ||
| 08-11-2021 | III | Exercise on SQL | Sh. Vinod Sencha, Core Faculty, RTI, Jaipur | ||
| 08-11-2021 | IV | Benefits to Public Sector, Private Sector and the public; Common misconceptions about PPP in Infrastructure Projects. | Rakesh Vijayvergia, Core Facutly, RTI, Jaipur | ||
| 09-11-2021 | I | Role of SAI in the International Arena including within Associations of SAIs | Mrs. Atoorva Sinha | ||
| 09-11-2021 | II | Overview of audit of public sector commercial undertakings | Mukesh Shrimal, AAO, O/o AG (Audit-II), Rajasthan, Jaipur | ||
| 09-11-2021 | III | Financial support to PPP projects in Infrastructure, Model Concession Agreements (MCA); Institutional Arrangements in State Governments | Chetan Prakasha Mandawaria, Jt. Director | ||
| 09-11-2021 | IV | Financial support to PPP projects in Infrastructure, Model Concession Agreements (MCA); Institutional Arrangements in State Governments | Chetan Prakasha Mandawaria, Jt. Director | ||
| 10-11-2021 | I | Mandate, Scope and Objectives of PPP Audit, Mandate for Audit of PPP Projects, International Auditing Stds. and Guidelines for the Audit of PPP Projects; Scope of PPP audit; Objectives; Types of Documents to be audited; When a Project should be subjected to Public audit. | P K Jain, Core Faculty, RTI, Jaipur | ||
| 10-11-2021 | II | Mandate, Scope and Objectives of PPP Audit, Mandate for Audit of PPP Projects, International Auditing Stds. and Guidelines for the Audit of PPP Projects; Scope of PPP audit; Objectives; Types of Documents to be audited; When a Project should be subjected to Public audit. | P K Jain, Core Faculty, RTI, Jaipur | ||
| 10-11-2021 | III | Basic Concepts of Commercial Accounting | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 10-11-2021 | IV | Basic Concepts of Commercial Accounting | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 11-11-2021 | I | Identifying and Sharing of Risks in PPP: Feasibility/Organisational Risk, Condition Precedent Risks, Financing Risks, Construction Risks, Operation and Maintenance Risk, Demand Risks, Revenue Risks, Risk from unforeseen developments, Termination Risks, Residual Value Risks | P K Jain, Core Faculty, RTI, Jaipur | ||
| 11-11-2021 | II | Identifying and Sharing of Risks in PPP: Feasibility/Organisational Risk, Condition Precedent Risks, Financing Risks, Construction Risks, Operation and Maintenance Risk, Demand Risks, Revenue Risks, Risk from unforeseen developments, Termination Risks, Residual Value Risks | P K Jain, Core Faculty, RTI, Jaipur | ||
| 11-11-2021 | III | Journal Entries | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 11-11-2021 | IV | Journal Entries | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 12-11-2021 | I | Auditing Process and Criteria for PPP Audit: Audit Methodology, Audit of Project Formulation and Approvals, Audit of Concession and Concession Period, Audit of Risk Allocation, Audit of Financing Risk, Audit of Viability Gap Funding, Audit of Tariff/Toll/User Charges, Audit of Total Project cost | P K Jain, Core Faculty, RTI, Jaipur | ||
| 12-11-2021 | II | Auditing Process and Criteria for PPP Audit: Audit Methodology, Audit of Project Formulation and Approvals, Audit of Concession and Concession Period, Audit of Risk Allocation, Audit of Financing Risk, Audit of Viability Gap Funding, Audit of Tariff/Toll/User Charges, Audit of Total Project cost | P K Jain, Core Faculty, RTI, Jaipur | ||
| 12-11-2021 | III | Main Books for Recording Financial Transactions | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 12-11-2021 | IV | Weekly test | |||
| 15-11-2021 | I | Public Financial Management(PFM) : An overview | Dr. N K Gautam, INGAF | ||
| 15-11-2021 | II | PFMS: Registration of user ID, pre-check, sanctions uploading and passing of B | Dr. N K Gautam, INGAF | ||
| 15-11-2021 | III | PFMS: Registration of user ID, pre-check, sanctions uploading and passing of B | Dr. N K Gautam, INGAF | ||
| 15-11-2021 | IV | PFMS: DDO interface | Dr. N K Gautam, INGAF | ||
| 16-11-2021 | I | PFMS : EIS Module ( For generation of salary Bills and other establishment Bills and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO | Dr. N K Gautam, INGAF | ||
| 16-11-2021 | II | PFMS : EIS Module ( For generation of salary Bills and other establishment Bills and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO | Dr. N K Gautam, INGAF | ||
| 16-11-2021 | III | PFMS : EIS Module ( For generation of salary Bills and other establishment Bills and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO | Dr. N K Gautam, INGAF | ||
| 16-11-2021 | IV | PFMS : EIS Module ( For generation of salary Bills and other establishment Bills and for maintenance of service records, transfer-in, transfer-out, passing of bills by DDO and PAO | Dr. N K Gautam, INGAF | ||
| 17-11-2021 | I | PFMS: GPF Module | Dr. N K Gautam, INGAF | ||
| 17-11-2021 | II | PFMS: GPF Module | Dr. N K Gautam, INGAF | ||
| 17-11-2021 | III | PFMS: Pension Module | Dr. N K Gautam, INGAF | ||
| 17-11-2021 | IV | PFMS: Pension Module | Dr. N K Gautam, INGAF | ||
| 18-11-2021 | I | PFMS: EAT Module | Dr. N K Gautam, INGAF | ||
| 18-11-2021 | II | PFMS: EAT Module | Dr. N K Gautam, INGAF | ||
| 18-11-2021 | III | PFMS: DBT Module | Dr. N K Gautam, INGAF | ||
| 18-11-2021 | IV | PFMS: DBT Module | Dr. N K Gautam, INGAF | ||
| 20-11-2021 | I | NTRP Module | Dr. N K Gautam, INGAF | ||
| 20-11-2021 | II | TSA Module | Dr. N K Gautam, INGAF | ||
| 20-11-2021 | III | Important Reports in PFMS | Dr. N K Gautam, INGAF | ||
| 20-11-2021 | IV | Important Reports in PFMS | Dr. N K Gautam, INGAF | ||
| 22-11-2021 | I | Posting of Transactions in Ledger | Pradeep Mundra, SAO, O/o AG (Audit-II), Rajasthan, Jaipur | Posting | |
| 22-11-2021 | II | Posting of Transactions in Ledger | Pradeep Mundra, SAO, O/o AG (Audit-II), Rajasthan, Jaipur | ||
| 22-11-2021 | III | Overview of IT Audit | Madan Maloo, SAO, O/o AG (Audit-II), Rajasthan, Jaipur | Information Security | |
| 22-11-2021 | IV | Planning of IT Audit | Madan Maloo, SAO, O/o AG (Audit-II), Rajasthan, Jaipur | ||
| 23-11-2021 | I | Preparation of Trial Balance | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | Trial Balance | |
| 23-11-2021 | II | Preparation of Trial Balance | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 23-11-2021 | III | General IT Controls | Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur | ||
| 23-11-2021 | IV | General IT Controls | Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur | ||
| 24-11-2021 | I | Adjustment entries for preparation of final accounts | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | Adjustment-Entries | |
| 24-11-2021 | II | Adjustment entries for preparation of final accounts | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 24-11-2021 | III | IT Controls-Application Controls | Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur | ||
| 24-11-2021 | IV | IT Controls-Application Controls | Upendra Rathore, AAO, O/o AG (Audit-I), Rajasthan, Jaipur | ||
| 25-11-2021 | I | Preparation of Trading and Profit and Loss Account | Deepak Khandelwal, CA | Trading P&L | |
| 25-11-2021 | II | Preparation of Trading and Profit and Loss Account | Deepak Khandelwal, CA | ||
| 25-11-2021 | III | Audit of IT Security and End User Computing Controls | Vinod Sencha, Core Faculty, RTI, Jaipur | Audit of IT Security | |
| 25-11-2021 | IV | Audit of IT Security and End User Computing Controls | Vinod Sencha, Core Faculty, RTI, Jaipur | EUCC | |
| 26-11-2021 | I | Preparation of Balance sheet | Deepak Khandelwal, CA | Balance Sheet | |
| 26-11-2021 | II | Preparation of Balance sheet | Deepak Khandelwal, CA | ||
| 26-11-2021 | III | Audit of Development and Acquisition of IT Assets | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 26-11-2021 | IV | Audit of Development and Acquisition of IT Assets | Vinod Kumar Sharma, Core Faculty, RTI, Jaipur | ||
| 27-11-2021 | I | Issue of Audit Certificate to Commercial Undertakings | Mukesh Shrimal, AAO, O/o AG (Audit-II), Rajasthan, Jaipur | ||
| 27-11-2021 | II | Material Management-Purchasing Concepts | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 27-11-2021 | III | Material Management-Purchasing Concepts | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 27-11-2021 | IV | Weekly test | |||
| 29-11-2021 | I | Material Management-Specifications and Standards | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 29-11-2021 | II | Material Management-Specifications and Standards | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 29-11-2021 | III | Material Management-Procurement Process | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 29-11-2021 | IV | Material Management-Procurement Process | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 30-11-2021 | I | Material Management-Logistics and Warehousing | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 30-11-2021 | II | Material Management-Use of IT Tools | Faculty from Indian Institute of Material Management/Electricity Companies | ||
| 30-11-2021 | III | Overall Evaluation test | |||
| 30-11-2021 | IV | Valediction by DG sir |