Courses Offered

• Access 2010 - Level 1 Beginning
• Access 2010 - Level 2 Intermediate
• Access 2010 - Level 3 Advanced
• Access 2010 - Level 4 Special Topics
• Adobe Acrobat Basics - Level 1 Beginning
• Adobe Acrobat Collaboration - Level 2 Intermediate
• Adobe Acrobat Forms - Level 3 Advanced
• Adobe Acrobat Training
• Creating and Managing Online Surveys - Level 2 Intermediate
• Creating and Managing Online Surveys - Level 1 Beginning
• E-mail Best Practices (Online)
• Excel 2010 - Level 1 Beginning
• Excel 2010 - Level 2 Intermediate
• Excel 2010 - Level 3 Advanced/Special Topics
• Introduction to Qualtrics Research Suite (New Survey Tool)
• Power Up Your Productivity Potential
• Qualtirics Reporting Tools - Level 3 Advanced
• SharePoint Essentials for End Users

Course Descriptions

	Access 2010 - Level 1 Beginning 7 Hours	Register
	For the beginning level of the Access 2010 course, participants will learn how to: create databases and tables, work with fields and records, and work with data entry rules. Participants will also learn how to create forms and perform operations in queries.
	Audience: A&P, Faculty, USPS, OPS, Student OPS

Return to Top

	Access 2010 - Level 2 Intermediate 7 Hours	Register
	For the intermediate level of the Access 2010 course, participants will learn how to: produce a report, normalize data, manage table relationships, and enforce referential integrity. Participants will also learn how to work with the Subdatasheet feature and Lookup fields, create joint queries, calculated fields, and summary values.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Access 2010 - Level 1 Beginning

Return to Top

	Access 2010 - Level 3 Advanced 4 Hours	Register
	For the advanced level of the Access 2010 course, participants will learn how to: print reports and labels, create and modify charts, and use PivotTables and PivotCharts. Participants will also learn how to add objects to forms and create advanced form types.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Access 2010 - Level 2 Intermediate

Return to Top

	Access 2010 - Level 4 Special Topics 4 Hours	Register
	This session offers additional training on Access’s advanced features. Participants will learn how to: use advanced queries, run and record a macro, and database management. Participants will also learn how to import, export, and link objects.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Access 2010 - Level 3 Advanced

Return to Top

	Adobe Acrobat Basics Level 1 Beginning - 3 Hours	Register
	This course is designed for all those who work with many file types and applications (e.g. Word, Excel, and PowerPoint) and want to present and archive information in a polished format using Adobe Acrobat. In this class you will compare capabilities of Adobe Reader and Adobe Acrobat, compile a list of Acrobat tools most useful to your job, create PDF files from other file types, review settings for Acrobat Distiller, combine multiple files into a single document, and set securities on PDF documents.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites:  Knowledge of basic Windows file management, such as creating new folders, copying/moving files between folders and drives, and re-naming of files and folders.

Return to Top

	Adobe Acrobat Collaboration Level 2 Intermediate - 3 Hours	Register
	This course is designed for all those who frequently have to share documents with others for review and want to track reviewer comments and streamline the review process using Adobe Acrobat. In this class you will annotate PDF files using editing and commenting tools in Adobe Acrobat. You'll also create a digital signature for signing PDF files that adds additional security to your documents during a review process. You'll practice using the E-mail Review and Envelope features for document sharing using Acrobat.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites:  Adobe Acrobat Basics

Return to Top

	Adobe Acrobat Forms Level 3 Advanced - 3 Hours	Register
	This course is designed for all those who collect information from stakeholders on paper and want to consider collecting this information electronically using forms created with Adobe Acrobat. In this class you will design an electronic form from scratch, create a form from a template, and convert a static PDF form to a fillable form. You'll practice exporting information from a filled form into a spreadsheet or other file type to use in other systems.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites:  Knowledge of basic Windows file management, such as creating new folders, copying/moving files between folders and drives, and re-naming of files and folders.

Return to Top

	Adobe Acrobat Training 4 Hours	Register
	This course is designed to teach participants the fundamental concepts, terminology and basic features of Adobe Acrobat 9 Pro.  In addition to learning PDF basics and exploring the Acrobat interface, participants will learn how to: Navigate and organize PDF documents Create PDF documents within Acrobat, other applications such as Word, and from webpages Modify the content of a PDF document Insert various types of multi-media into a PDF document Manage document security Create Adobe forms
	Audience: A&P, Faculty, USPS, OPS, Student OPS

Return to Top

	Creating and Managing Online Surveys Level 2 Intermediate - 2 Hours	Register
	This class covers the advanced functions of the University's online survey application, Qualtrics.  Participants learn how to use the library feature to save surveys and questions for reuse and about survey distribution methods, including customized email links, panels, and inclusion in social media sites.  These methods provide more efficient communication to the survey participants.  Participants learn how to modify the available reports and export survey results into PowerPoint and MS Word.  Creating and Managing Online Surveys, Level is prerequisite to this class.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Creating and Managing Online Surveys - Level 1

Return to Top

	Creating and Managing Online Surveys Level 1 Beginning - 3 Hours	Register
	This class introduces the basic functions of University's online survey application, Qualtrics.  Participants learn how to create, edit, format, publish, and share surveys.  Creation of several question types is covered, including matrix and conditional branching questions.  Participants learn how to export survey data and display reports.  This course is prerequisite to Creating and Managing Online Surveys, Level 2.
	Audience: A&P, Faculty, USPS, OPS, Student OPS.
	Prerequisites: Basic keyboard and mouse skills and familiarity with using a Web browser.

Return to Top

	E-mail Best Practices Online	Start Tutorial
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites:  Basic keyboard and mouse skills and familiarity with the Internet.

Return to Top

	Excel 2010 - Level 1 Beginning 7 Hours	Register
	For the beginning level of the Excel 2010 course, participants will learn how to: get started with Excel 2010, enter and edit data, modify a worksheet, and use functions. Participants will also learn how to format and print worksheets.
	Audience: A&P, Faculty, USPS, OPS, Student OPS

Return to Top

	Excel 2010 - Level 2 Intermediate 7 Hours	Register
	For the intermediate level of the Excel 2010 course, participants will learn how to: create and format charts, manage large workbooks, use multiple worksheets/workbooks, use advanced formatting tools and options, and use outlining subtotals. Participants will also learn how to work with tables and how to use cell and range names.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Excel 2010 - Level 1 Beginning

Return to Top

	Excel 2010 - Level 3 Advanced/Special Topics 4 Hours	Register
	For the advanced level of the Excel 2010 course, participants will learn how to: use advanced charting tools and options, use auditing features, protect worksheets/workbooks, and create PivotTables and PivotCharts. Participants will also learn how to enter logical, statistical, financial, and date functions.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Excel 2010 - Level 2 Intermediate

Return to Top

	Introduction to Qualtrics Research Suite (New Survey Tool) 2 Hours	Register
	The University has changed its online survey application to Qualtrics Research Suite.  This two-hour class introduces current users of Vovici to the new tool.  The class covers survey creation and distribution, downloading data, and reporting functions.
	Audience: This class is for students, faculty, and staff who already use the Vovici online survey tool.
	Prerequisites: Familiarity with the Vovici online survey tool.

Return to Top

	Power Up Your Productivity Potential 2 Hours	Register
	Technology only makes us more productive if it saves us time. This session will focus on the idea that technology is the tool and you are the agent. You will learn ways to optimize your focus in the workplace and at home and how you can better use the technology tools you have at your fingertips to work more productively.
	Audience: A&P, Faculty, USPS, OPS, Student OPS

Return to Top

	Qualtirics Reporting Tools Level 3 Advanced - 1 Hour	Register
	In this hands-on workshop, participants will learn how to use Qualtrics’ new report tool to create, edit, and publish or export reports.
	Audience: A&P, Faculty, USPS, OPS, Student OPS
	Prerequisites: Qualtrics Creating and Managing Online Surveys Levels 1 and 2

Return to Top

	SharePoint Essentials for End Users 2.5 Hours	Register
	This class is designed for faculty and staff who will access information on SharePoint departmental, committee, or collaboration sites. This is an instructor led, hands-on class that teaches SharePoint essentials such as navigating a site, using libraries and lists, working with documents, collaborating, approving workflow and finding content.
	Audience: A&P, Faculty, USPS, OPS, Student OPS

Return to Top