 |
 |
 |
  |
| Training & Support | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Software Training - Dates & Times
College
of Engineering - Network
Network Orientation (*using Windows XP)
(This training session will give an overview of the College of Engineering Network [minimal hands-on/seminar-type
session]. Learn about the College network, who to call
for help, what network drives/services are available,
password requirements, how to logon/logoff, connect to
network drives, etc.
Beneficial to NEW users within the
College of Engineering) Instructor - Sue Pysher
Databases Access 2003 Basics
(This is
a hands-on training session that provides a basic understanding
of Access for Windows. A basic overview of the
software and functions is covered, including creating
a new database, adding/editing records, creating queries,
and a brief introduction to creating forms & reports,
etc. The training is held in
3 half-day sessions). Instructor
- Sue Pysher
Access 2003 Mini-[Query Types & Query Wizards] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a half-day hands-on session that will cover the following topics: Using different types of queries - Update Query, Append Query, Crosstab Query, Make Table Query, Delete Query and also available Query Wizards [Find Duplicates Query Wizard & Find Unmatched Query Wizard]). Prerequisite: Basic understanding of Access. Instructor - Sue Pysher Access 2003 Mini - [Calculated & Joined Fields] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This half-day hands-on session will cover the following topics: Creating calculated & join fields within queries; using the Expression Builder; generating totals, averages, minimums, maximums, counts, etc.. within queries) Prerequisite: Basic understanding of Access. Instructor - Sue PysherAccess 2003 Mini - [Form Design] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This half-day hands-on training session will cover the following: Creating Input Forms using AutoForm or Form Wizard & Modifying the Form Design. Modify the design of your form - set a colored background, move objects, size objects, add titles, change tab order, insert images, create subforms, tab control, add buttons, etc.) Prerequisite: Basic understanding of Access. Instructor - Sue Pysher Access 2003 Mini - [Report Design] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a half-day hands-on training session on Report Design - Create reports and Modify reports within Report Design - move objects, hide objects, insert graphics, add titles, change group/sort order, change record source, number your records consecutively, add formulas). Prerequisite: Basic understanding of Access. Instructor - Sue Pysher
Access
2003
Mini - [Macros &
Switchboard] (In this hands-on training session , we'll work with Access macros [macros are an action or set of actions used to automate tasks] and introduce you to the macro window where macros are created. We'll create macros and attach these to various controls such as a command button, and a form. We'll revise macros to require data entry in certain fields, provide feedback to the user and automatically fill in a field's value based on another field's value. We'll also create macros to perform other functions. We'll use the Switchboard Manager within Access to create a Switchboard form that is used as the main user interface for the database. Prior knowledge of Access Forms, Queries and Reports is recommended)Instructor - Maria Ruth
Access
2003 Mini - [Pivot Tables & Pivot Charts] (This is a hands-on session where you will learn to create Pivot Tables and Pivot Charts for data analysis. You will learn to customize a pivot table by selecting subsets of data, rearranging data, adding and removing data, changing the data format, etc. You will also learn to create and customize pivot charts to provide an interactive summary of the data in a chart format). Prerequisite: Basic understanding of Access. Instructor - Maria Ruth Getting Started With Using the IBISFin Data Warehouse
(This will be an introduction to the User Group Database. You will learn the advantages of using the Data Warehouse over FIT, ICAG, etc. and you will learn how to receive information from the Data Warehouse Tables, etc. Also in this session, you will do some simple query exercises. This is a hands-on session.) Pre-requisite: Basic familiarity with Access Basic training. Instructor - Nancy Sabol Migrating to Access 2007
(This is a hands-on training session that will cover the new features and enhancements of the MS Access 2007 version. Prerequisite: Basic understanding of Access and familiarity with the NEW Office 2007 Interface. Recommended that users attend the Office 2007 Overview training session). Instructor - Sue Pysher
Desktop
Publishing Publisher 2003 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This training session will provide a hands-on introduction to the MS Office desktop publishing program. We will cover topics such as positioning, layering and grouping objects on a page, changing color and font schemes, working with mail merge and tables, etc.) Instructor- Maria Ruth Publisher 2003 Mini - [Merging with Other Applications] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is
a hands-on training session covering merging with other MS Application's
data to create Publisher Publications. We will be using the merge
function to create certificates, mailing address
labels, return address labels and business cards. We will be
merging with data from MS Access, MS Excel and MS Word and filter
and sort merged data). Migrating to Publisher 2007
(This
is a hands-on training session
that will cover the new features
E-Mail Eudora 7.0 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands on introduction to Eudora covering creating, sending, receiving, replying to, forwarding and redirecting e-mail messages. We will create mailboxes, mailbox folders, and address books. We will cover sending and opening attachments. We will create filters, personalities, signatures, stationery, and vacation auto-replies as well as cover customizing your Eudora toolbar.) Instructor - Maria Ruth Eudora 7.0 Mini - [Additional Mail Features] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands
on introduction where you will learn to manage email
accounts with personalities; create signatures; create stationery;
learn how to customize your toolbar plus much more.) Outlook 2003 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This
is a
3-half-day hands-on session that will
cover a wide range of features
within the Outlook 2003 program. Some
of the topics covered will
be: What is Microsoft Outlook? An
overview of Outlook's
components & terminology.
How Outlook compares with Eudora's & Netscape
Calendar's functions. Outlook’s ‘Navigation
Pane’ components – Mail,
Calendar, Contacts, Tasks, Notes. Adding
Shortcuts & Favorites
to the
Navigation Pane. Setting Outlook
defaults and options.
Outlook’s
new
Junk
Email Filtering. Outlook
Mail (INBOX) - basics of Outlook's
email, Creating Outlook signatures
(using set email editors), Using
Outlook Calendar, Creating
Contact
Entries (Nicknames) & Distribution
Lists, Using PH & LDAP to
find Internet email addresses,
Using Outlook Tasks and Notes. Quick Look at Other Outlook Features:
Find, Organize, Templates, Tips & Shortcuts
-
Important
Things to Remember when Getting
Started). Migrating to Outlook 2007
(This is a hands-on training session that will cover the new features and enhancements of Outlook 2007 version). Prerequisite: Basic understanding of Outlook and familiarity with the NEW Office 2007 Interface. Recommended that users attend the Office 2007 Overview training session). Instructor -Sue Pysher
Graphics Microsoft PictureIt! Photo 7.0 [Support Only. We no longer provide training for MS PictureIt! Photo. We have migrated to Adobe Photoshop Elements - please see the training session listed below] Adobe Photoshop CS3 Basics
(The Adobe Photoshop CS3 Basics software
program offers powerful photo-editing capabilities as well as
intuitive photo organizing and sharing features. During the training
session, we will explore the program's interface and use the Image
Organizer/Photo Browser to organize photos using Tags and
Collections. We'll edit photos in the Editor and introduce you to
the available toolbox tools and palettes. We'll work with shapes,
text, use a variety of photo editing tools, work with layers, and
apply filters, effects and styles. We will explore the various
creations you can create in Photoshop Elements such as photo slide
shows, photo albums, cards, calendars, etc. Lastly, we'll highlight
some of the features available in Adobe Photoshop (Adobe's leading
photo editing software application) that are not included in
Photoshop Elements.This session is held in
3-half days.
Office
Suites Office 2007 Overview
(This
half-day training session is minimal hands-on - Office 2007
is the NEW suite released by Microsoft that replaces the Office
2003 suite - come to
learn what features are new and/or changed in the software before
you upgrade or shortly after).Instructor - Sue Pysher
Presentation PowerPoint 2003 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands-on session that provides a basic understanding of PowerPoint's presentation capabilities. Some of the topics covered will be: creating an online slide presentation, inserting images, animation and sound, etc., as well as how to create handouts/speaker notes. Editing functions such as copying slides, moving slides, deleting slides, setting slide transition effects, building bulleted lists, and changing template designs, color schemes, etc.) This session is 2 half-days. Instructor: Sue Pysher PowerPoint 2003 Mini - [Jazzing Up Your Presentation] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a half-day hands-on session that covers the advanced features of adding animation effects to bulleted lists, clipart and other images, adding sound and video clips to your slides, adding action buttons, actions settings and hyperlinks to your presentation, creating summary slides and custom shows, using multiple design templates and new animation schemes). Prerequisite: Basic understanding of PowerPoint. Instructor - Sue Pysher Migrating to PowerPoint 2007
(This is a hands-on training session
that will cover the new features
Spreadsheet Excel 2003 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This hands-on training session provides a basic understanding of Microsoft Excel. Basic workbook/worksheet functions, creating basic formulas, autofill, using toolbar buttons, page setup options, formatting cells, creating subtotals, database functions, a brief look at creating pivot tables, charts, creating macros, and importing Excel data into Access. This session is an instructor-led, hands-on session. The training is held in 3 half-day sessions.) Prerequisite: None Instructor - Sue Pysher Excel 2003 Mini - [Formulas & Functions] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (In this training session, we will create Excel Formulas and Functions to perform calculations on Excel data. We will enter and edit different types of functions such as mathematical, statistical, date and time, etc. We'll cover additional features such as AutoCalculate, creating and using Range Names, Copying and Pasting formulas/functions, plus more…) Instructor - Maria Ruth Excel 2003 Mini - [Charts] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands-on session where we will create and edit Excel Charts. We will create and edit various chart components and we will demonstrate methods to emphasize the data. We will discuss chart types and selecting the correct chart type based on the data you wish to illustrate, plus more…). Instructor - Maria Ruth Excel 2003 Mini - [Macros] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This
training session will introduce you to macros in MS Excel. We will create/record
and modify macros. We
will configure Macros to be available for a single workbook or for
all workbooks. Then we'll make our Macros easy to run by assigning
it to run from a shortcut keystroke, from a button created on a custom
toolbar and by clicking on a graphic. Finally, we'll look at sample
macros already created and discuss their actions). Prerequisite: Basic
understanding of Excel. Excel 2007 Mini - [Pivot Tables & Pivot Charts] - guinea pig session #2 No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands-on session where you will learn to create Pivot Tables and Pivot Charts for data analysis. You will learn to customize a pivot table by selecting subsets of data, rearranging data, adding and removing data, changing the data format, etc. You will also learn to create and customize pivot charts to provide an interactive summary of the data in a chart format). Prerequisite: Basic understanding of Excel. Instructor - Maria Ruth Excel Data Manipulation - [Using Excel Database Capabilities] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This
is a half-day hands-on training session.
Some of the main topics covered
will be: Autofiltering your data,
Custom Filtering, Sorting Records,
Naming a Cell or Range of Cells,
Absolute vs. Relative Cell Addresses,
Copy/Paste Special (Linking),
Subtotals, Hiding Columns, Using
Function Wizard to do averages,
minimum/maximum, count functions,
an introduction to creating Pivot
Tables, Charts, and macros (separate mini-sessions
cover these 3 topics indepth),
Quick Highlighting Hints, Print
Headings on All Pages - Page
setup options, Stop gridlines
from printing, Inserting Hard
Page Breaks, Move or Copy a Sheet
to another Workbook. This
session is an instructor-led
hands-on session) Prerequisite: Basic
understanding of Excel.
Migrating to Excel 2007
(This
is a hands-on training session that will cover
the new features and enhancements of the Excel 2007
version.) Prerequisite: Basic understanding of Excel and familiarity
with the NEW Office 2007 Interface. Recommended that users
attend the Office 2007 Overview training session).
Instructor - Sue Pysher
VOIP
Phone System [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.]
Web Conferencing Adobe Acrobat Connect (formerly Breeze) Meeting - Overview
(This overview
session will provide faculty and staff with a brief look at Adobe Acrobat Connect (formerly
Breeze) Meeting, a web conferencing tool provided by the University.
Faculty and staff will be able to experience what a Meeting
‘Host’ or ‘Presenter’ can utilize during a created meeting,
as well as what ‘Participants’ (attendees) would view if attending a
Meeting. In addition, pertinent College and University
information will be relayed to attendees and important links to
documentation will be provided. Attendees will be able to
experience Adobe Acrobat Connect (formerly Breeze) Meeting and have the ability to actually
participate in a hands-on meeting). Prerequisite: None
Instructor - Maria Ruth This session is NOT intended to take the place of the University’s open demonstrations or formal hands-on training provided at the University level. It can provide a starting point for anyone interested in using or participating in Breeze Meetings.
Web
Page Design
FrontPage 2003 Basics [Support Only. We no longer provide training for FrontPage. We have migrated to Dreamweaver CS3 - please see the training session listed below] FrontPage 2003 Mini - [Forms] [Support Only. We no longer provide training for FrontPage. We have migrated to Dreamweaver CS3 - please see the training session listed below]
FrontPage
2003 Mini
- [Tables & Graphics] FrontPage 2003 Mini - [Issues Concerning Importing, Revising and Maintaining Web Pages] [Support Only. We no longer provide training for FrontPage. We have migrated to Adobe Photoshop Elements - please see the training session listed below] Migrating to FrontPage 2003 [Support Only. We no longer provide training for FrontPage. We have migrated to Dreamweaver CS3 - please see the training session listed below] Migrating to Dreamweaver 8.0 [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is
a hands-on training session that will cover the new features and
enhancements of the new Dreamweaver 8.0 version. Prerequisite:
Basic understanding of Dreamweaver MX 2004).
Instructor - Maria Ruth
(Dreamweaver MX 2004
users welcome!) Dreamweaver 8.0 Basics [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This
is a hands-on session that is an Introduction to Macromedia Dreamweaver 8.0,
a software application for creating web sites. In this session,
you will
be introduced to the program’s interface, use the Site
Definition Wizard to set up a web site, insert and format
text, insert and resize images, and insert hyperlinks. We
will work with layout tables and layout cells, tables, create
and apply templates, and introduce cascading style sheets.
Finally, we will review new features to Dreamweaver 8.0.)
Instructor - Maria Ruth Dreamweaver 8.0 Mini - [Images and Navigation] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands-on session where we will work with images and the various navigation tools you can insert into your web pages. We will work with image placeholders, image text flow and create an image map. We will insert links between pages, create a navigation bar, a jump menu and a pop-up menu. You will also be introduced to the Dreamweaver tools to manage links). Instructor - Maria Ruth Dreamweaver 8.0 Mini - [Page Layout Tools] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (This is a hands-on session where we will work with page layout tools available in Dreamweaver. We will work with tables, layout tables and layout cells, and layers. We will also explore pre-defined pages available in Dreamweaver). Instructor - Maria Ruth Dreamweaver 8.0 Mini - [Cascading Style Sheets] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (In this session, we will create and apply CSS Rules using the Property Inspector and using the CSS Styles Panel. We'll discuss the two Modes available in the CSS Styles Panel and use the panel to create, edit, and apply CSS Rules. We'll export CSS Styles to a new CSS Style Sheet and attach the new style sheet to a new page. You'll also get a chance to view and apply sample style sheets that come with Dreamweaver. You'll see how to create a new style sheet in code view as well as format navigation bar text using CSS Rules. Finally, you'll create a CSS-Based page layout using layers, nest layers, and add color and content to layers.) Prerequisite: Proficiency using Dreamweaver. Instructor - Maria Ruth
Dreamweaver 8.0 Mini - [Displaying XML Data Using Client-Side XSL Transformations] [No scheduled training at this time. Click here to email Lisa to be put on the pending list for future dates.] (As
the field of web design evolves, two trends emerge: content
relies more and more on data sources for live content and up-to-the-minute
information, and content is separated from how it is presented/from
its formatting. Using web pages to display XML (eXtensible
Markup Language) data addresses both of these trends. In this
training session, we will create Extensible Stylesheet Language
Transformations (XSLT) files to perform XSL transformations
using the visitors' browser. These are called client-side transformations.
Specifically, we will discuss terms such as XML and an XML
document, XML Schema, XSL Transformations, and Server-Side
vs. Client-Side XSL Transformations. We'll convert an existing
HTML page to an XSLT page, attach an XML source document, map
elements to the XSLT page, define repeating elements, attach
the XSLT Page to the XML source document, publish the
XML and XSL Transformation files and finally, view the transformed
XML file in the browser. You'll also get a chance to export
the results of a MS Access Query and a MS Excel Spreadsheet
to XML files and display this data transformed by an XSLT page.) Prerequisite:
Proficiency using Dreamweaver
Migrating to Adobe Dreamweaver CS3
(In this session, we will cover the CS3 purchasing options available for web designers and editors. We will use the Adobe CS3 Web Premium edition to explore the new features of Dreamweaver CS3 hands-on. Some | ||||||||||||||||||||||||||||||||||||||||||||||||||||||