Respected Member,

 

The following programs (all starting with 12th May 2008 in relation to Information Technology for the benefit of members are introduced:

 

 

Sr. No.

Particulars

Hours

Faculty

Fees

1.

Computer Awareness Training program

30 Hours

(NO CPE)

CA. Vishal Langalia, CA Pathik Shah, CA Atul Shah

Rs. 1000/-

2.

Computer Added Audit Tools

100 Hours (CPE Available as per Guidelines)

CA Vishal Langalia, CA Pamil Shah, CA Atul Trivedi, CA Atul Shah

Rs. 6000/-

3.

Advanced Information Technology  Study Group

3 Hours  meeting

(CPE Available)

10 meetings in a year – Eminent Faculty

Rs. 1200/-

4

 

Oracle SQL

50 Hours (NO CPE)

Oracle Approved Educational Partner

 

Rs. 6500/-

5.

SAP(FICO) of ICAI

No CPE

Details available at ICAI.ORG

At ICAI.ORG

 

For the 5th Serial No programme Center was available in Ahmedabad & now expected to start from Ahmedabad from 2nd Week of Ahmedabad at Gennovate, Navarangpura ,Ahmedabad.

 

CA Nitin Pathak                                                                 CA Bhailalbhai Patel

Advance IT Committee Chairman                                        Regional Council Members

CA   Jignesh Shah Co-Chairman

CA Pursotam Khandelwal , Convener

 

 

  1. Computer Awareness Training Program

 

Don’t misunderstand by name called “Computer Awareness Training program”, it includes ABCD….. of the fundamentals and reaches to the Data Analysis using MS-Excel and MS- Access.

 

  1. CAAT Tools

 

The new curriculum of 100 Hours has been framed revamping the old curriculum. It is desired that a member should undergo the course so that proper synchronization between theoretical knowledge and practical application is achieved.

 

 

 

 

 

The training components would focus on application software relevant for accounting and auditing. In addition, knowledge of electronic spreadsheets, data base management systems, web technology and system security and maintenance are strengthen.

 

Further Details are attached herewith.

Starting from 12th May,08 5.00 to 8.00 PM

 

  1. Advanced IT Study Group

 

      Advance Information Technology Study Group

 In order to promote the advance Information Technology subject , we have planned informal group who is intensely interested in joining for reading to gather the material . The groups run on a self-study basis. Members of the Group and in the process enrich their knowledge and share their experience with fellow members. Non-Group member speakers are invited only to introduce certain specialized subjects, which the Group members can then take up for further study.

 

Members of the Groups in past have benefited from such deliberations. In the larger interest of members of the society, the Committee has decided to invite new members the Groups if they are willing to contribute and share their knowledge and experience with fellow Group members. The profile of the Groups is that they are interested in study on Information Technology subject like : Information technology audit , Information Security, IT controls, review, IT governance , COBIT , ITIL . ISO-27001, Use of ACL , Advance Excel , VB, etc.

      The Groups run on self-financing basis. Initial contribution of each member would be Rs.1200. Members desirous of joining the Group may forwards a written application by way of a letter to the Branch. The application should clearly state name, address,  membership number, contact particulars (including e-mail ID. The member should also mention if he/she would like to participate and assist in administration of the Group. The application along with a cheque for Rs.1200 should reach Branch not latter than 30th May,08. Existing members should send their cheque for Rs.1200 with their name and membership number written in its back to continue their membership.

   The first of such meeting in planned on 12th May,08, atleast 10 meetings each of three hours in a year 2008 – 2009 will be arranged starting with 12th May, 2008 :

Subject:  Security, Backup Management & other Issue in CA’s Office.

 Speaker:  Shri. Manish Nayak

Time     :   5.00 PM to 8.00 PM 

Place     : Branch ,ICAI Bhawan , Ahmedabad

 

 

  1. Oracle SQL

 

Details are attached herewith.

Attached to Program number 2. “CAAT”

 

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:

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

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.

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Serial No :4

Attached to Program Number 4 “Oracle SQL”

 

Sub: Oracle 9i SQL training

 

 

Ref  by : Mr Nitin Pathak

 

Dear Sir

We are Authorised Oracle Education Partner and Authorised Prometric Testing center since last 6 years.  Oracle Database has been no 1 enterprise database irrespective of  platforms, applications used worldwide. And to understand the Database one must have hands on SQL. SQL is a basic and integral part of Database. Oracle is being used in Pharmaceuticals, Power, Banking, Finance, Bio-Tech, Realty, Production Houses, Telecom, Universities, SSIs, SMBs.

 

At ITS we are team of genuine professionals and consultants who deliver quality oracle solutions like training, problem solving, support and development.

Our Gujarat clients :
Working Professionals from SBI, GSFC, GNFC, Tata Chemicals, TCS, TM systems, Patni, Vadilal Icecream, Gujarat Ambuja Export, Navneet Publication, Cadmech (a Cadila Division), Prathma Blood center, Tata Teleservices, ABM steel, Aplitech Solution, GMDC,  Banco Group Baroda, Voltemp-Baroda, Zenith Infotech, Vaghbakri, Mehasana Dudhsagar Dairy, Amul(Anand) , Paras Pharmaceutical, Zydus-Cadila, Sterling Hospital, Sanghi Sement, Ambuja-Kodinar, Reliance-Jamnagar, JMC-Kalpataru Power and many other industry leaders have taken training at ITS. Software Professionals from companies like Elitecore, System-Plus, i-engineering, Gateway have also taken training at ITS.

Oracle 9i SQL Course contents :
Introduction, Writing Basic SQL SELECT Statements, Restricting and Sorting Data , Single-Row Functions , Displaying Data from Multiple Tables, Aggregating Data Using Group Functions, Sub-queries, Producing Readable Output with iSQL *PLUS,  Manipulating Data, Creating and Managing Tables, Including Constraints, Creating Views, Other Database Objects, Controlling User Access, SQL Workshop, Using SET Operators, Oracle 9i Date-time Functions, Enhancements to the GROUP BY Clause, Advanced Sub-queries, Hierarchical Retrieval
Oracle 9i Extensions to DML and DDL Statements.

This learning will enable auditors to audit in any environment competently.
Fees: Rs. 6500/- for Course
Duration : 50 hrs, 2 hrs /day
Courseware : Prepared by Oracle University and will be given to every participant.
Certification : Training completion certificate will be provided by Oracle Corporation to each participant which is a international recognition.
Exam Discount : If any participant want to give oracle international exam then he will be offered 40% discount in exam price at our prometric testing center.

For any question please call on 9825355519 to Mr Amit or 9825804094 / nitinmpathak@ yahoo.com  to CA Nitin Pathak

 

Serial No:5  The details of SAP-FICO is available on ICAI.ORG & also on SAP web-site.