Who We Are
PC Training
Web Site Design
Assessments
PC Systems
Other Services

Portfolio
Contact Info

web site design : web site hosting: graphic design : web development : internet access : ohio

Microsoft Office XP - Illustrated Introductory

Instructor: Robin Hyett
Office Phone: 440.749.3327
Office Hours: 10 am - 6 pm, M-F
E-mail: robin@familydesigns.net

Course Description:

In this course, the student will learn the most important topics of Microsoft Office XP. They are first presented with a quick review of the Office Suite, Windows, and Internet Explorer. Next, they will learn more advanced skills for Word, Excel, Access and PowerPoint; each application is covered in four units. They will learn how to use Object Linking and Embedding (OLE) to create integrated Office documents in four units that follow the Excel, Access, Word, and PowerPoint sections. The last section of the course provides an overview of Outlook.

Text/Materials:

Text: Beskeen/Duffy/Friedrichsen/Reding, Microsoft Office XP - Illustrated Introductory, Course Technology, 2002.
Project files: Spectrum WebFX will provide instructions on a CD of Project files.
Software: Microsoft Office XP, Internet Explorer 5, and Windows 2000 will be used. Another operating system may be used, but students may notice some differences in the appearance of certain dialog boxes.

Teaching Methods:

Lectures/Demonstrations: Important material from the text and outside sources will be covered in each session. Student should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured, outside material relevant to topics being covered.

Assignments: Concepts Reviews, Skills Reviews, Independent Challenges and other projects and readings will be periodically assigned to help support and supplement material found in the lessons. These assignments may require the application of various software applications.

Exams: Three exams will be given. The exams will be open book/note and will test assigned readings and material discussed in class. The final exam will not be comprehensive in nature. However, the instructor reserves the right to retest on material that was not appropriately comprehended.

Course Outline

Microsoft Office XP

Unit A: Introducing Microsoft Office XP

Discussion Topics

  • Define the Office XP Suite
  • Create a document with Word 2002
  • Build a spreadsheet with Excel 2002
  • Manage data with Access 2002
  • Create a presentation with PowerPoint 2002
  • Browse the World Wide Web with Internet Explorer
  • Integrate Office information
  • Merge office tasks with Outlook 2002

Internet Explorer

Unit A: Getting Started with Microsoft Internet Explorer

Discussion Topics

  • Understand Web browsers
  • Start Internet Explorer
  • Explore the browser window
  • Open and save a URL
  • Navigate Web pages
  • Get Help
  • Print a Web Page
  • Search for information on the Internet
  • Exit Internet Explorer

Microsoft Word 2002

Unit A: Getting Started with Word 2002

Discussion Topics

  • Understand word processing software
  • Start Word 2002
  • Explore the Word program window
  • Start a document
  • Save a document
  • Print a document
  • Use the Help system
  • Close a document and exit Word

Unit B: Editing Documents

Discussion Topics

  • Open a document
  • Select text
  • Cut and paste text
  • Copy and paste text
  • Use the Office Clipboard
  • Use the Spelling and Grammar checker and the Thesaurus
  • Find and Replace text
  • Use wizards and templates

Unit C: Formatting Text and Paragraphs

Discussion Topics

  • Format with fonts
  • Change font styles and effects
  • Change line and paragraph spacing
  • Align paragraphs
  • Work with tabs
  • Work with indents
  • Add bullets and numbering
  • Add borders and shading

Unit D: Formatting Documents

Discussion Topics

  • Set document margins
  • Divide a document into sections
  • Add page breaks
  • Add page numbers
  • Insert headers and footers
  • Edit headers and footers
  • Format columns
  • Insert clip art

Microsoft Excel 2002

Unit A: Getting Started with Microsoft Excel 2002

Discussion Topics

  • Define spreadsheet software
  • Start Excel 2002
  • View the Excel window
  • Open and save a worksheet
  • Enter labels and values
  • Name and move a sheet
  • Preview and print a worksheet
  • Get Help
  • Close a workbook and exit Excel

Unit B: Building and Editing Worksheets

Discussion Topics

  • Plan and design a worksheet
  • Edit cell entries
  • Enter formulas
  • Create complex formulas
  • Introduce Excel functions
  • Copy and move cell entries
  • Understand relative and absolute cell references
  • Copy formulas with relative cell references
  • Copy formulas with absolute cell references

Unit C: Formatting a Worksheet

Discussion Topics

  • Format values
  • Use fonts and font sizes
  • Change attributes and alignment
  • Adjust column widths
  • Insert and delete rows and columns
  • Apply colors, patterns and borders
  • Use conditional formatting
  • Check spelling

Unit D: Working with Charts

Discussion Topics

  • Plan and design a chart
  • Create a chart
  • Move and resize a chart
  • Edit a chart
  • Format a chart
  • Enhance a chart
  • Annotate and draw on a chart
  • Preview and print a chart

Integration

Unit A: Integrating Word and Excel

Discussion Topics

  • Understand Integration
  • Open multiple programs
  • Copy Word data into Excel
Quiz 1

Microsoft Access 2002

Unit A: Getting Started with Access 2002

Discussion Topics

  • Define database software
  • Learn terminology
  • Start Access and open a database
  • View the database window
  • Navigate records
  • Enter records
  • Edit records
  • Preview and print a datasheet
  • Get Help and exit Access

Unit B: Using Tables and Queries

Discussion Topics

  • Plan a database
  • Create a table
  • Modify a table
  • Format a datasheet
  • Understand sorting, filtering and finding
  • Sort records and find data
  • Filter records
  • Create a query
  • Modify a query

Unit C: Using Forms

Discussion Topics

  • Plan a form
  • Create a form
  • Move and resize controls
  • Modify labels
  • Modify text boxes
  • Modify tab order
  • Enter and edit records
  • Insert an image

Unit D: Using Reports

Discussion Topics

  • Plan a report
  • Create a report
  • Group records
  • Change the sort order
  • Add a calculation
  • Align controls
  • Format controls
  • Create mailing labels

Integration

Unit B: Integrating Word, Excel and Access

Discussion Topics

  • Merge data between Access and Word
  • Use Mail Merge to create a form letter
  • Export an Access table to Excel
Quiz 2

Microsoft PowerPoint 2002

Unit A: Getting Started with Microsoft PowerPoint 2002

Discussion Topics

  • Define presentation software
  • Start PowerPoint 2002
  • View the PowerPoint window
  • Use the AutoContent Wizard
  • View a presentation
  • Save a presentation
  • Get Help
  • Print and close the file and exit PowerPoint

Unit B: Creating a Presentation

Discussion Topics

  • Plan an effective presentation
  • Enter slide text
  • Create a new slide
  • Enter text in the Outline tab
  • Add slide headers and footers
  • Choose a look for a presentation
  • Check spelling in a presentation
  • Evaluate a presentation

Unit C: Modifying a Presentation

Discussion Topics

  • Open an existing presentation
  • Draw and modify an object
  • Edit drawing objects
  • Align and group object
  • Add and arrange text
  • Format text
  • Import text from Microsoft Word
  • Customize the color scheme and background

Unit D: Enhancing a Presentation

Discussion Topics

  • Insert clip art
  • Insert, crop and scale a picture
  • Embed a chart
  • Enter and edit data in the datasheet
  • Format a chart
  • Create tables in PowerPoint
  • Use slide commands
  • Set slide show timings and transitions
  • Set slide animation effects

Integration

Unit C: Integrating Word, Excel, Access and PowerPoint

Discussion Topics

  • Understand embedding and linking
  • Insert a Word outline into a PowerPoint presentation
  • Embed an Excel chart into a PowerPoint slide
  • Link and Excel worksheet to a PowerPoint slide
  • Update a linked Excel worksheet in PowerPoint
  • Export a PowerPoint presentation to Word

Unit D: Integrating Office Applications with Internet Explorer

Discussion Topics

  • Plan a web application
  • Create a Web page
  • Format a Web page
  • Create a Web page from a Word document
  • Create a Web page from an Access table
  • Create a Web page from an Excel workbook
  • Create Web pages from a PowerPoint presentation
  • Add hyperlinks

Outlook 2002

Unit A: Getting Started with Microsoft Outlook 2002

Discussion Topics

  • Understand email
  • Start Outlook 2002
  • View the Outlook 2002 window
  • Add a contact to the Address Book
  • Create and send new messages
  • Reply to and forward messages
  • Send a message with an attachment
  • Create a distribution list
  • Send a message to a distribution list

Appendix: Beyond Email: Understanding Additional Outlook 2002 Features

Discussion Topics

  • Manage your appointments and tasks
  • Manage your contacts
  • Preview your day
Quiz 3

Register your domain name with Family Designs for as low as $12.95 a year!! Click here!

© 1997-2003 Family Designs Consulting Services. All Rights Reserved.