A first course in Computers: based on Windows XP and office Xp / Sanjay Saxena

Part I
Introduction
Part II
Operating
Systems
1. Introduction to Computers
What is a Computer
What's so Special About Computers
Review^ Questions
2. History of Computers
Evolution
The First Computer
Next Generations
Review Questions
3. Basic Anatomy of Computers
The Basic Components
Functioning of the Components
Memory
Software Componehts
Input/Output Devices
Input Devices
Output Devices
External Storage Devices
Types of Computers
Personal Computer
Work Station
Mainframes :
Supercomputers
Review Questions
4. Operating Systems
Introduction
How Does \Mndows Differ From DOS?
Benefits of )Mndows
Part III 5. Windows XP
MS Introduction
WWiIInIdUoUwWs5 Featurweisn odfo Wwisn xdpo?ws XP
Getting Started
The Desktop
About Icons
Working with Windows
Types of Widows
Moving a Window . _
Minimizing, Restoring and Closing a Window
Resizing a Wndow
Start Menu and the Taskbar
The Start Menu
Switching between AH Programs
Using Windows Help and Support
Quitting Wndows
Wndows Explorer—Files and Folders
About Files and Folders
Starting Wndows Explorer
Moving Files
Copying Files by Click and Drag Method
Copying Multiple Files
Copying a Continuous Range of Files
Renaming a File
Deleting Files
Searching a File or Folder
The Recycle Bin
The Control Panel
Change or Remove Programs
Add New Programs
Adding or Removing Windows Components
Date and Time
Changing the Date and Time
Setting the Time Zone
Display
The Screen Saver
Wallpaper or Background
Customizing Your Desktop
Fonts f
Mouse
Button Configuration
Pointer Configuration
Motion Configuration
Mouse Pointers
Printers and Faxes
Scaimers and Camera
Sound and Audio Devices
Sounds
System Properties
Taskbar and Start Menu Settings
User Accounts
Network
Accessories
Media Playe*'
Calculator
Disk Defiragmenter
Notepad
Paint
Games
Windows Tour , ^
Help and Support Center
6. Windows Vista
Introduction
Background
The Early Nineties
Year 2000 and Later
Windows Vista
Guidelines for Basic Home Users Computer Setup
Welcome Center Windows Easy Transfer
Windows Experience Index New User Experiences
>\^ndowsAero User Experience Start Menu
Windows \^sta Start Menu >^ndows XP Start Menu
New Windows Vista Explorers User Interface:
Navigation and Usage Internet Explorer 7
Conclusion
Partly 7. MS Office XP
MS Office About MS Office
Why MS Office
8. MS Office 2007
Introduction Background New Offerings at a Glance
Editions New Features User Interface
The Office Button Ribbon Contextual Tabs
Mini Toolbar Super Tooltips Quick Access Toolbar
Zoom Slider SmartArt File Formats
User Assistance System Microsoft Office Groove 2007
Themes and Quick Styles What's New?
Microsoft Office Word 2007 Outlook Excel
Powerpoint OneNote Access
Publisher Infopath Visio Project
Microsoft Sharepoint Designer Server components
PartV Word Basics
MS Word Introduction
Starting Word
Creating Documents
Parts of Word "Window
Mouse Operations
Keyboard Operations
Individual Keys
Things to Avoid
Formatting Features
Menus, Commands, Toolbars and their Icons
LEARN BYDOD4G
yford Exercise-I .
Starting MS Word
Word Exercise-U
New Document
Entering Text
Entering Text in Text Box
Changing Font
Changing Font Size
Altemative Method
Aligning the Text
Italicizing the Text
Numbering
Bullets
Spelling
Print Preview
Print
Saving Documents
Closing the Document
Opening the Document
Exiting MS Word
Word Exercke-IU
Creating a Template
Creating Tables
Creating More Tables
Inserting Columns
Inserting Rows
Moving Tables
Drawing a Table
Text Box
Formatting
Insert Picture
Formatting a Picture
Formatting Text
Changing Fonts and Text Size
Print Preview
Save
Creating Documents based upon Template
Review Questions
10. Mail Merge
Word Exercise-rV
Creating the Main Document
Creating Data Source
Adding Fields
Removing Fields
Review Questions
11. Macros
Introduction
Inserting Header and Footer
Inserting Current Date, Time and Page Numbers
Do-It-Ypurself Exercises (I-XI)
Review Questions
Part VI 12. Excel Basics
MS Excel Introduction
Navigating
Selecting Cells
Selecting Cells with Mouse
Entering and Editing Text
Entering Numbers
Entering Formulas
Entering Dates
Alignment
Some Do's and Uon'ts
Menus, Commands and Toolbars
Standard Toolbar :
Formatting Toolbar
LEARNBY DOING
Excel Exercise-I
Starting Excel
Opening Workbook
Entering Text in Cells
Colunm Width
Alternate Method
Series Fill
Entering Formulas
Copying and Pasting the Formula
Summation
jdv Contents
Fonnatdng Cells
Currency Notation
Centering Across Selection, Changing Font and Size
Column AutoFit
Formatting Text (Bold, Italic)
Inserting Rows
Inserting Columns
Formula
Aligning Data
Formatting Date Range
Print Preview
Page Setup
Inserting Headers & Footers
Saving a File
Opening a File
Excel Exercise-II
Enterin^Text
Summation
Series Fill
Centre Aligning Across Cells
Changing Font lype & Size
Currency Format
Renaming a Worksheet
Copying Text between Worksheets
Deleting Cell Contents
Editing Cell Contents
Copying Data between Worksheets
Deleting Cell Contents
Entering Formula
Pasting the Formula
Creating a Chart
Saving a File
Excel Exercise-III
Starting Excel
What is a Database?
• Data Forms
Review Questions
13. Data Sort
Data Filters
Auto Filters
Valid Criteria
Invalid Criteria
Redundant Criteria
Review Questions
Part VII
MS
PowerPoint
Part VIII
MS Access
Part IX
MS
Outlook
14. Functions
ROUND SQRT AVERAGE
MBSf COUNT ,SUM
ABS ROMAN UPPER
CELL TODAY NOW
Do-It-Yourself Exercises I-VIII
MAX
IF , SUMIF
LOWER
15. PowerPoint Basics
Introduction
Navigating in PowerPoint
Creating a New Presentation
Opening a Presentation
Creating a New Slide
Deleting a Slide
Copying a Slide
Numbering the Slides
Saving a Presentation
Closing a Presentation
Saving a Presentation with a Different Name
Changing the Default Directory
Auto Save
Printing a Presentation
Working with PowerPoint
16. MS Access
Introduction
What is a Database?
Parts of an Access AMndow
Starting Microsoft Access
Creating a New Database
Creating Tables Using Table Wizard
Creating a New Table
Rename Columns
Saving the Database
Relationships
Creating Tables in Design View
Query
Forms
Reports
Exiting MS Access
17. MS Outlook
Introduction
Working with Outlook?
Parts of An Outlook Window
Part VII
MS
PowerPoint
Part VIII
MS Access
Part IX
MS
Outlook
14. Functions
ROUND : SQRT AVERAGE
MIN COUNT JSUM
ABS , ROMAN UPPER
CELL TODAY NOW
16.
MAX
IF SUMIF
LOWER
17.
Do-It-YourselfExercises I-VIII
15. PowerPoint Basics
Introduction
Navigating in PowerPoint
Creating a New Presentation
Opening a Presentation
Creating a New Slide
Deleting a Slide
Copying a Slide
Numbering the Slides
Saving a Presentation
Closing a Presentation
Saving a Presentation with a Different Name
Changing the Default Directory
Auto Save
Printing a Presentation
Working with PowerPoint
MS Access
Introduction
What is a Database?
Parts of an Access )A^dow
Starting Microsoft Access
Creating a New Database
Creating Tables Using Table Wizard
Creating a New Table
Rename Colunms
Saving the Database
Relationships
Creating Tables in Design View
Query
Forms
Reports
Exiting MS Access
MS Outlook
Introduction
Working with Outlook?
Parts of An Outlook )^ndow
Starting Outlook ...
The Address Book
Adding Contacts
Changing View
Finding a Contact
Filtering Contacts
Sorting Contacts
Calendar
Tasks
Journal
Inbox
Receiving E-mails
Notes
Part X 18. Internet Basics
Internet Introduction
Important Features
Intemet Protocols
IP Address
Domain Naming System (DNS) '
Communication Protocols
Connecting to the Intemet
Dial-Up Connections
Digital Subscriber Line (DSL)
Cable Modems
Integrated Services Digital Network (ISDN)
Prerequisites for Intemet
Hardware
Software
Others
Factors Affecting the Speed of Intemet Coimectivity
Configuring the Modem
Configuring a TCP/IP Connection
Search Engine
How Search Engines Work
Preliminary Searching Hints '
Boolean Searching
Using a Search Engine
E-Mail
Creating an E-Mail Account
Sending and Receiving E-Mails
Receiving E-Mails
Intemet Phone
Google Earth