|
CH. NO. |
CONTENTS |
CH. NO. |
CONTENTS |
|
1. |
COMPUTER OVERVIEW
INTRODUCTION
WHAT IS A COMPUTER
BENEFITS OF A COMPUTER
SPEED
ACCURACY
STORAGE
VERSATILITY
AUTOMATION
DILIGENCE
LIMITATIONS OF A COMPUTER
EXERCISE |
2. |
GENERATIONS AND TYPES OF COMPUTERS
GENERATIONS OF COMPUTERS
FIRST GENERATION COMPUTERS
SECOND GENERATION COMPUTERS
THIRD GENERATION COMPUTERS
FOURTH GENERATION COMPUTERS
COMPARISON BETWEEN GENERATIONS OF COMPUTERS
FIFTH GENERATION COMPUTERS
TYPES OF COMPUTERS
PC (MICROCOMPUTER)
MINICOMPUTERS
MAINFRAME COMPUTER
SUPERCOMPUTER
EXERCISE |
|
3. |
HARDWARE AND SOFTWARE
HARDWARE
SOFTWARE
EXERCISE |
4. |
THE I-P-O CYCLE
HOW DOES A COMPUTER WORK? (I-P-O CYCLE)
INPUT
PROCESSING
OUTPUT
DATA AND INFORMATION
EXERCISE |
|
5. |
INPUT AND OUTPUT DEVICES
INPUT DEVICES
KEYBOARD
MOUSE
JOYSTICK
SCANNER
OUTPUT DEVICES:
VISUAL DISPLAY UNIT
PRINTER
EXERCISE |
6. |
STORAGE DEVICES
INTERNAL OR PRIMARY STORAGE (MEMORY)
EXTERNAL OR SECONDARY STORAGE (MEMORY)
TYPES OF INTERNAL STORAGE
RAM
ROM
UNITS OF MEMORY
DISK DRIVES
HARD DISK DRIVES
FLOPPY DISK DRIVES
OPTICAL DISK DRIVES
MAGNETIC TAPE DRIVES
EXERCISE |
|
7. |
COMPUTER APPLICATIONS
USES OF COMPUTERS IN EVERYDAY LIFE
EDUCATION
INDUSTRY
BANKING SECTOR
HOSPITAL
TRANSPORTATION
INSURANCE
SCIENCE AND ENGINEERING
BUSINESS
TELECOMMUNICATION
ENTERTAINMENT
RAILWAYS AND AIRLINES
DESK TOP PUBLISHING
EXERCISE |
8. |
WINDOWS 98 BASICS
INTRODUCTION
WHAT IS A WINDOW
STARTING THE COMPUTER
IDENTIFYING DIFFERENT PARTS OF COMPUTER SCREEN
DESKTOP
START BUTTON
START MENU
ICONS
MENUS
QUICK LAUNCH TOOLBAR
SYSTEM TRAY
MOUSE USE
RIGHT CLICK
DIALOG BOXES
SHUTTING DOWN THE COMPUTER
EXERCISE
PRACTICE SESSION |
|
9. |
WORKING WITH WINDOWS 98
RUNNING AN APPLICATION
MAXIMISE, MINIMISE & CLOSE
USING ACCESSORIES
NOTEPAD
PAINT
WORDPAD
STARTING WORDPAD
CALCULATOR
CLIPBOARD
SYSTEM TOOLS
GAMES
ENTERTAINMENT
COMMUNICATIONS
USING WINDOWS 98 HELP
EXERCISE
PRACTICE SESSION |
10. |
INTRODUCTION TO MS-PAINT
INTRODUCTION
WHAT IS MS-PAINT
STARTING PAINT
OPENING AN EXISTING FILE
SELECTING AN AREA
MOVING AN AREA
ERASING A SMALL AREA
ERASING A LARGE AREA
STARTING A NEW PICTURE
SAVING A PICTURE
EXITING FROM MS-PAINT
EXERCISE
PRACTICE SESSION |
|
11. |
DRAWING AND ERASING FIGURES
TOOLBOX
PALLETTE
LINE TOOL
CURVE TOOL
RECTANGLE TOOL
ELLIPSE/CIRCLE
POLYGON
EXERCISE
PRACTICE SESSION |
12. |
ZOOMING A PICTURE
ZOOMING IN OR OUT OF A PICTURE
ENLARGING THE SIZE OF THE VIEWING AREA
SAVING PART OF A PICTURE INTO ANOTHER BITMAP FILE
EXERCISE
PRACTICE SESSION |
|
13. |
FILLING COLOURS
FILLING AN AREA OR OBJECT WITH COLOUR
PAINTING WITH A BRUSH
CHANGING THE COLOUR OF AN EXISTING LINE
CREATING AN AIRBRUSH EFFECT
CREATING CUSTOM COLOURS
EXERCISE
PRACTICE SESSION |
14. |
WORKING WITH PICTURES
CHANGING THE SIZE OF THE PICTURE
FLIPPING OR ROTATING A PICTURE OR AN OBJECT
STRETCHING AND SKEWING A PICTURE
PRINTING A PICTURE
INSERTING A BITMAP IMAGE
INSERTING TEXT
EXERCISE
PRACTICE SESSION |
|
15. |
STARTING WORDPAD
INTRODUCTION
STARTING WORDPAD
COMPONENTS OF A WORDPAD SCREEN
TITLE BAR
MENU BAR
FORMATTING TOOLBAR
RULER
STATUS BAR
WORK AREA
EXITING FROM WORDPAD
EXERCISE
PRACTICE SESSION |
16. |
CREATING A DOCUMENT
CREATING A NEW DOCUMENT
OPENING AN EXISTING FILE
SAVING A FILE
EXERCISE
PRACTICE SESSION |
|
17. |
PRINTING DOCUMENTS
PRINTING FILES OR DOCUMENTS
PRINT PREVIEW
SETTING PAGE MARGINS
EXERCISE
PRACTICE SESSION |
18. |
MOVING TEXT
SELECTING TEXT
COPYING THE TEXT
MOVING THE TEXT
MOVING THE TEXT BETWEEN DOCUMENTS
DELETING THE TEXT
SEARCHING FOR TEXT
REPLACING THE TEXT
USING THE VIEW MENU
EXERCISE
PRACTICE SESSION |
|
19. |
FORMATTING TEXT AND PRINTING DOCUMENTS
CHANGING THE FONT
FORMATTING THE PARAGRAPH
PREVIEWING AND PRINTING A DOCUMENT
EXERCISE
PRACTICE SESSION |
20. |
STARTING MS-WORD
INTRODUCTION TO WORD 97
STARTING MS-WORD
GETTING TO KNOW THE WORD SCREEN
TITLE BAR
MENU BAR
STATUS BAR
TOOLBARS
STANDARD TOOLBAR
FORMATTING TOOLBAR
SCROLL BARS
RULER
WORKSPACE
CREATING DOCUMENTS
SAVING DOCUMENTS
VIEWING THE DOCUMENTS
NORMAL VIEW
ONLINE LAYOUT VIEW
PAGE LAYOUT VIEW
OUTLINE VIEW
EXITING FROM MS-WORD
EXERCISE
PRACTICE SESSION |
|
21. |
EDITING TEXT
OPENING A DOCUMENT
EDITING TEXT
SELECTING AND MOVING TEXT
SELECTING TEXT
MOVING TEXT
EDITING TEXT WITH CUT, COPY AND PASTE
EXERCISE
PRACTICE SESSION |
22. |
FORMATTING DOCUMENTS
FORMATTING TEXT
CHARACTER FORMATTING STYLES
CHANGING FONT & FONT SIZE:
APPLYING COLOUR
EXERCISE
PRACTICE SESSION
|
|
23. |
ALIGNING TEXT
ALIGNING TEXT
ADDING HEADERS AND FOOTERS
NUMBERING PAGES
EXERCISE
PRACTICE SESSION |
24. |
USING HELP
USING HELP
PREVIEWING AND PRINTING A DOCUMENT
PRINTING OPTIONS
EXERCISE
PRACTICE SESSION
|
|
25. |
PROOFING A DOCUMENT
PROOFING A DOCUMENT
USING THE AUTOCORRECT FEATURE
USING FIND, REPLACE & GO TO OPTION
EXERCISE
PRACTICE SESSION |
|
Updated January
2005 |
|
CH. NO. |
CONTENTS |
CH. NO. |
CONTENTS |
|
1. |
INPUT, OUTPUT & STORAGE DEVICES
COMPONENTS OF A COMPUTER-HARDWARE
SOFTWARE
HOW DOES A COMPUTER WORK? (I-P-O CYCLE)
INPUT
PROCESSING
OUTPUT
INPUT DEVICES
KEYBOARD
MOUSE
JOYSTICK
SCANNER
OUTPUT DEVICES
VISUAL DISPLAY UNIT
PRINTER
INTERNAL OR PRIMARY STORAGE (MEMORY)
EXTERNAL OR SECONDARY STORAGE (MEMORY)
DISK DRIVES
HARD DISK DRIVES
FLOPPY DISK DRIVES
OPTICAL DISK DRIVES
MAGNETIC TAPE DRIVES
EXERCISE |
2. |
TYPES OF SOFTWARE
APPLICATION SOFTWARE
OPERATING SYSTEM
UTILITY SOFTWARE
COMPUTER LANGUAGES
COMPILERS
EXERCISE |
|
3. |
NUMBER SYSTEM
BINARY NUMBER SYSTEM
DECIMAL SYSTEM
OCTAL SYSTEM
HEXADECIMAL SYSTEMS
EXERCISE |
4. |
COMPUTER APPLICATIONS-AN OVERVIEW
USES OF COMPUTERS IN EVERYDAY LIFE
COMPUTER ANIMATION
COMPUTER AIDED DESIGN AND MANUFACTURING
COMPUTER AIDED INSTRUCTION (CAI)
ROBOTICS
VIRTUAL REALITY
ARTIFICIAL INTELLIGENCE (AI)
EXERCISE |
|
5. |
EXPLORING YOUR COMPUTER
MANAGING FILES AND FOLDERS
WORKING WITH FILES AND FOLDERS
CREATING A FOLDER
CREATING A FILE
FINDING FILES AND FOLDERS
OPENING AND RENAMING FILES AND FOLDERS
SELECTING FILES AND FOLDERS
COPYING AND MOVING FILES AND FOLDERS
DELETING FILES AND FOLDERS
EXERCISE
PRACTICE SESSION |
6. |
CUSTOMISING YOUR DESKTOP
CUSTOMIZING YOUR DESKTOP
CHANGING THE BACKGROUND OF THE DESKTOP
SETTING A SCREEN SAVER
CHANGING THE APPEARANCE OF WINDOWS
CHANGING COLOUR SETTINGS
ADDING BROWSING TOOLS AND USING TOOLBARS
EXERCISE
PRACTICE SESSION
|
|
7. |
ACCESSORIES
MS-PAINT
TOOLBOX
PALETTE
USING BASIC PAINTING TECHNIQUES
FILLING AN AREA OR OBJECT WITH COLOUR
CREATING AN AIRBRUSH EFFECT
NOTEPAD
CALCULATOR
GAMES
EXERCISE
PRACTICE SESSION |
8. |
MS-WORD
FONT LEVEL FORMATTING
ALIGNING TEXT
CREATING BULLETS AND NUMBERED LISTS
CHANGING THE CASE OF THE LETTERS
EXERCISE
PRACTICE SESSION
|
|
9. |
TABLES IN WORD
CREATING A TABLE
FORMATTING CELLS
FORMATTING TABLES
DELETING TABLES
ADDING BORDERS AND SHADINGS
EXERCISE
PRACTICE SESSION |
10. |
PRINTING WORD DOCUMENTS
INSERTING PAGE BREAKS
PAGE SETUP
PAGE ORIENTATION
PAGE LAYOUT
USING PRINT PREVIEW
PRINTING DOCUMENTS
EXERCISE
PRACTICE SESSION |
|
11. |
MS-DOS COMMANDS
DOS
NAMING FILES
FILE COMMANDS
TYPE
DEL
REN
DIR
COPY
DATE
TIME
INTERNAL AND EXTERNAL COMMANDS
EXERCISE
PRACTICE SESSION |
12. |
DIRECTORY HANDLING COMMANDS
HIERARCHICAL STRUCTURE OF FILES
DIRECTORY COMMANDS OF DOS
MKDIR
CHDIR
RMDIR
TREE
DIR
PATH
EXERCISE
PRACTICE SESSION |
|
13. |
INTRODUCTION TO MS-EXCEL
MS-EXCEL
STARTING EXCEL
OPENING A WORK BOOK
GETTING TO KNOW THE EXCEL SCREEN
TITLE BAR
TOOLBARS
MENU BAR
STATUS BAR
SCROLL BAR
FORMULA BAR
MOVING AROUND THE EXCEL SCREEN
CELL AND CELL ADDRESS
NAME BOX
SAVING A WORKBOOK
CLOSING A WORKBOOK
EXITING EXCEL
EXERCISE
PRACTICE SESSION
|
14. |
CREATING AND ENTERING DATA IN WORKBOOKS
CREATING NEW WORKBOOKS
OPENING NEW WORKSHEET
ENTERING DATA
TYPES OF DATA
TEXT
NUMBER
LOGICAL
ERROR
ENTERING DATA INTO CELLS
ENTERING NUMBER
ENTERING NUMBERS AS TEXT
ENTERING DATES AND TIMES
EXERCISE
PRACTICE SESSION
|
|
15. |
CELL MANIPULATION IN WORKBOOKS
SELECTING, MOVING AND DELETING CELLS
SELECTING CELLS
MOVING CELLS
DELETING CELLS
ENTERING DATA SERIES
ENTERING FORMULAS
TOTALLING ROWS AND COLUMNS
EXERCISE
PRACTICE SESSION |
16. |
EDITING WORKBOOKS
CUT, COPY AND PASTE
COPYING FORMULAS
ABSOLUTE, RELATIVE AND MIXED REFERENCE
AUTO COMPLETE
USING UNDO
EDITING A WORKBOOK
FIND AND REPLACE DATA
PERFORMING LANGUAGE CHECKS
EXERCISE
PRACTICE SESSION |
|
17. |
FORMATTING WORKSHEETS
FORMATTING WORKSHEETS
USING NUMBER FORMATTING
FORMATTING DATE AND TIME
FORMATTING TEXT
ALIGNING DATA
CHANGING COLUMN WIDTH
CHANGING ROW HEIGHT
INSERTING PICTURES
INSERT CLIPART
INSERT PICTURE
EXERCISE
PRACTICE SESSION
|
|
Updated January
2005 |
|
CH. NO. |
CONTENTS |
CH. NO. |
CONTENTS |
|
1. |
ADVANCED COMPUTER CONCEPTS
TYPES OF MEMORIES
CACHE
PRIMARY MEMORY
RAM
ROM
SECONDARY MEMORY
FLOPPY DISK
HARD DISK DRIVES
COMPACT DISK
UNITS OF MEMORY
SMART CARD
VIDEO CONFERENCING
VOICE RECOGNITION SYSTEMS
EXERCISE |
2. |
INDENTING TEXT
INDENTING TEXT
SPLIT SCREEN VIEW
PROTECTING DOCUMENTS
EXERCISE
PRACTICE SESSION |
|
3. |
FORMATTING PARAGRAPHS
FORMATTING PARAGRAPHS
ALIGNMENT
INDENTS AND SPACING
TAB STOPS
SETTING TAB STOPS
CLEARING TAB STOPS
EXERCISE
PRACTICE SESSION |
4. |
WORDART, CLIPART, HEADERS & FOOTERS
FORMATTING USING WORDART
INSERT PICTURES USING CLIPART
ADDING HEADERS AND FOOTERS
EXERCISE
PRACTICE SESSION |
|
5. |
USING MAIL MERGE
MAIN DOCUMENT
SPECIFYING THE DATA SOURCE
CREATING A NEW DATA SOURCE
ADDING MERGE FIELDS TO MAIN DOCUMENT
MERGING DATA
EXERCISE
PRACTICE SESSION |
6. |
USING LABELS
CREATING AND PRINTING LABELS
EXERCISE
PRACTICE SESSION |
|
7. |
FORMATTING WORKBOOKS
SELECTING A RANGE
INSERTING CELLS AND CELL RANGES
DELETING CELL AND CELL RANGES
INSERTING ROWS AND COLUMNS
MOVING AMONG WORKSHEETS
SELECTING WORKSHEETS
INSERTING SHEETS
DELETING SHEETS
EXERCISE
PRACTICE SESSION |
8. |
CHARTS
INSERTING CHARTS
CHART TERMS
CHOOSING THE TYPE OF CHART
LINE CHARTS
PIE CHARTS
SCATTER CHART
BAR CHART
AREA CHART
USING CHART WIZARD
EXERCISE
PRACTICE SESSION |
|
9. |
VIEWING, DRAWING & PRINTING
VIEWING THE WORKSHEET
SPLITTING AND FREEZING A WORKSHEET
SPLITTING
FREEZING
ADDING HEADERS AND FOOTERS.
WORKING WITH PAGE SETUP
SETTING MARGINS
SETTING A PRINT AREA
USING PRINT PREVIEW AND PRINTING
PRINT PREVIEW
PRINTING
EXERCISE
PRACTICE SESSION |
10. |
MS-ACCESS
INTRODUCTION TO ACCESS 97
WHAT IS ACCESS
WHAT IS DATA
WHAT IS DBMS
STARTING ACCESS
OPENING A DATABASE WINDOW.
INTRODUCTION TO DATABASE WINDOW
GETTING TO KNOW THE ACCESS SCREEN
TITLE BAR
MENU BAR
TOOLBARS
SAVING AND CLOSING A DATABASE FILE
SAVING
CLOSING
EXITING ACCESS
EXERCISES
PRACTICE SESSION |
|
11. |
INTRODUCTION TO POWERPOINT
INTRODUCTION TO POWERPOINT
WHAT IS POWERPOINT?
STARTING POWERPOINT
OPENING A PRESENTATION
POWERPOINT SCREEN
TITLE BAR
MENU BAR
STATUS BAR
TOOLBARS
SCROLL BAR
CLOSING A PRESENTATION
EXITING POWERPOINT
EXERCISE
PRACTICE SESSION |
12. |
CREATING NEW PRESENTATION
CREATING A NEW PRESENTATION
USING THE AUTOCONTENT WIZARD
SAVING A PRESENTATION
EXERCISE
PRACTICE SESSION |
|
13. |
USING MASTERS
THE SLIDE MASTER
EXERCISE
PRACTICE SESSION |
14. |
VIEWS IN POWER POINT
POWERPOINT VIEWS
SLIDE VIEW
OUTLINE VIEW
SLIDE SORTER
NOTES PAGES VIEW
SLIDE SHOW BUTTON
EXERCISE
PRACTICE SESSION |
|
15. |
WORKING WITH SLIDES
MOVING BETWEEN SLIDES
INSERTING AND DELETING SLIDES
ENTERING AND EDITING TEXT
ENTERING TEXT IN A PLACEHOLDER
ENTERING TEXT IN TEXT BOXES
CUT, COPY AND PASTE
EXERCISE
PRACTICE SESSION |
16. |
FORMATTING TEXT
ENHANCE THE PRESENTATION
CHANGING THE TEXT FORMATS
ADDING BULLETS
SETTING AND CLEARING TABS
ALIGNING TEXT
SLIDE COLOUR SCHEME
EXERCISE
PRACTICE SESSION |
|
17. |
CUSTOMISING PRESENTATION
SELECTING A SLIDE LAYOUT
USING THE UNDO BUTTON
CHANGING SLIDE LAYOUTS
CHANGING TEMPLATES
EXERCISE
PRACTICE SESSION |
18. |
ADDING OBJECTS IN PRESENTATIONS
ADDING CLIP-ART TO YOUR PRESENTATION
ADD GRAPHIC OBJECTS
EXERCISE
PRACTICE SESSION |
|
19. |
CHARTS AND DRAWINGS
ADDING A CHART SLIDE
EDITING A CHART
EXERCISE
PRACTICE SESSION |
20. |
CUSTOMISING CHARTS
ADDING TITLES TO A CHART
CHART TITLE ALIGNMENT
CHANGING CHART COLOURS
EXERCISE
PRACTICE SESSION |
|
21. |
SLIDE SHOW
CUSTOMISING THE SLIDE SHOW
SET TRANSITIONS
EXERCISE
PRACTICE SESSION |
22. |
AUTOMATING SLIDE SHOW
ANNOTATING A SLIDE SHOW
AUTOMATING A SLIDE SHOW
ANIMATING OBJECTS
SETTING PRESET ANIMATIONS
SETTING CUSTOM ANIMATIONS
INTERACT WITH OBJECTS
EXERCISE
PRACTICE SESSION |
|
23. |
PROBLEM SOLVING
PROBLEM DEFINITION
DIFFERENT METHODS OF PROBLEM SOLVING
ALGORITHMS
SYMBOLS USED IN ALGORITHM
SEQUENCE
SELECTION
REPETITION
ITERATION
LOOPING
FLOW CHART
FLOWCHARTING SYMBOLS
INPUT/OUTPUT SYMBOLS
FLOWLINES
PROCESSING SYMBOL
DECISION SYMBOL
CONNECTOR SYMBOL
PREPARE/INITIALIZE
EXERCISE |
24. |
FLOWCHARTING
ALPHANUMERIC AND NUMERIC DATA
NUMERIC DATA
ALPHANUMERIC DATA
CONSTANTS
NUMERIC CONSTANTS
ALPHANUMERIC OR STRING CONSTANTS
VARIABLES
NUMERIC VARIABLES
ALPHANUMERIC OR STRING VARIABLES
OPERATORS
ARITHMETIC OPERATORS
RELATIONAL OPERATORS
LOGICAL OPERATORS
EXAMPLES OF FLOWCHARTING
EXERCISE |
| |
|
|
Updated January
2005 |
|
CH. NO. |
CONTENTS |
CH. NO. |
CONTENTS |
|
1. |
COMPUTER LANGUAGES
COMPUTER LANGUAGES
HIERARCHY OF PROGRAMMING LANGUAGES
MACHINE LANGUAGE
ASSEMBLY LANGUAGE
HIGH-LEVEL LANGUAGE
COMPILERS
INTERPRETERS
ASSEMBLERS
CHARACTERISTICS OF LANGUAGES
PROCEDURAL AND NON PROCEDURAL LANGUAGES
SOME HIGH LEVEL LANGUAGES
FORTRAN
COBOL
BASIC
PASCAL
COMPARISON OF HIGH LEVEL LANGUAGES
DIFFERENCE BETWEEN A LANGUAGE AND A PACKAGE
EXERCISES |
2. |
DISCRETE MATHEMATICS AND LOGIC
BIT, NIBBLES AND BYTE
WORD LENGTH
CHARACTER REPRESENTATION
THE BINARY CONCEPT
BINARY NUMBER SYSTEM
DECIMAL SYSTEM
OCTAL SYSTEM
HEXADECIMAL SYSTEMS
EXERCISE |
|
3. |
SIMPLE CONVERSIONS FROM DECIMAL
DECIMAL TO BINARY
DECIMAL TO OCTAL
DECIMAL TO HEXADECIMAL
BINARY TO DECIMAL
OCTAL TO DECIMAL
HEXADECIMAL TO DECIMAL
BINARY ADDITION
BINARY SUBTRACTION
BINARY MULTIPLICATION
BINARY DIVISION
EXERCISE |
4. |
PROBLEM SOLVING
ALGORITHMS
SYMBOLS USED IN ALGORITHM
SEQUENCE
SELECTION
REPETITION
ITERATION
LOOPING
PSEUDOCODE
CHARACTERISTICS OF A GOOD PROGRAM
THE PROGRAMMING PROCESS
PROBLEM UNDERSTANDING AND DEFINING A PROBLEM
PROGRAM DESIGN
MODULAR PROGRAMMING
TOP-DOWN DESIGN
STRUCTURED PROGRAMMING
DESIGNING A SOLUTION
DOCUMENTATION
PROGRAM ANALYSIS AND SPECIFICATIONS
CODING
DEBUGGING
TESTING
EXERCISE |
|
5. |
BASIC ARITHMETIC OPERATIONS
HIERARCHY OF OPERATIONS
USE OF PARENTHESIS
EXPONENTIATION
USE OF COMMA (,)
USE OF SEMICOLON (;)
CONSTANTS – NUMERIC AND ALPHANUMERIC
NUMERIC CONSTANTS
RULES FOR NUMERIC CONSTANTS
ALPHANUMERIC OR STRING CONSTANTS
VARIABLES
RULES FOR CODING VARIABLES:
NUMERIC VARIABLES
ALPHANUMERIC OR STRING VARIABLES
EXERCISE |
6. |
SYSTEM COMMANDS
AUTO
CONT
DELETE
EDIT
LIST
LOAD
NAME
KILL
NEW
MERGE
RENUM
RESET
RUN
SAVE
SYSTEM
TRON
TROFF
EXERCISE |
|
7. |
PROGRAMMING TECHNIQUES
MODES OF BASIC OPERATION
PRINTING PROMPTS FOR THE USER
INPUT STATEMENT
OUTPUTTING THE DATA: PRINT STATEMENT
EXERCISE |
8. |
PRINT CONTROL
FORMATTING THE OUTPUT: COMMA CONTROL
MAKING TABLES: THE TAB FUNCTION
PRINT USING STATEMENT
OUTPUT OF NUMERIC VALUES
THE # CHARACTER
THE . CHARACTER (DECIMAL POINT)
THE , CHARACTER
THE + CHARACTER
OUTPUT OF STRING VALUES
EXERCISE |
|
9. |
QUICK BASIC
INTRODUCTION TO QUICK BASIC
STATEMENTS IN QUICK BASIC
CHARACTER SET
CONSTANTS – NUMERIC AND ALPHANUMERIC
NUMERIC CONSTANTS
RULES FOR NUMERIC CONSTANTS
ALPHANUMERIC OR STRING CONSTANTS
VARIABLES
RULES FOR CODING VARIABLES:
NUMERIC VARIABLES
ALPHANUMERIC OR STRING VARIABLES
EXPRESSIONS – NUMERIC & ALPHABETIC
NUMERIC EXPRESSION
ALPHABETIC EXPRESSION
OPERATORS
ARITHMETIC OPERATORS
RELATIVE OPERATORS
LOGICAL OPERATORS
EXERCISE |
10. |
STATEMENTS
REM STATEMENT
STOP STATEMENT
END STATEMENT
LET STATEMENT
PRINT STATEMENT
INPUT STATEMENT
EXAMPLES
EXERCISES |
|
11. |
TRANSFER OF CONTROL
JUMPING: THE GOTO STATEMENT
LOOP CONTROL
BRANCHING: THE IF…THEN STATEMENT
IF….THEN….ELSE
COUNTERS AND ACCUMULATORS
IF…THEN WITH COUNTERS
IF….THEN WITH ACCUMULATORS
IF…THEN WITH LOGICAL OPERATORS
EXAMPLES
EXERCISE |
12. |
THE FOR….NEXT LOOP
SERIES PROGRAMS – FOR…NEXT STATEMENT
EXAMPLES
EXERCISE |
|
13. |
MS ACCESS 97
WHAT IS DATA
WORKING WITH DATABASES
USING THE DATABASE WIZARD
WHAT IS A DATABASE
WORKING WITH TABLES
CREATING A NEW DATABASE
OBJECTS
ADDING TABLES TO A DATABASE
EXERCISES
PRACTICE SESSION |
14. |
FIELDS IN TABLES
FIELDS AND RECORDS
SETTING FIELD PROPERTIES
ADDING FIELDS
WORKING WITH DATASHEETS
ENTERING DATA
MOVING BETWEEN RECORDS AND FIELDS
USING GO TO
UPDATING RECORDS
EXERCISES
PRACTICE SESSION |
|
15. |
MANIPULATING RECORDS
SELECTING ROWS AND COLUMNS
FINDING RECORDS
CHANGING COLUMN WIDTH
ADDING AND SORTING RECORDS
ADDING RECORDS
SORTING RECORDS
SAVING A DATASHEET
EXITING DATASHEET VIEW
EXERCISES
PRACTICE SESSION |
16. |
TABLES
SETTING A PRIMARY KEY
SAVING A TABLE
CLOSING A TABLE
CREATING A QUERY
EXERCISES
PRACTICE SESSION |
|
17. |
USING FORMS
WHAT IS A FORM
USING AN AUTOFORM
CREATING A FORM
EXERCISES
PRACTICE SESSION |
18. |
DESIGN VIEW
APPLYING AN AUTOFORMAT
FORMATTING A CONTROL
EXERCISES
PRACTICE SESSION |
|
19. |
REPORTING TOOLS
WHAT IS A REPORT?
DESIGNING A REPORT
GROUPING RECORDS IN A REPORT
SORT AND SUMMARY ORDER
PREVIEWING, PRINTING AND SAVING A REPORT
CHANGING A REPORT LAYOUT
APPLYING AN AUTOFORMAT
FORMATTING A CONTROL
CREATING MAILING LABELS
EXERCISES
PRACTICE SESSION |
|
Updated January
2005 |
|
CH. NO. |
CONTENTS |
CH. NO. |
CONTENTS |
|
1. |
ADVANCED MS-DOS COMMANDS
FILES REQUIRED FOR MS-DOS
INTERNAL AND EXTERNAL COMMANDS
DIR
OPTIONS WITH DIR
COPYING & FORMATTING FILES
FORMATTING
DISKCOPY
COPY vs DISKCOPV
DISKCOMP
CHKDSK
XCOPY
EXERCISE
PRACTICE SESSION |
2. |
MORE OF DOS
DELETING AND LOADING EXECUTABLE FILES
WILD CARDS
BATCH PROCESSING COMMANDS
CREATING BATCH FILES IN DOS
EXECUTING A BATCH FILE
DOS AND ROM BIOS
WORKING OF DOS
THE DISK BOOTSTRAP
THE BASIC INPUT/OUTPUT SOFTWARE
THE FILE AND DISK MANAGER
THE COMMAND PROCESSOR
PHYSICAL LAYOUT OF THE DISK
BOOT SECTOR
FILE ALLOCATION TABLE
DIRECTORY AND DATA AREA
HIERARCHICAL STRUCTURE OF FILES
EXERCISES
PRACTICE SESSION |
|
3. |
CONTROL STATEMENTS
STOP STATEMENT
TRANSFER OF CONTROL
THE GOTO STATEMENT
LOOP CONTROL
BRANCHING: THE IF…THEN STATEMENT
IF….THEN….ELSE
COUNTERS AND ACCUMULATORS
IF…THEN WITH COUNTERS
IF….THEN WITH ACCUMULATORS
IF…THEN WITH LOGICAL OPERATORS
THE FOR….NEXT LOOP
EXERCISES |
4. |
PROGRAMS
OF FOR…NEXT AND IF…THEN |
|
5. |
LIBRARY FUNCTIONS
FUNCTIONS AND THEIR TYPES
MATHEMATICAL (OR NUMERIC FUNCTIONS)
SQR FUNCTION
INT FUNCTION
ABS FUNCTION
MOD FUNCTION
CINT FUNCTION
SGN FUNCTION
FIX FUNCTION
EXP FUNCTION
ASC FUNCTION
CHR$ FUNCTION
EXERCISES
PRACTICE SESSION |
6. |
READ DATA STATEMENT
READ DATA STATEMENT
DATA BLOCK
THE RESTORE STATEMENT
EXERCISE
PRACTICE SESSION |
|
7. |
OPERATION MODES
BATCH PROCESSING
TIME SHARING
REAL TIME SYSTEMS
ON LINE AND OFFLINE SYSTEMS
DISTRIBUTED PROCESSING
MUTIPROCESSING
MULTIPROGRAMMING
COMPUTER NETWORKS
DATA COMMUNICATIONS
LAN & WAN
LAN
TOPOLOGIES OF NETWORK
STAR NETWORK
MULTI-POINT OR BUS NETWORK
RING NETWORK
TREE TOPOLOGY NETWORK
WAN
ADVANTAGES OF NETWORKING
EXERCISES |
8. |
PROJECTS
Updated January
2005 |