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 90-minute course will cover a variety of topics to help participants use Excel 2007 more efficiently. Tips to be covered include logical formulas, absolute references, keyboard shortcuts, conditional formatting, charts, formatting options, and preparing for printing.

This beginner level class will provide further introductory instruction in Excel 2007. Topics include formatting numbers, text, and cells, using automatic formatting styles, creating conditional and custom formats, using templates, using worksheet protection, and using paste special.

This intermediate level class will focus on the graphics capabilities within Excel 2007. Topics include drawing objects, using effects on objects, using autoshapes and diagrams, and creating, editing, formatting, and modifying charts.

This intermediate level class will focus on features useful when working with data lists in Excel. Topics include managing data, working with databases, working with the data form, using AutoFilter, and working with advanced filters.

This intermediate level course teaches students how to use multiple worksheets and workbooks efficiently. Topics include importing and exporting data, using auditing tools, consolidating worksheets, working with multiple worksheets, managing worksheets, using and sharing workbooks, and managing files.

This course builds on the skills and concepts taught in all previous Excel 2007 classes. Topics include working with Comments, working with Outlines, working with Data Series, creating and using PivotTables, managing worksheets, and customizing Excel preferences.

Students will learn the basics of creating and running macros. Topics include using macros, recording and editing macros, using custom toolbars and buttons, working with the Personal Macro workbook, debugging macros, and creating a macro button.

This class will build on concepts learned in the Intro to Macros class and delve into using Visual Basic for Applications to create, run, and edit macros. Throughout the  course participants will develop macros to: format worksheets, create an interactive worksheet, work with multiple worksheets, and perform calculations. 

This intermediate/advanced level course will provide in-depth information on creating, managing and effectively using Pivot Tables in Excel. The participant either should have taken the intro class, or have experience using Excel. Topics include creating simple pivot tables, modifying results, creating interactive pivot tables which automatically extract, organize, and summarize data. Use pivot tables for financial reporting, budgeting, and data analysis.

This 90-minute course will cover a variety of topics to help participants use Outlook more efficiently. Topics include organizing messages, using Categories, using the Query Builder to find Outlook items, working with Rules, working with folders, and managing meetings.

This introductory class will look into the basics of Outlook.

This class will look into the additional features in Outlook. Topics include scheduling with the Calendar, managing Meetings, managing Contacts, working with Tasks, using the Journal, and working with Notes.

This intermediate level class will focus on using Outlook more efficiently. Topics include using Outlook message windows and features, creating HTML messages, using the address book, using the Rules Wizard, working with files and applications, working with folders, customizing the Information Viewer and the Outlook bar, and setting Outlook options.

This course covers the basic functions and features of PowerPoint 2007. Topics include exploring PowerPoint, presentation skills, using the outline tab, editing and proofing text, using slide sorter and slide show view, and printing presentations.

This course will explore customizing your presentation in PowerPoint 2007. Topics include formatting presentation text, using graphics images and drawing objects, creating and editing charts, creating a photo album, and customizing your presentation.

This course builds on the concepts presented in the previous PowerPoint courses. Topics include using SmartArt, applying special effects, creating a custom slide show, sharing the presentation, editing presentation and handout masters, and exporting handouts and slides.

This course presents the basic functions and features of Word 2007. Topics include exploring word, document skills, document views, text editing, character and paragraph formatting, document formatting, using the research task pane, and printing.

This class will provide further introductory instruction in Word 2007. Topics include basic text editing, checking spelling and grammar, using AutoCorrect, using Find and Replace, and customizing Word preferences.

This course will focus on formatting issues in Word 2007. Topics include using character and paragraph formatting, working with newsletter-style columns, section breaks, setting tabs, indenting paragraphs, working with lists, headers and footers, and Quick Parts.

This course covers tables and creating forms in Word 2007. Topics include working with tables, editing a table, sorting table data, using formulas in tables, creating forms, and protecting documents.

This course builds on skills and concepts from previous classes. Topics include inserting dates and symbols, applying borders and shading, working with drawing objects, inserting graphics, SmartArt, and using charts.

This class focuses on creating and editing a mail merge in Word 2007. Topics include creating a mail merge, sorting and filtering a recipient list, creating an email merge, creating a mail merge for labels and directories.

This course will cover creating and working with reference documents. Topics include working with comments and revisions, creating a table of contents and index, creating captions, creating citations and bibliographies, creating bookmarks, working with headers and footers, and creating master documents.

This course will touch on a little bit of everything you need to know to work with Word 2007. Topics include document formatting, using templates and wizards, using mail merge, setting tabs, bulleted lists, headers and footers, graphic objects, working with tables, and using forms.

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.

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.

Students will learn how to create and manage projects using Microsoft Project 2007. Topics include project basics, working with tasks, making adjustments to tasks, outlining tasks, working with views, working with resources, working with calendars, adjusting resources, assigning costs, and working with the Critical Path.

In this course, students learn how to create and modify publications with Microsoft Publisher 2007. Topics include creating basic publications, creating multi-page publications, layout design techniques, and finalizing documents.

Using Adobe LiveCycle Designer (included with Acrobat Professional) you can create interactive PDF forms that can be distributed, filled out, and submitted electronically; the feedback received can be collated quickly and efficiently.

This free, 90-minute workshop will demonstrate some of the new features of Photoshop and InDesign CS5.

This course will cover the features to get your photos ready for use on a webpage. Topics include resizing images, preparing finished images, optimizing web images, automating tasks, and basic gif animation.

This Print Design Open Work Session is being offered for UW Employees currently working on UW marketing materials (newsletters, brochures, etc.) and/or authoring print bids who  would like to receive feedback and assistance. Technical staff will be available to assist and answer questions during this two-hour, hands-on work session. *All InDesign files must be packaged correctly to receive assistance in this work session. For questions on how to package InDesign files, email uwmktg@uwyo.edu.

In this course, students will use Adobe Acrobat 9 to make their information more portable, accessible, and useful to meet the needs of their target audience. Topics include working with PDF documents, using the Acrobat interface, creating PDF documents from files, organizing PDF documents, adding bookmarks and hyperlinks, creating articles, using text tools, 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.

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.

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.

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.