Workshop Descriptions

Access

Introduction to Access 2010

This workshop introduces you to Microsoft Access 2010. In this workshop, you'll learn how to create a simple database. You'll also learn how to create basic forms, queries, and reports in order to enter, retrieve, and view data.

Datatel

Exporting Datatel Reports

This workshop focuses on exporting Datatel reports to Excel and CSV (comma delimited) formats. In this workshop, you'll learn the difference between these two formats and when to use them. You'll also learn how to prepare an Excel file for sorting and printing after you export the data.

DyKnow

DyKnow Overview for Faculty

DyKnow interactive classroom software enables you to transmit course content to student tablet PCs for personalized annotation, share student work, poll students, and more. This workshop is designed for faculty who are new to DyKnow and would like to learn about its features.

Excel

Creating Charts in Excel

In this workshop, you'll learn how to create clustered column, pie, and line charts in Excel 2010. You'll also learn how to format and modify charts.

Creating PivotTable and PivotChart Reports in Excel

A PivotTable report is an interactive report that you can use to view and analyze large amounts of data in different ways. A PivotChart is an interactive chart that you create from a PivotTable report. In this workshop, you'll learn how to create and modify PivotTable reports and PivotCharts in Excel.

Excel Formulas and Functions

In this workshop, you'll learn how to create formulas using relative and absolute cell references. You'll also learn how to use the SUM, AVERAGE, COUNT, MIN, MAX, COUNTIF, VLOOKUP, HLOOKUP, and CONCATENATE functions as well as how to create IF and nested IF statements.

Excel Tips & Tricks

In this workshop, you'll learn how to quickly sort data in a list, rotate cell contents vertically, show or hide gridlines, freeze parts of a worksheet, add headers and footers, copy ranges of cells, use shortcut keys, print ranges of cells, resize multiple columns and rows, and more.

Introduction to Excel 2010

This workshop introduces you to Microsoft Excel 2010. In this workshop, you’ll learn how to enter and format data on a worksheet, add borders and shading to worksheet, create simple formulas, and more.  

Performing What-If Analysis in Excel

Excel’s What-If analysis tools can be used to explore how different values will affect formula results. In this workshop, you’ll learn how to use the Scenario Manager to view different results, how to use Goal Seek to determine the unknown value that produces a desired result, and how to use Data Tables to view all the outcomes when you want to change two variables in a formula or a common variable in multiple formulas.

Sorting and Filtering Data in Excel

In this workshop, you'll learn how to sort data by multiple columns, use AutoFilter to display the largest or smallest numbers in a column, and display numbers greater than, equal to, or less than a specified number. You'll also learn how to create an advanced filter for use with complex criteria.

Miscellaneous

Protecting Your Personal Computer

Protecting your personal computer from viruses, spyware, and other Internet security threats is important if you want to maintain your privacy, keep your data secure, and ensure that your computer runs smoothly. In this workshop, you'll learn three basic steps that you can follow to protect your personal computer and how to scan your personal computer for viruses and spyware.

Moodle

Introduction to Moodle

This workshop is designed for faculty who have never used Moodle before or who would like to review basic material. In this workshop, you'll learn how to set up a new course site, enroll students, upload files, link to web pages, create graded assignments, and more.

Creating Quizzes in Moodle

This workshop is designed for faculty who would like to use the online quiz feature in Moodle. In this workshop, you'll learn about the different types of quiz questions that you can create (e.g., multiple-choice, true/false, essay, etc.) and quiz options (e.g., time limits, multiple attempts, question shuffling, feedback, etc.). You'll also learn how to create a quiz and quiz questions, how to review quiz results, and how to override a student's quiz grade.

Using Discussion Forums & Chat in Moodle

This workshop covers the different types of discussion forums you can use in Moodle and how to set up a chat room for real-time, synchronous discussions.

Office 2010

Office 2010 Overview

This workshop is designed for those who are new to Office 2010. In this workshop, you'll learn about the Office 2010 user interface and other major changes to Outlook, Word, Excel, and PowerPoint.

OneNote

Introduction to OneNote

Microsoft's OneNote is a digital notebook that you can use to gather and organize information. You can add text, pictures, screen clippings, math equations, web page links, documents, and more to OneNote notebooks. In this workshop, you'll learn how to create a new notebook, add new pages and sections, add different types of content, search content, and use the Send to OneNote printer to quickly send documents, e-mails, and web pages to a OneNote notebook.

Outlook

Creating a Group Schedule in Outlook

If multiple people in your department, organization, or group are using the Outlook calendar, then you can create a group schedule to quickly view all of their schedules at once. In this workshop, you'll learn how to create and edit a group schedule.

Introduction to Outlook 2010

This workshop introduces you to Microsoft Outlook 2010. In this workshop, you'll learn how to create, address, and send new e-mail messages, save messages that you want to keep in a personal folder, create personal distribution (mailing) lists, create new contacts, use the task list, schedule appointments and meetings, and more.

Managing E-Mail

This workshop offers tips for processing and organizing your e-mail more efficiently. For example, you’ll learn how to save messages in personal folders so that they don't take up space in your account, use Quick Steps to execute common tasks, use the Ignore and Clean Up Conversation commands to keep your Inbox from filling up with unwanted or redundant messages, use rules to direct incoming messages to specified folders, and more.

PowerPoint

Adding Animation to a PowerPoint Presentation

Adding animation to a PowerPoint presentation can help you emphasize important points, control the delivery of information, and add visual interest to your presentation. In this workshop, you’ll learn how to animate objects on slides and how to add transition effects between slides.

Adding Sound to a PowerPoint Presentation

In this workshop, you'll learn how to add music and sound effects (from your own audio files, CDs, or Clip Art) to slides in a presentation. You'll also learn how set up a presentation so that music plays automatically across multiple slides or all slides.

Creating a Photo Album in PowerPoint

PowerPoint's Photo Album feature enables you to quickly create a presentation of pictures in just a few easy steps. In this workshop, you'll learn how to create a photo album, add captions to pictures, change the picture layout, add a theme, insert additional slides, and more. You'll also learn how to put a PowerPoint photo album on the Web so that you can share it with others.

Introduction to PowerPoint 2010

This workshop introduces you to Microsoft PowerPoint 2010. In this workshop, you'll learn how to create a presentation from scratch that has a design, pictures, and speaker notes.

PowerPoint Tips & Tricks

In this workshop, you'll learn presentation design tips, how to reduce the file size of a large PowerPoint file, change the font, font size, or font color on all slides at once by editing the Slide Master, embed a YouTube video in a PowerPoint slide, add transition effects between slides, save a PowerPoint file as a video, and put a PowerPoint presentation on the Web, and more.

Reduce the File Size of a PowerPoint Presentation

If you want to run a PowerPoint presentation on a different computer, put it up on the Web, or e-mail it, then you may run into problems if the file size of the presentation is too large. In this workshop, you'll learn how to easily reduce the file size of a PowerPoint presentation by cropping, resizing, and compressing pictures.

Publisher

Introduction to Publisher 2010

This workshop introduces you to Microsoft Publisher 2010. In this workshop, you’ll learn how to create publications (e.g., newsletters, brochures, postcards, and greeting cards) from scratch and using Publisher templates.

SharePoint

Introduction to SharePoint

A SharePoint website allows a group to share documents and communicate online. This workshop presents an overview of SharePoint and covers how to use SharePoint's tools for online group collaboration.

Web Design & Development

Adding Pictures to Web Pages

In this workshop, you'll learn how to insert, resize, resample, and position pictures on a web page. You'll also learn how to add alternative text descriptions to pictures and create thumbnails.

Creating a Website Using Expression Web

In this workshop, you'll learn how to create a website from scratch using a dynamic web template. After you create and apply a dynamic web template to the pages in your website, you can easily update header, footer, and navigation bar information on one file. In this workshop, you'll learn how to create a dynamic web template, apply a dynamic web template to a web page, and modify a dynamic web template.

Creating Cascading Style Sheets

Cascading style sheets are used to control the appearance of web pages and make updating your web pages a snap! In this workshop, you'll learn how to create and modify inline, embedded, and linked cascading style sheets.

Creating Graphics for the Web

Would you like to create your own logo, banner, or custom buttons for your web site? In this workshop, you'll learn how to create your own graphics for the Web using Microsoft's Image Composer.

Introduction to HTML

In this workshop, you'll learn how to create a basic web page using Hypertext Markup Language (HTML) code. You'll also learn how to format and align text, insert paragraph and line breaks, insert and format horizontal lines, create bulleted and numbered lists, cerate hyperlinks, add pictures, and create tables using HTML code.

Windows

Accessing Your F: Drive Files Remotely

In this workshop, you'll learn how to use Remote Desktop and the File Access program to access your F: drive files from any computer that has Internet access.

Introduction to Windows 7

This workshop is designed for those who have little to no experience working in a Windows environment or are new to Windows 7. In this workshop, you'll learn how to use the Windows 7 desktop, access programs, work with files and folders, and more.

Saving and Organizing Files on the F: Drive

In this workshop, you'll learn what the F: drive is, why you should save your files there, where you should save your files on it, how much space you have to save your files, what to do if you run out of space, and how to organize your files in folders so that they will be easier to locate. You'll also learn tips for creating meaningful file names and different ways that you can view your files within folders.

Searching for Files in Windows 7

In this workshop, you'll learn several advanced searching techniques that will enable you to locate files quickly. For example, you'll learn how to search on content, title, file size, dates, keywords, file names, and extensions. You'll also learn how to search using the operators AND, OR, and NOT.

Word

Adding Headers and Footers to Word Documents

In this workshop, you’ll learn about the different types of headers and footers that you can add to documents, how to insert page numbers and dates in headers and footers, how to create different headers and footers for each section in a document, and more.

Creating Bibliographies in Word

In Word 2010, you can easily generate bibliographies based on source information that you provide. (Bibliographies may be formatted in different styles, including APA and MLA styles.) In this workshop, you'll learn how to insert and manage citations and create bibliographies.

Creating a Table of Contents in Word

Did you know that Word can automatically generate a table of contents when you use heading styles to define the different parts of a document? In this workshop, you'll learn how to apply heading styles, how to create and modify a table of contents, and how to format a table of contents.

Creating Interactive Forms in Word

In this session, you'll learn how to create forms that can be distributed and completed electronically in Word.

Introduction to Word 2010

This workshop introduces you to Microsoft Word 2010. Topics covered include formatting text and paragraphs, changing page setup options, adding page numbers, printing, and using proofing tools.

Word Mail Merges

In this workshop, you'll learn how to use Word 2010 to perform mail merges for letters, envelopes, labels, and directories. You'll also learn how to create and modify data files.

Tracking Document Changes in Word

When multiple authors are working on a single document, the Track Changes feature in Word 2010 can help everyone quickly communicate suggestions and identify who made what changes to the document. In this workshop, you'll learn how to turn on the Track Changes feature, add markup and comments to a document, view tracked changes in a document, remove markup and comments from a document, print a document with tracked changes, and more.

Using Styles in Word

A style is a group of formatting instructions that you apply all at once to a paragraph or to individual characters. Styles help ensure that your document is formatted consistently, and they make your documents easier to modify. For example, if you need to make a change to a style, you can change it one place and the change will appear all throughout your document where the style is used. In this workshop, you’ll learn how to create and use styles in Microsoft Word.

Using Tables in Word

Tables are a fantastic tool for formatting tabular information in Word documents. They allow you to wrap text in columns and make updating tabular information a breeze. In this workshop, you’ll learn how to create and use tables in Word.

Using the Outline View in Word

The Outline view in Word enables you to easily create document outlines and modify them using the Outlining tools. In this workshop, you'll learn how to create, modify, and view outlines.

Word Tips & Tricks

Learn how to work with toolbars, use shortcut keys, create tabs and indents using the ruler, view documents in different ways, change bullet types, use styles, and more.

Working with Pictures in Word

In this workshop, you'll learn how to insert, resize, crop, and position pictures in Word documents. You'll also learn how to create watermarks, wrap text, and create your own pictures using Word's drawing tools.

Working with Section Breaks in Word

Section breaks enable you to change the format and/or layout of a document within a page or between pages. For example, section breaks can be used to change the orientation of one page in a multi-page document to landscape. In this workshop, you'll learn about the different types of section breaks that you can add to a document and how to insert, view, and delete them.