Computer Workshop Descriptions

The aim of this introductory level class is to make databases understandable, and allow the participants to create a database from scratch. Topics to be covered include: database concepts, planning and designing databases, relating tables, changing the design of a table, basic queries, and basic forms and reports.

The Access 2010 Intermediate course will provide in-depth information on queries, forms, and reports. Topics to be covered include: basic queries, complex and advanced queries; creating forms and advanced form design; and working with reports and printing.

The advanced class will explore features of Access to help the user customize and better manage their Access database. Topics include: querying with SQL; creating basic and advanced macros; importing, exporting, and linking data; and optimizing and protecting databases.

This introductory class teaches the basic functions and features in Excel 2010. Topics to be covered include: basic workbook skills, entering and editing data, creating formulas, copying and moving data, formatting text and numbers, working with columns and rows, using page setup, and printing.

Pivot Tables are a great data analysis tool; a Pivot Table report is an interactive tool that automatically extracts, organizes, and summarizes your data. This intermediate/advanced level course will provide in-depth information on creating, managing, and effectively using Pivot Tables in Excel 2010. Topics to be covered include creating and modifying Pivot Tables, creating Pivot Charts, and Pivot Table tips.

This 90-minute course will cover a variety of topics to help participants use Excel 2010 more efficiently. Tips to be covered include conditional formatting, keyboard shortcuts, logical formulas, absolute references, charts, formatting options, and preparing for printing.

This intermediate level course teaches students how to manage large sets of data efficiently when multiple worksheets and workbooks are used.  Topics include working with multiple worksheets and workbooks, advanced formatting, consolidating worksheets, outlining and subtotals, using auditing tools, and advanced data management.

This advanced level class will delve into using Visual Basic for Applications (VBA) to create, run, and edit macros.
Topics include developing macros, creating macros to format worksheets, designing an interactive worksheet, using macros to work with multiple worksheets, and creating user-defined functions.

This 90-minute course will cover a variety of topics to help participants use Outlook more efficiently. Topics include customizing Outlook, organizing messages, working with contacts, working with folders, searching and filtering, and working with Rules.

The SharePoint Site Owner training session will review the Governance document, show permissions and how to assign permissions to SharePoint assets, as well as how to create SharePoint libraries, lists, sub-sites, content types, etc.  Users will also be able to customize their site assets.

The SharePoint Site Collection Admin training session will review the Governance document, show how - and when - to create Active Directory groups, restore deleted assets, manage site collection objects, manage quota, run site analytics, in addition to other topics.

This one-hour session will be a high level overview of SharePoint 2010. Come and see how SharePoint can help you and your department save time by using SharePoint to meet your needs. Examples will be shown of document libraries, group calendars, internal websites, content storage, and internal communication -- just to name a few.

Attendees will build SharePoint components which can then be ready for departmental or team use. Topics to be covered include group calendars, document libraries, meeting workspaces, creating internal collaboration sites - wikis, blogs, discussion pages; using SharePoint search, and basic SharePoint governance.

This 3-hr course will cover a variety of topics to help participants use MS Word 2010 more efficiently. Tips and features to be covered include: creating and working with tables, graphics, using styles, creating and formatting sections and page breaks, headers and footers, and tracking changes.

This course will explore the new features of the Windows 7 operating system. Topics to be covered include: customizing the environment, folders and libraries, new taskbar options, and new applications available within Windows 7.

Thinking about upgrading to Microsoft Office 2010? This 90-minute seminar will present an overview of the new features of the programs in Office 2010. The seminar will take place in our training lab so you can try out the features during the seminar.

WyoLync (Microsoft Lync 2010) is an integrated communication application which allows users to instant message, share applications or desktops from their computers, and create video or audio web conferences.

Participants will learn how to create and manage projects using Microsoft Project 2010. Topics include: Project basics, creating and working with tasks, scheduling tasks, working with resources, working with calendars, adjusting resources, assigning costs, and finalizing the task plan.

Learn to use Adobe Acrobat Pro more efficiently -- make your documents more portable, accessible, and useful.
Topics include creating PDF documents, modifying PDF documents, organizing PDF documents, adding bookmarks and hyperlinks, and working with comments.

In this course students will learn to use several of the tools and features of Photoshop CS5 to work with images.  Topics include: exploring the Photoshop environment, working with image selections, working with layers, adjusting images, retouching images, and preparing finished images.

This course will cover the skills to enhance your ability to work with images.
Topics include: fills and overlays, masks, vector paths, creative image effects, layer comps, resizing images, and automating tasks.

In this course students will work with some of the tools and features to create eye-catching printed documents using InDesign CS5. Topics to be covered include: exploring the InDesign environment, creating documents, working with text and graphic frames, master pages, and working with colors, gradients and strokes.

This course will cover the advanced features of InDesign CS5 to create and design documents. Topics to be covered include: document setup, working with swatches, vector paths, working with text layout, graphics, text editing, and working with long documents - creating books, tables of contents, and indexes.

Students will learn to use several of the tools and features of Photoshop CS6 to work with images.   Topics include: exploring the Photoshop environment, working with image selections, working with layers, adjusting images, retouching images, and managing and preparing finished images.

Learn how to use UW's FREE online survey tool to conduct your next survey or class evaluation. This 90-minute seminar will present an overview to the survey tool and will be located in our training lab so you can begin creating surveys in class. * This course is available online, on demand -- go to http://wyocast.uwyo.edu  and click on the Training folder. Next, click on the "UW Survey Tool" course title to start the video.  

Ensure your most valuable asset -- data -- remains protected. Back up all of your important files simply by using SyncBack's easy-to-use interface.  The scheduler can be used to automate the backup process; files can also be easily restored in case something happens to the original file.

If you’ve attended the Level 1 and/or the Level 2 training on the Cascade Server CMS and you’d like some additional help – come in to the lab to work on your site. Technical staff and trainers will be available to answer questions.

The template work session will provide an overview of the changes to the CMS page templates and we will address all questions in relation to these new templates. These workshops will provide an opportunity for content managers to gain hands-on experience with the new templates before the official launch, as well as ensure your pages load correctly during the review stage prior to launch.

This security seminar will discuss passwords, viruses, spyware, hacking, phishing as well as physical and system security precautions. Come and learn about the best practices to improve security in the workplace and at home, as well as how to protect yourself from identity theft.
Computer Security Seminar Presentation (PDF format)

TrueCrypt is a software system which helps you protect sensitive data by maintaining an encrypted data storage area on your computer. No data stored in an encrypted area can be read without using the correct password and encryption keys. If you store sensitive data, you should consider using data encryption. You can bring in and encrypt a storage device on your laptop, or test it on a lab machine before encrypting your computer.

Learn how to set up your departmental website using the new Web Content Management System. This two-hour session will give a basic orientation to the CMS -- you will get hands-on experience creating and editing web pages, creating folders, uploading files and photos, creating hyperlinks, and publishing a site.

Learn about the additional features of UW's new Web Content Management System. Topics to be covered include using video, callouts, homepage media slideshow, faculty and staff directory, and building web forms.