COPA Trade Syllabus
COPA Trade Syllabus
UNDER
2017
GOVERNMENT OF INDIA
MINISTRY OF SKILL DEVELOPMENT & ENTREPRENURESHIP
DIRECTORATE GENERAL OF TRAINING
CONTENTS
2
1. ACKNOWLEDGEMENT
The DGT sincerely express appreciation for the contribution of the Industry, State Directorate,
Trade Experts and all others who contributed in revising the curriculum. Special acknowledgement to
the following industries/organizations who have contributed valuable inputs in revising the curricula
through their expert members:
Co-ordinator for the course: Sh. Nirmalya Nath, ADT- CSTARI Kolkata
3
2. BACKGROUND
The period of apprenticeship training for graduate (engineers), technician (diploma holders
and technician (vocational) apprentices is one year. Certificates are awarded on completion
of training by the Department of Education, Ministry of Human Resource Development.
2.3 Reformation
The Apprentices Act, 1961 has been amended and brought into effect from 22nd December,
2014 to make it more responsive to industry and youth. Key amendments are as given
below:
Prescription of number of apprentices to be engaged at establishment level instead of
trade-wise.
Establishment can also engage apprentices in optional trades which are not designated,
with the discretion of entry level qualification and syllabus.
Scope has been extended also to non-engineering occupations.
Establishments have been permitted to outsource basic training in an institute of their
choice.
The burden of compliance on industry has been reduced significantly.
4
3. RATIONALE
(Need for Apprenticeship in Computer Operator And Programming Assistant trade)
The prime objective of this training is to prepare the apprentices to be programming
Assistant not only in learning the contents of the course but also in applying them efficiently.
Most software related jobs require knowledge and skill in more than one area. Today this
demand is growing louder as a person with even a simple title like office assistant is expected to
be proficient in areas like office automation, basic hardware, networking along with a good
knowledge of databases. At times a person may be expected to work with databases and may be
required to maintain or use web sites to work with these databases too.
The topics on Networking have been covered extensively keeping in mind the
importance of configuring and securing the networked systems and data against various types
of intrusions and threats.
During the On-Job Training, concepts of Java script, VBA and Tally are covered to
enable the apprentice to apply these when required in creating static/dynamic websites, using
the power of VBA for Microsoft office applications etc.
The project will help the apprentices to develop ability to apply the acquired theoretical
and practical tools/techniques to solve problems related to industry, academic institutions and
research laboratories.
During this period the apprentice shall work under a System Analyst and assist him/her in
preparation of system documentation, preparation of flow charts/diagrams, writing programs,
preparation of presentation. The apprentice shall be given the manuals to read about the
development tools and thus inculcating the habit of self-learning.
5
4. JOB ROLES: REFERENCE NCO
After completion of the course the apprentices shall be qualified for one or
more of the following job roles:
1. Office Automation.
2. Smart Accounting.
3. Web design and maintenance.
4. Computer maintenance.
5. Computer Training in schools and institutes.
6. Cyber Cafe setup and management.
7. IT online support
6
5. GENERAL INFORMATION
Note: Industry may impart training as per above time schedule, however this is not fixed.
The industry may adjust the duration of training considering the fact that all the
components under the syllabus must be covered. However the flexibility should be given
keeping in view that no safety aspect is compromised and duration of industry training to
be remain as 1 year.
7
6. COURSE STRUCTURE
1 1 1 1 1 1
1 2 3 4 5 6 7 8 9 0 1 2 3 4 5
Basic Training Block - I
Practical Training Block - I
8
7. SYLLABUS
7.1 BASIC TRAINING (BLOCK – I)
DURATION: 03 MONTHS
GENERAL INFORMATION
9
7.1.1 DETAIL SYLLABUS OF PROFESSIONAL SKILLS & PROFESSIONAL
KNOWLEDGE
Block –I
Basic Training
10
Using Word Processing Software Introduction to Word features, Office button,
Familiarization with the Word toolbars.
window components. Creating, saving and formatting and printing
Creating, saving and editing documents using Word.
documents using Word. Working with inserting objects, macro, mail
Inserting and formatting tables and merge, templates and other tools in Word.
other objects. Page setup and Printing Documents using word.
Using templates, autocorrect tools,
macros and the mail merge tool.
Working with Page layout settings
and printing documents.
Typing practice using open source
typing tutor tools.
3 Using Spread Sheet Application
11
Animating Slide transitions and presentation techniques.
Objects. Database Management Systems
Concepts of Data, Information and Databases.
Database Management Overview of popular databases, RDBMS, OODB
Creating database and designing a and NOSQL.
simple tables in Access. Rules for designing good tables. Integrity rules
Enforcing Integrity Constraints and and constraints in a table.
modifying the properties of tables Relationships in tables.
and fields. Introduction to various types of Queries and
Creating Relationships and joining their uses.
tables. Designing Access Reports and Forms.
Creating Forms. Introduction to macros, designer objects
Creating simple select queries with controls, their properties and behavior.
various criteria and calculations.
6-7 Configuring and Using Networks Networking Concepts
Viewing Network connections. Introduction to Computer Networks, Necessity
Connecting a computer to a and Advantages.
network and sharing of Devices, Client Server and peer to Peer networking
files and Folders. concepts.
Familiarization with various Concept of Proxy Server and proxy firewall
Network devices, Connectors and server.
Cables. Network topologies. Introduction to LAN, WAN
IP Addressing and Subnetfor IPV4 / and MAN.
IPV6,Masking, pinging to test Network components, viz. Modem, Hub, Switch,
networks. Router, Bridge, Gateway etc.
Using various tools for computer Network Cables,Wireless networks and Blue
maintenance, Network security. Tooth technology.
Internet Concepts Concept of ISO - OSI 7 Layer Model.
Browsing the Internet for information. Overview of various Network protocols Viz.
Creating and using e – mail for TCP/IP, FTP, Telnet etc.
communication. Logical and Physical Addresses, Classes of
Communication using text, video Networks.
chatting and social networking sites. Network Security &firewall concepts.
Identifying various threats to the Concept of DHCP Server.
system connected to the net. Internet Concepts
Protecting the computer against Introduction to WWW, Concept of Internet, Web
various internet threats. Browsers, internet servers and search engines.
Configure Outlook, mail service in Concepts of Domain naming Systems and E mail
mobile phones. Using tools like Skype, communication.
Google+ etc. Introduction to video chatting tools, VOIP and
Designing Static Web Pages Social Networking concepts.
12
Designing simple web pages with Concept of Cloud storage and Open Web Server.
text, pictures, tables, lists, Introduction to Internet Security, Threats and
hyperlinks, frames, marquees etc. attacks, Malicious Software types, Internet
using HTML tags. security products and their advantages.
Dividing website using division tag Web Design Concepts
in html 5 ,embed Google map into Concepts of Static and Dynamic Web pages.
website, how to put readymade Introduction to HTML and various tags in HTML.
slider, scrolling images, zoom image Creating Forms with controls using HTML.
on mouse over, create navigation Concepts of CSS and applying CSS to HTML
menubar in html using list. put Introduction to open source CMS viz,. Joomla,
image icon with links. Wordpress etc. and Web authoring tools viz.
Convert PSD file to html document Kompozer, FrontPage etc.
using html tags and images. Basic Concepts of Flash and Dreamweaver.
8-9 Java Script
Algorithms and flowcharts.
Java Script
Introduction to Web Servers and their
features.
Familiarization with JavaScript
Introduction to Programming and Scripting
elements.
Languages.
Embedding JavaScript in HTML to
Introduction to JavaScript and its application
display information in web pages.
for the web.
Documentation and Formatting.
JavaScript Basics – Data types, Variables,
Using JavaScript Variables, Data
Constants. Conversion between data types.
types, Constants and Operators.
The Arithmetic, Comparison, Logical and String
Working with functions, and calling
Operators in JavaScript. Operator precedence.
of function on JavaScript events.
Arrays in JavaScript – concepts, types and
Create running clock on website
usage.
using JavaScript.
Program Control Statements and loops in
Find users browser and operating
JavaScript.
system using javascript.
Introduction to Functions in JavaScript.
Client side validation of form in
Built in JavaScript functions overview.
javascript.
The String data type in JavaScript. Introduction
to String, Math and Date Functions.
Concepts of Pop Up boxes in JavaScript.
Introduction to the Document Object Model.
10-11 Programming with VBA Introduction to VBA, Features and Applications.
Familiarization with the VBA Editor. Introduction to VBA features and applications.
Writing simple programs involving VBA Data types, Variables and Constants.
VBA Data types, Variables, Operators in VBA and operator precedence.
Operators and Constants. Mathematical Expressions in VBA.
Working with string variables in Introduction to Strings in VBA.
13
VBA. Introduction to Arrays in VBA.
Creating and Manipulating Arrays in Conditional processing in VBA, using the IF,
VBA. Elseif, Select… Case Statements.
Working with conditional Loops in VBA Introduction to VBA.
statements like If. Elseif, Select … VBA message boxes and input boxes.
Case statements in VBA. Introduction to Creating functions and
Creating Message boxes and Input Procedures in VBA.
boxes in VBA. Using the built in functions.
Creating Functions and Creating and editing macros.
Procedures. Passing Parameters Introduction to Object Oriented Programming
and Using Returned Data. Concepts. Concepts of Classes, Objects,
Properties and Methods.
Events and Event driven programming
concepts.
The user forms and control in Excel VBA.
Properties, events and methods associated
with the Button, Check Box, Label, ComboBox,
Group Box, Option Button, List Box, Scroll Bar
and Spin button controls.
Overview of ActiveX Data objects.
Debugging Techniques.
12 Smart Accounting
Basics of Accounting, Golden Rules of
Accounting, Voucher Entry, Ledger Posting,
Using Accounting Software
Final Accounts Preparation.
Basic accounting practice.
Cash Book. Ratio Analysis, Depreciation, Stock
Familiarization with the Tally
Management.
interface.
Analysis of VAT,Cash Flow, Fund
Company creation, Account
FlowAccounting.
Creation, Voucher Entry in Tally.
Introduction to Tally, features and Advantages.
Report Generation (Creating
Implementing accounts in Tally.
statements like Invoice, Bill, Profit &
Double entry system of bookkeeping.
Loss account etc.).
Budgeting Systems, Scenario management and
E Commerce
Variance Analysis.
Familiarization with latest E
Costing Systems, Concepts of Ratios, Analysis
commerce websites viz. E bay,
of financial statements,Inventory Basics, POS
Amazon, FlipCart, OLX, Quikr
Invoicing, TDS, TCS, FBT, VAT & Service Tax
etc. and comparative study of
Processing in Tally.
the main features of these sites.
Tally Interface in Different Languages.
E Commerce
Definition of E commerce, Types, scope and
14
benefits of E commerce.
Difference between E commerce and
traditional commerce.
Capabilities requirements and Technology
issues for E commerce.
Types of E commerce web sites.
Building business on the net.
Concepts of on line Catalogues, Shopping
carts, Checkout pages.
Payment and Order Processing,
Authorization, Chargeback and other
payment methods.
Security issues and payment gateways.
Cyber Security:
15
7.1.2 EMPLOYABILITY SKILLS
GENERAL INFORMATION
5) Instructor Qualification :
16
7.1.2.1 SYLLABUS OF EMPLOYABILITY SKILLS
Block – I
Basic Training
Topic Topic Duration
No. (in hours)
English Literacy 7
1 Pronunciation :
Accentuation (mode of pronunciation) on simple words, Diction (use of word and
speech)
2 Functional Grammar
Transformation of sentences, Voice change, Change of tense, Spellings.
3 Reading
Reading and understanding simple sentences about self, work and environment
4 Writing
Construction of simple sentences Writing simple English
5 Speaking / Spoken English
Speaking with preparation on self, on family, on friends/ classmates, on know,
picture reading gain confidence through role-playing and discussions on current
happening job description, asking about someone's job habitual actions. Cardinal
(fundamental) numbers ordinal numbers. Taking messages, passing messages on and
filling in message forms Greeting and introductions office hospitality, Resumes or
curriculum vita essential parts, letters of application reference to previous
communication.
I.T. Literacy 8
1 Basics of Computer
Introduction, Computer and its applications, Hardware and peripherals,
Switching on-Starting and shutting down of computer.
2 Computer Operating System
Basics of Operating System, WINDOWS, The user interface of Windows OS,
Create, Copy, Move and delete Files and Folders, Use of Common applications.
3 Word processing and Worksheet
Basic operating of Word Processing, Creating, opening and closing Documents, use
of shortcuts, Creating and Editing of Text, Formatting the Text, Insertion & creation
of Tables. Printing document.
Basics of Excel worksheet, understanding basic commands, creating simple
worksheets, understanding sample worksheets, use of simple formulas and functions,
Printing of simple excel sheets.
Use of External memory like pen drive, CD, DVD etc,
4 Computer Networking and INTERNET
Basic of computer Networks (using real life examples), Definitions of Local Area
Network (LAN), Wide Area Network (WAN), Internet, Concept of Internet
(Network of Networks),
Meaning of World Wide Web (WWW), Web Browser, Web Site, Web page and
Search Engines. Accessing the Internet using Web Browser, Downloading and
Printing Web Pages, Opening an email account and use of email. Social media sites
and its implication.
Information Security and antivirus tools, Do's and Don'ts in
Information Security, Awareness of IT - ACT, types of cyber crimes.
17
Communication Skill 15
1 Introduction to Communication Skills
Communication and its importance
Principles of Effective communication
Types of communication - verbal, non verbal, written, email, talking on
phone.
Non verbal communication -characteristics, components-Para-language
Body - language
Barriers to communication and dealing with barriers.
Handling nervousness/ discomfort.
Case study/Exercise
2 Listening Skills
Listening-hearing and listening, effective listening, barriers to effective listening
guidelines for effective listening.
Triple- A Listening - Attitude, Attention & Adjustment.
Active Listening Skills.
3 Motivational Training
Characteristics Essential to Achieving Success
The Power of Positive Attitude
Self awareness
Importance of Commitment
Ethics and Values
Ways to Motivate Oneself
Personal Goal setting and Employability Planning.
Case study/Exercise
4 Facing Interviews
Manners, Etiquettes, Dress code for an interview
Do's & Don'ts for an interview
5 Behavioral Skills
Organizational Behavior
Problem Solving
Confidence Building
Attitude
Decision making
Case study/Exercise
Entrepreneurship skill 7
1 Concept of Entrepreneurship
Entrepreneurship- Entrepreneurship - Enterprises:-Conceptual issue
Entrepreneurship vs. Management, Entrepreneurial motivation.
Performance & Record, Role & Function of entrepreneurs in relation to the
enterprise & relation to the economy, Source of business ideas,
Entrepreneurial opportunities, The process of setting up a business.
2 Project Preparation & Marketing analysis
Qualities of a good Entrepreneur, SWOT and Risk Analysis. Concept &
application of Product Life Cycle (PLC), Sales & distribution Management.
Different Between Small Scale & Large Scale Business, Market Survey,
Method of marketing, Publicity and advertisement, Marketing Mix.
3 Institutions Support
Preparation of Project. Role of Various Schemes and Institutes for self-
employment i.e. DIC, SIDA, SISI, NSIC, SIDO, Idea for financing/ non
financing support agencies to familiarizes with the Policies /Programmes &
procedure & the available scheme.
18
4 Investment Procurement
Project formation, Feasibility, Legal formalities i.e., Shop Act, Estimation &
Costing, Investment procedure - Loan procurement - Banking Processes.
Productivity
1 Productivity
Definition, Necessity, Meaning of GDP.
2 Affecting Factors
Skills, Working Aids, Automation, Environment, Motivation
How improves or slows down.
3 Comparison with developed countries
Comparative productivity in developed countries (viz. Germany, Japan and
Australia) in selected industries e.g. Manufacturing, Steel, Mining,
Construction etc. Living standards of those countries, wages.
4 Personal Finance Management
Banking processes, Handling ATM, KYC registration, safe cash handling,
Personal risk and Insurance.
Occupational Safety, Health & Environment Education 5
1 Safety & Health
Introduction to Occupational Safety and Health importance of safety and
health at workplace.
2 Occupational Hazards
Basic Hazards, Chemical Hazards, Vibro-acoustic Hazards, Mechanical Hazards,
Electrical Hazards, Thermal Hazards. Occupational health, Occupational hygienic,
Occupational Diseases/ Disorders & its prevention.
3 Accident & safety
Basic principles for protective equipment.
Accident Prevention techniques - control of accidents and safety measures.
4 First Aid
Care of injured & Sick at the workplaces, First-Aid & Transportation of sick
person
5 Basic Provisions
Idea of basic provision legislation of India.
of safety, health, welfare under legislation of India.
6 Ecosystem
Introduction to Environment. Relationship between Society and Environment,
Ecosystem and Factors causing imbalance.
7 Pollution
Pollution and pollutants including liquid, gaseous, solid and hazardous waste.
8 Energy Conservation
Conservation of Energy, re-use and recycle.
9 Global warming
Global warming, climate change and Ozone layer depletion.
10 Ground Water
Hydrological cycle, ground and surface water, Conservation and Harvesting of water
11 Environment
Right attitude towards environment, Maintenance of in -house environment
Labour Welfare Legislation
1 Welfare Acts
Benefits guaranteed under various acts- Factories Act, Apprenticeship Act,
Employees State Insurance Act (ESI), Payment Wages Act, Employees Provident
Fund Act, The Workmen's compensation Act.
Quality Tools 5
19
1 Quality Consciousness :
Meaning of quality, Quality Characteristic
2 Quality Circles :
Definition, Advantage of small group activity, objectives of quality Circle, Roles and
function of Quality Circles in Organization, Operation of Quality circle. Approaches
to starting Quality Circles, Steps for continuation Quality Circles.
3 Quality Management System :
Idea of ISO 9000 and BIS systems and its importance in maintaining qualities.
4 House Keeping :
Purpose of Housekeeping, Practice of good Housekeeping.
5 Quality Tools
Basic quality tools with a few examples
Leadership and Team Building skills 8
1 Leadership
Discipline and Morale
Team Work
Case Study/ Exercise
2 Meet the Mentor
Role - play as a Supervisor
Organizing and Planning.
1 Time Management
Group Dynamics
Case Study/ Exercise
20
7.2 PRACTICAL TRAINING (ON-JOB TRAINING)
(BLOCK – I)
DURATION: 12 MONTHS
GENERAL INFORMATION
21
7.2.1 BROAD SKILL COMPONENT TO BE COVERED DURING ON-
JOB TRAINING
BLOCK – I (Duration- 12 months)
The candidate should be competent to execute following operation/ skills after completion of the
industrial training: -
22
Systems. Scenario management and Variance Analysis. Using Tally for Costing,
Ratio Analysis, Cash Flow, Funds Flow Statements. Analyzing and Managing
Inventory. Performing Point of Sales and Taxation.
11 Performing Systems Administration and using other Utilities, User creation,
Backup &Restore of Company. Using the Multilingual Functionality. Using E
Commerce Simulator Software for Marketplace Business Simulation. Identifying
and solving security issues in E- commerce and payment operations. Typing
Practice in Regional Languages.
12 A Simple project using Word, Excel, Access, HTML, CSS, JavaScript, VBA,
Tally or Networking.
13 A Simple project to present their learning through power point presentation.
23
8. ASSESSMENT STANDARD
8.1 Assessment Guideline:
Appropriate arrangements should be made to ensure that there will be no artificial
barriers to assessment. The nature of special needs should be taken into account while
undertaking assessment. Due consideration to be given while assessing for team work,
avoidance/reduction of scrape/wastage and disposal of scarp/wastage as per procedure,
behavioral attitude and regularity in training.
For this grade, the candidate with occasional guidance and showing due regard for safety
procedures and practices, has produced work which demonstrates attainment of an
acceptable standard of craftsmanship.
skill in the use of software tools, network tools and workshop/lab equipment
tolerances, time & space management while undertaking different work being
substantially in line with those demanded by the program/project.
good documentation, indentation, neatness and consistency in the program.
occasional support in completing the project/job.
b) Weightage in the range of above 75%- 90% to be allotted during assessment under
following performance level:
For this grade, the candidate, with little guidance and showing due regard for safety
procedures and practices, has produced work which demonstrates attainment of a
reasonable standard of craftsmanship.
good skill levels in the use of software tools, network tools and workshop/lab
equipment
good tolerances, time & space management while undertaking different work being
substantially in line with those demanded by the program/project.
a good level of documentation, indentation, neatness and consistency in the
program.
little support in completing the project/job
24
c) Weightage in the range of above 90% to be allotted during assessment under
following performance level:
For performance in this grade, the candidate, with minimal or no support in organization
and execution and with due regard for safety procedures and practices, has produced
work which demonstrates attainment of a high standard of craftsmanship.
high skill levels in the use of software tools, network tools and workshop/lab
equipment
high tolerances, time & space management while undertaking different work being
substantially in line with those demanded by the program/project.
a high level of documentation, indentation, neatness and consistency in the program.
minimal or no support in completing the project
25
8.2 FINAL ASSESSMENT- ALL INDIA TRADE TEST (SUMMATIVE
ASSESSMENT)
Note: - The candidate should pass in each subject conducted under all India trade test.
26
9. FURTHER LEARNING PATHWAYS
On successful completion of the course trainees can opt for Diploma course
(Lateral entry).
On successful completion of the course trainees can opt for CITS course.
Employment opportunities:
After completion of the course the apprentices shall be qualified for one or
more of the following job roles:
1. Office Automation.
2. Smart Accounting.
3. Web design and maintenance.
4. Computer maintenance.
5. Computer Training in schools and institutes.
6. Cyber Cafe setup and management.
7. IT online support
27
ANNEXURE – I
TOOLS & EQUIPMENT FOR BASIC TRAINING
Laptop 4th Gen Ci5 Processor, 4GB RAM, 1TB Hard Disk, Win8
2 01 No
Preloaded Licensed OS, 2GB Graphics Card, DVD Writer,
Standard Ports And Connectors.
28
12 2KVA online UPS 2 Nos.
3 Open source
Open Office or equivalent.
software
4 Open source
GIMP / Irfan View Image editor or equivalent
software
5 Open source
LINUX OS
software
Open source
8. E Commerce Simulation Software
software
29
9. Web Server : Any HTTP Web server / XAMPP or any other Open source
similar server software
30
7 RJ 45 Jack 200 Pcs
10 SMPS As required
19 CDs 50 Nos
20 DVDs 50 Nos.
Provision must be made for domain name registration and renewal from time to time for hosting the
web sites created by the trainees as part of the syllabus.
***
31
ANNEXURE – II
32
ANNEXURE-III
1. Due care to be taken for proper & inclusive delivery among the batch. Some of the
following some method of delivery may be adopted:
A) LECTURE
B) LESSON
C) DEMONSTRATION
D) PRACTICE
E) GROUP DISCUSSION
F) DISCUSSION WITH PEER GROUP
G) PROJECT WORK
H) INDUSTRIAL VISIT
2. Maximum utilization of latest form of training viz., audio visual aids, integration of
IT, etc. may be adopted.
3. The total hours to be devoted against each topic may be decided with due diligence to
safety & with prioritizing transfer of required skills.
33