UIS Home Search the UIS Website A-Z index
UIS Homepage

Information Technology Services University of Illinois Springfield

ITS Workshops

follow us badge

ITS is delighted to offer workshops on multimedia and productivity software packages. Check out the workshop schedule for upcoming sessions!

  • All on-campus workshops are limited to 15 participants.
  • There is no cost for UIS students, faculty, and staff. The charge for non-UIS participants is $20.00 per workshop, $30.00 for 2-day workshops and $100.00 for a semester pass.
  • Workshops are held in BRK 141B.
  • Registration is not required. If you want to reserve a spot, send us an email.

NOTE: If you have any questions, contact Kara McElwrath [206-8237 or kmcel2@uis.edu] or Jeff Sudduth [206-8350 or jsudd3@uis.edu].

 

Workshop Descriptions
Workshop Handouts
Archived Workshops

 

 


Online Workshops

Most workshops may also be attended online. The only requirements to participate in an online workshop are a computer with Internet access and speakers or a headset. A microphone is recommended, but not necessary. Simply click the link below to join. Employees may join by entering their credentials (NetID and password); students may join as guests and type in their first and last name.

Link to join online:  http://go.uis.edu/itstrain


Multimedia Software Workshop Descriptions

Introduction to the Mac Operating System: OS X Leopard
This workshop is designed to:

  • give attendees an understanding of, and experience in, navigating the Macintosh OS X Leopard interface
  • help familiarize Windows PC users with the Macintosh interface

return to Workshop Schedule

Scanning and Digitizing: Print Documents and Images
In this workshop, you will learn how to:

  • scan a print document and create a PDF file using Acrobat
  • scan images, as well as improve image quality using Photoshop

return to Workshop Schedule

Working with Audio: Introduction to Audacity
This workshop begins with an overview of Audacity, a digital audio editing and recording application. You will learn how to:

  • digitize your collection of CD audio
  • do live recording of audio
  • edit new and pre-existing digital audio
  • save your audio in several file formats

return to Workshop Schedule

Working With Images: Introduction to Photoshop
In this workshop, you will be introduced to the tools available in Photoshop, such as:

  • selection
  • cropping
  • drawing
  • color
  • text

You will also learn about the advantages of different file formats when working with images for the Web or print, such as:

  • GIF
  • TIFF
  • JPEG
  • PSD

return to Workshop Schedule

Working with Images : Intermediate Photoshop
This workshop builds upon the fundamentals learned in the ‘Introduction to Photoshop’ workshop. Learn about:

  • paint tools
  • coloring techniques
  • layers

You will learn how to use tools such as the:

  • healing brush
  • pattern stamp tool
  • custom shape tool

return to Workshop Schedule

Working with Animation: Introduction to Flash
This workshop is ideal for beginners with little or no prior experience of Flash, a web animation-authoring environment. The workshop serves as an introduction to:

  • the Flash interface
  • drawing and painting tools
  • basic animation

return to Workshop Schedule

Working with Animation: Intermediate Flash
This intermediate level workshop covers:

  • complex animation option, including frame-by-frame and onion-skinning
  • working with multiple scenes
  • creating buttons for assigned actions

return to Workshop Schedule

Creating a Website: Introduction to Dreamweaver
This workshop is designed to teach you how to construct a website using Dreamweaver. You will learn the basics of creating a website, as well as tools for simple site-building such as:

  • linking pages together with hyperlinks
  • adding images to your pages
  • formatting text and images in columns using a table

return to Workshop Schedule

Creating a Website: Intermediate Dreamweaver
This workshop builds upon the fundamentals learned in the ‘Introduction to Dreamweaver’ workshop. You will:

  • work with graphics
  • create banners for your website
  • learn to create mouse-overs
  • create a template for your website

return to Workshop Schedule

Creating a Website: Advanced Dreamweaver
This workshop will cover advanced features of Dreamweaver. You will learn how to:

  • create and apply cascading style sheets to help standardize formatting throughout a website
  • work with libraries to manage repeating website elements
  • work with basic Dreamweaver behaviors to add interactivity to your website

return to Workshop Schedule

Creating a Digital Movie: iPhoto, iMovie, and iDVD
The digital movie workshop will include:

iPhoto:

  • Importing photos from a digital camera
  • Organizing pictures
  • Retouching
  • Color enhancement
  • Creating a book out of your pictures
  • Adding pan and zoom motion to your still photographs
  • Creating a slideshow with background music
  • Burning a CD or DVD

iMovie:

  • Importing video from VHS tape or camcorder
  • Editing a video clip
  • Applying audio effect
  • Applying video effect
  • Applying transition
  • Integrating with iPhoto and iTunes
  • Adding chapter markers for DVD creation
  • Burning a CD or DVD

iDVD:

  • Integrating with iPhoto, iTunes, and iMovie
  • Creating a DVD show
  • Applying a built-in theme to the show
  • Burning a DVD

return to Workshop Schedule

Introduction to Cascading Style Sheets
This workshop will cover an overview of CSS. You will learn:

  • the basics of CSS
  • how CSS and XHTML work together
  • selectors
  • setting fonts, colors and backgrounds

return to Workshop Schedule

Intermediate Cascading Style Sheets
This workshop will cover intermediate elements of CSS. You will learn how to:

  • use basic floats for page layouts
  • design a webpage with CSS

return to Workshop Schedule

Creating Your Online Space: Introduction to Blogs and RSS
The Blogs workshop will include:

  • What are blogs
  • Blogs tour
  • Introduction to Facilitator and Participants
  • Creating your own blog
  • Creating and post a news item
  • Creating a story
  • Linking a news item to a story

The RSS workshop will include:

  • Using RSS channels to keep up on news, look for jobs, view upcoming concerts, monitor specific websites and much more
  • Making it easy and efficient to keep track of the latest content published by your favorite websites
  • Creating and publishing your own RSS news channel

return to Workshop Schedule

Social Networking: Introduction to Facebook
This workshop will introduce and cover some of the features of Facebook. You will learn how to:

  • create an account
  • find friends
  • edit your profile
  • add images and video
  • create events

return to Workshop Schedule

Social Networking: Facebook Pages, Events and Viral Marketing

This intermediate workshop is designed to help you use Facebook to network with colleagues, promote events, and more. In this workshop, we will learn to:

  • create more detailed events on Facebook and attract more participants
  • create Facebook Pages for your department, business, or project
  • create ads on Facebook for your Facebook Page and events

Note: You do not need to have attended the “Social Networking: Introduction to Facebook” workshop, but you should create a Facebook account (if you have not already done so) in preparation for this workshop.

return to Workshop Schedule

Social Networking: Introduction to Twitter
This workshop will introduce and cover some of the features of Twitter. You will learn how to:

  • Create an account
  • Set-up profile settings
  • Find friends / colleagues / others on Twitter

return to Workshop Schedule

Social Networking: To Twitter and Beyond
This workshop will showcase the use of Twitter on two occasions:

  • Speaker presentation at a local event
  • Unfolding event approximately 8,000 miles away from Central Illinois

return to Workshop Schedule

Get to Know the iPhone: A Productivity and Educational Tool

What does it take for an iPhone to progress from a toy and gadget to a productivity and educational tool?

This workshop walks you through the basics of the iPhone, tips and tricks, web apps, and more! The session is designed as a knowledge-sharing event wherein participants are encouraged to share their experiences with the iPhone or learn more about the iPhone as a productivity and educational tool. This workshop will also be beneficial for iTouch users.

As a pre-cursor to the event, peruse the following page for iPhone research at UIS -
http://www.uis.edu/its/iss/iphone_mk.html

For more information concerning configuring your iPhone to access UIS resources – http://www.uis.edu/its/iss/iphone.html

return to Workshop Schedule

Creating a Digital Movie: iMovie
The digital movie workshop will cover features of the iLife ’08 version of iMovie including:

  • Importing video from VHS tape or camcorder
  • Editing a video clip
  • Applying audio effect
  • Applying video effect
  • Applying transition
  • Integrating with iPhoto and iTunes
  • Adding chapter markers for DVD creation
  • Burning a CD or DVD

return to Workshop Schedule

Introduction to Mind Maps
What is a mind map?
A mind map is a visual representation of ideas, projects, thoughts that is centered around a key idea. You can visually build interrelationships between the ideas to a central concept. Mind maps can be used for -

  • brainstorming
  • problem-solving
  • project design
  • team building
  • active and collaborative learning

You will learn how to use FreeMind to develop your project idea from a central concept. We will use a free tool, FreeMind, for this workshop. This open-source software program runs on Windows, Linux, and Mac OS.

return to Workshop Schedule

Introduction to Flickr and Google Maps
This workshop is organized in two sessions and you can thereby attend one or both –

1) Introduction to Flickr, and
2) Introduction to Google Maps.

1) Introduction to Flickr
* Understanding Flickr
* Creating an Account
* Uploading, Organizing, and Sharing Images [and slideshows]
* Sampling of Flickr Sets

2) Introduction to Google Maps
* Understanding Google Maps
* Creating an Account
* Creating Google Map
* Sampling of Google Maps

return to Workshop Schedule

Introduction to Zotero
Zotero is a browser plugin [Firefox only] that allows you to “gather, organize, and analyze sources (citations, full texts, web pages, images, and other objects), and lets you share the results of your research in a variety of ways”.

Note: This workshop is not designed to teach you how to conduct research. The workshop is designed to teach you how to effectively use Zotero.

This workshop will cover:

  • Understanding Zotero
  • Creating an Account
  • Adding a source [and updating related information]
  • Sharing your sources

return to Workshop Schedule


Productivity Software Workshop Descriptions

When Good PowerPoint Presentations Go Bad
Have you seen a presentation that was just too much?

  • every single word was animated
  • graphics were haphazardly strewn across every slide
  • the font was too small to read
  • there was yellow text on a white background
  • the audience was falling asleep because the lights were dimmed and the background was black

Join us as we discuss tips for creating effective presentations with appropriate visual enhancements.

return to Workshop Schedule

Lights, Camera, Action! Tips for Running a PowerPoint Presentation
Now that the PowerPoint presentation is created, it’s time to run the show! In this session, we will explore the wide variety of presentation options, including:

  • using the pen tool to highlight points on a slide
  • using Presenter view to preview upcoming slides
  • using speaker notes
  • navigating through the slides (including how to skip slides or return to previous slides)
  • presenting a blank screen so that the audience focuses on you instead of what is on the slide
  • and much more!

return to Workshop Schedule

Maximizing the Use of Slide Masters to Make Global Changes In PowerPoint
Have you ever found yourself making the same changes on each individual slide in PowerPoint – changing fonts or sizes, adding a logo, or changing the bullet style? In this session, we will explore the power of slide masters, which allow you to make a change just once and it will apply to every slide in your presentation as well as to new slides that are added.

return to Workshop Schedule

Using Mail Merge to Create Labels, Certificates, and Form Letters in Word
In this session, we will learn:

  • how to use the mail merge feature in Word to create labels, certificates, and form letters
  • how to use Outlook contacts and distribution lists as our data source.

return to Workshop Schedule

Exploring Graphics in Word
In this session, we will explore the various graphics that can be used to enhance your Word documents, including:

  • WordArt
  • clip art
  • images
  • shapes
  • symbols
  • SmartArt.

We will also explore the use of page and paragraph borders [graphics that wrap all the way around a page or paragraph] as well as watermarks [for example, "DRAFT" printed lightly on the background of your document].

return to Workshop Schedule

Making your E-mail Work Harder for You
In this session, we will explore various e-mail message sending options. We will work with Voting Buttons, which allow you to include polling questions in your e-mail. Recipients can then “vote” by clicking the appropriate button, and Outlook will manage and tally the responses for you. In addition, we will learn how to:

  • send messages with high priority
  • request a notice once the message is delivered and/or read
  • send a message to be delivered at a particular time – for example, a reminder to your students to turn in their project even though you are out of town at a conference.

return to Workshop Schedule

Using Outlook’s Calendar to Manage your Time
In this session, we will explore Microsoft Outlook’s Calendar features, including:

  • setting meetings and events
  • inviting others to meetings, as well as checking their availability before sending the meeting request
  • scheduling recurring appointments [for example, weekly staff meetings].

return to Workshop Schedule

Formatting Spreadsheets in Excel
In this session, we will explore the formatting options available in Excel to enhance the visual appeal of spreadsheets. We will work with:

  • aligning cells
  • merging cells [for example, to create a title for the spreadsheet]
  • rotating text
  • creating cell borders
  • much more

return to Workshop Schedule

Jazzing up PowerPoint Presentations with Animations
Applying animation to text and graphics can really spice up your PowerPoint presentations. Join us as we learn:

  • how to animate objects
  • when animation is best used
  • how to avoid over-using animation

return to Workshop Schedule

Using Graphics to Enhance a Presentation
In this session, we will explore the wide variety of graphics available in PowerPoint. We will experiment with inserting and formatting:

  • WordArt
  • SmartArt
  • clip art
  • images
  • shapes

return to Workshop Schedule

Creating Workflow, Relationships, and Sequential Processes Diagrams with Ease
In this session, we will explore PowerPoint’s new SmartArt functionality, which allows us to create:

  • organizational charts
  • decision trees
  • workflows
  • cyclical information
  • relationships and similar processes

SmartArt is easy and fun to use – and can make a powerful visual statement!

return to Workshop Schedule

Managing your Inbox by Setting Rules
In this session, we will create rules to assist you in managing your mail. This session will be especially helpful for those who receive many messages each day and/or those who check their mail infrequently.

return to Workshop Schedule

Managing Contacts in Outlook
In this session, we will explore the functionality of using Microsoft Outlook’s Contacts as your “electronic rolodex”. We will:

  • create
    contacts and distribution lists [a group of people you commonly e-mail, like your fellow team members or lunch buddies]
  • see how
    contacts in Outlook can be used to create mailing labels or form letters in Word

return to Workshop Schedule

Creating Newsletters in Word
In this session, we will design and create a newsletter in Word, including:

  • adding banners
  • formatting the newsletter for multiple columns
  • inserting graphics
  • wrapping text around graphics or other elements.

return to Workshop Schedule

Creating Templates in Word – For Letterheads, Fax Cover Sheets, and More
Have you ever made changes to a document and saved it without renaming it – thus losing the original? In this session, we will learn how to create templates in Word. Templates allow you to use the same format of a document [including headers, footers, and fonts] without losing the original. Basically, Word creates a copy of the original, thus keeping it ‘safe’ from revision and allowing you to maintain a consistent look for all of your documents.

return to Workshop Schedule

Using Formulas and Functions in Excel
In this session, we will work with basic formulas and functions in Excel to create:

  • totals
  • averages
  • if statements

We will also convert text to upper or lower case.

return to Workshop Schedule

Need a Graphic to Visually Display Data? Use Excel’s Charting Tools to Make Your Data More Convincing!
In this session, we will create charts in Excel. In addition, we will work with the formatting options available, including:

  • legends
  • data labels
  • gridlines
  • colors and patterns

return to Workshop Schedule

Working with Data in Microsoft Excel
In this session, we will work with:

  • the sorting and filtering features in Excel
  • different worksheets in the same workbook
  • printing options, including adding headers and footers and fitting your spreadsheet to print on one page.

return to Workshop Schedule

What in Heaven is Office 2007?
Office 2007 is here! Please join us as we introduce the new look and interface of Microsoft Office 2007. We will explore the exciting new features available in Office 2007 as well as find where Microsoft moved all our old favorite features.

return to Workshop Schedule

The ‘New’ Way to Take Notes: Introduction to OneNote
Microsoft OneNote allows you to gather information in one place, find what you need fast, and share your notes and information with others. Join us as we explore the new features in OneNote and find out about its timesaving techniques!

return to Workshop Schedule

What’s New in Excel 2007
In this session, we will explore the new features in Excel 2007, including:

  • improved formula writing features
  • enhanced sorting and filtering options

return to Workshop Schedule

Advanced Formulas and Functions
In this session, we will explore some of the advanced formulas and functions available in Excel, including:

  • LOOKUP and PAYMENT functions
  • absolute references

return to Workshop Schedule

What’s New in Access 2007
In this session, we will explore the new features and look of Access 2007, including:

  • field and table templates that make creating a database easier than ever
  • two new views that allow you to work with forms and reports interactively

return to Workshop Schedule

Working with Access Tables - A Continuation
In this session, we will:

  • continue working with tables in Access
  • create reference tables to aid in data entry (allowing for data to be entered from a dropdown list)
  • continue setting field properties, like default values, captions, input masks, and validation rules
  • work with the sort, filter, and find/replace features.

return to Workshop Schedule

Designing Forms in Access
Forms provide a quick and easy way to modify and insert records into databases. They offer an intuitive, graphical environment easily navigated by anyone familiar with standard computer techniques. In this session, we will create, revise, and test forms.

return to Workshop Schedule

Creating Queries in Access
Queries can be used to quickly analyze and sort information that is in an Access database. A query allows you to present a question to your database by specifying specific criteria. Join us in this session as we design and create queries that put data to good use.

return to Workshop Schedule

Designing Reports in Access
Reports allow you to analyze the data you have collected in your database and print it in an organized format. In this session, we will design and create professional-looking reports to showcase information in a database.

return to Workshop Schedule

Moving Data Between Access and Excel
Part of the power of Access and Excel is the ability to easily transfer data between each application, thus allowing you to take advantage of the features of both applications. In this session, we will explore various ways to transfer data from Excel to Access and vice versa.

return to Workshop Schedule

Creating Pivot Tables in Excel
PivotTables are one of the most powerful features in Excel, allowing us to create multidimensional data views. With PivotTable reports, we can look at the same information in different ways with just a few mouse clicks. Data swings into place, answering questions, telling us what the data means.

return to Workshop Schedule

Macros in Excel: Recording, Running, and Editing
Macros offer a powerful and flexible way to extend the features of Excel. At its simplest, a macro is just a recording of the keystrokes and mouse actions involved in performing a particular task. At any time after the macro is created, the task can be automatically performed by invoking the macro, which essentially plays back the recording – thus creating a powerful and simple way to save time on repetitive tasks.

return to Workshop Schedule

Working with Publications: Introduction to Publisher
From signs and greeting cards to brochures and business cards, we will explore the features of Microsoft Publisher that allow us to create professional-looking publications with ease.

return to Workshop Schedule

Mastering Large Documents in Microsoft Word
Are you working on a novel, dissertation, or research paper? Join us as we explore the built-in functionality in Microsoft Word to make managing complex documents easier. We will:

  • work with subdocuments and master documents
  • insert a Table of Contents
  • create an index
  • insert images with captions
  • add footnotes and endnotes

return to Workshop Schedule

Designing Action Queries in Access
Action queries allow us to do more than merely select specific groups of records; they allow us to perform operations on groups of records. In this session, we will:

  • create action queries that delete records
  • append records
  • update information
  • create new tables

return to Workshop Schedule

Personalizing Your Access Database with a Switchboard
Switchboards allow us to tie our database objects (tables, queries, forms, reports, and macros) together with a user-friendly interface. In this session, we will design switchboards with various buttons for triggering events such as:

  • printing reports
  • opening forms
  • running queries
  • much more

return to Workshop Schedule

Introduction to Microsoft Groove
Groove is new to Office 2007 – and is touted as one of the top reasons to upgrade! Groove is a collaboration software program that brings teams together to work on project activities and share information — anywhere, anytime, with anyone. Join us as we explore how Groove workspaces save time and increase productivity!

return to Workshop Schedule

Outlook Tasks
In this session, we will explore the use and capabilities of Tasks in Microsoft Outlook:

  • Tasks allow you to create and manage a detailed “to-do” list
  • Tasks can be invaluable in project management. Tasks can be assigned to others, while the status of each task can be reported and maintained in Outlook.

return to Workshop Schedule

Working with Publications: Advanced Publisher
In this session, we will continue to explore some of the more advanced features of Publisher, including:

  • using mail merge
  • creating master pages (i.e. page templates)
  • importing a Word document
  • embedding and linking objects (like Excel charts or Word tables)
  • much more

return to Workshop Schedule

Do More With Internet Explorer and Firefox Add-ons
Web browser add-ons are powerful applications that enhance features and capabilities. Learn ways to make your browser do a whole lot more through powerful add-ons. Firefox and Internet Explorer boast a slew of add-ons that re-define the ability of a browser, while improving browsing experience and efficiency. A browser is not just a browser anymore!

return to Workshop Schedule

Excel Shortcuts
In this session, we will explore a variety of tricks in Excel, including:

  • making a chart with one press of the button
  • making your spreadsheet print on one page
  • making specific rows always print at the top of a page
  • converting one column into two
  • pasting cell formats

return to Workshop Schedule

Showcase of Free Tools
Learn, play, explore, and do a lot more, all for free! Join us as we take you through some exciting free software applications – some popular, some very new. From image processing and data storage to an operating system and foreign language tutorial, you will be sure to pick up some great tools in this session.

return to Workshop Schedule

PowerPoint: Adding Audio, Video, and Animation
In this session, we will explore some of the more advanced features of PowerPoint, including animation and incorporating multimedia (including a YouTube add-in for inserting videos)

return to Workshop Schedule

Tag, You’re It!
ITS is taking a backseat and letting you shine! If you have a tool, shortcut, add-on, application, etc that you think the UIS community could benefit from, please join us and share it with the group. There are no guidelines – just showcasing tools that you find helpful.

return to Workshop Schedule

Using Styles in Word to Make Documents Accessible and Formatting Easier
In this session, we will explore the Styles feature in Microsoft Word. The use of styles provides a structure to your document that can be discerned by a screen reader. Styles also allow you to easily apply consistent formatting to documents, as well as to quickly change existing formatting.

return to Workshop Schedule

Is Your Inbox Full? Need/Want to Clean It Up?
Are you coming dangerously close to reaching your 250MB e-mail limit? Or are you interested in storing e-mails outside of Outlook so that you can open them with other applications like Word? If so, this session is for you! We’ll discuss Outlook’s auto archive feature, as well as other alternatives for storage.

return to Workshop Schedule

Accessing Your Work Computer from Home: Remote Desktop
A snow storm, an out-of-town conference, a vacation. In scenarios such as these, you might find yourself with a need to access your files, a software application, or network resources (like a printer) from your work computer. Remote Desktop allows you to connect to your work computer and access all of your programs, files, and network resources as though you were actually sitting in front of your computer at work.

return to Workshop Schedule

Word Shortcuts
In this session, we will explore a variety of tricks in Word, including:

  • altering Word’s behavior
  • changing defaults (like margins, fonts, etc)
  • comparing similar documents
  • searching and navigation tips
  • printing multiple pages on one sheet
  • inserting frequently used text
  • inserting media (sound and/or video)

return to Workshop Schedule

PowerPoint Shortcuts
In this session, we will explore a variety of tricks in PowerPoint, including:

  • using multiple backgrounds in one presentation
  • making presentation file sizes smaller
  • grouping objects
  • using slides from other presentations
  • working with sound files
  • adding objects to every slide

return to Workshop Schedule

What’s New in PowerPoint 2007
In this session, we will explore the new and improved features in PowerPoint 2007, including:

  • custom slide layouts
  • SmartArt graphics
  • enhanced effects (like beveling and 3-D rotations)

return to Workshop Schedule

What’s New in Publisher 2007
In this session, we will explore the new and improved features in Publisher 2007, including:

  • a content library for storing frequently used text and graphics
  • enhanced templates
  • improved Pack and Go Wizard (which helps with commercial printing)
  • personalized hyperlinks, and much more

return to Workshop Schedule

Need to Manage Drafts/Revisions to Your Papers? Word’s Track Changes, Commenting, and Compare Tools can Help!
Word come with multiple tools to assist in reviewing documents, as well as managing the revisions. In this session, we will:

  • work with the track changes feature (which manages revisions by author as they are made)
  • add comments to a document (which allows notes to be added without altering the text)
  • explore the tri-pane review panel (a powerful new feature in Word 2007)

return to Workshop Schedule

What’s New in Word 2007
In this session, we will explore the new and improved features in Word 2007, including:

  • building blocks
  • the tri-pane review panel
  • the enhanced saving options

return to Workshop Schedule

What’s New in Outlook 2007
In this session, we will explore the new and improved features in Outlook 2007, including:

  • the To-Do bar
  • an attachment previewer
  • RSS feeds
  • task integration on the calendar

return to Workshop Schedule

Basic Tech Tips That Save Time
In this session, we will showcase some easy, yet powerful shortcuts that may save you time and cut down on frustration. For example, enlarging the text on a web page, using the spacebar to scroll through a web page one screenful at a time, easily selecting entire words/sentences/paragraphs, creating a keyboard shortcut to open a program, using Google to text questions or perform calculations or convert currencies, capturing what appears on your screen, and much more!

return to Workshop Schedule

Is Improved E-mail Communication One of Your New Year Resolutions? Check Out Some Shortcuts in Outlook That Can Help!
In this session, we will explore a variety of shortcuts in Outlook to help you better manage communications including:

  • Creating a desktop shortcut for people you frequently email
  • Converting e-mail messages into calendar appointments or contacts
  • Sending a message to undisclosed recipients
  • Deleting an address from the auto-complete list

return to Workshop Schedule

Getting Started with Access Databases
Access is a powerful tool, as a properly designed database provides you with access to up-to-date, accurate information. In this session, we will discuss the uses and benefits of Access, as well as scenarios for when to use Access and when to use Excel. We will also discuss design techniques that allow for databases that meet your needs and that can easily accommodate change. You will learn how to:

  • decide what information is needed
  • how to divide that information into the appropriate tables
  • how those tables relate to each other

In addition we will:

  • create reference tables to aid in data entry (allowing for data to be entered from a dropdown list)
  • set field properties, like default values, captions, input masks, and validation rules
  • work with the sort, filter, and find/replace features.

return to Workshop Schedule

Want to Create an Electronic Gradebook?
In this session, we will create a gradebook in Excel and work with formulas that:

  • create totals and averages
  • return letter grades
  • drop the two lowest grades
  • determine percentages

return to Workshop Schedule

Entering/Importing Data Into Access
In this session, we will work with two popular ways to get data into your database – entering data through a form and importing data from Excel. Forms provide a quick and easy way to modify and insert records into databases. They offer an intuitive, graphical environment easily navigated by anyone familiar with standard computer techniques. We will also explore various ways to transfer data from Excel to Access and vice versa. Part of the power of Access and Excel is the ability to easily transfer data between each application, thus allowing you to take advantage of the features of both applications.

return to Workshop Schedule

Putting Your Access Data to Use: Designing Queries
Queries can be used to quickly analyze and sort information that is in an Access database. A query allows you to present a question to your database by specifying specific criteria. Furthermore, queries allow us to do more than merely select specific groups of records; they allow us to perform operations on groups of records such as deleting records, appending records, updating information, and creating new tables. Join us in this session as we design and create queries that put data to good use.

return to Workshop Schedule

When Others Need to Use Your Access Data
Reports allow you to analyze the data you have collected in your database and print it in an organized format. However, in some cases, others may need to work with our database. Switchboards allow us to tie our database objects (tables, queries, forms, reports, and macros) together with a user-friendly interface. In this session, we will:

  • design and create professional-looking reports to showcase information in a database
  • design switchboards with various buttons for triggering events such as printing reports, opening forms, running queries, and much more

return to Workshop Schedule

Creating Effective E-mail Announcements in Publisher
E-mail is an efficient way to share information with many people. Unfortunately, our inboxes are often filled with unnecessarily bulky and/or poorly formatted messages that are difficult to manage or read. Join us in this session as we explore the features in Publisher that allows us to create and send effective e-mail announcements.

return to Workshop Schedule

Creating Interactive Online Forms with Adobe Acrobat
In this session, we will use Adobe Acrobat to create an electronic, interactive form complete with checkboxes, radio buttons, dropdown lists, and text fields that users can fill in online and then print.

return to Workshop Schedule

eDocs: Blackboard Integration
In this session, we will explore the connection between eDocs and Blackboard which allows you to add links to eDocs files directly in your Blackboard course. Because students are already logged into Blackboard, they will not need to log in to eDocs separately to view the files.

return to Workshop Schedule

eDocs: A Collaboration Tool
In this session, we will explore the features in eDocs that make collaboration with others easy including setting permissions, sending tickets, managing versions, logging, and more.

return to Workshop Schedule

eDocs: Using the wiki feature
In this session, we will explore the wiki feature in eDocs to create, share, and manage wikis.

return to Workshop Schedule

eDocs: Setting Permissions for Others to View/Edit Your Files
In this session, we will cover how to set permissions for others to access your files and review the various levels of permissions (Viewer, Contributor, and Administrator).

return to Workshop Schedule

eDocs: Quick and Easy Options to Access and Work With Your Files
In this session, we will explore the various ways to access eDocs files – mapping a drive to your personal and department eDocs accounts, bookmarking folders and files, and using My Network Places.

return to Workshop Schedule

eDocs: Tips and Tricks
In this session, we will highlight some of the best practices for using eDocs to store, manage, and share your files.

return to Workshop Schedule

File Management: Options for Reducing File Size
In this session, we will explore options for reducing the size of your files including resizing images, cropping images, compressing images, and storing files in compressed zip folders.

return to Workshop Schedule

Getting Started in Excel
In this session, we will create basic spreadsheets in Excel – entering and formatting text and numbers, sorting and filtering data.

return to Workshop Schedule

Excel: Formulas and Functions
In this session, we will work with a variety of functions including totals, averages, if statements, and lookup tables. We will also work with formulas that span multiple worksheets.

return to Workshop Schedule

Introduction to my.UIS
A revolutionary tool, my.UIS is a customizable, central location just for UIS faculty, staff and students for many university applications and web page links. my.UIS allows you to create a space with the information you most need and want in a single location. You’ll choose the content you need and want – register for classes, check your e-mail, find your i-Card balance, log into Blackboard, enter grades, view class rosters, check the calendar of UIS events, and much more. One of the best features of my.UIS is Single Sign-On. Once you log in, you can go to the applications you need without logging in again.

return to Workshop Schedule

Word: Managing/Revising Documents with Comments and Track Changes
Word comes with multiple tools to assist in reviewing documents, as well as managing the revisions. In this session, we will:

  • work with the track changes feature (which manages revisions by author as they are made)
  • add comments to a document (which allows notes to be added without altering the text)

return to Workshop Schedule

Word: Exploring SmartArt and Graphs
In this session, we will explore how SmartArt (new to Word 2007) and the built-in graphing capabilities can help enhance your Word documents.

return to Workshop Schedule

Introduction to Windows 7
In this session we will:

  • take a tour of Windows 7
  • highlight the new and improved features and functionality
  • discuss what you need to know before upgrading
  • discuss how Windows 7 works with UIS resources

return to Workshop Schedule

Introduction to Windows Movie Maker
Windows Movie Maker is a free tool available with the Windows operating system. We will use Movie Maker to create a digital movie using pictures, video clips, and audio.

return to Workshop Schedule


Multimedia Software Workshop Handouts

For ease in reproducing the workshop handouts, we have created Portable Document Format [PDF] files that you can download.

NOTE: Please note that you will need Adobe Reader to view/print the handouts. If Adobe Reader is not installed on your computer, please download and install Adobe Reader.

The workshop handouts are designed to be used in conjunction with workshop activities. Hence, not all the handouts are designed to be “How-To” documents.

Apple Macintosh Operating System

Apple iLife

Scanning

Audio

Adobe Photoshop

Adobe Flash

Adobe Dreamweaver

Social Networking


Productivity Software Workshop Handouts

For ease in reproducing the workshop handouts, we have created Portable Document Format [PDF] files that you can download.

NOTE: Please note that you will need Adobe Reader to view/print the handouts. If Adobe Reader is not installed on your computer, please download and install Adobe Reader.

Microsoft Office

Microsoft Windows

Microsoft Access

Microsoft Excel

Microsoft OneNote

Microsoft Outlook

Microsoft PowerPoint

Microsoft Project

Microsoft Publisher

Microsoft Visio

Microsoft Word

Microsoft Remote Desktop

 


Additional Technology Workshop Handouts

Classroom Technologies Handouts

Lab Instructions/Handouts

Google Apps Handouts

Miscellaneous Workshop Handouts

WordPress resources for updating department websites are available on the Office of Web Services website.

5 Ways You Can Use Series

This series showcases 5 ways you can use a variety of instructional technology tools and resources.

5 Ways You Can…

Archived Workshops

You can view these archived workshops with Adobe Flash Player or Apple iTunes.

Adobe Flash Download Adobe Flash Player
Apple iTunes Download Apple iTunes

Click on either icon next to the workshop title to view the session in Flash or iTunes. Remember to “subscribe” to the podcast to view the related content with audio.

Microsoft Office 2007

  • Adobe Flash Apple iTunes What in Heaven is Office 2007?

Microsoft Word

  • Adobe Flash Apple iTunes Mastering Large Documents in Word
  • Adobe Flash Apple iTunes Using Mail Merge to Create Labels, Certificates, and Form Letters in Word

Microsoft Access

  • Adobe Flash Apple iTunes Getting Started with Access
  • Adobe Flash Apple iTunes Working with Access Tables
  • Adobe Flash Apple iTunes Creating Queries in Access
  • Adobe Flash Apple iTunes Designing Forms in Access
  • Adobe Flash Apple iTunes Designing Reports in Access
  • Adobe Flash Apple iTunes Moving Data Between Access and Excel
  • Adobe Flash Apple iTunes Personalizing your Access Database with a Switchboard

Microsoft Excel

  • Adobe Flash Apple iTunes What’s New in Excel 2007
  • Adobe Flash Apple iTunes Creating and Formatting Charts in Excel
  • Adobe Flash Apple iTunes Creating PivotTables in Excel
  • Adobe Flash Apple iTunes Macros in Excel: Recording, Running, and Editing

Microsoft PowerPoint

  • Adobe Flash Apple iTunes When Good PowerPoint Presentations Go Bad

Microsoft Outlook

  • Adobe Flash Apple iTunes Outlook Tasks
  • Adobe Flash Apple iTunes Making Your E-mail Work Harder for You

Microsoft Publisher

  • Adobe Flash Apple iTunes Using Publisher to Create Marketing and Communications Materials

Google Apps

 

return to top