Windows XP Level 1

Performance-Based Objectives  Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

· You will create a document by using WordPad.

· You will organize the contents of your hard drive by using Windows Explorer.

· You will create an efficient work environment by using the Control Panel and Accessibility programs.

· You will perform a variety of media tasks by using the Help and Support Center.

· You will clean up your system by using My Computer and the Recycle Bin.

· You will find information on the Internet by using Internet Explorer.

Course Content

Lesson 1: Creating a Document in Windows

Topic 1A: Launch a Program

Topic 1B: Create a Document

Topic 1C: Save a Document

Topic 1D: Preview and Print a Document

Topic 1E: Cut, Copy, and Paste Information

Lesson 2: Organizing Files

Topic 2A: Find a File

Topic 2B: Create a Folder

Topic 2C: Move a File

Topic 2D: Create a Shortcut

Lesson 3: Omitted

Lesson 4: Creating an Efficient Work Environment

Topic 4A: Change Mouse Properties

Topic 4B: Change Volume and Sound Properties

Topic 4C: Change Display Properties

Topic 4D: Switch Users

Topic 4E: Work with Accessibility Programs

Lesson 5: Working with Media

Topic 5A: Use Help Search

Topic 5B: Create Favorites

Topic 5C: Play a Video

Lesson 6: Cleaning Up Your System

Topic 6A: Check System Capacity

Topic 6B: Analyze Your Hard Drive

Topic 6C: Delete File and Folders

Topic 6D: Empty the Recycle Bin

Lesson 7: Finding Information on the Internet

Topic 7A: Browse the Web

Topic 7B: Move to Specific Web Sites

Topic 7C: Use Favorites to Return to Web Sites

 

Windows Level 1

Course content

Lesson 1: The Windows Environment

  • Logging on to your Workstation
  • The Windows Desktop
  • Overview of Input Devices
  • The Taskbar and the Start Menu
  • Working with an Open Window
  • Using Help

Lesson 2: Working with the Windows Hierarchy

  • An Introduction to the Windows Hierarchy
  • My Computer
  • My Network Places
  • The Search Feature

Lesson 3: Using Windows Explorer

  • Orientation to the Windows Explorer
  • Creating Folders
  • Copying and Moving Objects
  • Using the Recycle Bin

Lesson 4: Working with Windows Programs

  • An Orientation to Windows Programs
  • Cutting, Copying, and Pasting in Windows Programs.

Lesson 5: Customizing the Windows Desktop

  • Working with Shortcuts
  • Using Web Style View for the Desktop and Folders
  • Working with Control Panel Settings

Lesson 6: Using the Network and the Active Directory

  • My Network Places
  • The Active Directory
  • Working Remotely

Lesson 7: Managing and Administering the Workstation

  • Microsoft Management Console
  • Control Panel
  • NTFS

Windows Level 2

Course content

Lesson 1: Customizing the User Interface

  • Modifying the Start Menu
  • Customizing the Taskbar
  • Setting Folder Options

Lesson 2: File Maintenance

  • Viewing File and Folder Attributes
  • Protecting Data
  • Managing File Associations

Lesson 3: System Tools

  • Managing Storage
  • Backup and Restore
  • Increasing Disk-Drive Space
  • Optimizing System Performance

Lesson 4: Printing

  • Adding a Network Printer
  • Managing Print Jobs
  • Windows Troubleshooters

Lesson 5: Using Applications

  • Administrator Privileges
  • Other Applications
  • Making Applications Easier To Use
  • Using Windows Accessories

GroupWise Level 1


Performance-Based Objectives

  • Discuss the basic concepts of an electronic mail package and navigate through the GroupWise environment.
  • Read mail, create and send messages, reply to and forward messages, work with advanced message options, set mail properties, and work with Sent items.
  • Use the Address Book to send messages, create a personal address book, create a mail group, and work with contacts.
  • Customize message headers, work with attachments, create checklists, archive messages, and delete messages.
  • Work with mail folders including the Junk Mail folder, sort and filter mail messages, and create color-coded categories.
  • Work with a calendar, schedule posted appointments, schedule appointments for others, and work with Reminder Notes.
  • Schedule a resource, use the Multi-User View feature, and create and use rules.

Course Content

Lesson 1: Getting Started with GroupWise

Topic 1A: An Overview of GroupWise

Topic 1B: The GroupWise Environment

Topic 1C: The GroupWise Help System

 

Lesson 2: Working with Mail Messages

Topic 2A: Reading Mail

Topic 2B: Creating and Sending Messages

Topic 2C: Reply to and Forward a Message

Topic 2D: Working with Advanced Message Options

Topic 2E: Setting Mail Properties

Topic 2F: Working with Sent Items

 

Lesson 3: Working with the Address Book

Topic 3A: Using the Address Book to Send Messages

Topic 3B: Creating a Personal Address Book

Topic 3C: Creating a Mail Group

Topic 3D: Working with Contacts

 

Lesson 4: Managing Mail

Topic 4A: Customizing Message Headers

Topic 4B: Working with Attachments

Topic 4C: Creating a Checklist

Topic 4D: Archiving Messages

Topic 4E: Deleting Messages

 

Lesson 5: Organizing Your Mailbox

Topic 5A: Working with Folders

Topic 5B: Configuring Junk Mail Handling

Topic 5C: Sorting and Filtering Mail Messages

Topic 5D: Creating Color-Coded Categories

 

Lesson 6: Using Your Calendar

Topic 6A: Working with a Calendar

Topic 6B: Scheduling Posted Appointments

Topic 6C: Scheduling Appointments for Others

Topic 6D: Working with Reminder Notes

 

Lesson 7: Using Resources and Multi-User Views

Topic 7A: Scheduling a Resource

Topic 7B: Using Multi-User View

Topic 7C: Working with Rules

 

GroupWise Level 2


Performance-Based Objectives

  • Customize GroupWise according to their preferences.
  • Use GroupWise Instant Messenger and participate in a discussion thread by using a shared folder.
  • Create, share and manage documents, and use GroupWise WebPublisher.
  • Use workflows to route, perform, and track tasks.
  • Work with mail and documents using the Web Access interface.
  • Create and use Rules to automate email responses, manage resource reservations, and set access rights.

 

Course Content

Lesson 1: Customizing GroupWise

Topic 1A: Customizing the Inbox

Topic 1B: Customizing the Calendar

 

Lesson 2: Using and Sharing Information

Topic 2A: Using Instant Messaging

Topic 2B: Using Discussion Threads

 

Lesson 3: Working with Documents

Topic 3A: Creating Documents

Topic 3B: Sharing Documents

Topic 3C: Managing Documents

Topic 3D: Using WebPublisher

 

Lesson 4: Controlling Workflow

Topic 4A: Working with Tasks

Topic 4B: Tracking a Broadcast Workflow Task

Topic 4C: Tracking a Sequential Workflow Task

 

Lesson 5: Introduction to GroupWise Web Access

Topic 5A: Exploring the WebAccess Environment

Topic 5B: Working with Mail Messages

Topic 5C: Organizing Web Mail Messages

Topic 5D: Documents and WebAccess

 

Lesson 6: Working with Rules and Access Rights

Topic 6A: Creating and Using Rules

Topic 6B: Using Rules to Manage Resource Reservations

Topic 6C: Setting Access Rights

 

 

 

Internet/Intranet

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Describe the software and hardware required to connect to the Internet, and identify the main components of the Internet Explorer 5.0 window.
  • Find Web sites that contain useful information, and use Favorites to maintain links to particularly useful sites.
  • Use Internet Explorer’s Help system to get information about how to browse more efficiently and effectively.
  • Use Outlook Express to send and receive email, as well as to participate in newsgroup discussions.
  • Download and unzip zipped files from the Internet, and browse and use files from an FTP site.
  • Use the Internet Options dialog box to specify a home page, control History, and change settings for temporary Internet files.
  • Personalize the MSN home page and identify other candidates to be used as a home page.

Course content

Lesson 1: Overview of Internet Explorer

  • Overview of the Internet and the World Wide Web
  • Orientation to Internet Explorer

Lesson 2: Browsing the Web

  • AutoComplete and Automatic Searching
  • Using Favorites to Return to Web Sites
  • Using Search Tools
  • Organizing Favorites
  • Finding People and Businesses

Lesson 3: Getting Help

  • Using Internet Explorer’s Help System
  • Getting Help Through the Web

Lesson 4: Introduction to Net Etiquette

  • Net Etiquette

Corel Office to Microsoft Office Transition

Performance-based objectives

Lesson objectives will assist students to become comfortable with the Microsoft Office suite, particularly Word and Excel.

  • Identify the differences in WordPerfect and Word and establish similarities in functionality.
  • Discussion of Reveal Codes and Styles as used in Microsoft Word.
  • Assistance with expectations when converting WordPerfect documents.
  • Identify the differences in Quattro Pro and Excel and establish similarities in functionality.
  • Assistance with expectations when converting Quattro Pro spreadsheets to Excel.

MS Office Tips & Tricks (1/2 day)

  • Snap to Grid Options

  • Convert Tables to Text or Text to Table

  • Auto-print Selected Incoming E-Mail Messages

  • Auto-Summarize Word Documents

  • Custom Table Borders

  • Split Window in Word

  • Duplicate Icon Functions

  • Change Formulas to Values

  • Link Text

  • Work Menu Button

  • Clearing WORK menu entry

  • Find/Replace/Special

  • Control Drag

  • Select an Entire Range of Cells in Excel

  • Add a Calculator to your Excel Toolbar

  • Shift Select

  • Control Select

  • Tiling Windows

  • Breakaway Toolbars

  • Right Drag Options

  • Function Keys by App

  • Ungroup Graphs

  • Relative to Page

  • Print Page Macro

  • Copy/Paste Special Values

  • Custom Lists

  • Conditional Formatting

  • Custom Graphs

  • Custom Numbers

  • Fill Series

  • Double Click Fill Series

  • Shift-end Down Arrow

  • Transpose

  • Text to Numbers

  • Validation

Windows 98 Level I
Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Use fundamental personal computing concepts and terminology
  • Work with Windows 98 desktop objects and windows
  • Navigate to information stored on their computer
  • Use Windows Explorer to manage files and folders
  • Use common Windows 98 program techniques by working with WordPad and Paint
  • Customize the Windows 98 desktop to best suit their needs
  • Access the Internet and use the basic functions of the Internet Explorer environment

Lesson 1: Introduction to personal computing

  • Orientation to personal computers
  • Orientation to how computers work
  • The larger world of personal computers

Lesson 2: The Windows 98 environment

  • The Windows 98 desktop
  • Orientation to the keyboard and mouse
  • The taskbar and the Start menu
  • Working with an open window
  • Using Help

Lesson 3: The Windows 98 hierarchy

  • An introduction to the Windows 98 hierarchy
  • My Computer
  • Network Neighborhood
  • The Find feature

Lesson 4: Using Windows Explorer

  • Orientation to the Windows Explorer
  • Creating folders
  • Copying and moving objects
  • Using the Recycle Bin

Lesson 5: Working with Windows 98 programs

  • An orientation to Windows 98 programs
  • Cutting, copying, and pasting in Windows 98 programs

Lesson 6: Customizing the Windows 98 desktop

  • Working with shortcuts
  • Using Web Style for the desktop and folders
  • Working with Control Panel settings

Lesson 7: Introduction to Internet Explorer

  • Connecting to the Internet
  • Using Internet Explorer
  • An overview of the Active Channel Guide
  • Shutting down Windows 98

 

TCP/IP : Introduction and Advanced

 

Overview: TCP/IP: Introduction and Advanced provides a basic understanding of the configuration, communication, and management of one of the most widely used internetworking protocols and the backbone of today's Internet.

Performance-Based Objectives

· Describe how and why the TCP/IP protocol suite was invented.

· Define the similarities and the differences between the OSI model and the TCP/IP model.

· Describe how TCP/IP addresses are structured.

· Describe the format of TCP/IP headers.

· Describe the functions of the prevalent TCP/IP protocols, ports, and sockets.

· Define the concept of subnetting and why it is used.

· Describe the functions of the TCP/IP routing protocols.

· Describe how Classless InterDomain Routing (CIDR) or supernetting helps conserve addresses.

· Define how multicasting works and the future of TCP/IP Ipv6.

 

Relational Database Design: A Practical Approach

Performance-based objectives

 

  • Be conversant with the terminology used in reference to relational databases and be familiar with the design process.
  • Identify data as fields, group fields into tables, select key fields, and identify table relationships.
  • Identify data problems and apply data normalization techniques to solve them.
  • Use referential integrity and other data integrity techniques to support the accuracy of data in the database.
  • Use criteria and operators and perform appropriate table joins in queries.
  • Understand basic SQL queries and techniques for improving the performance of queries.

 

Approach: Introduction

 

Performance-based objectives

 

  • Demonstrate an understanding of database concepts by using database terminology and identifying the components of an Approach database.
  • Apply database design principles by creating a database and inputting data.
  • Modify forms, worksheets, and databases by adding, moving, and deleting fields.
  • Find specific records or groups of records by using Approach to sort and locate data.
  • Manage data by using search criteria such as operators and conditions.
  • List, group, and summarize data by creating and modifying reports.
  • Enhance forms by applying data-validation techniques, moving objects, and adding macro buttons and graphics.
  • Manage multiple databases by applying database design principles and joining multiple databases.

 

Approach: Advanced

Performance-based objectives

 

* Define databases and add data to them by using templates and by importing and exporting data.

* Explore the Approach Preferences settings, and identify and solve common data problems by applying the concepts of data normalization.

* Create forms based on multiple databases by using a repeating panel.

* Display data from multiple databases by creating repeating panel reports.

* Analyze and evaluate the information in databases by creating worksheets, crosstabs, and charts.

* Create form letters and generate mailing labels from databases.

* Use existing macros like templates to create new macros, and create decision-making macros by using the If function.

* Personalize the Approach environment by displaying a customized set of SmartIcons and creating a custom menu.

 

 

Microsoft Publisher

Performance-Based Objectives

Upon successful completion of this course, students will be able to:
  • create a one-page publication.
  • modify a publication's layout and structure.
  • edit content in a publication.
  • format text.
  • format pictures.
  • identify the options for distributing a publication.

Course Content

Lesson 1: Creating a Basic Publication
Topic 1A: Examine the Publisher Environment
Topic 1B: Create a Publication from a Publication Design
Topic 1C: Replace Design Object Placeholders
Topic 1D: Save a Publication
Topic 1E: Create a Blank Publication
Topic 1F: Display Ruler Guides
Topic 1G: Add Text
Topic 1H: Insert a Picture from a File

 
Lesson 2: Modifying a Publication's Layout and Structure
Topic 2A: Insert and Delete Pages
Topic 2B: Insert a Text File
Topic 2C: Size Text Boxes and Picture Frames
Topic 2D: Move Text Boxes and Picture Frames
Topic 2E: Connect Text Boxes
Topic 2F: Divide Text Boxes into Columns
Topic 2G: Move a Page
Topic 2H: Create and Use a Master Page

 
Lesson 3: Editing Content in a Publication
Topic 3A: Edit Text in a Publication
Topic 3B: Research Information
Topic 3C: Find and Replace Text
Topic 3D: Check Spelling

 
Lesson 4: Formatting a Publication
Topic 4A: Format Text
Topic 4B: Apply Schemes
Topic 4C: Insert Symbols
Topic 4D: Indent Paragraphs
Topic 4E: Change Spacing Between Paragraphs
Topic 4F: Control Paragraph Flow
Topic 4G: Create Paragraph Styles
Topic 4H: Format Text Boxes

 
Lesson 5: Formatting Pictures in a Publication
Topic 5A: Format Picture Frames
Topic 5B: Crop a Picture
Topic 5C: Wrap Text Around a Picture
Topic 5D: Insert WordArt
Topic 5E: Insert a Design Gallery Object

 
Lesson 6: Preparing a Publication for Distribution
Topic 6A: Check the Design of a Publication
Topic 6B: Verify Pictures
Topic 6C: Create a Newsletter to Email
Topic 6D: Create a Web Page
Topic 6E: Publish a Web Site
Topic 6F: Preview and Print a Publication
Topic 6G: Templates

 
Appendix A: Computers and Computing: Basic Skills

 

 

 

 


Netscape Navigator

Performance-based objectives

  • Describe the software and hardware required to connect to the Internet, and identify the main components of the Netscape Navigator window.
  • Find Web sites that contain useful information, and use Favorites to maintain links to particularly useful sites.
  • Use Netscape Navigator's Help system to get information about how to browse more efficiently and effectively.
  • Download and unzip zipped files from the Internet, and browse and use files from an FTP site.
  • Use the Internet Options dialog box to specify a home page, control History, and change settings for temporary Internet files.
  • Personalize the home page and identify other candidates to be used as a home page.

 

 

Photoshop Level 1

Prerequisites: Before taking this course, students should be familiar with the basic functions of their computer's operating system, such as creating folders, launching programs, and working with windows. They should also have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc. The students should also be familiar with the basic features/functions and terminology of image editing.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:
  • explore the Photoshop CS3 environment.
  • work with image areas.
  • work with multiple layers.
  • enhance images.
  • save images in the web, print, and PDF formats.
  • manage assets by using the various tools available in Adobe Bridge.

Course Content

Lesson 1: Exploring the Photoshop Environment
Topic 1A: Explore the Photoshop Interface
Topic 1B: Customize the Workspace
Topic 1C: Explore the Navigation Tools
 
Lesson 2: Working with Image Areas
Topic 2A: Select Image Areas
Topic 2B: Save a Selection
Topic 2C: Modify a Selection
 
Lesson 3: Working with Layers
Topic 3A: Create Layers
Topic 3B: Create Type Layers
Topic 3C: Transform Layers
Topic 3D: Alter Type Properties
Topic 3E: Apply Layer Styles
Topic 3F: Undo Previous Steps
Topic 3G: Arrange and Group Layers
 
Lesson 4: Enhancing Images
Topic 4A: Paint Strokes on an Image
Topic 4B: Apply Filter Effects
Topic 4C: Convert an Image to Black and White
Topic 4D: Blend Layers
Topic 4E: Merge Layers and Flatten Images
 
Lesson 5: Saving Images for Web and Print
Topic 5A: Save Images for Use in Print Applications
Topic 5B: Save Images for the Web
Topic 5C: Save Images as PDF
 
Lesson 6: Managing Assets with Adobe® Bridge
Topic 6A: Explore Adobe Bridge
Topic 6B: Work with Adobe Bridge
Topic 6C: Work with Stacks and Filters in Adobe Bridge
Topic 6D: Apply Metadata and Keywords to Files
 
Appendix A: Adobe Certified Expert (ACE) Program®
 

Photoshop Level 2

Prerequisites: Before taking this course, students should have taken the Adobe® Photoshop® CS3: Level 1 course or have equivalent knowledge.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:
  • use the various tools to mask and clip layers to edit an image.
  • create and edit vector paths to use the paths to create masks.
  • use the tools available in Adobe® Photoshop® to enhance an image.
  • create special effects.
  • use the video tools available in Adobe® Photoshop® to edit video files.
  • automate tasks in Adobe® Photoshop®.

Course Content

Lesson 1: Masking and Clipping Layers
Topic 1A: Edit an Image Using Quick Mask Overlay
Topic 1B: Save and Edit a Selection as an Alpha Channel
Topic 1C: Work with Layer Masks
Topic 1D: Clip a Layer
 
Lesson 2: Masking with Vector Paths
Topic 2A: Create Vector Paths
Topic 2B: Edit Paths
Topic 2C: Mask Images with Paths
 
Lesson 3: Enhancing Photographs
Topic 3A: Retouch Photographs Using Photoshop Tools
Topic 3B: Adjust Tonal Range Using Adjustment Layers
Topic 3C: Create Patterns
Topic 3D: Create Swatches and Gradients
Topic 3E: Create a Custom Brush

 
Lesson 4: Creating Special Effects
Topic 4A: Preview Text Effects Using Layer Comps
Topic 4B: Warp an Image
Topic 4C: Work in Vanishing Point
 
Lesson 5: Working with Video Files
Topic 5A: Preview Videos in Photoshop
Topic 5B: Retouch Videos
 
Lesson 6: Automating Tasks
Topic 6A: Create an Action
Topic 6B: Manage Actions
Topic 6C: Automate Tasks in Adobe Bridge
 
Appendix A: Working in Adobe Device Central CS3
 
Supplemental Topic Preview Images in Adobe Device Central CS3
 
Appendix B: Adobe Certified Expert (ACE) Objectives Mapping


Project Management Professional Certification

Your ability as a project manager to demonstrate best practices in project management—both on the job and through professional certification—is becoming the standard to compete in today's fast-paced and highly technical workplace. This course expands upon the basic concepts of project management you discovered in the Project Management Fundamentals course and covers in-depth the essential elements of managing a successful project. Focusing on the generally accepted practices of project management recognized by the Project Management Institute, Inc. (PMI®), this course offers you a standards-based approach to successful project management across application areas and industries.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

Course Content

Lesson 1: Initiating a Project

Topic 1A: Apply Project Management Processes

Topic 1B: Create a Project Charter

Topic 1C: Develop a Draft Project Scope Statement

 

Lesson 2: Planning Project Work

Topic 2A: Develop a Project Management Plan

Topic 2B: Create a Scope Management Plan

Topic 2C: Create a Scope Statement

Topic 2D: Develop a Work Breakdown Structure (WBS)

 

Lesson 3: Developing Project Schedules, Cost Estimates, and Budgets

Topic 3A: Create an Activity List

Topic 3B: Create a Project Network Diagram

Topic 3C: Estimate Activity Resources

Topic 3D: Estimate Activity Durations

Topic 3E: Identify the Critical Path

Topic 3F: Develop a Project Schedule

Topic 3G: Estimate Project Costs

Topic 3H: Establish a Cost Baseline

 

Lesson 4: Planning Project Quality, Staffing, and Communications

Topic 4A: Create a Quality Management Plan

Topic 4B: Document Roles, Responsibilities, and Reporting Relationships

Topic 4C: Acquire Project Team

Topic 4D: Create a Communications Management Plan

 

Lesson 5: Analyzing Risks and Planning Risk Response

Topic 5A: Create a Risk Management Plan

Topic 5B: Identify Project Risks and Triggers

Topic 5C: Perform Qualitative Risk Analysis

Topic 5D: Perform Quantitative Risk Analysis

Topic 5E: Develop a Risk Response Plan

 

Lesson 6: Planning Project Procurement

Topic 6A: Prepare a Contract Statement of Work

Topic 6B: Prepare a Procurement Document

 

Lesson 7: Executing Project Work

Topic 7A: Project Plan Execution

Topic 7B: Perform Quality Assurance

Topic 7C: Develop the Project Team

Topic 7D: Distribute Project Information

Topic 7E: Request Seller Responses

Topic 7F: Select Sellers

 

Lesson 8: Monitoring and Controlling Project Work

Topic 8A: Control and Monitor Project Work

Topic 8B: Manage Changes to Performance Baselines

Topic 8C: Review Deliverables and Work Results

Topic 8D: Control Project Scope

 

Lesson 9: Monitoring and Controlling Project Schedules and Costs

Topic 9A: Control the Project Schedule

Topic 9B: Control Project Costs

 

Lesson 10: Monitoring and Controlling Project Quality, Staffing, and Communications

Topic 10A: Perform Quality Control

Topic 10B: Manage Project Team

Topic 10C: Report Project Performance

Topic 10D: Manage Stakeholders

 

Lesson 11: Monitoring and Controlling Project Risk and Contracts

Topic 11A: Monitor and Control Project Risk

Topic 11B: Administer a Contract

 

Lesson 12: Closing the Project

Topic 12A: Close a Project

Topic 12B: Close a Contract


Manage, Plan, and Analyze Inventory with MS Access

* Define data needed to track inventory.

* Calculate current inventory, archive inventory, and update records by creating queries.

* Summarize inventory usage by month with a Crosstab query, and calculate weekly average usage by creating a report.

* Use a reorder point to trigger supply orders by creating a query and modifying a form.

* Calculate the total value of inventory and total orders to suppliers by creating queries and reports.

 

Lab content

Lab Activity 1: What data do I need?

Lab Activity 2: What do I have in stock?

Lab Activity 3: How much do I need to order?

Lab Activity 4: When do I need to order?

Lab Activity 5: How am I doing?

Normalize Data from Excel to Access

Objectives

Upon successful completion of this Lab, students will be able to:

Create and normalize a database from Excel data using Access

Lab content

Lab Activity 1: Know the data

Lab Activity 2: Normalize the data

Lab Activity 3: Identify key fields and table relationships

Lab Activity 4: Import the data and finish the database design

Lab Activity 5: Build queries and a form

Bring Your Projects in Under Budget and On Time Using Microsoft Project 2000

Objectives

Lab Activity 1: Practice sound project management with Project 2000

Lab Activity 2: Use a baseline and avoid project overruns

Lab Activity 3: Get a handle on the data you need

Lab Activity 4: Take control of your schedule and tame project costs

Create and manage a worksheet database using Excel

Objectives

Upon successful completion of this Lab, students will be able to:

* Prepare worksheet data as an Excel list, and sort list data.

* Update a list by working on the worksheet and in a Data Form, and use Data Validation to help with data entry.

* Use the AutoFilter, Advanced Filter, and Data Form features to find list data that matches their criteria.

* Sort filtered data, display subtotals, and create charts from subtotals.

Lab content

Lab Activity 1: Prepare and sort a list

Lab Activity 2: Maintain a list

Lab Activity 3: Find data

Lab Activity 4: Use sorted and filtered data

 

Integrate data and graphs into your Word 2000 documents using Excel

Objectives

Upon successful completion of this Lab, students will be able to:

  • Incorporate Excel data and graphs into Word using various methods and know the difference between linking and embedding.
  • Dynamically update data in Excel graphs and customize graphs to create effective documents.
  • Use MS Graph to create charts.
  • Use graphics and visuals with graphs in Word.

 

Lab content

Lab Activity 1: Add some zing with Excel charts and data

  • Incorporate Excel data into Word
  • Graph it!
  • Link an Excel graph and Word document
  • Create a new graph from Word
  • Change the look of a linked graph
  • Break it up
  • Try it on your own

Lab Activity 2: Update Data and Customize your Excel graphs

  • Update a linked graph
  • Update an embedded graph
  • Add and automate captions
  • Try it on your own
  • Work with titles
  • Change the colors and patterns of a graph

Lab Activity 3: Use MS Graph to create charts

  • Create a graph using MS Graph
  • Illustrate a graph by adding a text box
  • Rotate text in a chart title
  • Convert a Word table to a graph using MS Graph
  • Choose what data to include in a chart
  • Import data from an Excel worksheet into MS Graph

Lab Activity 4: Use visuals in your graphs

  • Add a company logo to your Excel graph
  • Add visuals to an MS Graph graph
  • Customize visuals using Word
  • Try it on your own
  • Remove visuals from a data series

Boost Your Communication Skills Using MS Office

Objectives

Upon successful completion of this Lab, students will be able to:

 

· Identify the basics of effective communication, and include a feedback loop in their messages.

·Create an online resume using Word.

· Design a slide show for optimum visual impact, and rehearse the presentation in PowerPoint.

· Send and receive instant messages, and conduct a real-time meeting in a chat room.

  

Lab content

 

Lab 1: Identify the basics of effective communication

Identify the basics

Consider the components

One- and two-way communication

Identify the meaning of the message

Examine some scenarios

Include a feedback loop

 

Lab 2: Use Word to enhance your business writing

Write for the reader

Create an online resume

Design a resume for the Web

Post it to the Web

Try it on your own

 

Lab 3: Visualize your message

Presentation basics

Design for visual impact

Take time to rehearse

Try it on your own

 

 

Increase productivity by creating a Digital Dashboard using MS Office 2000

Objectives

Upon successful completion of this Lab, students will be able to:

  • Plan and organize content for a Digital Dashboard.
  • Identify what information they want to include in their first Digital Dashboard.
  • Design a basic Digital Dashboard.
  • Deploy, manage, and update a Digital Dashboard.

 

Lab content

Lab Activity 1: Get started

  • Get to know the Digital Dashboard
  • Download and install the Microsoft Digital Dashboard Starter Kit
  • View a sample Digital Dashboard
  • Try it on your own

Lab Activity 2: Identify your needs for your first Digital Dashboard

  • Brainstorm types of information you use everyday
  • Identify the people who will develop and use your first Digital Dashboard
  • Sketch out your basic Digital Dashboard
  • Try it on your own

Lab Activity 3: Design a basic Digital Dashboard

  • Design the pages of the Digital Dashboard
  • Create a navigation bar
  • Add content to the pages
  • Add a Public Folder to Outlook
  • Test the Digital Dashboard
  • Try it on your own

Lab Activity 4: Deploy, manage, and update your Digital Dashboard

  • Explore the possibilities for deploying a Digital Dashboard
  • Review some basic implementation concerns
  • Update your basic Digital Dashboard
  • Try it on your own
 

Personalize your business communications and reports using Microsoft Office

Objectives

Upon successful completion of this lab, students will be able to:

  • create mailing labels in Word using data from Excel
  • create personalized envelopes with Word’s Envelope feature
  • use a graphic theme in your Office documents
  • design personalized business cards in Word
  • analyze and chart Access data with Excel

Lab content

Lab Activity 1: Whip up some mailing labels with Excel data

  • Begin with a spreadsheet
  • Create the main document
  • Open the data source
  • Add merge fields to the main document
  • Merge the data
  • Print the labels

Lab Activity 2: Create custom envelopes with Word

  • Create a graphic
  • Add the graphic to an envelope
  • Save the envelope as a template
  • Enter the delivery address

Lab Activity 3: Create a graphic theme for Office documents

  • Save a slide as a graphic
  • Use a graphic in Excel as a chart background
  • Use a graphic in Word as a page border

Lab Activity 4: Design business cards with Word

  • Prepare the graphic
  • Create the text box
  • Enter and format the text
  • Combine the elements
  • Use Word’s Label feature to set up the card document
  • Print the cards

Lab Activity 5: Build an Excel chart to show off your Access data

  • Choose your file
  • Use Access’ Analyze It With MS Excel feature
  • Use Excel’s AutoFilter and Chart features

Keyboarding 101 (3 hour course)

Objectives:

Introduction:

Lesson 1:

 Lesson 2: 

 Lesson 3: 

 Lesson 4: 


 Keyboarding 102  (3 hour course)

Objectives:

Introduction:

 Lesson 1: 

 Lesson 2: 

 Lesson 3: 

 Lesson 4:

 


Microsoft® Office 2003: New Features

Prerequisites: Before taking this course, students are required to take the following courses or have equivalent knowledge:
  • Windows XP: Introduction
  • Word 2000: Level 1
  • Excel 2000: Worksheets
  • PowerPoint 2000: Level 1
  • Access 2000: Level 1
  • Outlook 2000: Level 1

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

Course Content

Lesson 1: Using the Office 2003 Environment
Topic 1A: The Office 2003 Environment
Topic 1B: Navigate in Task Panes
Topic 1C: Use Smart Tags
Topic 1D: Apply a Template from the Online Office Template Gallery

 
Lesson 2: Using the New Features of Word
Topic 2A: View a Document in Reading Layout View
Topic 2B: Translate Words in Your Document
Topic 2C: Translate Via the Web
Topic 2D: Apply a Watermark
Topic 2E: Create a Drawing
Topic 2F: Apply Formatting Using a Task Pane
Topic 2G: Lock Styles in Your Documents
Topic 2H: Create Merged Documents

 
Lesson 3: Using the New Features of Excel
Topic 3A: Create Borders by Drawing
Topic 3B: Watching a Formula
Topic 3C: Evaluate a Formula
Topic 3D: Manage Links
Topic 3E: Republish to the Web
Topic 3F: Play Back Worksheet Data

 
Lesson 4: Using the New Features of PowerPoint
Topic 4A: Create a Diagram
Topic 4B: Add a Motion Path
Topic 4C: Create Multiple Masters
Topic 4D: Send a Presentation for Review
Topic 4E: Compare and Merge Presentations
Topic 4F: Create Slide Show Annotations
Topic 4G: Package a Presentation

 
Lesson 5: Using the New Features of Access
Topic 5A: Improve Efficiency in a Database
Topic 5B: View Information on Object Dependencies
Topic 5C: Save an Object as a Data Access Page
Topic 5D: Apply a Theme
Topic 5E: Back Up a Database

 
Lesson 6: Using the New Features of Outlook Mail
Topic 6A: The Outlook Environment
Topic 6B: Create a Search Folder
Topic 6C: Manage Junk Email
Topic 6D: Create a Message with a Link
Topic 6E: Clean Up Your Mailbox

 
Lesson 7: Using the New Features of Outlook Calendar
Topic 7A: View Multiple Calendars
Topic 7B: Propose a New Meeting Time
Topic 7C: Color Calendar Items
Topic 7D: Apply Conditional Formatting to Calendar Items
Topic 7E: Create a Group Schedule
 

Network your office with Windows 2000 Professional

Target student: Students participating in this Lab should be educated Windows users who are very familiar with the following:

• Using Windows Explorer and My Computer.

• Creating folders and moving and copying files.

• Navigating in the Windows environment.

Objectives

Upon successful completion of this Lab, students will be able to:

• Describe how to set up a physical network and the components of a Windows 2000 Professional network.

• Create and manage user accounts, log on as a different user, and create a custom Microsoft Management Console.

• Share folders with co-workers on a Windows 2000 Professional network.

• Install a local printer and share it with others on the network.

Lab content

Lab Activity 1: Set up a physical network

Lab Activity 2: Create Windows 2000 user accounts

Lab Activity 3: Share folders with your co-workers

Lab Activity 4: Share a network printer

Revision and Support Information
 
 
Increase Efficiency and Customize the User Interface Using Windows 2000

 

Objectives

Upon successful completion of this Lab, students will be able to:

* Perform effective searches.

* Customize your desktop.

* Modify system settings.

* Work with Accessory programs.

 

Increase Efficiency and Customize the User Interface Using Windows 2000

Lab content

Lab 1: Perform effective searches

Perform an advanced search

Search for a Help topic and add it to the Favorites tab

Try it on your own

Lab 2: Customize your desktop

Create a desktop shortcut to Windows Explorer

Add live Web content to your desktop using the Active Desktop feature

Personalize your display properties

Try it on your own

Lab 3: Modify system settings

Modify the Start menu

Set Start menu properties

Install a printer

Try it on your own

Lab 4: Work with Accessory programs

Play a streaming news clip

Organize video clips on the Favorites menu

Integrate Accessory programs

Try it on your own

Microsoft® Office Excel 2003: Level 1

Course Specifications

Course length: 1.0 day(s)
Certification: Microsoft® Office Specialist: Excel 2003

Course Description

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

 
Prerequisites: To ensure your success, we recommend you first take the following Element K course or have equivalent knowledge:

Performance-Based Objectives

Upon successful completion of this course, students will be able to:


 

Course Content

Lesson 1: Getting Started with Excel

Topic 1A: An Overview of Excel

Topic 1B: Navigate in Excel

Topic 1C: Select Data

Topic 1D: Enter Data

Topic 1E: Save a Workbook

Topic 1F: Obtain Help

 

Lesson 2: Modifying a Worksheet

Topic 2A: Move and Copy Data Between Cells

Topic 2B: Fill Cells with Series of Data

Topic 2C: Edit Cell Data

Topic 2D: Insert and Delete Cells, Columns, and Rows

Topic 2E: Find, Replace, and Go To Cell Data

Topic 2F: Spell Check a Worksheet

 

Lesson 3: Performing Calculations

Topic 3A: Create Basic Formulas

Topic 3B: Calculate with Functions

Topic 3C: Copy Formulas and Functions

Topic 3D: Create an Absolute Reference

 

Lesson 4: Formatting a Worksheet

Topic 4A: Change Font Size and Type

Topic 4B: Add Borders and Color to Cells

Topic 4C: Change Column Width and Row Height

Topic 4D: Merge Cells

Topic 4E: Apply Number Formats

Topic 4F: Create a Custom Number Format

Topic 4G: Align Cell Contents

Topic 4H: Find and Replace Formats

Topic 4I: Apply an AutoFormat

Topic 4J: Apply Styles

 

Lesson 5: Developing a Workbook

Topic 5A: Format Worksheet Tabs

Topic 5B: Reposition Worksheets in a Workbook

Topic 5C: Insert and Delete Worksheets

Topic 5D: Copy and Paste Worksheets

Topic 5E: Copy a Workbook

 

Lesson 6: Printing Workbook Contents

Topic 6A: Set a Print Title

Topic 6B: Create a Header and a Footer

Topic 6C: Set Page Margins

Topic 6D: Change Page Orientation

Topic 6E: Insert and Remove Page Breaks

Topic 6F: Print a Range

 

Lesson 7: Customizing Layout

Topic 7A: Split a Worksheet

Topic 7B: Arrange Worksheets

Topic 7C: Freeze and Unfreeze Rows and Columns