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?

FAQ's on CPE Course on CAAT

 
 

When can I join the CAAT Course

You can join the CPE Course on CAAT anytime. You have to first register with the Institute by filling the online application form and send it to the ISA/ CAAT Helpdesk along with requisite fees. Thereafter, join a convenient batch with one of the Regional Council/ Branch/ CPE Chapter. Kindly confirm the availability of a suitable batch with your Regional Council/ Branch/ CPE Chapter before enrolling for a batch.

 

Back to Questions

 

Who may join CAAT Course?

Only members of the Institute are eligible to join the course. Persons who have passed the Final Examination of the Institute and have applied for Membership can send their application, however their registration would be made only after their registration as a member. The registration and issue of CPE Certificate would be made only after submitting proof of ICAI membership.

 

Back to Questions

 

What are the Objectives of CAAT Course?

The CPE Course on CAAT is a practical hands-on training course specifically designed for the members of the Institute. The objective is to enable professional accountants to access databases beneath accounting software and enable them to create SQL Queries, create Report, develop audit trail, create MIS reports and actually utilize computer as an effective tool for Accounting, Financial Planning and Forecasting Treasury Management, Financial Management and Auditing.

 

Back to Questions

 

Can ISA pass members join CAAT Course?

Since CPE Course on CAAT course is structured to provide practical skills and exposure to members in technology applications, especially towards analysis and reporting for financial/ auditing, even those who have passed the ISA course can join the Course to enhance their practical exposure.

 

Back to Questions

 

Is the CPE Course on CAAT mandatory for pursuing ISA Course?

While this course is not mandatory for pursuing the ISA Course, it is definitely recommended as it provides hands-on practical exposure to use of computers for typical financial analysis and reporting requirements. It is expected to enhance their practice and professional opportunities in Audit Practices using computers and numerous software applications. The special advantage apart, it is not mandatory to do CAAT Course before joining ISA course.

 

Back to Questions

 

What is the Syllabus for CAAT Course?

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

 

Back to Questions

 

What is the Course Fee for CPE Course on CAAT and how it must be paid?

The course fee for CPE Course on CAAT is payable in two components as follows:
* Course Registration Fee of Rs.1500/- payable to “The Secretary, ICAI” by DD/ Pay Order payable at Delhi/ New Delhi.
* Course Training Fee: A Variable amount ranging from Rs.4500/- (minimum) to Rs.6000/- (maximum) (both inclusive) payable to the   Regional Council/ Branch/ CPE Chapter in the account name to be confirmed with the respective office.

 

Back to Questions

 

What Certificate do I get on participating in the CPE Course on CAAT?

As the CPE Course on CAAT is a Continuing Professional Education (CPE) skill course, a CPE certificate giving the requisite CPE hours (currently 20) is issued on successfully completing the course. No other certificate is issued.

 

Back to Questions

 

What are the plans for the Course Delivery?

As the Committee on Information Technology has decided that the CPE Course on CAAT has to be organised by the concerned Regional Council/ Branch/ CPE Chapter, the candidates are required to contact their concerned office to organise a suitable batch at the earliest, for their benefit.

 

Back to Questions

 

What do I get on Course Registration?

Candidates should get their Course Registration Letter within about 10 days of receipt of their duly completed application with course fees and Course Materials (Three Volumes & CAAT Resources CD) within about a fortnight.

 

Back to Questions

 

 

Where do I send my form for registration to CPE Course on CAAT?

For registering to the CPE Course on CAAT, candidates are required to send their dully filled in and signed applications along with course registration fee to the following address of the Institute:


The Secretary,
Committee on Information Technology,
The Institute of Chartered Accountants of India,
5th Floor, Hostel Block, ICAI Bhawan, A-29,
Sector-62, Noida - 201309, India
Tel (Direct): +91 120 3045961
Tel (PABX) : +91 120 3045963 Ext. 992
Fax : +91 11 3045989
Web: www.isaicai.org; www.icai.org. E-mail: caat@icai.in

Back to Questions

 
 

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.
 

Back to Questionsground Materials

The CIT has already issued three volumes of Back to Questionsground 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