| 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: |
|
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. |
MS Access |
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 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. |
| 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. | | | |
|
| | |
