Introduction to Computers
Computers in Our World
Introduction
Necessity is the Mother of Invention
Capabilities of a computer
Classification of Computer
Application of Computers
Generation of computers
Addition Reading
Brief History of Computers
Computers and Hardware
Computer System
Input/Output Devices
Central Processing Unit abbreviated(CPU)
Brief Introduction to Memory
In Computers Everything is Binary
Input Data : Sources & Concepts
2
Keyboard
Graphical Input Devices
Those using Special Sensitivity
Those which senses Magnetic Ink
Industrial Robots
Output Devices and storage devices
¨ Why output is needed
¨ Monitor
¨ Printers
¨ Impact
¨ Non-impact Printers
¨ Plotters
¨ Storage Device
¨ Primary Devices
¨ Secondary Devices
¨ Magnetic Disks
¨ Those mounted in the computer
¨ Those which can be removed and used on various machines
Computer Software & Data Communication
¨ Computer Software
¨ Application Software & System Software
¨ Computer and Data Communication
¨ Advantages of Data Communication
¨ concept of network
¨ Classification according to the area covered by network
Operating System
¨ Introduction to Operating System
¨ Booting Procedure
¨ Types of Files
¨ DOS PROMPT
¨ Introduction to Dos Commands
Understanding DOS-I
¨ Internal DOS Commands
¨ Wild Card Character in Dos
¨ Directory Related Commands
¨ File Related Commands
Understanding DOS II
¨ External DOS Commands AND Utilities
Filters & Redirection
¨ Redirection
¨ Input Redirection of a command
¨ Filter Commands
¨ Connecting Pipe
¨ Combining Redirection and Filters
Batch files
¨ Techniques of batch Files
¨ Create your first batch file
¨ Suppressing of On-screen display of commands
¨ Decision making with Batch files
3
Operating System – MS DOS
Importance of an Operating System
A Guarantee to an Instant Start on MS-DOS
Getting Started on DOS with Booting the System
MSDOS.SYS
Command COM
Telling DOS the Data and Time
Concepts Review
Getting and Interpreting a Directory
Making use of Pause Key to freeze scrolling
Getting a Printed Copy of a Directory
Using Wild Card Character
What is a Wild Card Character ?
Concepts Review
Making use of Hierarchical Directories
What are Hierarchical Directories ?
Hierarchical Directory System
Making use of MKDIR or MD command
Making use of CHDIR or CD command
Making use of the RMDIR or RD command
Concepts Review
Copying commands
Copy command
Copy Source file Destination file
Disk copy source Destination
Concepts Review
Displaying the file contents
Syntax
Type Filename
Print Filename(s)
DEL Filename(s)
Erase Filename(s)
Formatting Disks
FORMAT <DRIVE:>/<SWITCHES>
Renaming Files
Rename Original Filename New filename
Clearing the Screen
Displaying the Version Number
VER
Find
Sort Filename
INTRODUCTION TO WINDOWS 2000
Introduction to Operating System
What is an Operating system ?
Why is it required ?
What are the types of an Operating System ?
What are the functions of an Operating System ?
Terms often used for Windows 2000
Introduction to Windows 2000
Specialties of Windows 2000
Terms often used in Windows 2000
4
TASKBAR -WHAT IS GOING ON ?
What is the Taskbar ?
What are its functions ?
Launching of applications with help of Launching Pad
Explanation of title bar and buttons
Switching between applications
Changing the size and position of the Taskbar
Properties of the Taskbar
DESKTOP – HOW DO I LOOK ?
Introduction to the Desktop
Main Icons on the Desktop
Properties of the Desktop
AN APPLET TEMPORARILY KEEPS APPLICATIONS AWAY
what does an Applet mean ?
Different Applets under Windows 2000
Clipboard Viewer
Character Map
Calculator
Clock
Games
Media Player
Paint
Sound Recorder
WordPad & Notepad
RECYCLE BIN – FLUSHING IS REQUIRED
Introduction to Recycle Bin
Working with Recycle Bin
Properties of Recycle Bin
MY BRIEFCASE – TAKE ME HOME
What is Briefcase in Windows 2000 ?
Linking files from the main computer to the laptop
Copying back the updated files
WINDOWS EXPLORER-NOTHING IS HIDDEN FROM ME
Two modes in which Windows Explorer works
My Computer
Windows Explorer
File Management Tools under Windows Explorer
NETWORK NEIGHBORHOOD-LOVE THY NEIGHBORS
Introduction
Network Neighborhood in Open window
Network Neighborhood in Explore window
Sharing
Sharing of files and folders
Sharing of hard disk
Sharing of Printers
Connecting a device temporarily
CONTROL PANEL-MY TOOL KIT
Introduction to Control Panel
Tools under Control Panel
Accessibility Options
Add new Hardware
Add Remove Programs
Date/Time
5
Display
Fonts
Keyboard
Mouse
Multimedia
32bit ODIALOG BOXC
Passwords
Printers
Regional Settings
Sounds
SHORTCUTS-SHORT BUT STRONG CUTS
What are shortcuts ?
Creating a shortcut on the Desktop
Creating a shortcut in the Start menu
Short-cut for Send To
Properties of short-cut
IN-BOX LET’S TALK WITH THEWHOLEWORLD
At a glance :
Introduction to In Box
Sending & Receiving e-mail
Sending & Receiving Fax
MULTIMEDIA-SINGING ALL THEWAY
What is a multimedia ?
Playing of a CD with CD Player
Playing of a CD with Media Player
Working with a Sound Recorder
INTRODUCTION TO MS OFFICE-2000
What is Windows
What is suite of Software
Selecting in Office Programs
Using Tools and Menus
Working in Documents
Cutting, Copying, and pasting
Saving a Document
Getting Help
Advantages of Word Processing under Windows
Various Word Processors available under Windows
Introduction to MSWord-2000
Opening a New Document
Opening an Existing Document
Recently opened files
Opening from the Documents menu
Exporting and Importing Files
Setting Up Your Pages
Choosing page Size and Orientation
Changing page Size
Changing Orientation
Setting Margins
Centering Page
Controlling Page Breaks
6
Typing in the Document
Inserting Today’s Date
Moving Around in the Document
Creating Sections
Inserting a Section break
Formatting a Section
Viewing Sections
Using Columns
Numbering Pages
On Your Own
Saving a File
Quitting Word
Formatting Text
Formatting Characters
Choosing Fonts
Enhancing Text Appearance
Inserting Special Characters
Changing Character Spacing
Formatting Paragraphs
Aligning Paragraphs
Indenting Paragraph
Setting Tabs
Changing Line Spacing
Adding Borders and Shading
Creating a Bulleted List
Creating a Numbered List
On Your Own
Selecting Styles
Selecting Text
Deleting Text
Correcting Mistakes
Using Undo
Using Redo
Using Auto Correct
Moving Text
Using Menu Commands to Move Text
Using Drag-and-Drop Editing
Copying text
Checking Your Document
Finding and Replacing Text
Finding Text
Replacing Text
Checking Your Spelling
Checking Your Grammar
Looking Up Words in the Thesaurus
Inserting a Picture from the Clip Art Gallery
Inserting a Picture
Adding a Border
Creating Headers and Footers
Adding Footnotes and Endnotes
Working with Tables and Graphics
Use a Wizard to help create and format a table.
Enter and edit data in a table.
7
Add borders and shading to a table.
Convert a table to text.
Add clip art to a document
Using Wizard to Create and Format a Table
Starting the Table Wizard
Using Table Auto Format
Entering Data into a Table
Moving Around in the Table
Entering Text
Working with Columns and Rows
Inserting and Selecting Columns and Rows
Deleting Columns and Rows
Inserting Columns and Rows
Changing Cell Height
Adding Borders and Shading
Applying Shading
Converting Text into a Table
Mail Merge
What is a Mail Merge ?
Setting up the mail merge
Creating a main document
Building the data source
Placing the merge fields
Templates, Wizards and Printing Techniques
Understanding Templates
Using Templates
Using Wizards
Printing Techniques
Viewing the Document before Printing
Viewing the Document before Printing
Changing to Print Preview
Using Print Preview
Printing Your Document
MS EXCEL-2000
INTRODUCTION TO EXCEL
Introduction to spreadsheets
Introduction to excel
File management in excel
Create a new workbook
Moving around in the worksheet
Entering data
Check spelling or automatically correct spelling errors
Selecting cells
Auto fill feature of excel
Quick data entry
Auto sum facility of excel
Auto format in excel
Quick movement
8
FORMATTING
Changing column width
Modifying row height
Changing font, size and style
Changing alignment of text
Wrapping of text
Vertical alignment of cells
Special formatting
Conditional formatting
ADDING FORMULATE AND FUNCTIONS
About formulae
Adding a formula in cell
Copying of formula
About functions
Adding a function
Copying of functions
Discussion of some useful functions
LARGE DATABASES
Create list
Editing records with data form
Data validation
Performing what if analysis
Annotating worksheet
Re-orienting worksheet
Pivot tables
Special facilities of wizard
ADDITIONAL FACILITIES TO FORMAT DATA
Inserting rows and columns
Giving quarterly subtotals
Hide and unhide
Grouping and outline
Sorting
Filtering of data
Adding subtotals
CHARTS AND MAPS
Chart
Move, resize and delete the chart
Change the chart type
Add new data to a chart
Updating chart items
Formatting patterns, texture and colors of bars
Creating a picture graph
Background
Trend lines in charts
Maps
Update the map
Format the map items
WORK WITH MULTIPLE WORKSHEETS
Switching between worksheets
Move or copy data from one worksheet to another
9
Insert a new worksheet
Reference to cells of other worksheet
Giving workbook name in the address
Renaming a worksheet
Moving a worksheet
Copying the worksheet
Deleting a worksheet
PRINTING IN EXCEL
Giving header and footer
Putting company name in the header
Giving the footer
Setting up the page
Insert a page break
Previewing the worksheet
Printing of the worksheet
IMPORTING AND EXPORTING OF DATA
Introduction to import and export of data
Importing and exporting data between excel and other
Office applications
View or save files from other programs as excel
Workbooks
Ways to retrieve data from an external database
Exchange data between excel and Microsoft access
MS Power Point-2000
Introduction
Applications of Power Point
File Management in Power Point
Starting of Power Point
Create the First Slide
Creating a New Slide
View the Presentation
Saving a Presentation
Close the Presentation
Create a New Presentation
Close Power Point
Changing Views
Add Text and other Objects to Slides
Enter Text
Edit Text
Format Text
Create Objects
Format the Objects
Grouping of objects
Add Clip Art
Create a Table
Add a Chart
Add Organization Chart
Templates and Master Slides
Changing the Color Schemes
Background settings of Slides
10
Concept of Master Slides
Adding Header and Footer
Applying a Readymade Design
Recorder of Slides
Giving Animation effects
Introduction to Animation Effects
Giving Build Effects
Customize Build Effects
Giving Transition Effects
Adding Transitions to a Slide
Links and Action buttons
Import a Word Document
Create Macros
Create Action buttons
Create Hyperlinks
Tuning up of Presentation
Introduction
Create a Presentation with Auto Content wizard
Performing a Rehearsal
Creating Custom Slide Show
Printing of Presentation
Pack and Go wizard
MS Access-2000
INTRODUCTION
Starting access 97
Opening an existing database
Opening the sample north window database
What is a database?
Managing database objects
UNDERSTANDING DATABASES
Why store data ?
You use tables to store data
Terminology time
Why use multiple tables ?
CREATING DATABASES
Introduction
Database is not a table
Creating a blank database
Using the file new database dialogue box
CREATING TABLES
Using the table wizard
Object naming rules
Planning a table from scratch
Creating a table without using a wizard
Defining a tables fields
Choosing appropriate data types
Defining field properties
Setting a primary key
Defining indexes
Saving a table structure
Switching between design and datasheet views
11
Changing properties
About lookup fields
ADDING, EDITING AND VIEWING DATA
Datasheet view and form view
Changing the datasheet appearances
Navigating forms and datasheets
Changing data in a table
Deleting data
Copying and moving data
Special techniques for memo fields
Duplicate key message
Null value in index
Validation rule
Changing the table design from datasheet view
Creating a table from a blank datasheet
SORTING
Introduction
Quick and easy sorting
Sorts within sorts
Filtering out unwanted records
Using advanced filter/sort
Creating complex filters
Specifying selection criteria
Specifying ‘and/or’ criteria
Sample filters
Saving a filter as a query