Implementation of Revised Syllabus on 100-hours Computer Training for CMA Intermediate Course

Last updated: 28 April 2014

THE INSTITUTE OF COST ACCOUNTANTS OF INDIA

(Statutory Body under an Act of Parliament)

CIRCULAR

Ref. No: BOS/02-04/14-15

Dated: Kolkata, 26th April,2014

Sub: Implementation of Revised Syllabus on 100-hours Computer Training for CMA Intermediate Course

The Council of the Institute in its 286th Meeting held on March 30,2014 at the Headquarters of the Institute, has approved the implementation of Revised Syllabus of 100-hours Compulsory Computer Training for students appearing from December 2014 term of Examination. The contents of the Revised Syllabus is appended below as Annexure I. Pursuant to such approval, it is hereby notified to all concerned that the contents specified in this revised syllabus shall have to be followed for imparting computer training for all students and shall be applicable from December 2014 term of Examination. This is applicable for students pursuing Courses under both Syllabus 2008 and Syllabus 2012, subject to exclusions specified.

Exclusions:

The following students are excluded from the ambit of Training under Revised Syllabus:

(i) who have already completed the 100-hours of Computer Training ( as per earlier syllabus) shall be exempted from undergoing Training under this Revised Syllabus ;

(ii) who have already commenced the 100-hours Computer Training ( as per earlier syllabus) shall also be exempted from undergoing Training under this Revised Syllabus, subject to submission of list of such students, by the concerned Regional Council/Chapter, mentioning the registration and name of such students, with a declaration that such students are presently undergoing the 100-hours Compulsory Computer Training under old syllabus of computer training.

(iii) who are presently undergoing the 100-hours Compulsory Computer Training from any Institution/Organization duly authorized by the Directorate of Studies, other than Regional Council/Chapter of the Institute, shall also be exempted from undergoing Training under this Revised Syllabus.

Further notified that, Study material of Revised Syllabus on 100-hours Computer Training has been prepared to ensure proper coverage and also to bring about uniformity in teaching methodology. Students who would be undergoing the training under Revised Syllabus of Computer Training shall be provided with a printed hard copy of the Study Material as a part of their CMA Intermediate Course. However, for administrative convenience, the distribution may be made separately through the respective Regional Council/Chapter.

The Soft copy of the Study Material will also be made available through the website of the Institute to all concerned for their advance information. Regional Councils/Chapters/ Authorised Computer Training Centres are to ensure strict compliance of this contents.

A format for issuance of Computer Training Completion Certificate shall also be circulated and the Certificate shall have to be issued in the specified format only, under seal and signature of the authorized personnel in the respective Regional Council/Chapter/Authorized Computer Training Centre.

All concerned are hereby requested to note this circular and facilitate to make a proper and wide publicity to meet the concern of stakeholders on the stated subjects.

This shall be applicable for such students who would be registered to the CMA Intermediate Course w.e.f.1st May,2014 and onwards, until further notification to this effect.

This issues with an approval of the competent authority.

CMA Chiranjib Das

Joint Director, Head - Academics Department ( Board of Studies)

Secretary to the Board of Studies Committee

Annexure I

Revised Syllabus of 100-hours Compulsory Computer Training for CMA Intermediate Course

1. Computer Fundamentals-  Introduction to Computer  Computer System -Essentials and part of computers to run the system -Memory, Input-Output Devices	2 hours
2. Operating System-  Introduction, Overview  Windows Operating System	2 hours
3. MS-Word-  Introduction  Document – creation, editing, printing  Making Tables  Spell Check and Grammar Check  Finding ,Replacing and Proofing Text  Bullets & Numbering  Tabs  Paragraph Formatting  Page Formatting  Insertion of Page no; Header and Footer  Mail Merge  Security Features in MS Word  Checking and Removing Virus  Converting word document to web document, PDF Files	4 hours
4. MS Excel-  Introduction  Creating a workbook  Using sheets in a workbook  Editing, Copying, Formatting Data  Cell Referencing, Ranges  Application of Auto/Advance Filter, Sorting, Subtotal  Mathematical, Logical, Statistical and Financial function  Application of V/H look up and validation  Creating Macros  Pivot Tables and Charts  Project on preparation of MIS Report	18 hours
5. MS PowerPoint  Introduction  Opening a presentation  Adding Slides  Fonts, styles, effect, alignment, text direction  Background Themes and Styles  Tables, Charts, Graphs  Clip Art/Scanned Object  Project on preparation of Power point presentation	8 hours
6. MS Access  Overview of Access  What is Access used for  Access Basics  Data Compiling in Access  Different Objects of MS Access  Tables ; Queries ; Forms; Reports  Database Concepts-Data, DBMS,RDBMS	8hours
7 Accounting Package-Tally ERP 9  Features of Tally ERP 9  Creation, Modification and Deletion-Company, Group, Ledger  Security Control, Back-up and Restore Process  Accounting Vouchers and Inventory Entries  Financial Statement  Budgeting  RATIO Analysis  Cash Flow Analysis  Cost Centre-Creation and Allocation  VAT, CST, SERVICE TAX, TDS-Accounting Entry in Tally ERP  Payroll processing through tally payroll  Company Merging and Splitting  Reports in Tally ERP  Export/Import of data	30 hours
8. Web Technology  Basic Concept of Internet  Services and Languages used in Internet  Types of Internet Connection, Address, Protocol, Browsers  Difference between Internet, Intranet, Extranet, www	4 hours
9. e-filing-  e-TDS, e-TCS  Individual and corporate Return  Annual Return of a Company  e-payment of Direct and Indirect Taxes  On line Application of PAN  Documentation and e-filing of PF/ESI  ACES (Automation of Customs, Excise & Service Tax)- Returns  VAT Return filling	14 hours
10. XBRL Taxonomy  Concept of XBRL Costing Taxonomy  Taxonomy and Tagging Concept  Process of preparation of Instant Documents	6 hours
11. ERP  Concept of ERP  Application	2 hours
12. Digital signature and verification of electronic record	2 hours