Courses

Courses offered by the Committee

The Committee on Information Technology has been constituted by the Council of the Institute as a non-standing Committee in the year 2000 to identify the emerging Information Technology challenges and convert them into gainful professional opportunities members through courses, conferences, seminars, workshops, technical guides, e-Learning modules. This section of the Committee Portal provides relevant details of the courses offered by the Committee for the benefit of members...........

Forensic Accounting & Fraud Detection using IT & CAATs

The Council of the Institute of Chartered Accountants of India, recognizing the need for Forensic Accounting and Fraud Detection, in the emerging economic scenario, has decided to launch the “Certificate Course on Forensic Accounting and Fraud Detection ”. Forensic Accounting and Fraud Detection specialization is in increasing demand considering increasing incidents of cyber crimes and frauds detection. It is the practice of utilizing accounting, auditing, CAATs/ Data Mining Tools, and investigative skills to detect fraud/ mistakes..............

CPE Courses on CAAT

Businesses are making increasing use of computers/ information technology to process & manage their operations, particularly those related to accounts & finance. While physical records are fast disappearing, the volume and variety of transactions are increasing in increasing proportion. In the times to come, accountants and auditors have to increasingly make use of the computers for financial analysis and reporting for accounting, auditing.....

ERP Courses

The Committee on Information Technology has identified IT Enabled Services (ITES), particularly ERP, as the next area for development for the profession, after the Post Qualification Course (PQC) on Information Systems Audit (ISA). As a part of this ERP Initiative, the Committee is organizing ERP Courses through leading ERP Vendors in the country .......

WHAT DO YOU WANT TO DO?

CPE Course on “Computer Accounting and Auditing Techniques (CAAT)”

The Committee on Information Technology of the Institute is pleased to announce a CPE Course on Computer Accounting and Auditing Techniques (CAAT) with the following thoroughly revised and revamped syllabus:

 

CAAT Syllabus

Sr. No. Title Coverage Total Hours Hands on
1 Windows 2000/XP Intro to Facilities & Commonly used features 3 0
2 Using MS Excel as
an Audit Tool
An Intro., Case Studies, Data Analysis & Reporting Features 18 12
3 RDBMS Concepts Database Concepts, Terminology, Models - An Intro; RDBMS, Data Modelling using ERD, DB Design using Normalization 6 0
4 MSAccess Creating Databases & Tables – An Intro; Event Handling & Report Generation; Using Macros - An Intro.; Using Queries - An Intro.; Case Study 15 12
5 Structured Query
Language (SQL)
Introduction to Data Definition Language Statements & Data Manipulation Language Statements (Creating Tables, Selecting Data, Inserting Data, Updating Records, Dropping a Table, Querying Database, Aggregating Data, Grouping, Ordering Data, Joining Tables etc.) & Case Studies 15 12
6 CAAT Tools Capabilities & Importing Data from Accounting & other Application Systems - An Intro; Analytical Reports, Duplicates/ Gaps. Sorting & Charting; Stratification, Summarization, Statistics & Aging - An Intro.; Sampling, Macros, Audit Trail, Pivot Tables - An Intro. 43 40
    Total Hours Allocated 100 76
 
The CAAT Course Registration Fee is Rs.1,500/-. The Institute Regional Councils/ Offices/ Branches/ CPE Chapters would be charging Practical Training Fee between Rs.4,500/- to Rs.6,000/- considering the local costs and number of candidates participating in the batch. They would also arrange for tea and refreshments on contributory basis, in case required by the candidates.
 
Candidates who complete the CAAT Course by attending 90% of the sessions would be issued a CPE Certificate, under the aegis of CPEC for participating in the CAAT course giving 20 CPE hours in the applicable/ approved format of CPE Certificate Form, for the CAAT Course.
 
Institute Members desirous of joining the CPE Course on CAAT are requested to contact their respective Regional Councils/ Offices/ Branches/ CPE Chapters to start suitable batches in which they can participate. Detailed guidelines have been provided to the Regional Councils/ Offices/ Branches/ CPE Chapters, in this regard. The said CAAT POU’s would be organizing batches of CAAT Course by suitably arranging training infrastructure and faculty members on self-supporting basis and would be responsible for the successfully organizing of the batches.
 
Institute Members desirous of joining the CPE Course on CAAT are requested to contact their respective Regional Councils/ Offices/ Branches to start suitable batches in which they can participate. Detailed guidelines have been provided to the Regional Councils/ Offices/ Branches/ CPE Chapters in this regard. Please refer to enclosed document on CIT Initiatives on CAAT for further details.
 
CIT Initiatives on Computer Accounting and Auditing Techniques (CAAT)
 

Need For CAAT

As we are aware, businesses are increasingly making use of computers/ information technology to process & manage their operations, particularly those related to accounts & finance. While physical records are fast disappearing, the volume and variety of transactions is increasing in increasing proportion. In the times to come, accountants and auditors have to increasingly make use of the computers for their requirements for financial analysis and reporting for accounting, auditing, taxation and other requirements.
 

CAAT Resources CD V 2.1

The CIT, recognizing this professional requirement, has issued the“CAAT Resources CD” (V 2.1) to enable members to develop in this area. Apart from containing working copies of four CAAT tools, the CD contains walkthroughs (step-by-step procedure of doing typical analysis with voice explanations), presentations, user guides, case studies etc. The CD enables members to have a hands-on practical experience in seeing and working with CAAT tools to have a better understanding of their capabilities and utility. We are sure that the Regional Council/ Branch would like to explore this CD as a part of their interactive programmes with the members.

 

A copy of this CD is provided to members participating in the ISA & CAAT Courses organized by the CIT and the same is also available for sale at a nominal price of Rs.40/- each. The Regional Councils/ Branches/ CPE Chapters can requisition required number of copies considering demand from members, as in the case of other publications of the Institute.

 

CPE Course on CAAT

Recognising CAAT as a thrust area for members to develop, the CIT organizes a CPE Course on CAAT for 100 hours to provide the required level of training and development support, in this critical area for members.

 

The syllabus of this course has also been thoroughly revised and revamped to better address the requirements of members in using computers for their financial/ accounting/ auditing analysis and reporting requirements, as can be seen in the enclosed announcement.

 

Practical Workshops

The CIT also organizes Practical Workshops on (a) Using CAAT’s and (b) Using MS-Excel as a tool for Financial Analysis & Reporting from time to time considering demand from members through the Regional Councils/ Offices/ Branches. These workshops have been found to be very useful by members and they are often convinced to join the CAAT Course. Practical Workshops are found to be very good starting points for members to start developing in this field, by getting expert level guidance and support.
 

Background Materials

The CIT has already issued three volumes of Background Materials for the CAAT Course. These are also available for sale at a nominal cost of Rs.400/- per set. The CIT is in the process of developing and making available more such materials.
Related Links
© The Institute of Chartered Accountants of India, 2009 | Site Map |Terms of Use |Best Viewed in 1024 X 768 Resolution
RSS Feed