Microsoft Office 2003: Getting Started Curriculum Outline
Introduction to Microsoft Office 2003
Overview/Description
To show how to open Office programs and use them to create files
Personnel at all levels of the enterprise; end users seeking an introduction to Microsoft Office 2003; end users seeking a basic IT certification such as ECDL, ICDL, IC3, or an equivalent
A basic knowledge of computer concepts such as how to use a keyboard and mouse; knowledge of the Windows 2000 and Windows XP environments would be an advantage
Introduction to Microsoft Office 2003
Back to List
Formatting and printing files in Office 2003
Overview/Description
To demonstrate how to format and add graphics to Office 2003 files
Personnel at all levels of the enterprise; end users seeking an introduction to Microsoft Office 2003; end users seeking a basic IT certification such as ECDL, ICDL, IC3, or an equivalent
A basic knowledge of computer concepts such as how to use a keyboard and mouse; knowledge of the Windows 2000 and Windows XP environments would be an advantage
Formatting and Printing Files in Office 2003
Back to List
Microsoft Office 2003: New Features Curriculum Outline
Microsoft Office 2003: New Features for End Users
Overview/Description
To describe new features of Microsoft Office Word, Excel, and PowerPoint 2003
Personnel at all levels of the enterprise, and end users
A good working knowledge of Microsoft Office 2000 or XP applications
Microsoft Office 2003: New Features for End Users
Back to List
Microsoft Office 2003: New Features for Outlook Users
Overview/Description
To describe new features of Microsoft Office Outlook 2003
Personnel at all levels of the enterprise, and end users
A good working knowledge of Microsoft Office 2000 or XP applications
Microsoft Office 2003: New Features for Outlook Users
Back to List
Microsoft Office 2003: New Applications
Overview/Description
To describe the new applications in Microsoft Office 2003
Personnel at all levels of the enterprise, and end users
A good working knowledge of Microsoft Office 2000 or XP applications
Microsoft Office 2003: New Applications
Back to List
Microsoft Office 2003: New Features for Advanced Users
Overview/Description
To describe the new features of Microsoft Office Access, FrontPage, SharePoint Services, and Office Publisher 2003
Personnel at all levels of the enterprise, and end users
A good working knowledge of Microsoft Office 2000 or XP applications
Microsoft Office 2003: New Features for Advanced Users
Back to List
Microsoft Access 2003 Curriculum Outline
Getting Started with Access 2003
Overview/DescriptionTo 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
Prerequisites Familiarity with the Microsoft Office environment
Expected Duration
3 Hours
Lesson Objectives:
Getting Started with Access 2003
- Identify the type of database model implemented by Microsoft Access
- Plan a database design that meets an organizations requirements
- Identify relationships when planning a database
- Select the appropriate database design for an organizations 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
Back to List
Basic Access 2003 Tables
Overview/DescriptionTo create and modify tables in Access 2003
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
Prerequisites Familiarity with the Microsoft Office environment
Expected Duration
3 Hours
Lesson Objectives:
Basic Access 2003 Tables
- Add a table to an Access database
- Add a table using the Design and Datasheet views
- Modify fields to define a tables features
- Use masked input fields and apply indexing to fields
- Create and modify a specific table in Access 2003
- Manage the data in records
- Identify the steps involved in creating the various types of relationships between tables
- Modify table data and edit relationships between tables
- Create a database containing relational tables in response to a business requirement
Back to List
Basic Access 2003 Forms
Overview/DescriptionTo create and modify forms in Access 2003
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
Prerequisites Familiarity with the Microsoft Office environment
Expected Duration
2 Hours
Lesson Objectives:
Basic Access 2003 Forms
- Select a suitable method for creating a form
- Select methods for adding and formatting controls
- Select methods for manipulating controls
- Select the correct options to bind a control
- Create a form with bound controls
- Select the correct options to format a form
- Select the correct options to manage records displayed in a form
- Format a form and manage records
Back to List
Using Queries and Reports in Access 2003
Overview/DescriptionTo create and modify queries and reports in Access 2003
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
Prerequisites Familiarity with the Microsoft Office environment
Expected Duration
3 Hours
Lesson Objectives:
Using Queries and Reports in Access 2003
- Select the options that allow you to create and run a select query
- Select the options that allow you to refine a query
- Select the options that allow you to perform calculations on a query
- Create and modify a query and print query results
- Create a crosstab query
- Find unmatched or duplicate records using queries
- Use queries to obtain information useful to an organization
- Select the appropriate methods to generate a specific report
- Add controls to a report
- Select the methods to organize data in a report
- Create a report and organize its data
Back to List
Personalizing and Maintaining Access 2003
Overview/DescriptionTo personalize the Access 2003 environment and maintain databases
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
Prerequisites Familiarity with the Microsoft Office environment
Expected Duration
1 Hour
Lesson Objectives:
Personalizing and Maintaining Access 2003
- Select methods of customizing the Access 2003 working environment
- Select methods of maintaining an Access 2003 database
- Perform backup and view dependencies in Access 2003
- Maintain a database and customize the working environment
Back to List
Enhancing Tables, Forms, and Reports in Access 2003
Overview/DescriptionTo implement advanced techniques for tables, forms, and reports
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
2.25 Hours
Lesson Objectives:
Enhancing Tables, Forms, and Reports in Access 2003
- Select the appropriate methods of allowing tables to access related data
- Apply data validation to tables
- Access and validate table data
- Add a subform and a subreport
- Create a switchboard form
- Apply conditional formatting to a form
- Add subforms and conditional formatting to a form interface and a switchboard to a database
Back to List
Advanced Querying in Access 2003
Overview/DescriptionTo use advanced queries such as joins, parameter, action, and SQL queries
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
1.75 Hours
Lesson Objectives:
Advanced Querying in Access 2003
- Use joins and parameter queries to obtain specific data
- Use an action query to modify records
- Use action queries to delete and copy data
- Edit a SELECT query using SQL
- Create queries to combine, update, and filter data
Back to List
Working with Data and Presentation in Access 2003
Overview/DescriptionTo use PivotTables, PivotCharts, and other applications to present and handle database data
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
2 Hours
Lesson Objectives:
Working with Data and Presentation in Access 2003
- Select appropriate methods of adding data to a database by importing or linking
- Select the appropriate methods to export Access data to a suitable format
- Use Access 2003 to import and export appropriately formatted data
- Use a PivotTable view to present data
- Use a PivotChart view to present data
- Organize data with PivotTables and PivotCharts
Back to List
Access 2003 and the Web
Overview/DescriptionTo make Access databases use web resources with hyperlinks and data access pages
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
1.25 Hours
Lesson Objectives:
Access 2003 and the Web
- Create a hyperlink address
- Implement the correct procedures for building and maintaining a data access page
- Prepare a data access page for different deployment scenarios
- Create a formatted data access page for a deployment scenario
Back to List
Access 2003 Programmability
Overview/DescriptionTo use macros and Visual Basic for Applications to add interactivity to database objects
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
1.25 Hours
Lesson Objectives:
Access 2003 Programmability
- Create a macro for a typical Access 2003 task
- Launch, modify, and debug macros
- Use the Visual Basic Editor to allow a database object to start handling users actions
- Create a macro and an event handler
Back to List
Database Administration in Access 2003
Overview/DescriptionTo implement methods of securing, sharing, replicating, and optimizing the performance of Access 2003 databases
Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
Prerequisites The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment
Expected Duration
2 Hours
Lesson Objectives:
Database Administration in Access 2003
- Implement methods of securing database information for a given scenario
- Set a database password and secure VB code in a given scenario
- Implement methods of sharing database information for a given scenario
- Implement methods of creating and synchronizing replicas for a given scenario
- Share and replicate database information for a particular scenario
- Implement procedures to improve the performance of a database
Back to List
Microsoft Excel 2003 Curriculum Outline
Basic Features of Excel 2003
Overview/DescriptionTo 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
Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
3 Hours
Lesson Objectives:
Basic Features of Excel 2003
- 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
Back to List
Printing and Collaborating in Excel 2003
Overview/DescriptionTo 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
Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Formatting Data in Excel 2003
- 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
Back to List
Excel 2003 Formulas and Functions
Overview/DescriptionTo 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
Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
3 Hours
Lesson Objectives:
Printing and Collaborating in Excel 2003
- 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
Back to List
Formatting Data in Excel 2003
Overview/DescriptionTo 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
Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Excel 2003 Formulas and Functions
- 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
Back to List
Excel 2003 Chart and Multimedia Features
Overview/DescriptionTo 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
Prerequisites Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office environment; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
3 Hours
Lesson Objectives:
Excel 2003 Chart and Multimedia Features
- 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
Back to List
Advanced Customization in Excel 2003
Overview/DescriptionTo demonstrate how to customize Excel workbooks and the Excel 2003 application
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
2.75 Hours
Lesson Objectives:
Advanced Customization in Excel 2003
- Create and customize templates in Excel 2003
- Create and apply styles in Excel 2003
- Create styles and templates in Excel 2003
- Customize Excel 2003 workbooks by changing their settings and properties
- Use macros in Excel 2003
- Customize an Excel 2003 toolbar
- Record a macro and assign it to a custom button in Excel 2003
- Customize a document using templates, formatting, and macros in Excel 2003
Back to List
Advanced formatting in Excel 2003
Overview/DescriptionTo demonstrate how to apply advanced formatting in Excel 2003
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
2 Hours
Lesson Objectives:
Advanced formatting in Excel 2003
- Create and use advanced number formats in Excel 2003
- Apply advanced custom number formats in Excel 2003
- Create and apply custom number formats in Excel 2003
- Apply conditional formatting to a worksheet in Excel 2003
- Create a conditional format and apply it to another cell in Excel 2003
- Apply advanced number and conditional formatting in Excel 2003
Back to List
Advanced Data Management in Excel 2003
Overview/DescriptionTo provide an overview of the advanced data management and organizational features in Excel 2003
Target Audience
EEnd users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
2.25 Hours
Lesson Objectives:
Advanced Data Management in Excel 2003
- Sort and filter data lists in Excel 2003
- Group and outline a data list in Excel 2003
- Subtotal data in Excel 2003
- Subtotal, filter, and group a data list in Excel 2003
- Use advanced mathematical, text, and database functions, and consolidate data in Excel 2003
- Use lookup functions in Excel 2003
- Use lookup, mathematical, and database functions in Excel 2003
Back to List
Advanced Data Analysis in Excel 2003
Overview/DescriptionTo provide an overview of the advanced data manipulation and analysis features in Excel 2003
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
3 Hours
Lesson Objectives:
Advanced Data Analysis in Excel 2003
- Create and modify PivotTable reports in Excel 2003
- Perform calculations on PivotTable reports in Excel 2003
- Create and modify a PivotTable report in Excel 2003
- Create and modify PivotChart reports in Excel 2003
- Create and edit a PivotChart report in Excel 2003
- Use the Goal Seek and Solver tools in Excel 2003
- Employ scenarios to analyze data in Excel 2003
- Create data tables and outline their uses in Excel 2003
- Use data-analysis tools in Excel 2003 to forecast values in a workbook
Back to List
Advanced Validation and Collaboration in Excel 2003
Overview/DescriptionTo identify the advanced data validation and collaboration features in Excel 2003
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
3 Hours
Lesson Objectives:
Advanced Validation and Collaboration in Excel 2003
- Validate data in Excel 2003
- Audit data in Excel 2003
- Validate data in an Excel worksheet
- Apply worksheet protection in Excel 2003
- Use passwords, encryption, and digital signatures to protect Excel 2003 workbooks
- Apply protection to a range, a worksheet, and a workbook in Excel 2003
- Share and merge workbooks in Excel 2003
- Track changes to data using a range of tools in Excel 2003
- Use Excel 2003 collaboration features to track changes and merge a workbook
- Apply data validation, protect, and share a workbook in Excel 2003
Back to List
Advanced Data Exchange in Excel 2003
Overview/DescriptionTo describe how to use Excel 2003 to share data between people, applications, and on the Web
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
Prerequisites Familiarity with the Windows 2000 or XP user environments
Expected Duration
4 Hours
Lesson Objectives:
Advanced Data Exchange in Excel 2003
- Link worksheets and workbooks and embed files in Excel 2003
- Link and embed data in a workbook in Excel 2003
- Import data from text files into an Excel 2003 workbook
- Create a query in Excel 2003
- Import data from Excel 2003 into other applications
- Import external data into Excel 2003 and import Excel data into another application
- Import data from the Web into Excel 2003
- Create a web query in Excel 2003
- Outline core XML concepts and work with XML files in Excel 2003
- Create an XML document in Excel 2003
- Create a simple XML document in Excel 2003
Back to List
Microsoft FrontPage 2003 Curriculum Outline
Getting Started with FrontPage 2003
Overview/Description
To introduce the basic features and functionality of Microsoft FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily
Familiarity with a Windows user environment; familiarity with Office XP Word 2003; basic end-user experience of the Internet or an intranet
Getting Started with FrontPage 2003
Back to List
Working with graphics, hyperlinks and tables in FrontPage 2003
Overview/Description
To describe how to add graphics, hyperlinks and tables to web pages using FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily
Familiarity with a Windows user environment; familiarity with Office XP Word 2003; basic end-user experience of the Internet or an intranet
Working with graphics, hyperlinks and tables in FrontPage 2003
Back to List
Working with Web Sites in FrontPage 2003
Overview/Description
To demonstrate how to apply themes and styles, and work with shared borders in FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily
Familiarity with a Windows user environment; familiarity with Office XP Word 2003; basic end-user experience of the Internet or an intranet
Working with Web Sites in FrontPage 2003
Back to List
Organizing Content Using Templates and Frames in FrontPage 2003
Overview/Description
To provide an overview of how to organize content in FrontPage 2003 using Dynamic Web Templates and frames
Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily
Familiarity with a Windows user environment; familiarity with Office XP Word 2003; basic end-user experience of the Internet or an intranet
Organizing Content Using Templates and Frames in FrontPage 2003
Back to List
Structuring and Publishing Web Sites in FrontPage 2003
Overview/Description
To describe how to structure and publish FrontPage 2003 web sites
Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily
Familiarity with a Windows user environment; familiarity with Office XP Word 2003; basic end-user experience of the Internet or an intranet
Structuring and Publishing Web Sites in FrontPage 2003
Back to List
Working with Code in FrontPage 2003
Overview/Description
To demonstrate how to work with code in FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily
The Microsoft Office 2003: Beginning FrontPage learning path; familiarity with a Windows user environment; basic familiarity with the Microsoft Office suite; basic end-user experience of the Internet or an intranet
Working with Code in FrontPage 2003
Back to List
Importing and Working with Data in FrontPage 2003
Overview/Description
To explain how to import web sites, create forms, and work with databases using FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily
The Microsoft Office 2003: Beginning FrontPage learning path; familiarity with a Windows user environment; basic familiarity with the Microsoft Office suite; basic end-user experience of the Internet or an intranet
Importing and Working with Data in FrontPage 2003
Back to List
Enhancing Web Sites with Advanced FrontPage 2003 Features
Overview/Description
To enhance web sites with dynamic components using FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily
The Microsoft Office 2003: Beginning FrontPage learning path; familiarity with a Windows user environment; basic familiarity with the Microsoft Office suite; basic end-user experience of the Internet or an intranet
Enhancing Web Sites with Advanced FrontPage 2003 Features
Back to List
Administering Web Sites in FrontPage 2003
Overview/Description
To introduce the issues involved in administering web sites in FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily
The Microsoft Office 2003: Beginning FrontPage learning path; familiarity with a Windows user environment; basic familiarity with the Microsoft Office suite; basic end-user experience of the Internet or an intranet
Administering Web Sites in FrontPage 2003
Back to List
Using Windows SharePoint Services and FrontPage 2003
Overview/Description
To provide an overview of using Windows SharePoint Services in conjunction with FrontPage 2003
Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily
The Microsoft Office 2003: Beginning FrontPage learning path; familiarity with a Windows user environment; basic familiarity with the Microsoft Office suite; basic end-user experience of the Internet or an intranet
Using Windows SharePoint Services and FrontPage 2003
Back to List
Microsoft Outlook 2003 Curriculum Outline
Sending and Receiving Messages in Outlook 2003
Overview/DescriptionTo 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
Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet
Expected Duration
3 Hours
Lesson Objectives:
Sending and Receiving Messages in Outlook 2003
- 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
Back to List
Formatting and Managing Messages in Outlook 2003
Overview/DescriptionTo 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
Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet
Expected Duration
3 Hours
Lesson Objectives:
Formatting and Managing Messages in Outlook 2003
- 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
Back to List
Scheduling events, Appointments, and meetings in Outlook 2003
Overview/DescriptionTo 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
Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet
Expected Duration
3 Hours
Lesson Objectives:
Scheduling Events, Appointments, and Meetings in Outlook 2003
- 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
Back to List
Using Task Lists, Contact Lists, and Notes in Outlook 2003
Overview/DescriptionTo demonstrate how to use task lists, contact lists, and notes 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
Prerequisites Basic knowledge of word processing and computing; familiarity with the Microsoft Windows and Office environments, and a very basic understanding of the Internet
Expected Duration
2 Hours
Lesson Objectives:
Using Task Lists, Contact Lists, and Notes in Outlook 2003
- Create and use a list of contacts in Outlook 2003
- Manage contacts in Outlook 2003
- Create and manage a contact
- Create a task list
- Manage a task list
- Accept, create, and assign tasks
- Create and use notes
Back to List
Customizing E-mail, Views, Navigation, and E-mail Accounts in Outlook 2003
Overview/DescriptionTo demonstrate how to customize e-mail, views, and navigation and configure additional e-mail accounts 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
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet
Expected Duration
3.25 Hours
Lesson Objectives:
Customizing E-mail, Views, Navigation, and E-mail Accounts in Outlook 2003
- Customize the Outlook 2003 interface
- Perform customization tasks in Outlook 2003
- Change mail editor and message formats in Outlook 2003
- Recognize how stationery and themes are used in Outlook 2003 and apply stationery to messages
- Use stationery and themes in Outlook 2003
- Work with stationery and themes in Outlook 2003
- Customize Outlook 2003 views
- Customize the Contacts view in Outlook 2003
- Configure additional e-mail accounts in Outlook 2003
- Configure a Hotmail account in Outlook 2003
Back to List
Tracking, Categorizing, Searching, and Printing in Outlook 2003
Overview/DescriptionTo demonstrate how to track, categorize, search, and print items 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
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet
Expected Duration
3 Hours
Lesson Objectives:
Tracking, Categorizing, Searching, and Printing in Outlook 2003
- Use the Journal in Outlook 2003
- Track a project using the Journal in Outlook 2003
- Use categories to organize information
- Categorize items in Outlook 2003
- Organize items using public and private folders in Outlook 2003
- Search for items in Outlook in a given scenario
- Create and use Search Folders in Outlook 2003
- Create searches and Search Folders in Outlook 2003
- Print Outlook items
- Set Page Setup options and print styles
- Define and apply print styles in Outlook 2003
Back to List
Configuring Rules, Alerts, and Junk Mail Settings in Outlook 2003
Overview/DescriptionTo demonstrate how to organize, manage, and prioritize data using rules, alerts, and the Junk E-mail Filter 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
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet
Expected Duration
2 Hours
Lesson Objectives:
Configuring Rules, Alerts, and Junk Mail Settings in Outlook 2003
- Identify how to use rules to filter mail in Outlook 2003
- Identify how to use rules to filter mail with public folders and the Out of Office Assistant
- Create a rule in Outlook 2003 for a given scenario
- Identify how to use alerts and rules in Outlook 2003
- Configure alerts in Outlook 2003
- Recognize the characteristics of the Junk E-mail Filter
- Control junk mail in Outlook 2003
- Configure and manage the Junk E-mail Filter in Outlook 2003
Back to List
Sharing Folders, Schedules, and Contacts and Using SharePoint Data in Outlook 2003
Overview/DescriptionTo demonstrate the information sharing and collaboration capabilities of 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
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet
Expected Duration
3 Hours
Lesson Objectives:
Sharing Folders, Schedules, and Contacts and Using SharePoint Data in Outlook 2003
- Work with shared folders and delegate access in Outlook 2003
- Use custom folders in Outlook 2003
- Configure a shared folder in Outlook 2003
- Work with group schedules in Outlook 2003
- Use group schedules in Outlook 2003
- Publish schedules on the Internet
- Use the Mail Merge feature in Outlook 2003
- Use vCards in Outlook 2003
- Recognize how to use SharePoint Services with Outlook 2003
- Use SharePoint Services with Outlook 2003
Back to List
Data Security in Outlook 2003
Overview/DescriptionTo demonstrate the data security features in Outlook 2003
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
2.50 Hours
Lesson Objectives:
Data Security in Outlook 2003
- Recognize how to configure security options in Outlook 2003
- Recognize how to protect against viruses in attachments and macros in Outlook 2003
- Configure Internet security zones and use global settings to control downloads
- Implement data security in Outlook 2003
- Recognize how to obtain and use digital certificates in Outlook 2003
- Work with signed and encrypted messages in Outlook 2003
- Work with signed and encrypted messages and import and export a digital ID
- Use digital signatures and encryption in Outlook 2003
Back to List
Archiving and Storing Data, and Using IRM in Outlook 2003
Overview/DescriptionTo demonstrate how to back up and manage data in Personal Folders files, and to use Information Rights Management to control data communication in Outlook 2003
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
1.25 Hours
Lesson Objectives:
Archiving and Storing Data, and Using IRM in Outlook 2003
- Recognize how to use AutoArchive and Mailbox Cleanup to manage folders in Outlook 2003
- Use AutoArchive and Mailbox Cleanup to manage data in Outlook 2003
- Work with Personal Folders files in Outlook 2003
- Recognize how to configure and use IRM in Outlook 2003
Back to List
Working in Outlook 2003 from Multiple Locations
Overview/DescriptionTo demonstrate how to work remotely, work offline, and work in Cached Exchange mode in Outlook 2003
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
3.25 Hours
Lesson Objectives:
Working in Outlook 2003 from Multiple Locations
- Recognize how to configure remote connections in Outlook 2003
- Recognize how to connect to Exchange Server mail over the Internet
- Identify how to configure Cached Exchange mode
- Configure a remote connection using Cached Exchange mode
- Recognize how to configure and synchronize offline folders in Outlook 2003
- Recognize how to create and configure a Send/Receive group
- Recognize how to control offline access in Outlook 2003
- Perform offline access configuration tasks in Outlook 2003
- Recognize how to use Remote Mail in Outlook 2003
- Work with Remote Mail in Outlook 2003
Back to List
Newsreaders, Online Meetings, Instant Messaging, and Faxing Information in Outlook 2003
Overview/DescriptionTo demonstrate how to configure and use newsreaders, online meetings, instant messaging, and Internet faxing in Outlook 2003
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
2.50 Hours
Lesson Objectives:
Newsreaders, Online Meetings, Instant Messaging, and Faxing Information in Outlook 2003
- Recognize how to use the Outlook Express Newsreader in Outlook 2003
- Use the Outlook Express Newsreader in Outlook 2003
- Recognize how to set up online meetings in Outlook 2003
- Set up an online meeting in Outlook 2003 using NetMeeting
- Recognize how instant messaging in Outlook 2003 works
- Recognize how to send a fax using an Internet fax service
- Recognize how to modify, forward, and add an attachment to a fax in Outlook 2003
- Send instant messages and faxes from Outlook 2003
Back to List
Customizing Toolbars and Commands and Creating Forms in Outlook 2003
Overview/DescriptionTo demonstrate how to customize toolbars and commands, and to build and manage custom forms in Outlook 2003
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
3.25 Hours
Lesson Objectives:
Customizing Toolbars and Commands and Creating Forms in Outlook 2003
- Recognize how to customize Outlook 2003 toolbars and commands
- Manage menus and toolbars in Outlook 2003
- Create a toolbar in Outlook 2003
- Identify what custom forms are used for in Outlook 2003
- Identify how to work with forms in design mode in Outlook 2003
- Create a custom form in Outlook 2003
- Create a custom task form in Outlook 2003
- Publish customized forms in Outlook 2003
- Test and publish a custom form in Outlook 2003
- Create a custom form in Outlook 2003
Back to List
Outlook 2003 and Business Contact Manager
Overview/DescriptionTo demonstrate how to use Outlook 2003 with Business Contact Manager
Target Audience
Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003
Prerequisites The Microsoft Office 2003: Beginning Outlook learning path or equivalent; the Microsoft Office 2003: Advanced Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment, and, preferably, an understanding of the Internet and Microsoft Exchange
Expected Duration
3.50 Hours
Lesson Objectives:
Outlook 2003 and Business Contact Manager
- Identify the main features of Business Contact Manager and configure it in Outlook 2003
- Recognize how to configure accounts and business contacts in Outlook with BCM
- Create an account and a business contact in Outlook with BCM
- Configure opportunities and the product master list in Outlook 2003 with BCM
- Configure an opportunity and the product master list in Outlook with BCM
- Recognize how to generate linked items for BCM records
- Manage linked items for BCM records
- Create and manage linked items in Outlook with BCM
- Use views and reports in Outlook with BCM
- Protect and share BCM data
- Change the BCM database associated with a profile and export BCM data
Back to List
Microsoft PowerPoint 2003 Curriculum Outline
Creating Basic Presentations using PowerPoint 2003
Overview/DescriptionTo 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2.50 Hours
Lesson Objectives:
Creating Basic Presentations using PowerPoint 2003
- 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
Back to List
Slide Layout and Design in PowerPoint 2003
Overview/DescriptionTo 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
1.50 Hours
Lesson Objectives:
Slide Layout and Design in PowerPoint 2003
- 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
Back to List
Using Visuals in PowerPoint 2003 Presentations
Overview/DescriptionTo describe how to add visuals to 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Using Visuals in PowerPoint 2003 Presentations
- Add visual elements to a document in PowerPoint 2003
- Modify objects in PowerPoint 2003 presentations
- Enhance a PowerPoint 2003 presentation by using visual elements in your slides
- Use diagrams, tables, and charts in PowerPoint 2003 presentations
- Present data in a presentation using diagrams, tables, and charts
- Create a presentation that includes visual images, a table, and a chart, in a given scenario
Back to List
Finalizing PowerPoint 2003 presentations
Overview/DescriptionTo finalize and distribute 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Finalizing PowerPoint 2003 Presentations
- Insert speaker notes, headers, and footers in PowerPoint 2003 presentations
- Protect and save PowerPoint 2003 presentations
- Print PowerPoint 2003 presentations
- Add speaker notes, headers, and footers to a PowerPoint 2003 presentation, and save and print it
- Distribute PowerPoint 2003 presentations
- E-mail a PowerPoint 2003 presentation and publish it as a web page
Back to List
Customizing PowerPoint 2003 Presentations
Overview/DescriptionTo describe how to customize 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Customizing PowerPoint 2003 Presentations
- Include multimedia elements in a PowerPoint 2003 presentation
- Add animation to slides in PowerPoint 2003
- Insert multimedia clips and animation to slides in PowerPoint 2003
- Modify the visual design of PowerPoint 2003 presentations
- Change the color scheme and background of a PowerPoint 2003 presentation
- Create a PowerPoint 2003 presentation containing multimedia and animation, in a given scenario
Back to List
Preparing PowerPoint 2003 Presentations for Effective Delivery
Overview/DescriptionTo describe how to add slide timings and transitions, action buttons, and hyperlinks to 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
1.75 Hours
Lesson Objectives:
Preparing PowerPoint 2003 Presentations for Effective Delivery
- Customize the delivery of a PowerPoint 2003 presentation
- Apply slide transitions and timings to a PowerPoint 2003 presentation
- Add navigational capabilities to a PowerPoint 2003 presentation
- Insert hyperlinks and action buttons in a PowerPoint 2003 presentation
- Create a PowerPoint 2003 presentation containing slide transitions, hyperlinks, and action buttons
Back to List
Running, Broadcasting, and Reviewing PowerPoint 2003 Presentations
Overview/DescriptionTo describe how to run an effective PowerPoint 2003 presentation and explain how to broadcast and collaborate on 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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2.75 Hours
Lesson Objectives:
Running, Broadcasting, and Reviewing PowerPoint 2003 Presentations
- Set up slide shows in PowerPoint 2003
- Run a slide show presentation in PowerPoint 2003
- Set up and run slide shows in PowerPoint 2003
- List ways of making PowerPoint 2003 presentations more effective
- Broadcast a PowerPoint 2003 presentation online
- Set up broadcast settings and schedule an online broadcast of a PowerPoint 2003 presentation
- Use the presentation review process in PowerPoint 2003
- Send a PowerPoint presentation for review and reconcile the review
Back to List
Settings, Customization, and Office 2003 Integration with PowerPoint 2003
Overview/DescriptionTo describe how to customize PowerPoint 2003 toolbars, menus, and options, create and run macros, and integrate PowerPoint 2003 with other Microsoft Office 2003 applications
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
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Settings, Customization, and Office 2003 Integration with PowerPoint 2003
- Use PowerPoint 2003 smart tags and Options buttons
- Insert objects in PowerPoint 2003 presentations
- Use linked and embedded objects in PowerPoint 2003
- Customize PowerPoint 2003
- Configure PowerPoint 2003 options
- Customize the interface and modify settings in PowerPoint 2003
Back to List
Microsoft Project Professional 2003 Curriculum Outline
Creating and Defining a Project
Overview/DescriptionTo discuss the basics of project management and to begin creating a new project using Project Professional 2003
Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project Professional 2003; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A basic knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred Additionally, as this path is primarily concerned with familiarizing the learner with Microsoft Office Project Professional 2003 application, we recommend that for those who wish to learn specifically about project management, that they consult Business Skills for our project management curricula
Expected Duration
4 Hours
Lesson Objectives:
Creating and Defining a Project
- Identify the basic concepts involved in project management
- Identify the functions that a project manager can carry out with Project 2003
- Recognize the project management features associated with Project Professional 2003
- Identify the Help features in Project Professional 2003
- Create and save a project in Project 2003
- Set up a new project in Project Professional 2003
- Create a project in Project Professional 2003
- Outline tasks for a project in Project Professional 2003
- Organize tasks in Project 2003
- Sequence project tasks for a given scenario
- Outline suitable task information and constraints for a project in a given scenario
- Create task dependencies and constraints in a project schedule
Back to List
Specifying and Assigning Resources
Overview/DescriptionTo define how resources are assigned, adjusted, and administered
Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project Professional 2003; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A basic knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred Additionally, as this path is primarily concerned with familiarizing the learner with Microsoft Office Project Professional 2003 application, we recommend that for those who wish to learn specifically about project management, that they consult Business Skills for our project management curricula
Expected Duration
2.75 Hours
Lesson Objectives:
Specifying and Assigning Resources
- Define resources and work times for a specific project
- Assign resources to tasks in a project
- Administer resources using Project Professional 2003
- Modify resource assignments in a project
- Carry out resource leveling on a project in a given scenario
- Assign cost details for a project in a given scenario
- Set resource leveling and cost details for a project using Project 2003
- Outline the best practices for managing resources in Project Professional 2003
Back to List
Tracking and Reporting Progress
Overview/DescriptionTo define how to track and report on the progress of your project
Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project Professional 2003; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A basic knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred Additionally, as this path is primarily concerned with familiarizing the learner with Microsoft Office Project Professional 2003 application, we recommend that for those who wish to learn specifically about project management, that they consult Business Skills for our project management curricula
Expected Duration
3.25 Hours
Lesson Objectives:
Tracking and Reporting Progress
- Implement a suitable baseline for a project, in a given scenario
- Select a tracking method for a project
- Prepare a project for tracking in a given scenario
- Carry out a progress check on your project
- Perform tracking on a project using Project Professional 2003
- Select an appropriate view or report for a project
- Modify a view or report in Project Professional 2003
- Print a project view or report
- Create and print a new view and report in Project Professional 2003
- Outline the steps and best practices for tracking and reporting on a project
Back to List
Advanced Customization
Overview/DescriptionTo identify how to structure your project using advanced customization features
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
2.50 Hours
Lesson Objectives:
Advanced Customization
- Customize a template in Project 2003 for a given scenario
- Customize settings and menu options in Project 2003
- Modify custom data for a given scenario
- Customize a projects settings in Project 2003
- Customize tasks and resource information views in Project 2003
- Create a WBS code for a project in Project 2003
- Customize a projects settings
Back to List
Sharing Project Data and Working with Macros
Overview/DescriptionTo identify how to share project data across applications and work with time-saving macros
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
2 Hours
Lesson Objectives:
Sharing Project Data and Working with Macros
- Import project data from different file formats
- Export project data to an Office application
- Export project data to a non-Office-based file format
- Use Project 2003 to work with data in other formats
- Use macros to automate repetitive steps in Project 2003
- Create and work with a macro in Project 2003
Back to List
Organizing and Managing Project Information
Overview/DescriptionTo identify how to organize project information for efficient performance
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
3 Hours
Lesson Objectives:
Organizing and Managing Project Information
- Sort project information in a given scenario
- Apply a filter to a project
- Create a group for project information in a given scenario
- Modify a projects information views
- Record actual information for a project
- Update actual project cost information for a given scenario
- Use Project 2003 to carry out earned value analysis on a project
- Manage project information using Project 2003
- Interpret an earned value report
Back to List
Working Collaboratively
Overview/DescriptionTo identify how to use e-mail to work collaboratively
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
2.25 Hours
Lesson Objectives:
Working Collaboratively
- Carry out project consolidation in a given scenario
- Create a resource pool project for a given scenario
- Create external dependencies across projects
- Manage tasks and resources across multiple projects
- Use an e-mail workgroup for project collaboration
- Communicate with project resources using e-mail
- Use e-mail to collaborate on a project
Back to List
Enterprise Project Management
Overview/DescriptionTo identify how project managers can set up and manage an enterprise project using Project Professional 2003, Project Server, and Project Web Access
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
2 Hours
Lesson Objectives:
Enterprise Project Management
- Select the most appropriate scenario where Project Server and Web Access can be used
- Create an enterprise project
- Use Project 2003 to create an enterprise project
- Set up a project for team collaboration
- Use Project Web Access to collaborate with a project manager in a given scenario
- Manage collaboration using Project 2003 and Project Web Access
Back to List
Advanced Analysis of your Project
Overview/DescriptionTo identify how you can use Project 2003s collaborative functions to manage and analyze project information
Target Audience
Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003
Prerequisites A knowledge of standard project methodology; familiarity with Microsoft Windows and Office environments; a knowledge of previous versions of Project is preferred, particularly Microsoft Office 2003: Beginning Project Professional Additionally, as this path is concerned with familiarizing the learner with the advanced planning and customization features within Microsoft Office Project Professional 2003, it is recommended that those who wish to learn specifically about Project Management consult our Business Skills curricula for PMI certified project management courses
Expected Duration
2.75 Hours
Lesson Objectives:
Advanced Analysis of your Project
- Use Windows SharePoint Services to manage project information in a given scenario
- Identify the functions provided by the Project and Resource Centers
- Use Project 2003 to track issues and risks in a given scenario
- Manage project documentation, risks, and issues
- Use PERT analysis in Project 2003 to estimate a tasks duration details
- Use the Project Analyzer to analyze project data for a given scenario
- Use the Portfolio Modeler to analyze resource allocation in a given scenario
- Carry out an analysis on project data for an enterprise
Back to List
Microsoft Publisher 2003 Curriculum Outline
Getting Started with Publisher 2003
Overview/DescriptionTo provide a basic introduction to Publisher 2003 and the features and tools used for creating publications in Publisher, and to demonstrate the options for getting help as you work
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2.25 Hours
Lesson Objectives:
Getting Started with Publisher 2003
- Identify the main features of the Publisher 2003 interface
- Recognize how to create a publication in Publisher 2003
- Recognize how to use the Page Sorter to arrange pages and apply backgrounds in Publisher 2003
- Recognize how to configure page setup and page layout options in Publisher 2003
- Create a publication with Publisher 2003
- Use the Help and Research options in Publisher 2003
- Use the Research pane and the Help feature in Publisher 2003
Back to List
Working with Text Boxes, Text, and Tables in Publisher 2003
Overview/DescriptionTo demonstrate how to work with text boxes, text, and tables in Publisher 2003
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Working with Text Boxes, Text, and Tables in Publisher 2003
- Recognize how to create and modify text boxes in Publisher 2003
- Create and configure text boxes in Publisher 2003
- Recognize how to format text in Publisher 2003
- Recognize how to create tables in Publisher 2003
- Format text and tables in Publisher 2003
- Recognize how to use text tools in Publisher 2003
Back to List
Printing and Working with Graphics and Objects in Publisher 2003
Overview/DescriptionTo provide an overview of printing, inserting, and modifying graphics and objects in Publisher 2003
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2.75 Hours
Lesson Objectives:
Printing and Working with Graphics and Objects in Publisher 2003
- Work with pictures in Publisher 2003
- Recognize how to use Clip Art and the Design Gallery in Publisher 2003
- Add and configure graphics in Publisher 2003
- Work with shapes in Publisher 2003
- Recognize how to manipulate objects in Publisher 2003
- Configure graphical objects with Publisher 2003
- Recognize how to preview and print a publication in Publisher 2003
- Print a publication in Publisher 2003
Back to List
Working with E-mail and Web Sites in Publisher 2003
Overview/DescriptionTo provide an overview of how to create e-mail publications and web sites in Publisher 2003
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2.75 Hours
Lesson Objectives:
Working with E-mail and Web Sites in Publisher 2003
- Recognize how to create e-mail publications with Publisher 2003
- Recognize how to send e-mail publications with Publisher 2003
- Send an e-mail publication using Publisher 2003
- Recognize how to create a web site with Publisher 2003
- Recognize how to add and modify graphics and navigation bars in Publisher 2003 web publications
- Recognize how to add and modify hyperlinks, hot spots, and form controls in Publisher 2003 web publications
- Recognize how to publish web sites in Publisher 2003
- Create a web site with Publisher 2003
Back to List
Working with Mail and Catalog Merges in Publisher 2003
Overview/DescriptionTo provide an overview of mail and catalog merges in Publisher 2003
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
1 Hour
Lesson Objectives:
Working with Mail and Catalog Merges in Publisher 2003
- Recognize how to create a mail merge in Publisher 2003
- Create a mail merge with Publisher 2003
- Recognize how to create a catalog merge using Publisher 2003
Back to List
Advanced Design Techniques and Printing with Publisher 2003
Overview/DescriptionTo provide an overview of advanced design techniques and printing in Publisher 2003
Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
3.25 Hours
Lesson Objectives:
Advanced Design Techniques and Printing with Publisher 2003
- Recognize how to customize design elements in Publisher 2003
- Customize design elements in Publisher 2003
- Work with master pages in Publisher 2003
- Recognize how to configure master pages in Publisher 2003
- Use master pages in Publisher 2003
- Recognize how to use special paper and the Design Checker in Publisher 2003
- Recognize how to set printer and device options, and configure advanced print settings in Publisher 2003
- Recognize how to configure color preferences for commercial printing in Publsiher 2003
- Recognize how to use the Pack and Go wizard and to save a publication as a PostScript file in Publisher 2003
- Use the commercial print tools in Publisher 2003
Back to List
Microsoft Visio 2003 Curriculum Outline
Creating Diagrams with Visio 2003
Overview/DescriptionTo introduce Visio 2003 and its features and demonstrate how to use it to create diagrams
Target Audience
End users, office personnel at all levels, and anyone wishing to become familiar with Visio 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
3.25 Hours
Lesson Objectives:
Creating Diagrams with Visio 2003
- Identify the main features of Visio 2003
- Use the main components of the Visio 2003 interface
- Get help and other useful information while working in Visio 2003
- Navigate the Visio 2003 interface
- Create basic drawings in Visio 2003 using templates
- Manipulate shapes on the drawing page
- Work with connectors in Visio 2003
- Add shapes and connectors and manipulate them
- Save, preview, and print a diagram in Visio 2003
- Save and print a diagram in Visio 2003
Back to List
Developing Diagrams with Visio 2003
Overview/DescriptionTo demonstrate how to add and modify text and shapes
Target Audience
End users, office personnel at all levels, and anyone wishing to become familiar with Visio 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
3.75 Hours
Lesson Objectives:
Developing Diagrams with Visio 2003
- Add text to Visio 2003 shapes and diagrams
- Edit and format text in Visio 2003
- Insert and manipulate text in Visio 2003
- Create tables in Visio 2003
- Create tables using tab stops or shapes in Visio 2003
- Identify how to use rulers, gridlines, and guides
- Format shapes in Visio 2003
- Format shapes and position them on the drawing page
- Add and edit pages in Visio 2003
- Work with background and foreground pages in Visio 2003
- Create shapes, stencils, and templates in Visio 2003
- Create new stencils and templates
Back to List
Visio 2003 and Other Programs
Overview/DescriptionTo demonstrate how you can use Visio 2003 with other programs
Target Audience
End users, office personnel at all levels, and anyone wishing to become familiar with Visio 2003
Prerequisites Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments
Expected Duration
2 Hours
Lesson Objectives:
Visio 2003 and Other Programs
- Link Visio 2003 diagrams to Office applications and export Visio shapes as graphics
- Embed Visio shapes and diagrams in Office documents
- Link to and embed Visio diagrams in other Office documents
- Use data from other programs in Visio 2003 diagrams
- Bring data from other programs into a Visio diagram
- Share and protect Visio 2003 diagrams
- Share Visio drawing files while protecting the originals
Back to List
Microsoft Word 2003 Curriculum Outline
Getting Started with Word 2003
Overview/DescriptionTo 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
1 Hour
Lesson Objectives:
Getting Started with Word 2003
- 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
Back to List
Working with text and paragraphs in Word 2003
Overview/DescriptionTo 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
2 Hours
Lesson Objectives:
Working with Documents in Word 2003
- 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
Back to List
Structuring, editing, saving, and opening documents in Word 2003
Overview/DescriptionTo demonstrate how to structure, edit, save, and open 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
2 Hours
Lesson Objectives:
Structuring, editing, saving, and opening documents in Word 2003
- 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
Back to List
Printing, Help, and Automated Formatting in Word 2003
Overview/DescriptionTo 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
3 Hours
Lesson Objectives:
Printing, Help, and Automated Formatting in Word 2003
- 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
Back to List
Working with Documents in Word 2003
Overview/DescriptionTo 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
2 Hours
Lesson Objectives:
Working with Tables and Media Features in Word 2003
- 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 2003s speech recognition function
- Use the handwriting features in Word 2003
Back to List
Working with Tables and Media Features in Word 2003
Overview/DescriptionTo 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
Prerequisites The Microsoft Office 2003: Common Features Across Office Applications learning path; familiarity with a Windows environment
Expected Duration
4 Hours
Lesson Objectives:
Working with Tables and Media Features in Word 2003
- 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 2003s speech recognition function
- Use the handwriting features in Word 2003
Back to List
Advanced Formatting in Word 2003
Overview/DescriptionTo provide a detailed overview of the advanced page formatting features in Word 2003
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Advanced Formatting in Word 2003
- Use the advanced page formatting options in Word 2003
- Create and modify styles in Word 2003
- Apply themes and backgrounds and read document statistics in Word 2003 documents
- Apply page borders and themes and modify styles in a Word 2003 document
- Use footnotes and endnotes in Word 2003
- Create and revise endnotes using Word 2003
Back to List
Advanced Document Navigation in Word 2003
Overview/DescriptionTo demonstrate the advanced document navigation features in Word 2003
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
1 Hour
Lesson Objectives:
Advanced Document Navigation in Word 2003
- Use tables of contents in Word 2003
- Use hyperlinks, bookmarks, and frames in Word 2003
- Create indexes and cross-references in Word 2003
- Use advanced document navigation features in Word 2003
Back to List
Advanced Data Manipulation Features in Word 2003
Overview/DescriptionTo provide a detailed overview of the tools available for advanced data manipulation in Word 2003
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Advanced Data Manipulation Features in Word 2003
- Use forms in Word 2003
- Use fields in Word 2003
- Insert a field into a form and into a standard Word 2003 document, and configure print options for fields
- Use mail merge in Word 2003
- Use advanced mail merge options in Word 2003
- Create and manipulate mail merge data in Word 2003
Back to List
Using Tables, Charts, and Graphs in Word 2003
Overview/DescriptionTo provide a detailed overview of using tables, charts, and graphics
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Using Tables, Charts, and Graphics in Word 2003
- Create Word 2003 tables from Excel data
- Insert and use charts in Word 2003
- Insert Excel worksheets and charts in Word 2003
- Insert and use graphics in Word 2003
- Format drawings and insert picture watermarks in Word 2003
Back to List
Advanced Document Features in Word 2003
Overview/DescriptionTo provide a detailed overview of the advanced document features available for use in Word 2003
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
2 Hours
Lesson Objectives:
Advanced Document Features in Word 2003
- Create, edit, and use macros in Word 2003
- Customize toolbars and menus in Word 2003
- Create and record a macro in Word 2003
- Create a custom toolbar and menu in Word 2003
- Use master documents and subdocuments in Word 2003
- Modify and manage master documents in Word 2003
- Work with master documents in Word 2003
Back to List
Collaborative Features in Word 2003
Overview/DescriptionTo provide a detailed overview of the collaborative features in Word 2003
Target Audience
Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2003; advanced end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent
Prerequisites The Microsoft Office 2003: Beginning Word learning path; familiarity with the Microsoft Windows environment and some experience of using Microsoft Office; competency in the use of Microsoft Word; an understanding of the Internet and web-page functionality, as well as an understanding of the process of web-page creation, would be an advantage
Expected Duration
4 Hours
Lesson Objectives:
Collaborative Features in Word 2003
- Share documents and create document versions in Word 2003
- Configure security settings for a document in Word 2003
- Manage document versions and apply editing and style restrictions in Word 2003
- Use shared workspaces to collaborate in Word 2003
- Use a shared workspace to manage shared documents in Word 2003
- Work with document versions in Word 2003
- Use HTML in Word 2003 to create, modify, and optimize web pages
- Work with XML files in Word 2003 and recognize the function of smart documents
- Work with web pages and XML files in Word 2003
- Use the Track Changes feature and work with changes from multiple reviewers
- Review documents that have been edited by several users and send documents for review by e-mail
Back to List
Microsoft Office 2003
Microsoft Office 2003 training will help you learn desktop skills in Microsoft Office 2003 productivity programs such as; Microsoft
Word, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Access, Microsoft Publisher, Microsoft Visio and Microsoft
Project.
CBT Direct's Microsoft Office 2003 training provides computer literacy, measures your proficiency, and identifies any opportunity to enhancement your skills. Being able to use Microsoft Office 2003 efficiently will help set you apart from your peers in a very competitive job market.
Benefits of CBT Direct’s Online Microsoft Office Training
CBT Direct boasts the most beneficial online training on the market. With CBT Direct’s online training, you have the flexibility to
study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Microsoft Office training course is
accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct - the most affordable online
training solution today.
The unique design of CBT Direct’s Microsoft Office training course incorporates a proven four-step learning process: presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s Microsoft Office training course ensures the greatest level of comprehension and retention. CBT Direct is also a Microsoft Certified Partner.
Who Benefits from CBT Direct’s Microsoft Office Training?
Anyone interested in the knowledge of basic word processing and computing and wants familiarity with the Microsoft Office programs.
What Professionals Will Learn from CBT Direct’s Microsoft Office Training
Microsoft Office 2003: Getting Started
This course covers an introduction to Microsoft Office 2003 and how to format and print files.
Click here to see a detailed curriculum outline.
Microsoft Office 2003: New Features
This course covers what new features are in Microsoft Excel, PowerPoint, Outlook, Access and Publisher 2003.
Click here to see a detailed curriculum outline.
Microsoft Access 2003
This course covers getting started with Access 2003, basic tables, basic forms, queries, reports, importing and exporting data and
data presentation in Access 2003. The training will also teach you how to use advanced data management, programmability and
administration as well as database administration in Access 2003.
Click here to see a detailed curriculum outline.
Microsoft Excel 2003
This course will cover getting started with Excel 2003, manipulating, formatting data and Worksheets, reviewing and printing. The
training also teaches you Excel 2003 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data
management, advanced customization and how to analyzing data and how to protect and share Excel 2003 workbooks.
Click here to see a detailed curriculum outline.
Microsoft FrontPage 2003
This course covers getting started with FrontPage 2003, working with graphics, hyperlinks, tables and organizing content using
templates and frames. You will also learn how to structure and publish web sites, work with code, import data, enhance web sites
with advanced features, administer web sites and how to use Windows SharePoint Services and FrontPage 2003.
Click here to see a detailed curriculum outline.
Microsoft Outlook 2003
This course will cover getting started with Outlook 2003, formatting and managing E-mail, how to use the calendar in Outlook 2003.
The training will also teach you how to use contacts, tasks, notes, customize the interface and to complete searches, print items
and work with RSS Feeds in Outlook 2003. Students will be introduced to customizing Outlook 2003, using the Journal, configuring
rules, alerts, junk mail, working with SharePoint, calendars and Forms. Lastly, you will learn data security, archiving, working
offline, how to use instant and unified messaging, as well as, the business contact manager in Outlook 2003.
Click here to see a detailed curriculum outline.
Microsoft PowerPoint 2003
This course will cover getting started with PowerPoint 2003, how to add graphics to presentations, how to add multimedia and
animations to presentations, how to create custom slide shows and how to distribute presentations using PowerPoint 2003.
Click here to see a detailed curriculum outline.
Microsoft Project Professional 2003
This course covers creating, defining, specifying, assigning resources, tracking, reporting, advanced customization, sharing Project
data, working with macros, organizing, managing information and working collaboratively. The training also introduces the student to
Enterprise Project Management and advanced analysis of your project.
Click here to see a detailed curriculum outline.
Microsoft Publisher 2003
This course covers creating customized publications with Publisher 2003 and extending Publisher beyond publications.
Click here to see a detailed curriculum outline.
Microsoft Visio 2003
This course covers creating Visio diagrams, enhancing and customizing diagrams in Visio 2003. You will also learn how collaborate and
use Visio 2003 with other programs.
Click here to see a detailed curriculum outline.
Microsoft Word 2003
This course will cover getting started with Word 2003, working with text, paragraphs, structuring, editing, saving, and opening
documents. You will also learn how to use the printing, help, automated formatting, advanced formatting and advanced document
navigation in Word 2003. The training introduces student to tables, charts, graphics, advanced data manipulation and advanced document
features.
Click here to see a detailed curriculum outline.
Microsoft Office 2003: Getting Started
Microsoft Office 2003: New Features
Microsoft Access 2003
Microsoft Excel 2003
Microsoft FrontPage 2003
Microsoft Outlook 2003
Microsoft PowerPoint 2003
Microsoft Project Professional 2003
Microsoft Publisher 2003
Microsoft Visio 2003
Microsoft Word 2003