ESSENTIAL SKILLS

Gain essential skills by learning about the Windows or Macintosh operating system, the Microsoft Office suite, and presentation equipment.

Using Projection and Presentation Equipment  Lunchtime Session

GroupWise: Working with Address Books and Group Lists
GroupWise: Managing Your Mailbox
GroupWise: Tips and Tricks   Lunchtime Session

Macintosh Tips & Tricks  Lunchtime Session

Microsoft Excel Basics

Microsoft Excel Intermediate

Statistics in Excel  Lunchtime Session

Presentations in PowerPoint, Basics Lunchtime Session
Presentations in PowerPoint, Advanced  Lunchtime Session

Microsoft Word: Displaying Data in Tables

Microsoft Word:  Creating a Form

Microsoft Word:  Mail Merge
Microsoft Word: Time-Saving    Lunchtime Session
Microsoft Word: Tips for Solving Unexpected Formatting Problems  Lunchtime Session

RefWorks Basics    Lunchtime Session

Write-N-Cite Basics   Lunchtime Session


Return to Fall 2007 Overview>

Using Projection and Presentation Equipment    

Be prepared for your organization’s big event! Learn how to use the built-in classroom media equipment now, and avoid stress later. This one-hour session will cover using the digital projector, VCR, DVD player, and cable TV hookup in classrooms, plus how to hook up a laptop and other equipment. You will also get an overview of using the equipment in all of the major auditoriums on campus. Lots of opportunities for hands-on practice will be given.

Prerequisites:  Basic knowledge of how to use a VCR and DVD player.

Instructor: Stephen Davis

Date: September 12th
Time: 12:00-1:00 PM
Location: Wright Hall 7

OR

Date: October 4th
Time: 12:00-1:00 PM
Location: Wright Hall 7

Workshop Objectives:

• Provide training on how to use the standard classroom media equipment.
• Give opportunity for hands-on practice. Explain variations in auditorium equipment.

Instructional Content and Learning Activities:

Presentation Outline (PDF)
Presentation Handout (PDF)

Related Links:

Classroom Support website
Classroom Equipment Database

To register for this workshop, click here.

Back to top>

GroupWise: Working with Address Books and Group Lists

Learn to create a new address book, customize name completion when addressing a message, and set the search order of your address books. This class will show you how to add individual addresses and create group lists (sometimes called distribution lists) to your personal address book in GroupWise.

Prerequisites: Familiarity with the GroupWise desktop client for Windows.

Platform: PC only
Date: October 17th
Time: 10:00-12:00
Location: Seelye B2
Instructor: Liane Hartman

To register for this workshop, click here.

Back to top>

GroupWise: Managing Your Mailbox

This class will explain how to set up your GroupWise archive and create folders. Learn ways to sort your mail for moving or deleting single or multiple messages.

Prerequisites: Familiarity with the GroupWise desktop client for Windows.

Platform: PC only

Instructor: Liane Hartman

Date: October 2nd
Time: 9:00-10:30
Location: Seelye B2

OR

Date: November 5th
Time: 10:30-12:00 PM
Location: Seelye B2

To register for this workshop, click here.

Back to top>

GroupWise: Tips and Tricks

This class will explain how to quickly sort, select several messages to move, change the subject to something more meaningful to you and to color code your mailbox. 

Prerequisites: Familiarity with the GroupWise desktop client for Windows.

Platform: PC only

Instructor: Liane Hartman

Date: September 21st
Time: 12:00-1:00
Location: Seelye B2

To register for this workshop, click here.

Back to top>

Macintosh Tips & Tricks

Mac OS X makes it easy to get work done, but what if you knew the secrets to make it even easier? This workshop will cover little-known or overlooked features of Mac OS X, along with free applications available to everyone. The aim of the workshop is to make using Mac OS X easier, more efficient, and fun for your everyday work.

Prerequisites:

• Familiarity with Mac OS X.
• An interest in learning how to make better use of their Mac.

Instructor: Bruce O'Leary

Please note that this class meets two times.

Date: September 18th
Time: 12:00-1:00 PM
Location: Seelye 411

OR

Date: October 3rd
Time: 12:00-1:00 PM
Location: Seelye 411

Workshop Objectives:

• Provide specific information and demonstrations of little-used, overlooked or unknown Mac OS X features.
• Provide information and demonstrations of free or low-cost third party applications.

Instructional Content and Learning Activities:

Related Links:

Mac OS X Hints
OSX FAQ’s Tip of the Day
Apple’s Mac 101
Tuning Mac OS X Performance
ResExcellence
Your Multilingual Mac

To register for this workshop, click here.

Back to top>

Microsoft Excel Basics

This class will cover the fundamental elements of Excel. You will learn to enter and edit data, navigate within a workbook, and use basic formatting, simple formulas, and functions. Learn to create a chart from your data.

Prerequisites: Basic familiarity with the Windows or Macintosh operating system.

Instructor: Liane Hartman


Date: September 13th
Time: 3:00-5:00
Location: Seelye B2

OR

Date: September 18th
Time: 3:00-5:00
Location: Seelye B2

OR

Date: October 31(Faculty and Staff only)
Time: 9:00-12:00
Location: Seelye B2

Objectives:  

Participants will become familiar with the following topics and procedures:

• Identify the basic elements of a worksheet
• Enter a variety of data
• Format data
• Auto Fill feature
• Basic formulas
• Basic elements of a chart

Instructional Content and Learning Activities:

Presentation Handout (PDF)

To register for this workshop, click here.

Back to top>

Microsoft Excel Intermediate

This course is designed for those individuals who are familiar with the basic Excel fundamentals, but who want to learn a little more.   We will take the mystery out of printing worksheets; page setup, repeat of header or column rows, adding a header and footer. Learn how to link the worksheets together so as numbers change on one worksheet, related sheets update automatically.  You will also perform single-level and multiple-level sorts by using the Sort buttons.  

Prerequisites: Understanding the basics of Excel.

Instructor: Liane Hartman


Date: September 25th
Time: 3:00-5:00 PM
Location: Seelye B2

OR

Date: November 7th (Faculty and Staff only)
Time: 9:00-12:00
Location: Seelye B2

Objectives:  

Participants will become familiar with the following topics and procedures:

• Page Setup
• Repeat of Header and Column Rows
• Adding a Header or Footer
• Linking cells and Worksheets
• Basic single and multiple level sorts

To register for this workshop, click here.

Back to top>

Statistics in Excel

This session will provide participants with an understanding of how to use Excel for statistical analysis. Descriptive analysis such as mean, median, mode, and standard deviation, some inferential statistics, and charting will all be covered. Participants will leave the workshop with a better understanding of the capabilities and limitations of Excel for statistical analysis.

Prerequisites: Basic familiarity with Microsoft Excel.


Date: September 27th
Time: 12:00-1:00 PM
Location: Seelye B3
Instructor: Thomas Laughner

OR

Date: October 1st
Time: 7:00-8:00 PM
Location: Seelye B3
Instructor: Thomas Laughner

To register for this workshop, click here.

Back to top>

Presentations in PowerPoint, Basics  

This workshop is an introduction to the basics of Microsoft PowerPoint, the popular digital slideshow software. Participants will learn to create a new slideshow and add slides, choose a slide layout and create their own custom layouts, insert photos, charts, and other graphics, and choose a design template and customize their own. This workshop will also include tips on how to use PowerPoint effectively to highlight a presentation and keep the audience’s attention.

Prerequisites:

• Some basic computer experience, such as word processing and checking email.
• Participants should be PowerPoint beginners. This course will start from the very beginning.

Instructor: Caroline Moore

Date: September 17th
Time: 12:00-1:00 PM
Location: Center for Media Production


OR

Instructor: Stephen Davis
Date: September 27th
Time: 12:00-1:00 PM
Location: Wright 233


Workshop Objectives:

• Provide an overview of PowerPoint’s features and interface.
• Explain how to create a PowerPoint presentation that includes non-text elements.
• Demonstrate how to use built-in templates and customize presentations.
• Provide hands-on activities for participants to try out each step of creating a presentation.

Instructional Content and Learning Activities:

Presentation Outline (PDF)
Presentation Handout (PDF)

Related Links:

Microsoft PowerPoint website
Online Templates
Online PowerPoint Training and Tips
Advanced PowerPoint Tutorials

To register for this workshop, click here.

Back to top>

Presentations in PowerPoint, Advanced

Have you ever seen a PowerPoint presentation where elements flew on and off screen, or one slide faded into the next, and wondered how it worked? This session will teach you all about using Animations and Transitions in PowerPoint to add interest and emphasis to your presentations. You will also learn tips on how to use these features for best effect, and when to stick to the basics.

Prerequisites: Familiarity with all topics covered in PowerPoint Basics.

Instructor: Caroline Moore

Date: September 24th
Time: 12:00-1:00 PM
Location: Center for Media Production


OR

Date: October 11th
Time: 12:00-1:00 PM
Location: Center for Media Production

Workshop Objectives:

• Demonstrate the use of Animations and Transitions in PowerPoint.
• Show the participants how to use built-in Animations and Transitions and how to customize and create their own.
• Provide hands-on activities for participants to try out each step of creating a presentation.

Instructional Content and Learning Activities:

Presentation Outline (PDF)
Presentation Handout (PDF)

Related Links:

Microsoft Powerpoint website
Advanced Topics: Using Motion Paths
Advanced Topics: Timing
Cool PowerPoint Animations Tutorial

To register for this workshop, click here.

Back to top>

Microsoft Word: Displaying Data in Tables

Learn how to create tables that fit your design needs and format them to have a great look using border-lines, colors, shading, and AutoFormat.

Prerequisites: Basic familiarity with Microsoft Word.


Date: October 15th
Time: 2:00-4:00
Location: Seelye B2
Instructor: Liane Hartman

Objectives:  

Participants will become familiar with the following topics and procedures:

• Table and Border toolbars
• Inserting text
• Selecting cells, rows, and columns
• Borders and shading

Instructional Content and Learning Activities:

Presentation Handout (PDF)

To register for this workshop, click here.

Back to top>

Microsoft Word: Creating Forms

This workshop will help you transform a printed Word document into a form by associating form fields with the form questions.  Word includes many different types of form fields:  text boxes for typed entries, date fields, time fields, check boxes and drop down choices.  Forms are usually created with a word table in the background.  Forms can be printed or filled in electronically using Word.

Prerequisites: Basic familiarity with Microsoft Word Tables.


Date: October 18th
Time: 2:00-4:00
Location: Seelye B2
Instructor: Liane Hartman

Objectives:  

Participants will become familiar with the following topics and procedures:

• Forms Toolbar
• Inserting fields
• Working with the table
• Protecting a Form

Instructional Content and Learning Activities:


To register for this workshop, click here.

Back to top>

Microsoft Word: Time-Saving Tips

In this class, we will review selection techniques and learn some time-saving keystrokes for working in Word. Learn about the AutoFormat and AutoCorrect features and how to customize them or turn them off.

Prerequisites: Basic familiarity with Microsoft Word.

Instructor: Liane Hartman

Date: September 20th
Time: 12:00-1:00
Location: Seelye B2

OR

Date: October 3rd
Time: 12:00-1:00
Location: Seelye B2

Objectives:

Participants will become familiar with the following topics and procedures:

• Popular shortcut keys
• Format Painter
• Auto Correct
• Smart Tags

Instructional Content and Learning Activities:

Presentation Handout (PDF)


To register for this workshop, click here.

Back to top>

Microsoft Word: Tips for Solving Unexpected Formatting Problems

This class will review a variety of unexpected formatting problems and the soultions. 

Prerequisites: Basic familiarity with Microsoft Word.

Instructor: Liane Hartman

Date: October 10th
Time: 12:00-1:00
Location: Seelye B2

Objectives:

Participants will become familiar with the following topics and procedures:

• Track Changes
• Styles
• Paste Options
• Ruler
• Sections/Header/Footer

To register for this workshop, click here.

Back to top>

Microsoft Word: Mail Merge

The mail merge process involves taking information from one document (the data source) and combining it with another document (main document).  You will learn to use the Mail Merge toolbar to create data, form letters, envelopes and labels. 

Prerequisites: Basic familiarity with Microsoft Word.

Instructor: Liane Hartman

Date: November 14th
Time: 9:00-11:00
Location: Seelye B2

Objectives:

Participants will become familiar with the following topics and procedures:

• Mail Merge Toolbar
• Data Source
• Merge Fields
• Creating Letters/Envelopes/Labels
• Customizing the Toolbar

Related Links:

Using the Mail Merge Toolbar in Microsoft Word XP

To register for this workshop, click here.

Back to top>

RefWorks Basics

RefWorks is a web-based bibliographic management program that enables users to store, manage, and output (in a variety of styles) bibliographic references from various sources, including online article databases. RefWorks can help you effectively organize and manage citations while conducting research, incorporate references into word processing documents, and create independent bibliographies in a variety of styles. In order to use RefWorks, users must first create an individual account.

Prerequisites: None.

Instructor: Rebecca Pappert

Date: September 24th
Time: 12:00-1:00
Location: Neilson Library Classroom

OR

Date: September 27th
Time: 12:00-1:00
Location: Neilson Library Classroom

Objectives:

Participants will become familiar with the following topics and procedures:

• Import references directly from online databases
• Import references in a text file
• Add references manually
• Create folders
• Sort and edit

Instructional Content and Learning Activities:

Presentation Handout (PDF)


To register for this workshop, click here.

Back to top>

Write-N-Cite Basics

Write-N-Cite is a feature within RefWorks which allows you to access your references while working within Microsoft Word. Write-N-Cite allows you to insert citation placeholders and when you are ready to add a bibliography to the end of the document, Write-n-Cite will create a bibliography and properly format your in-text citations based upon only those references that have been inserted into your Word document.

Prerequisites: None.

Instructor: Liane Hartman

Date: October 1st
Time: 12:00-1:00
Location: Neilson Library Classroom

OR

Date: October 4th
Time: 12:00-1:00
Location: Seelye B2

Objectives:

Participants will become familiar with the following topics and procedures:

• In-text citations
• Citation Placeholder within Word

Instructional Content and Learning Activities:

Presentation Handout (PDF)


To register for this workshop, click here.

Back to top>