|
Sl.
No.
|
Concepts
|
Theory
|
Practical
|
|
1.
|
Introduction
to Computers
|
6
|
–
|
|
2.
|
Operating
System (DOS & Windows)
|
5
|
7
|
|
3.
|
Word
Processing (MS Word)
|
6
|
18
|
|
4.
|
SpreadSheet
Package (MS Excel)
|
6
|
18
|
|
5.
|
Computer
Communication & Internet
|
5
|
7
|
|
6.
|
Business
System (FoxPro)
|
30
|
36
|
|
7.
|
Programming
in C
|
36
|
36
|
|
8.
|
Visual
Basic
|
36
|
36
|
|
Total
|
130
|
158
|
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.
PROGRAMMING IN C :
7.1 Overview of C Programming :
7.1.1 Introduction to C programming
- its power
7.1.2 Basic structure of C programming,
Execution of sample C programs
7.1.3 Character set, keyboards,
identifiers, constants, variables data types
declaration of variables
7.2 C Operations and Expressions :
7.2.1 Arithmetic, relational, logical
and assignment operators
7.2.2 Increment & decrement operators,
conditional operators, operator precedence
and associativity
7.2.3 Arithmetic expressions, evaluation
and type conversion in expressions
7.2.4 Character reading & writing;
formatted input and output
7.3 Decision making :
7.3.1 Decision making; and branching,
simple and nested IF statement, IF...... ELSE
statement, switch statement
7.3.2 Decision making and looping,
while, do, for statements
7.4 Arrays :
7.4.1 One and two dimensional array
7.4.2 Array initialisation
7.4.3 Handling of character strings
by using array, reading and writing strings,
concatenation and
comparisons of strings, string handling functions.
7.5 User-defined functions :
7.5.1 Need for user defined functions,
simple example
7.5.2 Call by value & call by reference
function - their uses
7.5.3 Return values & their types
7.5.4 Nesting of function, recursion
7.6 Structure :
7.6.1 Structure definition and initialisation
7.6.2 Arrays of structure, Arrays within
structure, structures within structure, size of
structure.
7.7 Pointers :
7.7.1 Understanding pointers, declaration
& initialisation of pointers
7.7.2 Accessing variables through pointer
expressions, pointer arithmetic
7.7.3 Pointers and arrays, strings, functions
& structures
7.8 File handling in C :
7.8.1 Definition of files, opening &
closing of files
7.8.2 I/O operations on files
7.9 Pre-processor and linked list :
7.9.1 Introduction to pre-processor,
its application
7.9.2 Concepts and advantages of linked
list, its use in C
8.
VISUAL BASIC :
8.1 The Integrated Development
Environment :
8.1.1 Menu bar, toolbars,
project explorer, toolbox, the properties Window
8.1.2 The form designer
8.1.2.1 Form layout
8.1.2.2 Immediate Window
8.1.3 Edit, View, Run, Debug,
options
8.1.4 Using the application
wizard
8.2 Managing projects :
8.2.1 Concept of VB project
8.2.1.1 Creating the project
8.2.1.2 Opening, saving the projects
8.3 Elements of the user interface
8.3.1 Designing the user
interface
8.3.2 Creating forms and
code modules
8.3.3 Aligning the controls
8.4 Running the application
8.5 Programming an application
8.5.1 Programming the command
buttons
8.5.2 Groping controls
8.6 Visual development and event-driver
programming
8.6.1 Common properties
8.6.2 Methods and common
events
8.7 Customizing the environment
8.7.1 Editor tab, format
tab, general tab, docking tab, environment tab
8.8 Introduction to Visual Basic
Language :
8.8.1 Variable
8.8.1.1 Declaring variables
8.8.1.2 Type of variables
8.8.1.3 Converting variables types
8.8.1.4 User - defined data types
8.8.1.5 Special values
8.8.1.6 Forcing variables declarations
8.8.1.7 A variable’s scope
8.8.1.8 The lifetime of a variable
8.9 Constants
8.9.1 Arrays
8.9.2 Collections
8.10 Procedure, subroutines,
functions, arguments
8.11 Control flow statements and conditional statements
8.12 Loop statements
8.13 Iteration
8.14 Working with Forms :
8.14.1 The appearance
of forms
8.14.1.1 Loading
8.14.1.2 Showing and hiding forms
8.15 Controlling one form within
another
8.16 Using form templates
8.17 Menus
8.17.1 Designing menu
8.17.2 Programming
menu commands
8.17.3 Using access
and shortcut keys
8.17.4 Manipulating
menus at runtime
8.17.5 Mouse conflicts,
Dragging list items
8.18 Using message boxes and
input dialogs
8.19 Using standard modules instead of form modules
8.20 ActiveX controls :
8.20.1 The Text Box
Controls
8.20.1.1 Basic properties
8.20.1.2 Manipulating the control’s text
8.20.1.3 Text selection
8.20.1.4 Search and replace operations
8.20.1.5 Capturing keystrokes
8.21 The list box and combo
box controls
8.21.1 Basic properties
8.21.2 The listbox
control’s methods, Arrows
8.21.3 Indexing with
the listbox control
8.21.4 Searching a
sorted list
8.22 The scroll bar and slider
controls
8.22.1 Scroll bar
control
8.22.2 Scroll bar
control’s events
8.23 Dialog control
8.23.1 Using the common
dialog control
8.23.2 color common
dialog box
8.23.3 Font dialog
box
8.23.4 The file open
and file save common dialog boxes
8.23.5 Print dialog
box
8.23.6 Help common
dialog box
8.24 The file controls
8.25 The built - in ActiveX
controls