Essential Introduction to Computers
- Input Devices
-
System Unit
- Microsoft Windows XP Professional
- Windows XP Desktop
- Starting an Application Program
- Windows Explorer
- Creating a Document and Folder in Microsoft Word
- File Management in Windows Explorer
- Finding Files or Folders
- Using Help and Support
- What is the Microsoft Office 2003 suite
- Output Devices
- Storage Devices
- Communication Devices
- Computer Software
- Networks and the
Internet
- How to Purchase a
Computer
Microsoft Access 2003 Creating and Using a Database
- What is Microsoft Office Access 2003?
- Starting Access
- Creating a New Database
- The Access Window
- Creating a Table
- Adding Records to a Table
- Quitting Access
- Opening a Database
- Additional Records
- Previewing and Printing the Contents of a Table
- Creating Additional Tables
- Using Queries
- Using a form to View Data
- Creating a Report
- Access Help System
- Quitting Access
- Designing a Database
Querying a Database Using the Select Query Window
- Creating and Running Queries
- Entering Criteria
- Sorting Data in a Query
- Joining Tables
- Calculations
- Crosstab Queries
Maintaining a Database Using the Design and
Update Features of Access
- Updating Records
- Filtering Records
- Changing the Structure
- Changing the Appearance of a Datasheet
- Mass Changes
- Validation Rules
- Referential Integrity
- Ordering Records
- Creating and Using Indexes
- Special Database Operations
Microsoft Excel 2003 Creating a Worksheet and an Embedded Chart
- What is Microsoft Office Excel 2003
- Starting and Customizing Excel
- The Excel Worksheet
- Worksheet Window
- Selecting a Cell
- Entering Text
- Entering Numbers
- Calculating a Sum
- Using the Fill Handle to Copy a Cell to Adjacent
Cells
- Formatting the Worksheet
- Using the Name Box to Select a Cell
- Adding a 3-D Clustered Column Chart
- Saving a Workbook
- Printing a Worksheet
- Quitting Excel
- Starting Excel and Opening a Workbook
- AutoCalculate
- Correcting Errors
- Excel Help System
Formulas, Functions, Formatting, and Web Queries
- Entering the Titles and Numbers into the Worksheet
- Entering Formulas
- Using the AVERAGE, MAX, and MIN Functions
- Verifying Formulas Using Range Finder
- Formatting the worksheet
- Checking Spelling
- Previewing and printing the Worksheet
- Displaying and printing the Formulas Version of
the Worksheet
- Importing External Data from a Web Source
- Changing the Worksheet Names
- Emailing a Workbook from within Excel
What-If Analysis, Charting, and Working with
Large Worksheets
- Rotating Text and using the Fill Handle to Create
a Series
- Copying a Cell’s Format Using the Format Painter
Button
- Copying a Range of Cells to a Nonadjacent
Destination Area
- Inserting and Deleting Cells in a Worksheet
- Entering Numbers with Format Symbols
- Freezing Worksheet Titles
- Displaying a System Date
- Absolute versus Relative Addressing
- Making Decision – The IF Function
- Formatting the Worksheet
- Adding a 3-D Pie Chart to the Workbook
- Renaming and Reording the Sheets and Coloring
Their Tabs
- Changing the View of the Worksheet
- What-If Analysis
Microsoft Word 2003 Microsoft Office Word 2003
- The Word Window
- Entering Text
- Saving a Document
- Formatting Paragraphs and Characters
- Inserting Clip Art
- Correcting Errors
Creating Research Paper
- MLA Documentation Style
- Changing the Margins
- Adjusting Line Spacing
- Using a Header to Number Pages
- Typing the Body of a Research Paper
- Creating an Alphabetical Works Cited Page
- Proofing and Revising the Research Paper
Creating a Resume using a Wizard and a Cover
Letter with a Table
- Using Word’s Resume Wizard to Create a Resume
- Personalizing the Resume
- Creating a Letterhead
- Creating a Cover Letter
- Addressing and Printing Envelopes and Mailing
Labels
- Smart Tags
- Document Summary
Microsoft PowerPoint 2003 Using a Design Template and Text Slide Layout to
Create a Presentation
- What is Microsoft Office PowerPoint 2003
- Starting and Customizing PowerPoint
- The PowerPoint Window
- Choosing a Design Template
- Creating a Title Slide
- Text Attributes
- Adding a New Slide to a Presentation
- Creating a Text Slide with a Single-Level Bulleted
List
- Creating a Text Slide with a Multi-Level Bulleted
List
- Moving to Another Slide in Normal View
- Viewing the Presentation in Slide Show View
- Printing the Presentation
Using the Outline Tab and Clip Art to Create a
Slide Show
- Using the Outline Tab
- Creating a Presentation on the Outline Tab
- Adding a Slide on the Outline Tab
- Creating Text Slides with Multi-Level Bulleted
Lists on the Outline Tab
- Adding Clip Art to a Slide
- Changing the Size of clip Art
- Adding a Header and Footer to Outline Pages
- Applying Animation Schemes
- Animating Clip Art
- Running an Animated Slide Show
|
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
YesNo
|
