CEDMAP

‘COMPUTER AWARENESS PROGRAM’

UNDER SGSY

COURSE SYLLABUS

The scheduled course for the training program would be as approved in

the project by the Ministry of Rural Development. The four course that
would be conducted are detailed as below:

• Data Entry cum Office Automation

• DTP with Screen Printing

• Financial Accounting with Database

Management

• Hardware and Networking

The course description along with the UNITARY [MONTH & WEEK
WISE] COURSE SYLLABUS are given as under.

The course is divided into 6 months out of which the First month would
be for Basic English Language and the month 6th would be for
Personality development & Communication Skills.
Data Entry cum Office Automation
• The course comprises of basics of computers along with the MS-
Office and Internet. The course aims are preparing the students
for the post Office Assistant and Data entry operator.

- [MONTH-1]

WEEK-1 -Basics of English Language

Noun, Definition, meaning and use
Pronoun, Definition, meaning and use
Verb Definition, meaning and use
Adjective, Definition meaning and use
Important words for daily use
WEEK-2 - Gender, Tense (Past, Present & Future)
Use of Gender, Defining Gender
Use of Male and Female Gender
Tense – Past, Present & Future
Making short Sentences
WEEK-3- English Communication
Written Communication – Writing words and small paragraphs in English
Written application and short letters
Formatting personal and official letters
Rules and practices in English Written language
WEEK-4- Public Speaking
Extempore in English language – simple topics
Self Introduction – Debates etc
Group Discussion
Discussions on Current Topics
- [MONTH – 2]

WEEK-1 - Basic Computer Operations: MS Windows

1. Features of MS Windows.
2. Familiarizing with Desktop, Icons, Start menu,
Task-bar, etc.
3. Shutting-down Windows
4. Introduction to Active Desktop & Working with
it.
5. Concept of Program groups, Program Items,
Files and Folders.
WEEK-2 -
6. Basic operations such as Opening, closing,
maximizing, minimizing, etc. on a Program
Window.
7. Introduction and familiarization with
Accessories like Calculator, Notepad, Word pad.
8. Windows explorer/My Computer- Simple uses
for disk, folder and file management.
WEEK-3 -
9. Control Panel: Frequently used facilities:
Display, date/time, mouse, modem.

Documentation and Data Management

WEEK-4 -
MS-Word
1. Word processing concept and advantages.
2. Features of MS-Word.
3. Creating a new document & entering text.
4. Basic formatting techniques.
5. Tips and shortcuts, saving a file.
- [MONTH-3]
WEEK-1 -
6. Editing Sessions: Cut-and-paste, Finding and
replacing text.
7. Printing a document.
8. File management tools (Work efficiently with files
and folders)
WEEK-2 -
9. Spelling and grammar checkers.
10. Mail merge, Import/Export.

Data Management and Tabulation

WEEK-3 -
MS- Excel
1. Introduction to electronic spreadsheet.
2. Features of MS-Excel.
3. Creating worksheets, Entering data/ text in
cells.
4. Formatting cells and sheet.
5. Navigation with in worksheet.
5. Editing sheets: Copy, Cut, Paste, Find,
Replace, Save and Open
WEEK-4 -
6. Changing row height, column width.
7. Inserting/deleting rows and columns in a
worksheet.
 8. Simple formula to perform calculation on your
data.
9. Print options to set a print area. Previews &
Printing
10. Graphs – Creation & Modification.
11. Introduce Excel’s built-in functions for specialized
calculations.

– [MONTH – 4]

WEEK-1 -
Presentations
Power-Point
1. Introduction to Power Point.
2. Creating slides.
3. Arranging slides to form presentations.
4. Editing slides, formatting text/objects.
WEEK-2 -
5. Running a slide show.
6. Adding effects to text/object element on slides
– animating text.
7. Adding background, colors and graphics.
8. Manipulating slide backgrounds and color
schemes.
9. Using auto content wizard.

WEEK-3 -
Database Management
MS- Access
1. Introduction to MS-Access.
2. Overview of databases and databases design.
 3. Creating a table and adding data to it.
4. Column width & various data types
5. Accessing the databases (retrieval).

WEEK-4 -
6. Editing/Modifications in the tables.
7. Using Search in table.
8. Create search based on logical compression
and wild cards.
9. Use the report wizards to create various
reports.
[MONTH – 5]

WEEK-1 -
Enhancing Communications – E-mail & Internet –
Introduction to Internet Technology.
1. Concept of Websites and WebPages.
2. Site Nomenclature.
3. Use my connection for dialing.
WEEK-2 -
4. Using a popular Browser to surf the net.
5. Creating your personal E-mail account.
6. Sending & Receiving E-mails.
WEEK-3 -
7. Attaching a file.
8. Using the Address book.
9. Chat on Internet:
a. How to open chat option.
b. Create room, Change room.
WEEK-4 -
** FIELD VISITS, COURSE REVISION & PROBLEM
SOLVING
- [MONTH – 6]
PERSONALITY DEVELOPMENT & COMMUNICATION
SKILLS

WEEK-1 -
 About importance of Communication – A
fundamental necessity
 Types of Communications
 Assertive Communication
 Interpersonal Communication (Handling
Queries and Aggressive Customers)
 Barriers of Communications
 Stage freight and Public speaking

WEEK-2 –
• Learning Presentation Skills
• Acquiring Confidence
• Body Language
• Preparing presentations and Audio Visual Aids
(Presentation Skills)
• Dress up and Personal Hygiene
• Influencing Skills
• Handling and Influencing Customers
• Identifying personal strengths and skill set
• Acquiring New Skills and Personality Aspects
• Important personality traits and their
development

WEEK-3 -
• Business and Office Etiquettes
 • Understanding General Human Nature and
Psychology
• Understanding human Behavior (Male, Female,
Coworkers, Boss etc.)
• Group Psychology and Team Work

WEEK-4 -
• Methodology for Personality Development
• Group discussions
• Role plays
• Simulation
• Case studies
• One to one and one to many interaction
 • DTP WITH SCREEN PRINTING
o The course comprises of the basics of computers
along with the Desk Top Publishing and screen printing.
The course prepares the students for DTP operators and
designers.

[MONTH-1]
WEEK-1 -
Basic English Language
Noun, Definition, meaning and use
Pronoun, Definition, meaning and use
Verb Definition, meaning and use
Adjective, Definition meaning and use
Important words for daily use
WEEK-2 -
Gender, Tense (Past, Present & Future)
Use of Gender, Defining Gender
Use of Male and Female Gender
Tense – Past, Present & Future
Making short Sentences
WEEK-3 -
English Communication
Written Communication – Writing words and small paragraphs in English
Written application and short letters
Formatting personal and official letters
Rules and practices in English Written language
WEEK-4 -
Public Speaking
Extempore in English language – simple topics
Self Introduction – Debates etc
Group Discussion
Discussions on Current Topics
- [MONTH-2]

WEEK-1 -
COMPUTER BASICS

Fundamentals of Computers

• Definition & Classification of Computers

• Central Processing Unit (CPU)
• Peripherals
• Input & Output Units
• Understanding Disks
• Block Diagram

WEEK-2 -
Introduction to Operating System

• MS Windows

Features of MS Windows.
• Familiarizing with Desktop, Icons, Start
menu, Task-bar, etc.
• Shutting-down Windows.
• Introduction to active Desktop &
Working with it.
• Concept of Program Groups, Program
Items, Files and Folders.
• Basic Operations such as Opening,
Closing, Maximizing, Minimizing etc. on a
Program Window.
• Introduction and familiarization with
Accessories like Calculator, System Tools, Note
Pad, Word Pad, Paintbrush, Entertainment etc.
 • Windows explorer: Simple uses for disk,
folder and file management.
• Control Panel: Some of basic and
frequently used facilities, Display, Date/Time,
Keyboard, Mouse, Modems, Regional Setting,
Sounds.
• Working with My-Computer.

INTERNET & EMAIL

WEEK-3 -
• Introduction to Internet Technology.
• Introduction to Internet Explorer.
• Concept of Websites and WebPages.
• Use my connection for dialing.
• Log on to Internet.
• Browsing/Surfing with the help of
Internet- Explorer(File, Edit, View, Go
Favorites, Toolbar)
• Closing Internet Explorer.
• Learning to use E-mailing.

WEEK-4 -
• Read/Send mails through send & receive
options.
• Working with Boxes (Inbox, Outbox,
Sent box).
• Composing/Attaching a file.
• Using the Address book.
• Import/Export-message/address.
• Internet options.
• Working online.
• Open free E-mail IDs.
• Using search engine to find sites.
• Closing your Dial-up networking
connection.
- [MONTH-3]

WEEK-1 -

PAGEMAKER
Knowing PageMaker

• Getting Started
• Hardware Requirements
• Installing the software
• Components of the PageMaker window

Working with File

• Creating a new document

• New document window
• Knowing the Tool Box options.
• Entering text
• Using the formatting type
• Using preferences
• Saving the file

WEEK-2 -
Editing & Formatting Text

• Using cut and paste

• Using multiple paste
• Applying different settings to the font
• Using the Paragraph Alignment & Style
options
• Defining the Styles.
• Inserting objects
 • Creating TOC
• Using Ruler

WEEK-3 -
Using Layout & Element

• Working with guidelines & Column

Guides
• Inserting and Removing pages
• Wrapping Text
• Using the Fill & Stroke options.
• Working with Frames.
• Creating line and Objects
• Designing a Page Layout
• Creating a Publication

WEEK-4 -
Advanced Techniques of PageMaker

• Adding design elements

• Changing PageMaker option
• Working with Graphics in PageMaker
• Creating of templates
• Creating a newsletter template
• Creating templates from Existing
documents
• Defining custom styles
• Working with Tables
• Working with layers
• Working with colors
• Working with Photoshop filters
- [MONTH-4]

COREL DRAW

WEEK-1 - Introduction to Corel draw

• Requirement, Version, Environment
• Need & uses
• Installation procedure
WEEK-2 - Knowing & Working with the Tools
• The standard Tool bar
• The Tool box
• The Menus
• Working with Dockers & Roll- ups
• Text handling
• Desktop publishing
WEEK-3 - Working with the Objects
• Creating objects
• Importing objects
• Turning Multiple objects to one
• Using fills and outlines
• Other features
WEEK-4 - Working with Drawings
• Creating your own drawing
• Drawing curves lines
• Working with Images
• Lines & outlines
• Using fills
• Using layers
- [MONTH-5]

PHOTOSHOP
WEEK-1 -
• Getting an image into Photoshop
• Using Layers, Channel & Paths
• Working with History States & Actions
• Designing & Saving Images for Web
• Knowing the features
WEEK-2 -
• Working with the Editing Tools
• Working with Layers, channels & Paths
• Manipulating the Images
• Using the History States & Actions
• Designing Images for the web
WEEK-3 -
SCREEN PRINTING, SOUND FORGE &
FLASH
• BASIC’S OF SCREEN PRINTING
• FIELD VISIT FOR LIVE DEMO OF
SCREEN PRINTING
• Sound Forge and Flash [Introduction]
WEEK-4 -
** FIELD VISITS, COURSE REVISION & PROBLEM
SOLVING
- [MONTH-6]

PERSONALITY DEVELOPMENT & COMMUNICATION

SKILLS

WEEK-1 -
 About importance of Communication – A
fundamental necessity
 Types of Communications
 Assertive Communication
 Interpersonal Communication (Handling
Queries and Aggressive Customers)
 Barriers of Communications
 Stage freight and Public speaking

WEEK-2 -
• Learning Presentation Skills
• Acquiring Confidence
• Body Language
• Preparing presentations and Audio Visual Aids
(Presentation Skills)
• Dress up and Personal Hygiene

WEEK-3 -
• Influencing Skills
• Handling and Influencing Customers
• Identifying personal strengths and skill set
• Acquiring New Skills and Personality Aspects
• Important personality traits and their
development
• Business and Office Etiquettes
 • Understanding General Human Nature and
Psychology
• Understanding human Behavior (Male, Female,
Coworkers, Boss etc.)
• Group Psychology and Team Work

WEEK-4 -
• Methodology for Personality Development
• Group discussions
• Role plays
• Simulation
• Case studies
• FINANCIAL ACCOUNTING WITH DATABASE
MANAGEMENT
o This course prepares the students for working in the
Computer accounting field. The students are trained for the
basics and then are taught the details of accounting through
computers. The course prepares students for Accounts
assistants.
- [MONTH-1]

WEEK-1 - Basics of English Language

Noun, Definition, meaning and use
Pronoun, Definition, meaning and use
Verb Definition, meaning and use
Adjective, Definition meaning and use
Important words for daily use
WEEK-2 - Gender, Tense (Past, Present & Future)
Use of Gender, Defining Gender
Use of Male and Female Gender
Tense – Past, Present & Future
Making short Sentences
WEEK-3 - English Communication
Written Communication – Writing words and small paragraphs in English
Written application and short letters
Formatting personal and official letters
Rules and practices in English Written language
WEEK-4 - Public Speaking
Extempore in English language – simple topics
Self Introduction – Debates etc
Group Discussion
Discussions on Current Topics

- [MONTH – 2]

WEEK-1 -

COMPUTER BASICS
Fundamentals of Computers

• Definition & Classification of Computers

• Central Processing Unit (CPU)
• Peripherals
• Input & Output Units
 • Understanding Disks
• Block Diagram

Introduction to Operating System

MS Windows
Features of MS Windows.
• Familiarizing with Desktop, Icons, Start
menu, Task-bar, etc.
• Shutting-down Windows.

WEEK-2 -
• Introduction to active Desktop &
Working with it.
• Concept of Program Groups, Program
Items, Files and Folders.
• Basic Operations such as Opening,
Closing, Maximizing, Minimizing etc. on a
Program Window.
• Introduction and familiarization with
Accessories like Calculator, System Tools, Note
Pad, Word Pad, Paintbrush, Entertainment etc.

WEEK-3 -

• Control Panel: Some of basic and

frequently used facilities, Display, Date/Time,
Keyboard, Mouse, Modems, Regional Setting,
Sounds.
• Working with My-Computer.
 INTERNET & EMAIL

• Introduction to Internet Technology.

• Introduction to Internet Explorer.
• Concept of Websites and WebPages.
• Use my connection for dialing.
• Log on to Internet.
• Browsing/Surfing with the help of
Internet- Explorer(File, Edit, View, Go
Favorites, Toolbar)
• Closing Internet Explorer.

WEEK-4 -
• Learning to use E-mailing.
• Read/Send mails through send & receive
options.
• Working with Boxes (Inbox, Outbox,
Sent box).
• Composing/Attaching a file.
• Using the Address book.
• Import/Export-message/address.
• Internet options.
• Working online.
• Open free E-mail IDs.
• Using search engine to find sites.
• Closing your Dial-up networking
connection.

- [MONTH – 3]
 FINANCIAL ACCOUNTING IN TALLY

WEEK-1 –

Introduction

• Getting Started
• The Tally Screen
• Creating the first company

WEEK-2 -
Working with Masters

• Creating under various head as below:

• Account Master
• Group Company
• Ledger

WEEK-3 -
• Inventory Master
• Stock Group
• Multiple Stock Group

WEEK-4 -
Working with Vouchers

• Types
• Entering Vouchers
• Printing Vouchers
- [MONTH-4]
FINANCIAL ACCOUNTING IN TALLY

WEEK-1 -
Final Accounts
• Creating Trading A/c
• P & L A/c
• Balance Sheet

WEEK-2 -
Working with Reports

• Generating different reports

• Printing of Reports

WEEK-3 -
Security Measures in Tally
• Access rights
• Creating Logins

WEEK-4 –
Tally Revision and Practical Application
- [MONTH – 5]
WEEK-1 -
MS – ACCESS
The MS - Access Database

• Creation
• Knowing the different aspects of
database
Working with Table

• Creation
• Creating Multiple tables
• Setting the field properties
• Entering Records
WEEK-2 -

• Modifing the records

• Exporting data to Excel

MS – EXCEL & REVISION

• Introduction to electronic spreadsheet.
• Features of MS-Excel.
• Creating worksheets, Entering data/ text
in cells.
WEEK-3 -
• Formatting cells and sheet.
• Navigation with in worksheet.
• Editing sheets: Copy, Cut, Paste, Find,
Replace, Save and Open
• Changing row height, column width.
• Inserting/Deleting rows and columns in
a worksheet.
WEEK-4 -
• Simple formula to perform calculation on
your data.
• Print options to set a print area.
• Previews & Printing
• Graphs – Creation & Modification.

- [MONTH-6]

PERSONALITY DEVELOPMENT & COMMUNICATION

SKILLS

WEEK-1 -
 About importance of Communication – A
fundamental necessity
 Types of Communications
 Assertive Communication
 Interpersonal Communication (Handling
Queries and Aggressive Customers)
 Barriers of Communications
 Stage freight and Public speaking

WEEK-2 -
• Learning Presentation Skills
• Acquiring Confidence
• Body Language
• Preparing presentations and Audio Visual Aids
(Presentation Skills)
• Dress up and Personal Hygiene

WEEK-3 -
• Influencing Skills
 • Handling and Influencing Customers
• Identifying personal strengths and skill set
• Acquiring New Skills and Personality Aspects
• Important personality traits and their
development
• Business and Office Etiquettes
• Understanding General Human Nature and
Psychology
• Understanding human Behavior (Male, Female,
Coworkers, Boss etc.)
• Group Psychology and Team Work

WEEK-4 -
• Methodology for Personality Development
• Group discussions
• Role plays
• Simulation
• Case studies
 • HARDWARE AND NETWORKING
o The course of Hardware and Networking is designed for the
trainees to gain the maximum mileage out of the boom in
the Job segment in the Hardware and Networking segment.
The course would prepare the students as Assistant
Hardware and Networking Professionals.

- [MONTH-1]

WEEK-1 - Basics of English Language

Noun, Definition, meaning and use
Pronoun, Definition, meaning and use
Verb Definition, meaning and use
Adjective, Definition meaning and use
Important words for daily use
WEEK-2 - Gender, Tense (Past, Present & Future)
Use of Gender, Defining Gender
Use of Male and Female Gender
Tense – Past, Present & Future
Making short Sentences
WEEK-3 - English Communication
Written Communication – Writing words and small paragraphs in English
Written application and short letters
Formatting personal and official letters
Rules and practices in English Written language
WEEK-4 - Public Speaking
Extempore in English language – simple topics
Self Introduction – Debates etc
Group Discussion
Discussions on Current Topics
- [MONTH-2]

WEEK-1 –

KNOWING ABOUT SOFTWARE & HARDWARE

Introduction to Computers
Knowing about Software & Hardware

IDENTIFICATION OF DIFFERENT PARTS OF

COMPUTERS, ITS INSTALLATION PROCEDURES & ITS
CONNECTING TECHNIQUES AND SLOTS

Components of Computer
• Power on/off switch
• Reset switch
• Floppy disk drive
• CDD
• Light Indicators
• Power in Socket
• Monitor Power Socket
• Serial port
• Monitor Port
• Parallel port
• Keyboard Socket
• Expansion Card slots
• Mouse Socket
• Ethernet Card
• Sound card
• RAM
• USB Port
WEEK-2 -

Mother Board

• RAM Slot
• Display Adapter Card
• Power Supply Slot
• Disk Drive Controller Port
• Cache Memory
• CPU
• Math Co- Processor Slot

Power Supply

• SMPS
• Power Supply Cable

Cables (of various kinds & use)

WEEK-3 -
Input Devices

Key Board

• Installing a Keyboard
• Various function & Utilities of different
Keys
• Different types & Features
• Water logged Keyboard
• Other liquid Assaults
• Upgrading a keyboard
• Setting different options of Key Board
using Control Panel
 Mouse

• Types & Features

• Various Parts
• Installations
• Setting different options using Control
Panel
Scanner

• Installing & configuring

• Types & Features
• Various S/W
• Application Software to use Scanner

Output Devices

Monitor

• Type
• Installation
• Different features of Monitor
WEEK- 4 -

Printer

• Type
• Installation
• Necessary S/W
• Various Features of Printers
• Building driver information
• How to increase the speed of printer?
• Setting Printer over a network
 Speaker

• Types
• Capacities
• Connecting the devices
• Testing the devices

I/O Device

Modem
• Types & Features
• Installing & Configuring

- MONTH-3 -

WEEK-1 -

Power Control Devices

UPS

• Types & Features

• Understanding the working
• Connecting it with Computers & Printers
• Testing the capacity
• Testing the battery
• Ensuring optimum utilization of batteries
WEEK-2 -
Inverter

• Types & Features

• Understanding the working
• Connecting it with Computers & Printers
• Testing the capacity
 • Testing the battery
• Ensuring optimum utilization of batteries
WEEK-3 -

Storage Devices

Floppy Disk Drive

• Types & Features

• Connecting the Drive
• Establishing its connection with Mother
Board.

Hard Disk Drive

• Types & Features

• Connecting the Drive
• Establishing its connection with Mother
Board
WEEK-4 -

Compact Disk Drive

• Types & Features

• Connecting the Drive
• Establishing its connection with
Mother Board
• Installing the Drive

Zip Drive

• Types & Features

• Troubleshooting techniques
- [MONTH-4]

WEEK-1 -

ASSEMBLING PC

Assembling Your First PC

• Collecting the required tools & tool kit

like: Bend Paper Clip, Chip Puller, Inserter
Grouting, Wrist Strap, Pliers, Screw Driver, and
Wire Cutter.
• Connecting individual Parts
• Finalizing the assembling process
• Taking Precaution
WEEK-2 -

Getting Familiar with Operating System

• Working with DOS & Windows

• Using the Internal & External Commands
of DOS
• Using the Control Panel of Windows

Formatting a Disk

• Floppy disk drive

• Hard disk drive

Making a Disk Bootable

• Floppy disk drive

 • Hard disk drive

WEEK-3 -

Partitioning the Hard Disk

• Using the different Partitioning

software’s
• Checking the Disk for Bad Sectors
• Fixing the Bad Sectors

Installing / Uninstalling Software’s

• Installations of different OS
(DOS/Windows 98 / 2000/ XP)
• Installing different software’s used for
common tasks
• Uninstalling software’s
• Installing a component from a suite /
bundle
WEEK-4 -

CMOS Setup

• Standard configuration
• Advanced Settings
• Optimization
• Maintenance and Trouble shooting
Using Auto Configuration

• BIOS defaults
• Power on defaults

Handling Password Related Queries

Creating / Updating Autoexec. Bat & Config. Sys file

- [MONTH-5]

WEEK-1 -
REPAIR & MAINTENANCE
• Identification of common faults in
computer & its rectification
• Differentiation of Hardware & Software
faults
• Fixing the problems arising due to
software
• Aligning the Floppy Drive
• Repairing the SMPS
• Repairing the Printers
• Servicing the Printer
• Cleaning the different parts of computer
• Refilling the Printer Cartridges

WEEK-2 -

Diagnosing System

• Virus Scanning & Removing

• Troubleshooting
• Using Anti Virus Software
• Fault Simulation

WEEK-3 -
COMMUNICATION PROTOCOLS
• Overview of TCP/IP and other Protocols
• Installation & Configuration
• TCP/IP
 • IP Address
• Troubleshooting TCP/IP

Network Technologies

• Introduction

• Types of Networking

• LAN
• WAN
• MAN
• Topologies

• Bus
• Tree
• Star
• Ring
• Application

• Transmission Media

• Switching Techniques

WEEK-4 -
Devices Required For Networking

• Cables
• Hub
• Router
• Bridge
• Transparent
• Source Routing
 • Router
• Administrative control over a Network

** FIELD VISITS, COURSE REVISION & PROBLEM

SOLVING
- [MONTH-6]

PERSONALITY DEVELOPMENT & COMMUNICATION

SKILLS

WEEK-1 -
 About importance of Communication – A
fundamental necessity
 Types of Communications
 Assertive Communication
 Interpersonal Communication (Handling
Queries and Aggressive Customers)
 Barriers of Communications
 Stage freight and Public speaking

WEEK-2 -
• Learning Presentation Skills
• Acquiring Confidence
• Body Language
• Preparing presentations and Audio Visual Aids
(Presentation Skills)
• Dress up and Personal Hygiene

WEEK-3 -
• Influencing Skills
• Handling and Influencing Customers
• Identifying personal strengths and skill set
• Acquiring New Skills and Personality Aspects
• Important personality traits and their
development
• Business and Office Etiquettes
 • Understanding General Human Nature and
Psychology
• Understanding human Behavior (Male, Female,
Coworkers, Boss etc.)
• Group Psychology and Team Work

WEEK-4 -
• Methodology for Personality Development
• Group discussions
• Role plays
• Simulation
• Case studies