Overview/Description: To provide a basic introduction to Word 2003 and the features and tools used for creating and navigating documents in Word
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
Expected Duration: 80 Minutes
Lesson Objectives

• Perform the basic tasks necessary to start work in Word.
• Identify the main features of the Word 2003 screen.
• Use the Word navigation tools to search through documents.
• Open Word, display a toolbar, and find text.

Overview/Description: To demonstrate how to format text and organize paragraphs in Word
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
Expected Duration: 140 Minutes
Lesson Objectives

• Insert page and section breaks into a document.
• Adjust the spacing and insert columns.
• Correct and customize spelling and grammar, and use the Find and Replace tool in Word.
• Correct a spelling error, adjust line and character spacing, and organize text into columns.
• Save and open Word documents.
• Save documents as web pages, text (TXT) files, or rich text format (RTF) files.
• Save a Word document to a new folder, save a Word document as a web page, and modify the document saving options.

Overview/Description: To describe how to use the Print, Help, and automated formatting features in Word
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
Expected Duration: 180 Minutes
Lesson Objectives

• Use the Edit menu, the Office Clipboard, and the Show/Hide button to move, copy, and paste text.
• Preview documents, run a word count, and print documents, envelopes, and labels in Word.
• Use the Help and Research options in Word.
• Use the Office Clipboard and Research task pane, modify the page setup, and print a document.
• Use style options to format text.
• Use the AutoCorrect features in Word to correct errors, configure Word to recognize common errors and exceptions, and automate the completion and formatting of text.
• Use templates and wizards to create and format documents.
• Apply, find, and modify styles, modify the AutoCorrect settings, and create a document from a template.
• Create a formal letter in Word 2003 and save it to a specific folder.

Overview/Description: To provide an overview of the document formatting, navigation, and recovery features in Word 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
Expected Duration: 140 Minutes
Lesson Objectives

• Insert headers, footers, and page numbers into a Word document.
• Navigate Word documents using various views.
• Use advanced navigation features.
• Add a header and footer to a document and use the Reading Layout view.
• Use document collaboration features in Word 2003.
• Use the document recovery features in Word 2003.
• Open and repair a corrupted document, merge two Word documents, and insert a comment.

Overview/Description: To describe tables and media features in Word 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
Expected Duration: 195 Minutes
Lesson Objectives

• Create and format tables in Word.
• Modify the structure of a table in Word 2003.
• Work with data in tables and create a table style.
• Create, format, and modify a table.
• Create and format a table in Word 2003.
• Add text effects, shapes, and shape effects to a document.
• Insert WordArt and a shape into a document.
• Insert and modify picture files, clip art, and diagrams in a document.
• Insert a picture and diagram into a document.
• Use Office 2003's speech recognition function.
• Use the handwriting features in Word 2003.

Overview/Description: To provide an overview of the basic features of Excel 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 195 Minutes
Lesson Objectives

• Outline the basic features of a spreadsheet and identify the main interface and Help features of Excel 2003.
• Create a workbook and navigate through the worksheets in it.
• Enter data and text in a worksheet in Excel 2003.
• Save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003.
• Enter data in a workbook and save it.
• Edit data and filter cells in an Excel 2003 worksheet.
• Copy and move a cell and a range of cells in Excel 2003.
• Insert, edit, copy, and move worksheets.
• Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook.
• Add and modify data and a worksheet in Excel 2003.

Overview/Description: To demonstrate how to format worksheets in Excel 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 120 Minutes
Lesson Objectives

• Apply and adapt a range of Excel cell formats.
• Use visual design techniques to apply formatting to an Excel 2003 workbook.
• Manipulate rows and columns in an Excel 2003 worksheet.
• Apply various types of formatting to an Excel 2003 workbook.
• Apply number formatting to cells in Excel 2003.
• Apply a number format to cell content in Excel 2003.
• Format text and cells and apply number formats to data in Excel 2003.

Overview/Description: To demonstrate the printing and collaboration features in Excel 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 120 Minutes
Lesson Objectives

• Run a spell check, and use the previewing features in Excel 2003.
• Adjust the Page Setup options and print a document in Excel 2003.
• Use a range of printing option features in Excel 2003.
• Adjust printing options and preview and print a document in Excel 2003.
• Create and edit comments and send a workbook for review in Excel 2003.
• Insert comments and send a workbook for review in Excel 2003.

Overview/Description: To provide an overview of the calculation features in Excel 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 160 Minutes
Lesson Objectives

• Use formulas to perform basic calculations in Excel 2003.
• Create a formula in Excel 2003.
• Use references and names in Excel 2003 formulas.
• Enter a formula that uses cell references in Excel 2003.
• Use functions to perform calculations in Excel 2003.
• Use logical, financial, and date functions in Excel 2003.
• Use the Insert Function feature to insert basic and advanced functions.
• Use formulas and functions to perform calculations in Excel 2003.

Overview/Description: To demonstrate the chart, graphical, and web features in Excel 2003
Target Audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 200 Minutes
Lesson Objectives

• Create charts to display data in Excel 2003.
• Create a chart using the Chart wizard in Excel 2003.
• Edit chart source data and change chart type in Excel 2003.
• Format, move, and resize a chart in Excel 2003.
• Change a data series and chart type in Excel 2003.
• Insert graphics in Excel 2003.
• Modify graphics in Excel 2003.
• Insert a picture into an Excel 2003 worksheet.
• Save a worksheet as a web page and work with hyperlinks in Excel 2003.
• Create an HTML spreadsheet in Excel 2003.

Overview/Description:To explain how to create basic presentations using PowerPoint 2003
Target Audience:Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification.
Expected Duration: 160 Minutes
Lesson Objectives

• Use the main components of the PowerPoint 2003 interface.
• Get help and other useful information while working in PowerPoint 2003.
• Use different methods to create presentations in PowerPoint 2003.
• Create PowerPoint 2003 presentations using different methods.
• Enter and format text in PowerPoint 2003.
• Modify text layout in a PowerPoint 2003 presentation.
• Format text in a PowerPoint 2003 presentation.
• Create three PowerPoint 2003 presentations.

Overview/Description:To demonstrate how to modify slide layout and design in PowerPoint 2003 presentations
Target Audience:Office personnel at all levels; those wishing to become familiar with PowerPoint 2003; those wishing to become certified in the Microsoft Office Specialist Program as Office PowerPoint 2003 Specialist or an equivalent end-user certification.
Expected Duration: 95 Minutes
Lesson Objectives

• Organize slides in PowerPoint 2003 presentations.
• Apply slide layout styles to a PowerPoint 2003 presentation.
• Rearrange the slides in a PowerPoint 2003 presentation.
• Create PowerPoint 2003 presentations using design templates.
• Use design templates to create PowerPoint 2003 presentations.

Overview/Description:To demonstrate how to send and receive messages in Outlook 2003
Target Audience:Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 160 Minutes
Lesson Objectives

• Navigate the principal features of Outlook 2003.
• Access the appropriate Help in Outlook 2003, given a scenario.
• Launch and navigate Outlook 2003, and access Help.
• Create a message.
• Address, save, and send a message.
• Create, address, save, and send a message in Outlook 2003.
• Access, reply to, and forward incoming messages.
• Reply to a message, turn on the AutoPreview feature, and forward a message.

Overview/Description:To demonstrate how to format and manage messages in Outlook 2003
Target Audience:Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 160 Minutes
Lesson Objectives

• Format messages and add signatures.
• Specify options for messages.
• Create a default signature and organize a vote.
• Insert and view attachments.
• Insert, view, and save an attachment.
• Color-code messages and flag messages for attention.
• Manage and organize messages.
• Organize Inbox messages.

Overview/Description:To demonstrate how events, appointments, and meetings are scheduled in Outlook 2003
Target Audience:Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Outlook 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003; end-users seeking basic IT certification, such as ECDL, ICDL, IC3, or an equivalent
Expected Duration: 180 Minutes
Lesson Objectives

• Navigate the Outlook 2003 Calendar.
• Schedule appointments and events in the Calendar in Outlook 2003.
• Create an appointment and an event.
• Plan and schedule an Outlook meeting.
• Manage Outlook meetings.
• Schedule a meeting using the Calendar.
• Update and repeat calendar entries.
• Customize the Outlook Calendar.
• Set Calendar options and create and customize a recurring series.

Overview/Description:To create and navigate an Access 2003 database
Target Audience:End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level
Expected Duration: 160 Minutes
Lesson Objectives

• Identify the type of database model implemented by Microsoft Access.
• Plan a database design that meets an organization's requirements.
• Identify relationships when planning a database.
• Select the appropriate database design for an organization's needs.
• Associate the main elements of the Access 2003 interface with their functions.
• Select the methods for creating a database.
• Recognize the functions provided by the database objects in an Access database.
• Create an Access database and view its data in different views.