INDUSTRIAL TRAINING INSTITUTE,
SPLIT-UP OF SYALLABUS(SEM-1)
TRADE:-COPA
Week Practical
Name of practical
No.
No.
Computer components and Windows
Operating System
Disassembling,Identification of
components and Reassembling a
Desktop computer.
starting & closing Windows application
Familiarization with Windows
O.S.desktop, using icons,buttons and
customizing the desktop.
Managing files and folders, using
removable drives
Viewing system properties and control
panel details.Viewing and setting
environmental variables.
Working with MS Paint.
Computer Hardware basics and
Software Installation Viewing the
BIOS and changing the Boot
order.Formatting the hard disk and
loading O.S and necessary application
software.
1
2
INSTRUCTOR'S NAME:Lesson
No.
Installation of DVD, using different types
of hard disks.Bluetooth Configuration,
DVD write techniques.
Familiarization with DOS CLI & Linux
Operating Systems.Using basic DOS
commands for directory listing, file and
folder management etc.
10
11
12
13
14
10
Using Basic Linux commands for
directory listing, file and folder
management, password etc.
15
11
Using the Linux graphical user interface
for file and folder management,
exploring the system etc.
16
12
Using Word Processing Software
Familiarization with the Word window
components.
17
6
13
14
7
20
16
Using the mail merge tool.
Document enhancement.Working with
Page layout settings
printing documents.
Typing practice using open source typing
tutor tools.Practice of using shortcut
keys.
21
18
22
23
20
Using Spread Sheet Application
Creating, Saving Excel Spreadsheets.
24
21
Formatting Excel Spreadsheets.
25
22
Using Absolute and Relative referencing,
linking sheets,Conditional formatting etc.
23
Using Excel functions of all major
categories.
24
Using various data types in
Excel,Sorting, filtering and validating
data.
25
Creating and formatting charts.
26
Performing data analysis using what if
tools.
11
19
Using templates,autocorrect tools
19
10
18
15
17
8
Creating, saving and editing documents
using Word.
Inserting and formatting tables and other
objects.
27
Modifying Excel Page setup and printing.
26
27
28
28
Image editing, Creating presentations
& Using Open Office Use of windows and
open source image editing software .
29
29
Creating Slide shows, Inserting
objects.Creating a simple presentation
project using Open Office.
30
30
Working with Open Office
31
12
31
13
14
32
32
Creating Relationships and joining tables.
33
33
Creating Forms.
Creating simple select queries with various
criteria and calculations.
34
35
Modifying form design with
controls, macros and events.
36
36
Importing and exporting data to
and from Access. Compressing and
Encrypting databases.
37
37
Viewing Network connections. Connecting a
computer to a network and sharing of
Devices,files and Folders.
34
15
16
17
Database Management Creating database
and designing a simple tables in
Access.modifying the properties of
tables and fields.
35
38
39
38
Familiarization with various Network devices,
Connectors and Cables.
40
39
Setting up and configuring LAN in a
Computer Lab as peer to peernetwork.
Setting up a proxy server/ DHCP Server with
firewall.
41
40
Setting up video conferencing.
41
Using various tools for computer
maintenance, Network security.
42
18
42
Browsing the Internet for
information.Creating and using e mail for
communication.
43
Communication using text, video chatting
and social networking sites.
43
44
44
45
19
Configure Outlook, mail service in mobile
phones. Using tools like Skype Google+ etc.
Designing simple web pages withtext,
pictures, tables,lists,hyperlinks, frames,
marquees etc.using HTML tags.
45
46
Designing Web Pages with Forms and Form
Controls using HTML tags.
20
47
Creating Web Pages using CSS.
46
21
48
Using WYSIWYG web design tools
to design and edit web pages with
various styles.
47
G INSTITUTE,
BUS(SEM-1)
NSTRUCTOR'S NAME:-Jyoti
Name of lesson
History of computer
Importance of computer
Generations of computer
Types of computer
Concepts of Hardware and Software.
Computer Hardware basics.
Various Input devices in
use and their features.
Various Output devices in
use and their features.
Introduction to the functions of an
Operating System, Popular Operating
Systems in Use.
Introduction to the booting process,
BIOS settings and their modification.
Introduction to various types of
memories and their features.
Basic Hardware and software issues and
their solutions.
Formatting and Loading O.S and
Application software and Antivirus.
Introduction to DOS Command Line
Interface & Linux Operating
System.Introduction to basic DOS
Internal and External Commands.
Introduction to Linux Operating System
features, structure, files and processes.
Introduction to various Linux
Shells.Basic Linux commands.
Word Processing Introduction to the
various applications in office.
Introduction to Word features,Office
button, toolbars.
Creating, saving and formatting and
printing documents using Word.
Working with inserting objects macro,
templates and other tools in Word.
mail merge
Page setup and Printing Documents
using word.
Introduction to Excel features and Data
Types.
Cell referencing. Use of functions of
various categories, linking Sheets.
Introduction to various functions in all
categories of Excel.
Concepts of Sorting, Filtering and
Validating Data.
Analyzing data using charts, data
tables, pivot tables, goalseekingand
scenarios.
Introduction to Open Office.Introduction to
the properties and editing of images.
Introduction to Power Point and its
advantages.Creating Slide Shows.
Fine tuning the presentation and
good presentation techniques.
Database Management Systems
Concepts of Data, Information and
Databases. Overview of popular
databases, RDBMS, OODB and NOSQL.
Rules for designing good tables.
Integrity rules and constraints in a
table.
Relationships in tables.
Introduction to various types of
Queries and their uses.
Designing Access Reports and
Forms.
Introduction to macros, designer
objects controls, their properties
and behavior.
Networking Concepts Introduction to
Computer Networks, Necessity and
Advantages.
Client Server and peer to Peer networking
concepts.Concept of Proxy Server and proxy
firewall server.
Network topologies. Introduction
to LAN, WAN and MAN.
Network components, viz.Modem, Hub,
Switch, Router,Bridge, Gateway etc.Network
Cables,Wireless networks
and Blue Tooth technology.
Overview of various Network
protocols Viz. TCP/IP, FTP, Telnet
etc.Network Security &firewall
concepts.
Internet Concepts
Introduction to WWW, Concept of
Internet, Web Browsers, internet
servers and search engines.
Introduction to video chatting
tools, VOIP and Social Networking
concepts.Open Web ServerConcept of Cloud
storage and Open Web Server.
Web Design Concepts Concepts of Static
and Dynamic Web pages.
Introduction to HTML and various tags in
HTML.Creating Forms with controls using
HTML.
Concepts of CSS and applying CSS to HTML.
Introduction to open source CMS and Web
authoring tools
