Program   

Course Title   

Time*   

Short Description

Getting Started   

3 hrs   

Select text, edit document, save, cut, copy, paste, define auto correct entries

Tabs and Tables

2-3 hrs

Insert tabs, create tab leaders, use tables

Mail Merge   

2-3 hrs

Setting up main document, data document and merging the two together to create individual letters, labels, lists and envelopes

Graphics   

2-3 hrs 

Inserting clip art and pictures, wrapping text around graphics, using page borders, using the column command to create newsletters

Getting Started   

2-3 hrs 

Demonstrate structure of workbook and worksheets, rename worksheets, moving worksheets, using group editing, get stared with formulas and functions

Using Formulas and Functions   

2-3 hrs   

Continue identifying and developing formulas and using functions. Using absolute and relative references.

Using Excel as a Database   

2-3 hrs 

Create a database, sort records, using filters and creating pivot tables.

Using and Creating Graphs   

2-3 hrs 

Select cells and create graphs. Change parameters of graphs, add and remove data from graphs

Getting Started   

2-3 hrs 

Create a new presentation, add slides, import design template, indent text, insert graphics

Animating the Presentation   

2-3 hrs 

Use transitions and builds, adding sound and video

Getting Started   

4-6 hrs 

Use the tools in the program to create one page documents

Beyond the Basics   

4-6 hrs 

Work with multi-page documents, import text, format text, use the master

Inspiration   

Overview   

1.5-2 hrs

Use the functions of the diagram and outline screens

Getting Started   

1.5-2 hrs 

Use of hard and soft buttons, getting started with graffiti, creating and beaming a business card.

Becoming More Productive   

1.5-2 hrs   

Define and use categories, beam applications, dates and notes, create shortcuts.

Getting Started   

4-6 hrs

Understand structure of web site, set page and shared border properties, use themes, and insert tables.

Beyond the Basics   

4-6 hrs

Use graphics, set up web for publishing, create meta tags, publish web

Getting Started   

4-6 hrs   

Create database, define fields, add layouts, define buttons, and create scripts.

Beyond the Basics   

4-6 hrs   

Create related files, define passwords, continue defining fields including calculating fields and use portals

Getting Started   

2-3 hrs 

Create e-mail messages, reply to messages, attach files, add contacts and create appointments.

Power User   

2-3 hrs 

Add voting buttons to messages, schedule meetings, use the Journal, create and share tasks.

Digital Camera and Scanner   

Getting Started   

2-3 hrs 

Use the digital camera and scanner and bring images into Word.

Designing Flyers   

3-6 hrs

Demonstrate the elements of effective one page flyers, make over participants samples

Designing Newsletters   

3-6 hrs 

Demonstrate the elements of effective newsletters, make over participants samples

Photoshop & Photoshop Elements