NSQF LEVEL- 6

SECTOR- IT &ITeS

GOVERNMENT OF INDIA
Ministry of Skill Development & Entrepreneurship
Directorate General of Training
CENTRAL STAFF TRAINING AND RESEARCH INSTITUTE
EN-81, Sector-V, Salt Lake City, Kolkata – 700091
 COMPUTER SOFTWARE
APPLICATION
Applicable for “Computer Operator & Programming Assistant (COPA)” and
“Database System Assistant” Trade

(Non-Engineering Trade)

SECTOR – IT & ITeS

(Revised in 2019)

Version 1.1

CRAFTS INSTRUCTOR TRAINING SCHEME (CITS)

NSQF LEVEL - 6

Developed By
Government of India
Ministry of Skill Development and Entrepreneurship
Directorate General of Training
CENTRAL STAFF TRAINING AND RESEARCH INSTITUTE
EN-81, Sector-V, Salt Lake City,
Kolkata – 700 091
www.cstaricalutta.gov.in
 COMPUTER SOFTWARE APPLICATION (CITS)

CONTENTS

S No. Topics Page No.

1. Course Overview 1
2. Training System 2
3. General Information 6
4. Job Role 8
5. Learning Outcomes 10
6. Course Content 11
7. Assessment Criteria 21
8. Infrastructure 24
Annexure I –List of Trade Experts 27
 COMPUTER SOFTWARE APPLICATION (CITS)

1. COURSE OVERVIEW

The Craft Instructors’ Training Scheme is operational since inception of the

Craftsmen Training Scheme. The first Craft Instructors’ Training Institute was established in
1948. Subsequently, 6 more institutes namely, Central Training Institute for Instructors (now
called as National Skill Training Institute (NSTI)), NSTI at Ludhiana, Kanpur, Howrah,
Mumbai, Chennai and Hyderabad were established in 1960’s by DGT. Since then the CITS
course is successfully running in all the NSTIs across India as well as in DGT affiliated private
institutes viz. Institutes for Training of Trainers (IToT). This is a competency-based course of
one year duration. “Computer Software Application” CITS trade is applicable for Instructors
of “COPA” and “Database System Assistant” trades.

The main objective of Crafts Instructor training programme is to enable Instructors

explore different aspects of the techniques in pedagogy and transferring of hands-on skills
so as to develop a pool of skilled manpower for industry, also leading to their career growth
& benefiting society at large. Thus promoting a holistic learning experience where trainee
acquires specialized knowledge, skills & develops attitude towards learning & contributing in
vocational training ecosystem.

This course also enables the instructors to develop instructional skills for mentoring
the trainees, engaging all trainees in learning process and managing effective utilization of
resources. It emphasizes on the importance of collaborative learning & innovative ways of
doing things. All trainees will be able to understand and interpret the course content in right
perspective, so that they are engaged in & empowered by their learning experiences and
above all, ensure quality delivery.

1
 COMPUTER SOFTWARE APPLICATION (CITS)

2. TRAINING SYSTEM

2.1 GENERAL

CITS courses are delivered in National Skill Training Institutes (NSTIs) & DGT affiliated
institutes viz., Institutes for Training of Trainers (IToT). For detailed guidelines regarding
admission on CITS, instructions issued by DGT from time to time are to be observed. Further
complete admission details are made available on NIMI web portal
http://www.nimionlineadmission.in.The course is of one-year duration. It consists of Trade
Technology (Professional skills and Professional knowledge), Training Methodology and
Engineering Technology/ Soft skills. After successful completion of the training programme,
the trainees appear in All India Trade Test for Craft Instructor. The successful trainee is
awarded NCIC certificate by DGT.

2.2 COURSE STRUCTURE

Table below depicts the distribution of training hours across various course elements
during a period of one year:

S No. Course Element Notional Training Hours

1. Trade Technology
Professional Skill (Trade Practical) 640
Professional Knowledge (Trade Theory) 240
2. Soft Skills
Practical 100
Theory 100
3. Training Methodology
TM Practical 320
TM Theory 200
Total 1600

2.3 PROGRESSION PATHWAYS

 Can join as an Instructor in a vocational training Institute/ technical Institute.

 Can join as a supervisor in Industries.

2.4 ASSESSMENT & CERTIFICATION

The CITS trainee will be assessed for his/her Instructional skills, knowledge and
attitude towards learning throughout the course span and also at the end of the training
program.

2
 COMPUTER SOFTWARE APPLICATION (CITS)

a) The Continuous Assessment (Internal) during the period of training will be done by
Formative Assessment Method to test competency of instructor with respect to assessment
criteria set against each learning outcomes. The training institute has to maintain an
individual trainee portfolio in line with assessment guidelines. The marks of internal
assessment will be as per the formative assessment template provided on
www.bharatskills.gov.in

b) The Final Assessment will be in the form of Summative Assessment Method. The All
India Trade Test for Crafts Instructor for awarding National Craft Instructor Certificate will
be conducted by DGT at the end of the year as per the guideline of DGT. The learning
outcome and assessment criteria will be the basis for setting question papers for final
assessment. The external examiner during final examination will also check the individual
trainee’s profile as detailed in assessment guideline before giving marks for practical
examination.

2.4.1 PASS CRITERIA

Pass Marks
S Internal Full
Subject Marks Internal
No. Assessment Marks Exam
Assessment
Trade Theory 100 40 140 40 24
Trade
1.
Technology Trade
Practical 200 60 260 120 36

Practical 50 25 75 30 15
2. Soft Skills
Theory 50 25 75 20 15

Training TM Practical 200 30 230 120 18

3.
Methodology TM Theory 100 20 120 40 12
Total Marks 700 200 900 370 120

The minimum pass percent for Trade Practical, TM Practical, Soft Skill Practical
Examinations and Formative assessment is 60% & for all other subjects is 40%. There will be
no Grace marks.

2.4.2 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 the assessment. While assessing, the major factors to be considered are

3
 COMPUTER SOFTWARE APPLICATION (CITS)

approaches to generate solutions to specific problems by involving standard/non-standard

practices.

Due consideration should also be given while assessing for teamwork,

avoidance/reduction of scrap/wastage and disposal of scrap/waste as per procedure,
behavioral attitude, sensitivity to the environment and regularity in training. The sensitivity
towards OSHE and self-learning attitude are to be considered while assessing competency.

Assessment will be evidence based comprising of the following:

 Demonstration of Instructional Skills (Lesson Plan, Demonstration Plan)

 Record book/daily diary
 Assessment Sheet
 Progress chart
 Video Recording
 Attendance and punctuality
 Viva-voce
 Practical work done/Models
 Assignments
 Project work

Evidences and records of internal (Formative) assessments are to be preserved until

forthcoming yearly examination for audit and verification by examining body. The following
marking pattern to be adopted while assessing:

Performance Level Evidence

(a) Weightage in the range of 60%-75% to be allotted during assessment
For performance in this grade, the candidate  Demonstration of fairly good skill to
should be well versed with instructional establish a rapport with audience,
design, implement learning programme and presentation in orderly manner and
assess learners which demonstrates establish as an expert in the field.
attainment of an acceptable standard of  Average engagement of students for
crafts instructorship with occasional guidance learning and achievement of goals
and engage students by demonstrating good while undertaking the training on
attributes of a trainer. specific topic.
 A fairly good level of competency in
expressing each concept in terms the
student can relate, draw analogy and
summarize the entire lesson.
 Occasional support in imparting
effective training.

4
 COMPUTER SOFTWARE APPLICATION (CITS)

(b) Weightage in the range of 75%-90% to be allotted during assessment

For performance in this grade, the candidate  Demonstration of good skill to establish
should be well versed with instructional a rapport with audience, presentation
design, implement learning programme and in orderly manner and establish as an
assess learners which demonstrates expert in the field.
attainment of a reasonable standard of crafts  Above average engagement of students
instructorship with little guidance and engage for learning and achievement of goals
students by demonstrating good attributes of while undertaking the training on
a trainer. specific topic.
 A good level of competency in
expressing each concept in terms the
student can relate, draw analogy and
summarize the entire lesson.
 Little support in imparting effective
training.
(c) Weightage in the range of more than 90% to be allotted during assessment
For performance in this grade, the candidate  Demonstration of high skill level to
should be well versed with instructional establish a rapport with audience,
design, implement learning programme and presentation in orderly manner and
assess learners which demonstrates establish as an expert in the field.
attainment of ahigh standard of crafts  Good engagement of students for
instructorship with minimal or no support and learning and achievement of goals
engage students by demonstrating good while undertaking the training on
attributes of a trainer. specific topic.
 A high level of competency in
expressing each concept in terms the
student can relate, draw analogy and
summarize the entire lesson.
 Minimal or no support in imparting
effective training.

5
 COMPUTER SOFTWARE APPLICATION (CITS)

3. GENERAL INFORMATION

Name of the Trade Computer Software Application -CITS

Trade Code DGT/4004

NCO – 2015 4131.0600, 3514.0300, 2522.0100, 2521.0202, 2356.0100
NSQF Level Level-6
Duration of Craft
One Year
Instructor Training
Unit Strength (No. Of 25
Student)
Entry Qualification Degree in Computer Science/ Information Technology or MCA/MSc
(Computer Science Computer / Information Technology) / NIELIT “B” or
equivalent from recognized Board/ University.
OR
Diploma in Computer Science/Information Technology or BCA/BSc
(Computer Science/Information Technology) or equivalent from
recognized Board/ University.
OR
National Trade Certificate in COPA or related trades.
OR
National Apprenticeship Certificate in COPA or related trades.
Minimum Age 18 years as on first day of academic session.

Space Norms 84 sq. m

Power Norms 3.45 KW

Instructors Qualification for
1. Computer Software B.Voc/ Degree in Computer Science/Information Technology or
Application -CITS MCA/MSc (Computer Science /Information Technology) or NIELIT “B" or
Trade equivalent from AICTE/ UGC recognized university / board with 2 years
experience in relevant field.
OR
Diploma (Minimum 2 Years) in Computer Science/Information
Technology or BCA/B.Sc (Computer Science/Information Technology) or
equivalent from recognized university / board or relevant Advanced
Diploma (Vocational) from DGT with 5 years experience in relevant field.
OR
NTC/ NAC passed in COPA trade with seven years experience in relevant
field.

6
 COMPUTER SOFTWARE APPLICATION (CITS)

Essential Qualification:
Relevant National Craft Instructor Certificate (NCIC) in COPA trade in any
of the variants under DGT.
2. Soft Skills MBA/ BBA / Any Graduate/ Diploma in any discipline from AICTE/ UGC
recognized College/ university with Three years’ experience and short
term ToT Course in Soft Skills from DGT institutes.
(Must have studied English/ Communication Skills and Basic Computer
at 12th / Diploma level and above).
3. Training B.Voc/ Degree in any discipline from AICTE/ UGC recognized College/
Methodology university with two years experience in training/ teaching field.
OR
Diploma in any discipline from recognized board / University with five
years experience in training/teaching field.
OR
NTC/ NAC passed in any trade with seven years experience in training/
teaching field.

Essential Qualification:
National Craft Instructor Certificate (NCIC) in any of the variants under
DGT / B.Ed /ToT from NITTTR or equivalent.
4. Minimum Age for 21 Years
Instructor
Distribution of training on Hourly basis: (Indicative only)
Total Hrs Trade Trade Soft Skills Training Methodology
/week Practical Theory Practical Theory Practical Theory

40 Hours 16 Hours 6 Hours 2.5 Hours 2.5 Hours 8 Hours 5 Hours

7
 COMPUTER SOFTWARE APPLICATION (CITS)

4. JOB ROLE

Brief description of job roles:

Manual Training Teacher/Craft Instructor; instructs students in ITIs/Vocational Training
Institutes in respective trades as per defined job role. Imparts theoretical instructions for the
use of tools& equipment of related trades and related subjects. Demonstrate process and
operations related to the trade in the workshop; supervises, assesses and evaluates students
in their practical work. Ensures availability & proper functioning of equipment and tools in
stores.

Computer Operator; operates computer and peripheral equipment to process business,

scientific, engineering, or other data, according to operating instructions. Enters
commands, using keyboard of computer terminal, and presses buttons and flips switches
on computer and peripheral equipment, such as tape drive, printer, data communications
equipment, and plotter, to integrate and operate equipment, following operating
instructions and schedule. Loads peripheral equipment with selected materials, such as
tapes and printer paper for operating runs, or oversees loading of peripheral equipment by
Peripheral Equipment Operators. Enters commands to clear computer system and start
operation, using keyboard of computer terminal. Observes peripheral equipment and error
messages displayed on monitor of terminal to detect faulty output or machine stoppage.
Enters commands to correct error or stoppage and resume operations. Notifies supervisor
of errors or equipment stoppage. Clears equipment at end of operating run and reviews
schedule to determine next assignment. Records problems which occurred, such as down
time, and actions taken. May answer telephone calls to assist computer users encountering
problem. May assist workers in classifying, cataloguing, and maintaining tapes.

Programming Assistant; installs, maintains and updates computer programs by making

minor changes and adjustments to them under the guidance of computing professionals.
Maintains and updates documents of computer programs and installations. Applies
knowledge of principles and practices in the area of programming and computing in order
to identify and solve problems arising in the course of their work. They may receive
guidance from managers or professionals. May supervise other workers also.

Database Administrator; co-ordinates physical changes to computer databases; and codes,

tests, and implements physical database, applying knowledge of database management
system: Designs logical and physical databases or reviews description of changes to
database design to understand how changes to be made affect physical database (how data
is stored in terms of physical characteristics, such as location, amount of space, and access
method). Establishes physical database parameters. Codes database descriptions and
specifies identifiers of database to database management system or directs others in coding
database descriptions. Calculates optimum values for database parameters, such as amount
of computer memory to be used by database, following manuals and using calculator.

8
 COMPUTER SOFTWARE APPLICATION (CITS)

Specifies user access level for each segment of one or more data items, such as insert,
replace, retrieve, or delete data. Specifies which users can access databases and what data
can be accessed by user. Tests and corrects errors, and refines changes to database. Enters
codes to create production database. Selects and enters codes of utility programs to
monitor database performance, such as distribution of records and amount of available
memory. Directs programmers and analysts to make changes to database management
systems. Reviews and corrects programs. Answers user questions. Confers with co-workers
to determine impact of database changes on other systems and staff cost for making
changes to the database. Modifies database programs to increase processing performance,
referred to as performance tuning. Workers typically specialize in one or more types of
database management systems. May train users.

Junior Data Associate; is responsible for designing and implementing processes and layouts
for complex, large-scale data sets used for modelling, data mining, and research purposes.
Responsibilities also include designing and implementing statistical data quality procedures
around new data sources.

Reference NCO-2015:-

a) 2356.0100 – Manual Training Teacher/ Craft Instructor.

b) 4131.0600 – Computer Operator
c) 3514.0300 – Programming Assistant
d) 2522.0100 – Database Administrator
e) 2521.0202 – Junior Data Associate

9
 COMPUTER SOFTWARE APPLICATION (CITS)

5. LEARNING OUTCOMES

Learning outcomes are a reflection of total competencies of a trainee and assessment

will be carried out as per the assessment criteria.

5.1 TRADE TECHNOLOGY

1. Setup LAN and configure various network devices related software in a computer.
2. Manage network application &secure network and practice on network
architecture.
3. Create and manage database file using MYSQL.
4. Design and Develop web pages using Java Script.
5. Design and Develop web pages using PHP.
6. Develop spread sheets by embedding VBA.
7. Design dynamic webpage using java (AWT, APPLET).
8. Maintain accounts using accounting software.

10
 COMPUTER SOFTWARE APPLICATION (CITS)

6. COURSE CONTENT

SYLLABUS FOR COMPUTER SOFTWARE APPLICATION–CITS TRADE

TRADE TECHNOLOGY
Reference Professional Skills Professional Knowledge
Duration
Learning Outcome (Trade Practical) (Trade Theory)
Practical Setup LAN and Demonstrate on Network Architecture
96 Hrs configure various 1. Straight Cabling and Cross  Layering &Protocols.
network devices cabling.  OSI & Internet Architecture.
Theory related software in 2. Switch Configuration.  Network topology
36 Hrs a computer. 3. LAN and WAN setup.  Link & Medium Access
4. Setting TCP/IP. protocols, IEEE 802
standards, Performance
Manage network issues
application &  Network Adaptors. Circuit
Secure network switching – packet
and practice on switching.
network  Internetworking -
architecture. bridges - Internet
protocol -
Addressing –
Routing Protocols.
 UDP - TCP- Congestion
Control – Presentation
aspects.
Demonstrate on Applications & Network
5. Network Monitoring and Management:
Control (SNMP, V2, V3,  Telnet, FTP – e-mail – DNS.
RMON,RMON2).  Multimedia Applications
6. Wireless Networking  Security, Monitoring
Design. &Control
7. Implementing Voice over  SNMP V2 and V3, RMON,
IP. RMON2.
8. Configuring DHCP, IPV4/  The wireless channel - Link
IPV6. level design - Channel access
Network design -Standards.
 Optical Networks - Cross
connects –LANS
 Voice Over IP – Multimedia

11
 COMPUTER SOFTWARE APPLICATION (CITS)

Networks.
 Introduction to VPN and
DHCP
Demonstrate on Network Security
9. Configuring Network  Attacks, Services and
Security for preventing Mechanisms, Security
Attacks. Attacks, Security Services,
10. Setting password policy Integrity check, Digital
11. Sniffing on Switched Signatures, Authentication.
Networks  Concept of Cryptography.
12. IP Address Spoofing  Hash Function
13. DNS Spoofing  SSL Protocol
14. Password Cracking:  Intrusions and Viruses,
Dictionary vs Brute- Force Firewalls, Intrusion
vs Hybrid methods Detection.
15. Handling Denial of Service  Cyber security systems &
16. Using Tools like John the cyber laws.
Ripper, Cain & Abel etc.
17. Configuring Firewalls
Practical Create and Demonstrate on Database Concepts
96Hrs manage database 18. Installation of MySQl.  Concept of DBMS, RDBMS.
file using MYSQL. 19. Troubleshooting basic  Data Models, Concept of
Theory installation issues. DBA, Database Users.
36Hrs 20. Creation and use of  ER Model & Diagram,
database. Database Schema.
21. Designing of tables.  Designing Database using
22. Applying data integrity Normalization Rules.
rules.  Various data types Data
23. Using the DDL, DCL and integrity, DDL DML and DCL
DML statements. statements.
24. Enforcing constraints,  Enforcing Primary key and
primary key and foreign foreign key.
key.  Adding Indices.
25. Adding indices to Tables.
Demonstrate on Queries
26. Simple select queries.  Concepts of Transactions
27. Insert and delete queries ACID Property of
Update queries. Transaction Constraints.
Demonstrate on Joins and Functions
28. Using the Number, Date  Joining of tables
and Character functions.  Sub Queries

12
 COMPUTER SOFTWARE APPLICATION (CITS)

29. Joins, Group by, Having,  Functions used in query like

Sub query. sum, average, max, min,
30. Indexing and Optimizing count etc.
Query.  Indexing and Query
Optimization.
Demonstrate on Stored Procedures, Triggers and
31. Creating and using stored Cursors
procedures.  Introduction to Stored
32. Creating and executing Procedures.
mysql table level triggers.  Introduction to Triggers and
33. Creating cursors in mysql. Cursor.
34. Using cursors in mysql.  Creating Trigger
35. Implementing mysql  Creating Cursor
security.  Using Cursor
36. Simple application on
Database using SP, Triggers,
Cursors and Indexing.
Practical Design and Demonstrate on Introduction to Java Script
64Hrs Develop web pages 37. Using the Java Script  Introduction to JavaScript.
using Java Script. Syntax.  Java Script Syntax, Variables,
Theory 38. Using Variables, Operators Operators and Expression.
24Hrs and Writing Expressions  Control Flow.
39. Programming with Control  Functions
Flow statements  Concept of Object oriented
40. Creating and using Objects Development.
in JavaScript  Concept of DOM.
41. Creating and using  Forms and JavaScript.
Functions
42. Using Java Script with Forms

Demonstrate on Java Script and dynamic web

43. Creating Cookies with pages
JavaScript  Concept of Cookies
44. Creating CSS  Cascaded Style Sheets
45. Error Handling in JavaScript  Error Handling in JavaScript
46. Implementing an AJAX  Concept of AJAX
application
Practical Design and Demonstrate on Hypertext Preprocessor
144Hrs Develop web pages 47. Installing a web XAMP/  Introduction to PHP and PHP
using PHP. WAMP server on your PC configuration file
then Installing PHP  Basic PHP Syntax -Variables,
Theory 48. Creating files to test the

13
 COMPUTER SOFTWARE APPLICATION (CITS)

54Hrs use of PHP variables and Data Types, Super Global

data types Variables, PHP Functions,
49. Creating files to use Built in PHP Operators.
functions  Creating Dynamic pages
50. Creating Dynamic Pages with PHP
51. Using Flow Control  Creating Dynamic Pages
statements  Flow Control and Loops.
52. Creating Loops in PHP  Arrays in PHP
53. Creating and using arrays
Demonstrate on PHP Forms
54. Creating PHP & HTML  PHP and HTML Forms
Forms.  String Manipulating
55. Using String Manipulating Functions
Functions.  Magic Quotes
56. Enabling and Disabling  Including Files
Magic Quotes.  User Functions in PHP
57. Using the include  Form processing
statement in PHP.  PHP MySql.
58. Working with user
functions.
59. Designing and processing
forms.
Demonstrate on PHP Database connection, mail
60. Connecting to MySql server and file management
with PHP.  PHP connection to MySql
61. Querying a Database.  PHP querying databases
62. Create a basic user  Using PHP regular
authentication system expressions
using PHP and MySQL.  PHP Cookies
63. Using regular expressions.  PHP Sessions
64. Create and retrieve  PHP mail() function and
cookies. sending mail
65. Starting and storing PHP  PHP File operations
sessions.
66. Sending Mail with PHP.
67. Creating, reading,
uploading and editing files
in PHP.
Practical Develop spread Demonstrate writing code to Introduction to VBA, Features
80Hrs sheets by 68. Use VBA Data types, and Applications.
embedding VBA. Variables, Operators and  Introduction to VBA features
Theory Constants. and applications.

14
 COMPUTER SOFTWARE APPLICATION (CITS)

30Hrs 69. Work with string variables  VBA Data types, Variables
in VBA. and Constants.
70. Create and manipulate  Operators in VBA and
arrays in VBA. operator precedence.
71. Use the mathematical,  Mathematical Expressions in
conversion, date and string VBA.
functions in VBA.  Introduction to Strings in
72. Work with conditional VBA.
statements like If, Else if,  Introduction to Arrays in
Select … Case statements in VBA.
VBA.  Conditional processing in
73. Use the control structures VBA, using the IF, Else if,
for looping in VBA. Select… Case Statements.
74. Create Message boxes and  Introduction to Loops in
Input boxes in VBA. VBA. VBA message boxes
and input boxes.
Demonstrate writing code to Functions and methods
75. Create functions and  Introduction to functions
procedures. and procedures in VBA.
76. Pass parameters and use  Using the built in functions.
returned data  Creating and editing macros.
77. Use VBA built in Functions  Debugging Techniques.
in Programmes
78. Create and edit macros
79. Debugging
Forms, controls and events
80. Create forms with basic driven programming
controls.  Introduction to Object
81. Modify the properties of Oriented Programming
the form and controls at Concepts. Concepts of
design time. Classes, Objects, Properties
82. Create controls and modify and Methods.
their properties at runtime.  The user forms and control
83. Write programs with in Excel VBA.
methods and events.  Properties, events and
84. Use Active controls. methods associated with the
85. Design a simple project Button, Check Box, Label,
involving MS Excel and Combo Box, Group Box,
VBA. Option Button, List Box,
86. Developer tool box in MS Scroll Bar and Spin button
Excel. controls.

15
 COMPUTER SOFTWARE APPLICATION (CITS)

 Events and Event driven

programming concepts.
 Overview of ActiveX Data
objects.
Practical Design dynamic 87. Installing JAVA. Object Oriented Programming
96Hrs webpage using 88. Setting the Class path. and JAVA Language
java (AWT, 89. Writing and Executing a  Object Oriented
Theory APPLET). simple JAVA Program to Programming with Core Java
36 Hrs display “Hello”.  Java Programming features
 JVM, Byte codes and Class
Demonstrate writing JAVA path
programs to :  Java Program Development
90. Use various data types in  Compilation and Execution
JAVA. of JAVA programs
91. Use various operators in  Basic JAVA language
JAVA. elements – keywords,
92. Create and use Local, comments, data types and
Instance and Class variables.
variables.  JAVA Arithmetic,
93. Read text from the Assignment, Relational,
keyboard using scanner Logical, Increment /
class read text from the Decrement operators and
keyboard using console expressions.
class.  JAVA String Operators
 JAVA Input and Output
streams, System in, System
out.
 Input using Scanner class
and Console class methods
Demonstrate writing JAVA JAVA Program Flow Control
programs to :  Decision making and flow
94. Use the if and if … else control using if…then, if
statements. then else, nested if, switch
95. Use the Switch statement. case and the conditional
96. Use the Do … While and ternary operators in JAVA.
while – do loops.  Loop control flow using
97. Use the For Loop. while – do, do – while loops,
98. Use the Break and Continue for loop, using the break,
Keywords. continue statements.
99. Use the JAVA Numbers  Terminating the JAVA
Class methods. program.

16
 COMPUTER SOFTWARE APPLICATION (CITS)

100. Use the JAVA Character  JAVA Number, Character

Class methods. and String Classes.
101. Use the JAVA String Class  Arrays in JAVA.
methods.
102. Create and use arrays.
Demonstrate writing JAVA JAVA Classes, Overloading and
programs to : Inheritance
103. Create and use simple
classes, objects and  JAVA Objects, Classes and
methods in JAVA. Methods.
104. Pass data and Objects to  Passing data and objects as
Methods. parameters to methods.
105. Return data and Objects  Method Overloading.
from Methods.  Constructors and
106. use constructors in JAVA Overloaded constructors.
107. Create and use Overloaded  Inheritance in JAVA.
methods in JAVA.  Method Overriding in JAVA.
108. Override methods in JAVA.
109. Create and use Super class,
Sub class in JAVA.
Demonstrate writing JAVA Multithreading and Exception
programs to : Handling in JAVA
110. Create and run a thread.  Thread concept and life
111. Create a thread by cycle of thread.
extending Thread class.  Extending thread class and
112. Create thread by using thread methods
implementing Runnable  Thread priority and runnable
interface. Interface
113. Use major thread methods.  Multithreading and
114. Test multithreading with Synchronization
and without  Exception Handling concepts
synchronization. and hierarchy
115. Handle common  Exception types and
exceptions. methods
116. Use multiple try – catch  Concepts of “ try, catch and
blocks. throw and finally” in
117. Use the “throw” and exceptions.
“finally” keywords handle  User defined exceptions
user defined exceptions.
118. Create and use virtual Abstract Classes and Interfaces
methods. in JAVA
119. Create abstract classes and  Concept of Virtual methods.

17
 COMPUTER SOFTWARE APPLICATION (CITS)

methods. 
Concept of Abstract classes
120. Create interfaces in JAVA. and methods
121. Override methods in JAVA.  Features of Abstract Classes
122. Create and implement an  JAVA Interfaces and their
interface. advantages
123. Extend interfaces in JAVA.  Method Overriding in JAVA
124. Create and use a package in Polymorphism in JAVA
JAVA.  Creating , implementing and
extending interfaces
 Creating and using Packages
in JAVA.
Demonstrate writing JAVA Abstract Windowing Tool Kit
programs to :
 Introduction to user
125. Create a simple container interface and AWT
using Frame class and components and containers
extending another Frame  Introduction to AWT UI
class. controls, hierarchy and their
126. Create a container with a features
few controls.  Introduction to event
127. Create a container with handling
controls with action  Introduction to event
listeners and event handling classes
handlers.  Introduction to event
128. Create a GUI to draw listener interfaces
different plane shapes over  Introduction to AWT Layouts
a predefined area.
Practical Maintain accounts 129. Demonstrate types of Accounting principles
64Hrs using accounting accounts.  Concepts and importance of
software. 130. Making journal accounting and book
Theory transactions. keeping.
24Hrs 131. Perform double entry  Introduction to the common
bookkeeping. accounting terms: business,
132. Create a ledger. capital, price, value, debit,
133. Create a Journal. credit, income, expenditure,
134. View different reports like profit, loss.
Balance Sheet, P&L A/c,  Accounting heads,
Day Books. accounting equation and
types of accounts.
 Rules and principles of debit
and credit.

18
 COMPUTER SOFTWARE APPLICATION (CITS)

 Double entry bookkeeping

and balance sheet.
 Introduction to Journals,
Voucher Entry, Ledger
Posting, Final Accounts
Preparation.
 Cash Book. Ratio Analysis,
Depreciation, Stock
Management.
 Introduction to VAT, GST
Cash Flow, Fund Flow
Accounting.
135. Familiarization with the Introduction to Smart
Tally interface. Accounting
136. Company creation, Account  Introduction to Tally,
Creation, Voucher Entry in
features and Advantages.
Tally.
137. Report Generation  Implementing accounts in
(Creating statements like Tally.
Invoice, Bill, Profit & Loss  Double entry system of
account etc.) bookkeeping using Tally
138. Performing Cost Centre &
Cost Category
management.
139. Managing Budgeting Using Accounting Software
Systems.  Budgeting Systems, Scenario
140. Scenario management and management and Variance
Variance Analysis. Analysis.
141. Using Tally for Costing,  Costing Systems, Concepts
Ratio Analysis, Cash Flow, of Ratios, Analysis of
Funds Flow Statements. financial statements,
142. Analyzing and Managing Inventory Basics, POS
Inventory. Invoicing, TDS, TCS, FBT, VAT
143. Performing Point of Sales &Service Tax Processing in
and Taxation. Performing Tally GST.
Systems Administration and  Tally Interface in Different
using other Utilities, User Languages.
creation, Backup &Restore
of Company.
144. Using the Multilingual
Functionality.

19
 COMPUTER SOFTWARE APPLICATION (CITS)

SYLLABUS FOR CORE SKILLS

1. Soft Skills (Common for all Non-Engineering CITS trades) (100 Hrs + 100Hrs)
2. Training Methodology (Common for all trades) (320Hrs + 200Hrs)

Learning outcomes, assessment criteria, syllabus and Tool List of above Core Skills subjects
which is common for a group of trades, provided separately in www.bharatskills.gov.in

20
 COMPUTER SOFTWARE APPLICATION (CITS)

7. ASSESSMENT CRITERIA

LEARNING OUTCOMES ASSESSMENT CRITERIA

TRADE TECHNOLOGY
1. Setup LAN and configure Crimp Cross and straight Cable using Rj45.
various network devices Install and configure Server-Client Network and all related protocol
related software in a services.
computer. Configure network devices.
Configure DHCP(ipv4,ipv6)

2. Manage network Managing Server Network Security.

application & secure Manage server using various cryptography concept.
network and practice on Network security and monitoring.
network architecture. Setting password policy.
Configure Firewall (Hardware and Software).

3. Create and manage Create a database of any School, College or Company using
database file using MYSQL. DDL,DML AND DCL.
Relate two tables using ER model & Diagram.
Relate two table using Primary Key & Foreign Key.
Evaluating Database and Application architectures with the help of
ACID Transaction.
Combine rows from two or more tables, based on a related
column between them using JOIN.
Reuse the code over and over again using stored procedure.
Insert a row into a specified table or when certain table columns
are being updated using SQL Trigger.
Structuring a relational database using normalization.
Use Constraints in database.
Create a SQL query using INDEX Statement.
Create cursor in processing row by row.

4. Design and Develop web Design a dynamic webpage using various operators in java scripts.
pages using Java Script. Design a dynamic webpage in java scripts using various control
statement and loping structure.
Design a dynamic webpage using function in java script.
Design a dynamic webpage using forms validations in java scripts.
Create cookies for client side system.
Design a dynamic webpage using CSS.
Handle compile time, runtime and logical errors while writing

21
 COMPUTER SOFTWARE APPLICATION (CITS)

programs in java scripts.

Create dynamic webpage using AJAX.

5. Design and Develop web Create a simple PHP program to declare variable and data types.
pages using PHP. Use Built in functions and predefined functions in PHP.
Use conditional statements if, if else, nested if and Switch using
PHP.
Apply looping statements for loop, While loop, Do While Loop and
for Each loop using PHP.
Create a PHP program of Array to store the Data using Objects.
Design a Form using HTML and validate it using PHP.
Work on String manipulating functions in PHP.
Design and Process a form and connect to MySQL Database.
Retrieve data from database using PHP program.
Create a Basic Authentication system using PHP and MySQL.
Check whether Email is valid using regular expressions.
Perform a Starting and Storing of PHP Sessions.

6. Develop spread sheets by Create a control form on VBA (like label, textbox, combo box etc.).
embedding VBA. Create simple program involving VBA data types, variable,
operator and constant.
Apply conditional statements like if, else-if and select.
Manipulate array in VBA.
Execute programs involving Math metical, conversion, date and
string function in VBA.
Create function, procedure, passing parameter and using return
data.
Apply macro with excel in VBA form.
Check debug, step through code, breakpoint, find and fix error
while debugging.
Develop a simple project involving using function, if-else
statement, loop.

7. Design dynamic webpage Design webpage and application using object oriented
using java (AWT, APPLET ) programming concepts like inheritance, polymorphisms etc. using
java.
Design application in java by using data types operator and
variables.
Develop application using scanner and console class.
Design webpage and application using conditional statement and
oops.

22
 COMPUTER SOFTWARE APPLICATION (CITS)

Develop application using Number, Character and String class.

Design and develop application by using arrays and methods.
Develop and design dynamic webpage using multithreading.
Design dynamic webpage using AWT and APPLETS.

8. Maintain accounts using Interface basic accounting with tally.

accounting software. Create company account, ledger, journal and voucher entry in
tally.
Generate report for invoice bill profit and loss account.
Perform cost centre& cost category management.
Create manage budgeting system.
Use tally for costing ratio and analysis, cash flow and fund flow.
Perform point of sales and taxation (VAT, Excise etc.)
Create users, take backup & Restore of Company.
Use multilingual functionality in Tally.

23
 COMPUTER SOFTWARE APPLICATION (CITS)

8. INFRASTRUCTURE

LIST OF TOOLS AND EQUIPMENT FOR COMPUTER SOFTWARE APPLICATION- CITS

S No. Name of the Tool &Equipment Specification Quantity

A. TRAINEES TOOL KIT

1. Desktop computer CPU: 32/64 Bit i3/i5/i7 or latest 26Nos. (25
processor, Speed: 3 GHz or for lab and
Higher. RAM:-4 GB DDR-III or one for
Higher, Wi-Fi Enabled. Network classroom)
Card: Integrated Gigabit
Ethernet, with USB Mouse, USB
Keyboard and Monitor (Min. 17
Inch. Licensed Operating
System and Antivirus
compatible with trade related
software.
2. Laptop Latest Ci5 Processor, 4GB 01 No.
RAM,1TB HardDisk,Win8
Preloaded Licensed OS,2GB
Graphics Card, DVD Writer,
Standard Ports And
Connectors.
3. Wi–Fi Router 24Port Switch With Wireless 01 No.
Connectivity option
4. Structured cabling (to enable working As required
with Wired Networks too for
Practicals)
5. Internet or Intranet Connectivity As required
6. Laser Printer Monochrome A4 Size 01 No.
7. Network Monochrome Laser Printer 01 No.
A4 Size
8. Optical Scanner (Flatbed A4) 01 No.
9. DVD or Blu-Ray Writer 02 Nos.
10. LCD / LED (Or Latest) Projector with 02 Nos.
matte (antiglare) screen (One each
for classroom
and lab)
11. UPS As required
12. Cable crimping tool 02 Nos.

24
 COMPUTER SOFTWARE APPLICATION (CITS)

13. Standalone Hard Disks 500 GB or Higher 02 Nos.

14. Network Rack 01 No.
15. Standard Screw Driver Set 02 Nos.
16. LAN Setup As required
B. SOFTWARE PER UNIT
17. MySql Open Source 12 Users
18. PHP Open Source 12 Users
19. Browser Open Source 12 Users
20. Web Server Apache Server /Any HTTP Web 12 Users
server / XAMPP or any other
similar server Open Source
21. WYSIWYG Web Designer or 12 Users
Dreamweaver or any Open source
tools like Kompozer, FrontPage
express / Word press or similar tools
along with FTP tools for ex. Filezilla
etc.
22. MS OFFICE 2010 or Latest Version 12 Users
23. Antivirus software - licensed 12 Users
C. CONSUMABLES
24. White Board Markers As required
25. Duster Cloth (2’by 2’) As required
26. Cleaning Liquid 500ml As required
27. Xerox Paper (A4) As required
28. Full Scape Paper(White) 2 reams
29. Cartridges for printer As required
30. RJ45 Jacks 200 Pcs
31. Optical Mouse(USB/PS2) As required
32. Key Board (USB/PS2) As required
33. SMPS As required
34. CMOS Batteries As required
35. 3Pin Power Chord As required
36. Cat6/5/5e cable 100 meters
37. Stapler Small 2 Pcs
38. Stapler Big 1 Pc
39. AAA battery for remote As required
40. AA battery for clock As required
41. Pen Drives 8 GB 2Nos
42. CDs 50Nos
43. DVDs 50 Nos.

25
 COMPUTER SOFTWARE APPLICATION (CITS)

44. Wall Clock 1Pc

D. FURNITURE AND ACCESSORIES
45. Hand Held Vacuum cleaner 01 No
46. Pigeon hole cabinet: 25 01 No
compartments
47. 01 each-for
Chair and table for the instructor Class room&
lab
48. Dual Desk or Chair and Tables for 25 NO
Trainees for Class Room
49. Computer table laminated top 150 X 650 X 750 mm ( or similar 14 Nos.
size) with sliding tray for key (13 for lab
board and one shelf for storage and 1 for
for the lab classroom)
50. Operators chair (mounted on castor 25 Nos.
wheels, Adjustable height) for the lab
51. Printer table 650 X 500 X 750 mm can be 03 Nos.
varied as per local
specifications
52. Split type Air conditioners As required
53. Storage cabinet 60 X 700 X 450 mm 01 Nos.
54. White Board 02 nos.
01 each-for
Class room&
lab
55. Steel Almirah 01 No.
Note:
Provision must be made for:
1. Domain name registration and its renewal from time to time for hosting and testing the
websites created by the trainees as part of the syllabus.
2. Licensed Antivirus software - Renewal or new procurement, as the situation demands, from
time to time upon expiry of validity period.

26
 COMPUTER SOFTWARE APPLICATION (CITS)

ANNEXURE – I
The DGT sincerely acknowledges contributions of the Industries, State Directorates,
Trade Experts, Domain Experts and all others who contributed in revising the curriculum.

Special acknowledgement is extended by DGT to the following expert members who

had contributed immensely in this curriculum.

Name & Designation

S No. Organization Remarks
Sh./Mr./Ms.
Mentor Council
1. Dr. Sanjeev Kumar Gupta, National Institute of Electronics and Chairman
Head, Technical Wing Information Technology,
Electronics Niketan, 6, CGO
Complex New Delhi 110 003
2. Rajeev Menon, Cognizant Technology Solutions Member
Sr. Director India Pvt. Ltd. 12th & 13th Floor,
"A" wing, Kensington Building,
Hiranandani Business Park, Powai,
Mumbai - 400 076
3. Srikantan Moorthy, Infosys Electronics City, Hosur Road Member
SVP & Head - Education & Bangalore 560 100
Research
4. Deepak Jain, WIPRO, Doddakannelli Member
Senior VP & Global Head- Sarjapur Road, Bangalore - 560 035
Work Force Planning
5. K. Ganesan, Tata Consultancy Services Member
Vice President -Human Ltd.,200FtThoraipakkam-Pallavaram
Resources Ring Road,Thoraipakkam,Chennai-
600 096,Tamil Nadu
6. Saurabh Joshi, Accenture Services Pvt. Ltd. 7th Member
G.M. floor, Tower C, building no. 8,DLF
Cybercity Phase II, Gurgaon-122002
7. Ravi Shankar B. Mind Tree Ltd, Global Village Member
RCVE Post, Mysore Road, Bangalore
59
8. Umesh Gupta, Open Software Technology(India) Member
CEO Ltd.,512,PhaseV,Udyog Vihar,
Gurgaon- 122016
9. Prof. S.C. De Sarkar Indian Institute of Technology Member
Bhubaneswar Bhubaneswar-751 013
10. Dr. Arti Kashyup, Indian Institute of Technology Mandi, Member
Associate Professor PWD Rest House, Near Bus Stand
Mandi - 175 001, Himachal Pradesh
11. Dr. B. Mahanty, Indian Institute of Technology Member
Professor Kharagpur Kharagpur ,India - 721302

27
 COMPUTER SOFTWARE APPLICATION (CITS)

12. Dr. Narayanaswamy N S, D/o Computer Science and Engg Member

Associate Professor Indian Institute of Technology
Madras, IIT P.O., Chennai -600 036
13. Prof. Ashis.k. Pani, XLRI Jameshepur, Road Number 1, Member
Professor Circuit House Area, Sonari,
Jameshepur, Jharkhand-831011
14. S.K. Pradad, National Institute of open Schooling Member
System Analyst A-24-25, Institutional Area, Sector-
62, NOIDA -201309
15. Pramod Tripathi, National Institute of open Schooling Member
Senior Executive Officer A-24-25, Institutional Area, Sector-
62, NOIDA -201309
16. Koushalya Barik, National Institute of Open Schooling, Member
AssistantDirector(Academic A-24-25, Institutioal Area, Sector-62
) NOIDA-201309
CORE GROUP
17. Naresh Chandra, JDT DGET,New Delhi Mentor
18. Dr. M. Jayprakasan, Dy.
ATI Chennai Leader
Director of Training
19. B.K. Singha, Dy. Director of
CSTRI, Kolkata Member
Training
20. N. Sundararajan, DPA Gr.B NIMI, Chennai Member
21. ValluruBabu, Dy. Director of
DGET, New Delhi Member
Training
22. A.K.V. Annapurna, Training
ATI ,Hyderabad Member
Officer
23. Sk. Altaf Hossain, Training
ATI, Howrah Member
Officer
24. B. Biswas, Vocational
RVTI, Kolkata Member
Instructor
25. Sanjay Kr. Gupta,
RVTI , Vadodara Member
Vocational Instructor
26. S.K. Acharya, Vocational
NVTI ,Noida Member
Instructor
27. P. Narmada, Vocational RVTI,
Instructor Member
Bangalore
28. Anvar Muhmed,
RVTI, Trivandrum Member
Vocational Instructor
29. P.T. Noushad, Assistant
ITI (W), Coimbatore Member
Training Officer,
30. Kunal Shanti Priya, ITI, Daltonganj, Redma, Daltonganj -
Vocational Instructor Member
822101

28
 COMPUTER SOFTWARE APPLICATION (CITS)

29