HomeTEC Home Page BackBack to the Programs Page

Desktop Applications General Syllabus

Certification Track:

MOS Microsoft Office Specialist

Course Prerequisites:

Computer skills, including knowledge of a Windows environment, be able to type and use a mouse. 

Course Length:

1 Day Microsoft Word 2003 CDP-100
1 Day Microsoft PowerPoint 2003 CDP-101
1 Day Microsoft Excel 2003 CDP-102
1 Day Microsoft Outlook 2003 CDP-103
1 1/2 Days Microsoft Access 2003 CDP-104

Course Objectives:

Microsoft Word 2003

Working with Paragraphs.  Working with Documents.  Using Tables. Working with Picture and Charts. Using Mail Merge. Using Advanced Features. Collaborating with Workgroups. Making Word Documents 508 compliant and accessible to those with disabilites. Using new SharePoint features such as XML, research task pane, shared workspaces and meeting workspaces.  

PowerPoint 2003

Creating a Presentation. Modifying a Presentation. Working with Text. Working with Visual Elements. Customizing a Presentation. Creating Output. Delivering a Presentation. Managing Files.  Making PowerPoint Documents 508 Compliant.  Setting up accessible meetings. Using new SharePoint features such as lists, smart tags, shared workspace and meeting workspaces.

Excel 2003

Importing and Exporting Data.  Using Templates. Using Multiple Workbooks. Formatting Numbers. Printing Workbooks. Working with Named Ranges. Working with Toolbars. Using Macros. Auditing a Worksheet. Displaying and Formatting Data. Using Analysis Tools. Collaborating with Workgroups. Using new SharePoint features such as smart tags and XML, shared workspace, meeting workspaces, discussions.

Outlook 2003

Handling mail messages, using the address book, working with contacts, managing tasks, managing appointments, working with events, customizing outlook and accessible e-mail. Using new SharePoint features search folders, quick flags, integrating the SharePoint calendar with Outlook 2003, shared workspace and meeting workspaces.

Access 2003

Planning and designing databases, Working with Access. Building and modifying tables. Building and modifying forms. Viewing and organizing information. Defining relationships. Producing reports. Integrating with other applications. Using Access tools. Analyzing and normalizing. Access databases in government work. Using new SharePoint features such as smart tags,  XML, shared workspaces and meeting workspaces. 

Student Labs

Student labs include hands on practical application of Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Access.

Instructional Methods:

This course combines lecture, presentation, laboratory hands-on exercises, discussions and problem solving.  Assessments will be made by practical exercises and examinations/quizzes.

Resources: 

Student Workbooks, exercises and readings that accompany the text, web site resources, electronic mail mentoring opportunities and computer-based training materials.  MOS practice testing software.

Individual Class Price:

1 Day Microsoft Word - $229.00
includes Microsoft Office Specialist exam, student workbooks (309 pages), practice testing software, course card, book tote and class supplies a $150 value.

1 Day Microsoft PowerPoint - $229.00
includes Microsoft Office Specialist exam, student workbooks (249 pages), practice testing software, course card, book tote and class supplies a $150 value.

1 Day Microsoft Excel - $229.00
includes Microsoft Office Specialist exam, student workbooks (287 pages), practice testing software, course card, book tote and class supplies a $150 value.

1 Day Microsoft Outlook - $229.00
includes Microsoft Office Specialist exam, student workbooks (287 pages), practice testing software, course card, book tote and class supplies a $150 value.

2 Days Microsoft Access - $329.00
includes Microsoft Office Specialist exam, student workbooks (336 pages), practice testing software, course card, book tote and class supplies a $150 value.

Copyright 2004 TEC.  This Web Site is Section 508 Compliant