Course Catalog


     CPDT Course Catalog

 



  


 

Types of courses
 

icon instructor 

  Instructor-Led Training  The instructor-led training schedule is published every semester and can be viewed here.  
         
 

icon online 

  Online Training  Online classes can be viewed online at any time from any place with an Internet connection.
         
  icon pdf    Supplemental Materials  Supplemental materials are provided in .pdf format if they are available.

     Browse by Category      

 

Desktop Productivity

Courses Offered

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



    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



    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