Home >  Information Technology Services >  IT Help Documents >  Workshop Descriptions  

Information Technology Services

Workshop Descriptions

Click here to view our calendar of current workshop offerings.

Microsoft Office: These workshops cover basic and advanced topics with the Microsoft Office suite, including transitioning to Office 2007 from previous versions. Also, please see our training handouts for Microsoft Office seminars.

Multimedia: These workshops, conducted in the E-Learning Center, cover multimedia applications and graphics arts topics.


Microsoft Word 2007 (Module I)

In this course you will explore the Word window, select options using menus and dialog boxes, get Help for specific Word commands and components, and use the "Ribbon" interface. You will also enter text into new documents, save, close documents, and print documents. You will also use the Formatting toolbar, change fonts and point sizes, and change other character attributes. Set tabs, indent paragraphs, number pages, define styles, use the Thesaurus, and check spelling are also part of this module. This module is useful is you are transitioning from an older version of Microsoft Word.


Back to Top

Microsoft Word 2007 (Module II)

This course will allow you to acquire skills in using the intermediate and advanced features of MS-Word 2007. Your will create data documents, create main documents, and merge documents to create form letters and mailing labels. You will sort columnar lists and paragraphs; insert tables into documents; enter, move and select text and cells; insert rows and columns, merge table cells; format text and numbers; and perform calculations. You will record and run macros, and edit and delete macros.

Prerequisites: MS Word 2007 (Module I)

Back to Top

Microsoft Excel 2007 (Module I)

This course will allow you to move around the worksheet, select ranges, resize and move windows, and save and print a workbook. You will enter labels, numbers, formulas and dates; edit cell data; copy data from one cell to another cell; make multiple copies of a range data, move data by cutting and pasting; print jobs; define page setup options by creating headers and footers; change margins and print worksheets. You will also create charts, change types, use legends and print charts.


Back to Top

Microsoft Excel 2007 (Module II)

In this course you will review some of the concepts presented in MS-Excel 2007 (Module I). You will also name formulas, cells, and cell ranges. You will find and replace data, use automatic and manual recalculations, freeze worksheet titles horizontally and vertically, clear frozen tiles, use the VLOOKIP, IF, MIN, MAX, COUNTA, ROUNDS, and PMT functions.

Prerequisites: MS Excel 2007 (Module I)

Back to Top

Microsoft Access 2007 (Module I)

You will identify database components, create tables using Table Wizard, defining data types, and describing fields; save, print and close tables. You will work with records by viewing table datasheets, moving around table windows, and adding, editing, and saving records; set primary keys; and print table records. This course will show you how to save and print selected queries. You will also create, modify, save and print forms and reports.


Back to Top

Microsoft Access 2007 (Module II)

In this course, you will review some of the concepts presented in Microsoft Access 2007 (Module I). You will also specify multiple criteria using And criteria and Or criteria, select records that match a list of values, display unique values, and select records that contain values. You will create calculated fields; crosstab queries using the Query Wizard; use action tables to make new tables and delete, append, and update records.

Prerequisites: MS Access 2007 (Module I)

Scheduled by appoinment only.

Back to Top

Microsoft PowerPoint 2007 (Module I)

This course will cover the basic features that PowerPoint 2007 offers. You will learn how to get started with the PowerPoint application. It will explore all the tool bars and menus, throwing light on their basic functions. You will learn to open existing presentations, create new presentations, edit information in presentations and work with font and other text attributes. You will also learn to use the AutoContent wizard and design templates for creating new customized presentations. Inserting clip art, applying slide transition effects, playing slide shows, and printing presentations will also be covered.


Back to Top

Microsoft PowerPoint 2007 (Module II)

This course will cover the advanced features of PowerPoint 2007. You will learn to work with the custom animation feature, apply animation to clip art and text, and apply other advanced features such as sound effects and music and movie files. It will also teach you how to customize slide backgrounds, bullets and objects/clip art that you use in your presentation (resizing, rotating, grouping/ungrouping, and stacking, etc). You will also learn to make graphs and organizational charts. You will learn to save presentations as web pages, use data created in other programs or import data from other office applications.

Prerequisites: MS-PowerPoint 2007 (Module I).

Back to Top

Using Digital Still Cameras Q & A

This workshop is for users who have digital cameras, but may not fully understand all of the features. Users who would like to start using digital cameras would also benefit. The goal is to give the user the knowledge to take their own photographs for use in assigned projects and instruction. The workshop will be one and one half hours long, starting with a 45 minute introduction and demonstration with question and answer period for the remainder of time. Basic use of scanners will be covered during the first part as well.

The workshop will cover:

  • Types of digital cameras and how they work.
  • Some of the common features found on all digital cameras and how to use them.
  • How to take better photographs (basic).
  • Basics in scanning from print media, photos, slides and negatives.
  • Participants can make an appointment to bring in their own camera if they want help understanding some of its functions. (limited to 30 minutes each)

Note: This seminar only offered in the E-Learning Center

Back to Top

Photoshop Basics

This workshop will cover some basic functions in Photoshop in preparation for using Photoshop to correct and manipulate images. The workshop consists of thirty minutes of introduction and demonstration followed by hands on use for one hour. The workshop focuses on the tools in the tool bar and how to use them, as well as the pallet windows. Participants will be required to perform a series of tasks using the tools and pallets. (Images will be provided.)

Note: This seminar only offered in the E-Learning Center

Back to Top

Basic Image Editing and Enhancement in Photoshop

This workshop will cover some basic functions used to edit and correct or enhance an image using Photoshop. The workshop will be, forty-five minutes of introduction and demonstration followed by hands on use for one hour. (Images will be provided.) This workshop will cover:

  • Some of the menu bar commands.
  • Adjusting exposure.
  • Adjusting color.
  • Adjusting size and resolution.
  • File types and choosing the best type and resolution for a particular situation.
  • Using the transformation tools (size, rotate, skew. Etc.)
  • Sharpening and blurring images.

Participants will be required to adjust the color and exposure on a number of images, Resize them, do some enhancement and prepare them for use on the web, powerpoint, video, and print.

Prerequisites: Photoshop Basics.

Note: This seminar only offered in the E-Learning Center

Back to Top

Dreamweaver Basics

This workshop is for those who want to create a simple website or a browser based electronic Portfolio. There will be 30 minutes of introduction followed by one hour of hands on. This workshop will cover:

  • Setting up a site
  • The interface
  • Gathering your content
  • Inserting images
  • Inserting tables
  • Using templates
  • Using style sheets

Note: This seminar only offered in the E-Learning Center

Back to Top

Basic Digital Audio Recording and editing

This workshop is for those who want to record and edit audio for use in PowerPoint, Podcasting, web sites, and video production and music. There will be 30 minutes of introduction followed by one hour of hands on. This workshop will cover:

  • cover basic audio recording using a single microphone and mixer as well as the audio input on the computer
  • Type of hardware for recording audio
  • Sample rate and bit depth
  • Proper recording levels
  • Audio file formats
  • Cutting out unwanted, material and blank spaces
  • using filters, EQ, and some other audio tools to enhance audio
  • Exporting to use in Powerpoint, Podcasting, CD quality music, and for use in video

Note: This seminar only offered in the E-Learning Center

Back to Top

Basic Video Editing

This workshop is for those who need to use video in Powerpoint, websites or other class projects. There will be 30 minutes of introduction followed by one hour of hands on. The workshop will cover:

  • A short discussion on how to record video
  • Type of hardware need for editing video
  • Ways of digitizing video (getting it in the computer)
  • Setting up the software for recording
  • The software interface
  • Ways of editing the video
  • Exporting the video for use in Powerpoint, CD, DVD, websites, etc.

Note: This seminar only offered in the E-Learning Center

Back to Top

Contact Information

Information Technology Services

Telephone: 703-526-6990

Status of ITS Systems & Services

All services are currently operating normally.