Aff.

By-All India Council of Computer Education (AICCE)

Data Entry course fees and Course Duration – 60 days (1 hrs per day)Fees – 3000/-
Basic Computer Course Syllabus

English Taiping MS WINDOWS, COMPUTER BASICS

Hindi typing (Optional)
 Computer Basic
 Ms Paint (If required)  Creating Folder
o Paint Box  Directories, input units, Output unit
o Home Tab  Central Processing Units,
 Clipboard Group  What is hard ware, what is Software
 Cut  Windows short cut keys
 Copy
MS WORD
 Paste
o Image Group Module 1: Text Basics
 Crop  Typing the text, Alignment of text
 Resize
 Editing Text: Cut, Copy, Paste, Select
 Rotate
All, Clear
o Tool group
 Find & Replace
 Pencil
 Fill with color Module 2: Text Formatting and saving
 Text file
 Eraser  New, Open, Close, Save, Save As
 Color picker
 Formatting Text: Font Size, Font
 Magnifier
Style
o Shapes group
 Font Color, Use the Bold, Italic, and
o Colors Group
Underline
o View Tab
 Change the Text Case
 Zoom
 Line spacing, Paragraph spacing
 Show or Hide
 Shading text and paragraph
 Display
 Working with Tabs and Indents

THDC Colony, Help Line No:9837751014,6397095263

 Aff.By-All India Council of Computer Education (AICCE)

Module 3: Working with Objects & Module : Proofing the document

Header & Footers
 Check Spelling As You Type.
 Shapes, Clipart and Picture, Word  Mark Grammar Errors As You Type.
Art, Smart Art  Setting AutoCorrect Options
 Columns and Orderings - To Add
Module 6: Printing
Columns to a
 Document  Page Setup, Setting margins
 Page Number, Date & Time  Print Preview, Print
 Inserting Word art
MS EXCEL
 Inserting symbols
 Inserting custom Header and Footer Module 7: Introduction to Excel
 Inserting objects in the header and  Introduction to Excel interface
footer
 Understanding rows and columns,
 Add section break to a document Naming Cells
Module 4: Working with bullets and  Working with excel workbook and
numbered lists sheets

 Customizing List style Module 8:Formatting excel work book:

 Page bordering
 New, Open, Close, Save, Save As
 Page background
 Formatting Text: Font Size, Font
 Watermark
Style
 Page color
 Font Color, Use the Bold, Italic, and
Module 5: Tables Underline
 Wrap text, Merge and Centre
 Working with Tables, Table
 Currency, Accounting and other
Formatting
formats
 Table Styles
 Modifying Columns, Rows & Cells
 Alignment option
 Merge and split option

THDC Colony, Help Line No:9837751014,6397095263

 Aff.By-All India Council of Computer Education (AICCE)

Module 9: FORMULAS & FUNCTIONS Module 12 :BILLING / INVOICE

CREATION
 Shortcut Keys
 Functions(Sum, Average. Min, Max,  GST Bill Calculation
Small, Large)  Preparing GST Bill
 Worksheet protection  Page Layout Margin Setting
 Page setup Module 13 :Time and Date Functions
Module 10: ADVANCED FUNCTIONS  Today, Now
 If, And, OR, Not Functions  Date, Date if, DateAdd
 Count  Day, Month, Year
 Count A Module 14 :Printing Workbooks
 Count If
 Setting Up Print Area
 Count Blank
 Customizing Headers & Footers
 Datedif Funtion
 Designing the structure of a
 Conditional Formatting
template
 Text to Column
 Print Titles –Repeat Rows / Columns
 Data Table
 Freeze Panes

Module 11 :TEXT FUNCTIONS

 Upper
 Lower
 Proper
 Left
 Right
 Mid
 Concatenate
 Len
 Replace
 Date
 Day
 Month
 Year

THDC Colony, Help Line No:9837751014,6397095263

 Aff.By-All India Council of Computer Education (AICCE)

MS POWERPOINT

Module 15: Setting Up PowerPoint INTERNET & E-MAIL

Environment:
 What is Internet?, Receiving
 New, Open, Close, Save, Save As Incoming Messages
 Typing the text, Alignment of text  Sending Outgoing Messages, Email
 Formatting Text: Font Size, Font addressing
Style  Email attachments, Browsing, Search
 Font Color, Use the Bold, Italic, and engines
 Underline  send attachments, files, photos, and
 Cut, Copy, Paste, Select All, Clear other documents through
text WhatsApp,
 Find & Replace  Text chatting, Job Searching
 Downloading video and Music

Module 16:Creating slides and applying

themes

 Inserting new slide

 Changing layout of slides
 Duplicating slides
 Copying and pasting slide
 Applying themes to the slide layout
 Changing theme color
 Slide background
 Formatting slide background
 Using slide views

THDC Colony, Help Line No:9837751014,6397095263