|
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 |
|
|
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. |
|
|
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. |
|
|
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 |
|
|
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. |
|
|
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 |
|
|
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 |
|
|
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 |
|