SYLLABUS

Syllabus for the Trade of “COMPUTER OPERATOR AND PROGRAMMING ASSISTANT”under Craftsmen Training Scheme.

First Semester: Code no. COPA – 01

Duration:6 months ( 26 weeks)

	Week No.		Trade Practical	Trade Theory
				Introduction to Computers and
		Computer components and Windows		Windows Operating System
				 History,Generations, Types,
		Operating System
				Advantages and Applications of
			Disassembling,Identification of
				Computers.
			components and Reassembling a
				 Concepts of Hardware and
			Desktop computer.
				Software. Computer Hardware
			Familiarization with Windows O.S
				basics.
			desktop, using icons,buttons and
	1-2			 Introduction to various processors.
			customizing the desktop.
				 Introduction to the functions of an
			Managing files and folders, using
				Operating System, Popular
			removable drives.
				Operating Systems in Use.
			Viewing system properties and
				 Main features of Windows O.S
			control panel details.Viewing and
				 Various Input/ Output devices in
			setting environmental variables.
				use and their features.
			Working with MS Paint.
				 Using Scanner, Printer and
				Webcam.
		Computer Hardware basics and Software
		Installation		Computer Hardware basics and
			Viewing the BIOS and changing the	Software Installation
			Boot order.	 Introduction to the booting
			Identify and rectify common	process, BIOS settings and their
	3		hardware and software issues.	modification.
			Formatting the hard disk and loading	 Introduction to various types of
			O.S and necessary application	memories and their features.
			software.	 Basic Hardware and software
			Installation of DVD, using different	issues and their solutions.
			types of hard disks.	 Formatting and Loading O.S and
			Bluetooth Configuration, DVD writing	Application software and Antivirus.
			techniques.
			4

		Familiarization with DOS CLI & Linux		Introduction to DOS Command Line
				Interface & Linux Operating System.
		Operating Systems.
				 Introduction to basic DOS Internal
			Using basic DOS commands for
					and External Commands.
			directory listing, file and folder
				 Introduction to Open Source
			management etc.
					Software.
	4-5		Using Basic Linux commands for
				 Introduction to Linux Operating
			directory listing, file and folder
					System features, structure, files
			management, password etc.
					and processes.
			Using the Linux graphical user
				 Introduction to various Linux
			interface for file and folder
					Shells.
			management, exploring the system
					Basic Linux commands.
			etc.
		Using Word Processing Software		Word Processing
			Familiarization with the Word
				 Introduction to the various
			window components.
					applications in office.
			Creating, saving and
				 Introduction to Word features,
			editingdocuments using Word.
					Office button, toolbars.
			Inserting and formatting tables and
				 Creating, saving and formatting
			other objects.
	6-8				and printing documentsusing
			Using templates,autocorrect tools,
					Word.
			macrosand the mail merge tool.
				 Working with inserting objects,
			Working with Page layout settings
					macro, mail merge, templates and
			and printing documents.
					other tools in Word.
			Typing practice using open source
				 Page setup and Printing
			typing tutor tools.
					Documents using word.
			Practice of using shortcut keys.
				Spread Sheet Application
		Using Spread Sheet Application
				 Introduction to Excel features and
			Creating, Saving and Formatting		Data Types.
			Excel Spreadsheets.		Cell referencing. Use of functions
			Using Absolute and Relative		of various categories, linking
	9-11		referencing, linking sheets,		Sheets.
			Conditional formatting etc.		Introduction to various functions
			Using Excel functions of all major		in all categories of Excel.
			categories.		Concepts of Sorting, Filtering and
			Using various data types in Excel,		Validating Data.
			Sorting, filtering and validating		Analyzing data using charts, data
			data.		tables, pivot tables, goal seek and
			5

	 Creating and formatting charts.			scenarios.
		Importing &Exporting Excel Data.		Introduction to Reporting.
	 Performing data analysis using
		“what if” tools.
	 Modifying Excel Page setup and
		printing.
	 Simple projects using Excel &
		Word.
	Image editing, Creating presentations &
	Using Open Office
		Use of windows and open source	Image editing, Creating presentations
			& Using Open Office
		image editing software like Open
		Office Draw, GIMP, Irfan View or a	 Introduction to Open Office.
		similar tool.
			 Introduction to the properties and
		Creating Slide shows, Inserting
12				editing of images.
		objects.
			 Introduction to Power Point and its
		Animating Slide transitions and
				advantages.
		Objects.
				Creating Slide Shows.
		Creating a simple presentation
			 Fine tuning the presentation and
		project using Open Office.
				good presentation techniques.
	 Working with Open Office for word
		processing and spreadsheet
		application.
			Database Management Systems
	Database Management			Concepts of Data, Information and
	 Creating database and designing a			Databases. Overview of popular
		simple tables in Access.		databases, RDBMS, OODB and
		Enforcing Integrity Constraints		NOSQL.
		and modifying the properties of		Rules for designing good tables.
		tables and fields.		Integrity rules and constraints in a
13-15		Creating Relationships and joining		table.
		tables.		Relationships in tables.
		Creating Forms.		Introduction to various types of
	 Creating simple select queries			Queries and their uses.
		with various criteria and		Designing Access Reports and
		calculations.		Forms.
		Creating Simple update, append,		Introduction to macros, designer
		make table, delete and crosstab		objects controls, their properties
		6

queries.

and behavior.

Modifying form design with controls, macros and events.

Importing and exporting data to and from Access.

Compressing and Encrypting databases.

			Networking Concepts
				Introduction to Computer
	Configuring and Using Networks			Networks, Necessity and
				Advantages.
		Viewing Network connections.
			 Client Server and peer to Peer
		Connecting a computer to a
				networking concepts.
		network and sharing of Devices,
			 Concept of Proxy Server and proxy
		files and Folders.
				firewall server.
		Familiarization with various
				Network topologies. Introduction
		Network devices, Connectors and
				to LAN, WAN and MAN.
		Cables.
				Network components, viz.
		IP Addressing and Subnetfor IPV4 /
				Modem, Hub, Switch, Router,
16-17		IPV6,Masking, pinging to test
				Bridge, Gateway etc.
		networks.
				Network Cables,Wireless networks
		Configuring Hub and Switch.
				and Blue Tooth technology.
	 Setting up and configuring LAN in a
			 Concept of ISO - OSI 7 Layer
		Computer Lab as peer to peer
				Model.
		network.
			 Overview of various Network
		Setting up a proxy server/ DHCP
				protocols Viz. TCP/IP, FTP, Telnet
		Server with firewall.
				etc.
	 Setting up video conferencing.
			 Logical and Physical Addresses,
		Using various tools for computer
				Classes of Networks.
		maintenance, Network security.
				Network Security &firewall
				concepts.
			 Concept of DHCP Server.
	Internet Concepts		Internet Concepts
	 Browsing the Internet for information.			Introduction to WWW, Concept of
	 Creating and using e – mail for			Internet, Web Browsers, internet
18	communication.			servers and search engines.
	 Communication using text, video			Concepts of Domain naming
	chatting and social networking sites.			Systems and E mail
	 Identifying various threats to the			communication.
	system connected to the net.			Introduction to video chatting
		7

	 Protecting the computer against	tools, VOIP and Social Networking
	various internet threats.	concepts.
	 Configure Outlook, mail service in	 Concept of Cloud storage and
	mobile phones. Using tools like Skype,	Open Web Server.
	Google+ etc.	 Introduction to Internet Security,
		Threats and attacks, Malicious
		Software types, Internet security
		products and their advantages.
	Designing Static Web Pages	Web Design Concepts
	 Designing simple web pages with	 Concepts of Static and Dynamic
	text, pictures, tables,lists,	Web pages.
	hyperlinks, frames, marquees etc.	 Introduction to HTML and various
	using HTML tags.	tags in HTML.
	 Designing Web Pages with Forms	 Creating Forms with controls using
19-21	and Form Controls using HTML	HTML.
	tags.	 Concepts of CSS and applying CSS
	 Creating Web Pages using CSS.	to HTML
	 Using WYSIWYG web design tools	 Introduction to open source CMS
	to design and edit web pages with	viz,. Joomla, Wordpress etc. and
	various styles.	Web authoring tools viz.
		Kompozer,FrontPageetc.
22-23	Project Work
24-25	Examinations
26	Admissions for the next session

8

SecondSemester : Code no. COPA – 02

Duration:6 months ( 26 weeks)

Week		Trade Practical		Trade Theory
No.
	Java Script		Java Script
		Familiarization with JavaScript		Algorithms and flowcharts.
		elements.	 Introduction to Web Servers and their
	 Embedding JavaScript in HTML to			features.
		display information in web pages.	 Introduction to Programming and
		Documentation and Formatting.		Scripting Languages.
	 Using JavaScript Variables, Data		 Introduction to JavaScript and its
		types, Constantsand Operators.		application for the web.
	 Working with Arrays, Control		 JavaScript Basics – Data types,
		statements and Loops in		Variables, Constants.Conversion
		JavaScript.		between data types.
	 Writing functions in JavaScript.			The Arithmetic,Comparison, Logical
1-7		Working with String, Math and		and String Operators in JavaScript.
		Date functions in JavaScript.		Operator precedence.
	 Switch, Loops, Breaks and Errors.		 Arrays in JavaScript – concepts, types
	 Using Java Script Objects.			and usage.
	 Working with JavaScript Libraries.		 Program Control Statements and loops
	 Using simple Open source web			in JavaScript.
		server (like XAMPP) and FTP	 Introduction to Functions in JavaScript.
		software (For ex. Filezilla).	 Built in JavaScript functions overview.
	 A simple project using 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.
	Programming with VBA		Introduction to VBA, Features and
	 Familiarization with the VBA		Applications.
		Editor.	 Introduction to VBA features and
8– 15		Writing simple programs involving		applications.
		VBA Data types,Variables,	 VBA Data types,Variables and
		Operators andConstants.		Constants.
	 Working with string variables in		 Operators in VBA and operator
		9

		VBA.		precedence.
	 Creating and Manipulating Arrays		 Mathematical Expressions in VBA.
		in VBA.	 Introduction to Strings in VBA.
		Writing programs involving	 Introduction to Arrays in VBA.
		Mathematical,Conversion, Date	 Conditional processing in VBA, using
		andString Functions in VBA.		the IF, Elseif, Select… Case
		Working with conditional		Statements.
		statements like If. Elseif, Select …	 Loops in VBA Introduction to VBA.
		Case statements in VBA.	 VBA message boxes and input boxes.
	 Writing programs in involving		 Introduction to Creating functions and
		Loops.		Procedures in VBA.
	 Creating Message boxes and Input		 Using the built in functions.
		boxes in VBA.	 Creating and editing macros.
		Creating Functions and	 Introduction to Object Oriented
		Procedures. Passing Parameters		Programming Concepts. Concepts of
		and Using Returned Data.		Classes, Objects, Properties and
	 Using VBA built in functions in			Methods.
		programs.	 Events and Event driven programming
	 Creating and editing macros.			concepts.
	 Writing code to work with Excel		 The user forms and control in Excel
		VBA forms and form controls like		VBA.
		buttons, Checkboxes, Labels,		Properties,events and methods
		ComboBox, GroupBox, ListBox,		associated with the Button, Check
		Option Button, Scroll Bar and Spin		Box, Label, ComboBox, Group Box,
		button. Modification of object		Option Button, List Box, Scroll Bar and
		properties.		Spin button controls.
		Using ActiveX controls.	 Overview of ActiveX Data objects.
	 Programming with methods and			Debugging Techniques.
		events.
		Debugging, Stepping Through
		Code, Breakpoints, Finding and
		Fixing Errors.
	 A simple project involving MS
		excel and VBA.
	Using Accounting Software		Smart Accounting
		Basic accounting practice.	 Basics of Accounting, Golden Rules of
16-19	 Familiarization with the Tally			Accounting, Voucher Entry, Ledger
		interface.		Posting, Final Accounts Preparation.
		Company creation,Account	 Cash Book. Ratio Analysis,
		Creation, Voucher Entry in Tally.		Depreciation, Stock Management.
		Report Generation (Creating	 Analysis of VAT,Cash Flow, Fund
		10

		statements like Invoice, Bill, Profit		FlowAccounting.
		& Loss account etc.).	 Introduction to Tally, features and
	 Performing Cost Centre & Cost			Advantages.
		Category management.	 Implementing accounts in Tally.
		Managing Budgeting Systems.	 Double entry system of bookkeeping.
		Scenario management and		Budgeting Systems, Scenario
		Variance Analysis.		management and Variance Analysis.
	 Using Tally for Costing, Ratio		 Costing Systems, Concepts of Ratios,
		Analysis,Cash Flow, Funds Flow		Analysis of financial
		Statements.		statements,Inventory Basics, POS
		Analyzing and Managing		Invoicing, TDS, TCS, FBT, VAT &
		Inventory.		Service Tax Processing in Tally.
	 Performing Point of Sales and		 Tally Interface in Different Languages.
		Taxation. Performing Systems
		Administration and using other
		Utilities, User creation, Backup
		&Restore of Company.
		Using the Multilingual
		Functionality
	E Commerce		E Commerce
	 Familiarization with latest E		 Definition of E commerce, Types,
		commerce websites viz. E bay,		scope and benefits of E commerce.
		Amazon, FlipKart, OLX, Quikr	 Difference between E commerce
		etc. and comparative study of		and traditional commerce.
		the main features of these		Capabilities requirements and
		sites.		Technology issues for E commerce.
20		Using E Commerce Simulator	 Types of E commerce web sites.
		Software for Marketplace	 Building business on the net.
		Business Simulation.	 Concepts of on line Catalogues,
	 Identifying and solving security			Shopping carts, Checkout pages.
		issues inE- commerce and	 Payment and Order Processing,
		payment operations.		Authorization, Chargeback and
				other payment methods.
			 Security issues and payment
				gateways.
	Typing practice
			Cyber Security:
21		Typing Practice in Regional
		Language	 Overview of Information Security,
				Security threats, information Security
		11

		vulnerability and Risk management
		 Introduction to Directory Services,
		Access Control, Software
		Development Security, Privacy
		protection, Audit and Security.
		 Introduction to I.T Act and penalties
		for cybercrimes.
22-23	Project Work
24-25	Examinations
26	Admissions for CITS

Note: Syllabus for the subject of Employability Skills is common for all the trades