Certificate
Course in Computer Application (CCA)
DETAILED
SYLLABUS
1. INTRODUCTION TO COMPUTERS :
1.1 Why study about Computer ?
1.2 Computer Application of the future.
1.3
Characteristics of a Computer.
1.4 Generation of Computers :
First Generation, Second Generation, Third Generation,
Fourth Generation and Fifth
Generation Computing.
1.5 Classification of Computers :Classification
according to applications - General purpose
Computers - Special purpose Computers, Classification according to construction
- Analog, Digital & Hybrid Computers, Home Computers, Personal Computers,
Mini Computers, Mainframe Computers, Super Computers.
1.6 Commonly used terms : Hardware,
Software, Liveware & Firmware.
1.7 Input, Output & I/O Devices, CPU,
Auxiliary Storage Devices.
1.8 Networking Concepts : Local Area Network (LAN),
Wide Area Network (WAN), Internet
& Intranet.
1.9 Translators : Interpreters,
Compilers and Assemblers.
2.
OPERATING SYSTEM (DOS & WINDOWS) :
2.1 DOS :
2.1.1 What is Disk Operating
System (DOS) ? How is MS-DOS organised ? The
Input/Output Systems, Command Processor, Utilities, Internal
& External
Commands.
2.1.2
Different versions of MS-DOS.
2.1.3 Directory Coomands
: DIR, MD, RD, TREE & PATH.
2.1.4 File Management Commands
: COPY, XCOPY, DEL, RENAME, ATTRIB, BACKUP,
RESTORE & SYS.
2.1.5 General Commands :
TYPE, DATE, TIME & PROMPT.
2.1.6 Disk Management Commands
: FORMAT, CHKDSK, DISKCOPY, LABEL & VOL.
2.1.7 DOS Utility Command : MOVE, DELTREE, MSBACKUP, SCANDISK, SETVER
UNDELETE, UNFORMAT & XCOPY.
2.1.8 Using Copy Con to build
file.
2.1.9 Introduction to sample
batch files.
2.1.10 Configuration Systems
: Config.sys file, Autoexec.bat file.
2.1.11 System Configuration
Commands : Files, Buffers, Country.
2.1.12 Batch File Command
: ECHO, PAUSE, REM.
2.2
WINDOWS :
2.2.1
Windows Basics - An overview of different versions of Windows.
2.2.2 The User Interface
: The Desktop, the Task Bar, The Start Button, the Title
Bar, the Control Panel, Wizards, the Fine Feature, Properties, Quick View,
Right Checking and Font Management.
2.2.3 Windows Accessories
: Entertainment, Fax, Games, System Tools, Calculator,
Calendar Card File, Character Map, Imaging, Notepad, Paint and Wordpad.
2.2.4 Miscellaneous Windows Features : My Computer Icon, Network Neighborhood,
Explorer, Folders.
3.
WORD PROCESSING (MS WORD) :
3.1 Basics :
3.1.1 An introduction
to Word Processing
3.1.2 Creating
3.1.3 Saving documents
3.1.4 Quitting documents
3.2 Opening Documents and Moving
Around :
3.2.1 Opening a document
3.2.2 Save a file with
new name
3.2.3 Moving around
in a document
3.2.3.1 Scrolling through a document
3.2.3.2 Scroll line by line
3.2.3.3 Scroll window by Window
3.3 Manipulating Windows
3.4 Steps to manipulate Windows
3.4.1 Arrange Windows
3.4.2 The active Windows
3.4.3 Maximizing a window
3.4.4 Splitting a window
3.5 Printing Documents
3.5.1 Previewing documents
3.5.2 Editing Text
3.5.2.1 Edit Text in Print Preview
3.5.3 Inserting page breaks
3.5.4 Printing document
3.5.4.1 Print a document from the Standard Toolbar
3.5.4.2 Print a document from the Menu
3.5.5 Shrinking a document
to fit a page
3.5.5.1 Reduce the number of pages by one
3.6 Selecting Text
3.6.1 Various ways to select
Text
3.6.1.1 Selecting a single word
3.6.1.2 Selecting a line
3.6.1.3 Selecting a paragraph
3.6.1.4 Selecting the entire document
3.6.1.5 Using keyboard to select text
3.6.2 The Ruler
3.6.3 The Menu Commands
3.6.3.1 Menu Bar Commands
3.6.4 The Shortcut Menu
Commands
3.6.5 Keyboard Shortcut
3.7 Editing Text
3.7.1 Insert and Delete
3.7.2 Delete extra spacing
between paragraphs
3.7.3 Edit text in a sentence
3.7.4 Select and delete
a word
3.8 Moving and copying text
using drag-and-drop technique
3.9 Using Smart Cut and Paste
3.10 Finding and Replacing Text
3.11 Proofing document with Spelt Check and Grammar
Check
3.11.1 Checking
the spelling of the entire document
3.11.2 Spelt
checking selected text
3.11.3 Using
the Thesaurus
3.11.3.1 Looking up for a word in the thesaurus
3.11.3.2 Replace another word
3.11.4 Using the
Grammar Command
3.11.4.1 Checking the grammar and spelling
together
3.12 Using AutoCorrect, AutoComplete
and AutoText
3.13 Document Enhancement
3.13.1 Adding borders
and shading
3.13.1.1 Adding a border
3.13.1.2 Adding shading
3.13.1.3 Turning off the borders toolbar
3.13.2 Adding
header and footers
3.13.3 Setting up
multiple columns
3.13.4 Adjusting
margins
3.14 Creating and printing
merged documents
3.15 Creating tables
3.15.1 Creating a
table
3.15.1.1 Inserting the table
3.15.1.2 Typing the text
3.15.1.3 Adjusting the width of the columns
3.15.1.4 Auto adjustment for the column width
3.15.2 Inserting
and deleting rows and columns
3.15.2.1 Steps to insert a column
3.15.2.2 Type text in the new column
3.15.2.3 Insert a row
3.15.2.4 Delete a column
4. SPREADSHEET PACKAGE (MS EXCEL) :
4.1 Worksheet basics
4.1.1 Initiation
4.1.1.1 Worksheet background
4.1.2 Getting started
4.1.3 Entering information
in a Worksheet
4.1.3.1 Enter the heading information as text
4.1.3.2 Entering the data
4.1.3.3 Entering text
4.1.3.4 Entering dates
4.1.3.5 Entering alphanumerics
4.1.3.6 Entering values
4.2 Selecting data range
4.3 Toolbars
4.3.1 Using toolbars
4.3.1.1 The Standard toolbar
4.3.1.2 The Formatting toolbar
4.3.1.3 Changing the font style and its size
4.3.1.4 Displaying the current format
4.3.2 Using Menus
4.3.3 Using Shortcut Menus
4.3.4 Using Keyboard Shortcuts.
4.4 Editing data in a Cell
4.4.1 Copying entries
4.4.2 Inserting and deleting
cells
4.5 Working with Formulae
4.5.1 Totaling rows and
columns automatically Autosum
4.5.2 Creating simple formulas
4.5.2.1 Components of a formula
4.5.2.2 Display the current date
4.5.2.3 Using arguments
4.6 Working with ranges
4.6.1 Creating names
4.6.1.1 Rules for naming ranges
4.6.1.2 Create range names
4.6.1.3 Creating default range names
4.6.1.4 Saving range names
4.6.2 Editing names
4.6.3 Using names in formulas
4.6.4 Copying formats to
other cells
4.6.5 Formatting date-using
the formatting toolbar
4.6.6 Customizes formatting
changing default currency of $ to Rs.
4.7 Printing worksheet
4.7.1 Previewing worksheet
4.7.2 Setting up pages
4.7.3 Adjusting the worksheet
data in a limited printing space
4.7.3.1 Print a portion of a worksheet
4.7.3.2 Accommodate a large worksheet on one page
4.7.3.3 Adjusting the worksheet in two pages
4.7.4 Adding print title
4.7.5 Adjusting margins
4.7.6 Inserting page breaks
in your worksheet
4.7.7 Adding headers and
footers to the printed worksheet
4.7.8 Printing a worksheet
4.8 Working with graphs and
charts
4.8.1 Creating charts using
chartwizard
4.8.2 Sizing and moving
charts
4.8.3 Updating charts
4.8.4 Changing the chart
types
4.8.5 Adding titles and
gridlines and formatting legends
4.8.5.1 Adding a chart title
4.8.5.2 Adding gridlines
4.8.5.3 Formatting legends
4.8.6 Previewing and printing
charts.
5.
COMPUTER COMMUNICATION & INTERNET :
5.1 Basic of Computer Networks
5.1.1 LAN
5.1.2 WAN
5.2 Internet
5.2.1 Concept of Internet
5.2.2 Application of Internet
5.3 Service on Internet
5.3.1 WWW and Web-Site
5.3.2 Electronic Mails
5.3.4 Communication on Internet
5.4 Surfing the Internet
5.4.1 Giving the URL address
5.4.2 Search
5.4.3 Moving around in a
Web-Site
5.4.4 Printing or Saving
portion of Web Pages
5.5 Basic of Electronic Mail
5.5.1 What is an Electronic
Mail ?
5.5.2 E-mail addressing
5.5.3 Mailbox : Inbox and
Outbox
5.6 Using E-mails
5.6.1 Viewing an E-mail
5.6.2 Sending an E-mail
5.6.3 Saving mails
5.6.4 Sending same mail to
various Users
5.7 Document Handling
5.7.1 Sending soft copy as
Attachment
5.7.2 Enclosures to E-mail
5.7.3 Sending a portion of
Document as E-mail
6.
BUSINESS SYSTEM (FoxPro) :
6.1 Introduction to Business
Data Processing
6.1.1 Overview of Business Systems
6.1.1.1 Management functions
6.1.1.2 Level of Management
6.1.1.3 Information requirement for planning, co-ordination and control for
various
levels in Business, Industry and Government
6.1.2 Profile of data in Business Systems
6.1.2.1 Large volumes of data and data handling implicit
6.1.2.2 Identification of relevant data
6.1.2.3 Classification of data elements by function (Master, Transaction,
Control,
Security, Checking) and by source (Raw and Derived)
6.1.2.4 Primary and Secondary
6.1.3 Computer System as a potent to meet business data processing needs,
facilities
available in computerised systems for :
6.1.3.1 Data capture, online and offline
6.1.3.2 Validation, storage, processing and output
6.1.3.3 Transmission
6.1.4 Concepts of DBMS
6.1.4.1 Databases defined
6.1.4.2 Relational databases defined
6.1.4.3 Phases of database design
6.1.5 Report production and file updation
6.1.6 Foxpro for Business Systems
6.1.6.1 Introduction to FoxPro
6.1.6.1.1 What is FoxPro under Windows ?
6.1.6.1.2
What is a database ?
6.1.6.1.3
What is a relational database ?
6.1.6.1.4
Starting FoxPro
6.1.6.1.5
Data types
6.1.6.1.6
Creating database
6.1.6.1.7
Adding records
6.1.6.1.8
Viewing database
6.1.6.1.9
Saving database
6.1.6.1.10
Editing - edit - browse
6.1.6.1.11
Deleting - record - files
6.1.6.1.12
Modify database structure
6.1.6.1.13
Open and close database file
6.1.6.1.14
Quit FoxPro
6.1.7 Sorting and Indexing
6.1.7.1 Sort
6.1.7.2 Index
6.1.7.3 Types of Index
6.1.7.4 Indexing Commands - set index - set order - reindex - close index
6.1.8
Querying
6.1.8.1 Query with menu - goto - locate - continue - seek
6.1.8.2 Query with commands - locate - find - seek
6.1.8.3 Locate and seek vs locate and continue
6.1.8.4 Set filter commands 6.1.8.5 View files - create view - set view
6.1.9 FoxPro Programming
6.1.9.1 Create command file
6.1.9.2
Memory variable
6.1.9.3 Operator
6.1.9.4 Functions
6.1.9.5 Coomands
6.1.10 More on FoxPro Programming (Loop construct)
6.1.10.1 Do...While
6.1.10.2
if, else, endif
6.1.10.3 nested if
6.1.10.4 case
6.1.10.5 wait
6.1.10.6
zap
6.1.10.7 Program code for - data entry - deleting records - generating reports
- send report to printer
7.
MAKING SMALL PRESENTATIONS :
7.1 Basics :
7.1.1 Difference between presentation and document
7.1.2 Using Power Point
7.1.3 Opening a Power Point Presentation
7.1.4 Using Wizard for creating a presentation
7.2 Creation of Presentation
:
7.2.1 Title
7.2.2 Text Creation
7.2.3 Fonts and Sizes
7.2.4 Moving to Next Slide
7.3 Preparation of Slides :
7.3.1 Selection of type of Slides
7.3.2 Importing text from Word Documents
7.3.3 Moving to Next Slide
7.3.4 The Slide Manager
7.4 Providing Aesthetics :
7.4.1 Slide Designs
7.4.2 Background and Text Colors
7.4.3 Making your own Slide format
7.4.4 Footnotes and Slide numbering
7.5 Slide
Manipulation and Slide Show
7.6 Presentation of the Slides :
7.6.1
Using the Slide Show
7.6.2 Printing the Slides and Handouts
7.6.3 Slide Sorter
7.6.4 Title Sorter