Technical Training

 Course Listings & Registration

Before signing up for a course: Please obtain your supervisor's approval and review our Enrollment and Cancellation Policies. Important - unsupported browsers and popup blockers will create browsing issues with our Learning Management System; please refer to our Learning Center Page for a list of compatible browsers.

Course enrollments are handled by the UC Learning Center, please have your CruzID and Gold password to log in.  For fee based courses you will need to provide a Fund, Organization, and Account information upon enrollment. Workshops are for UCSC employees only.

Outside Vendor Classes are marked with two stars (**) and require a minimum number of students enrolled for the class to run. If that number is not reached 5 business days before the class, we must cancel. Please register early!

Note: All classes are intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable on the dual-boot computers in both labs.

To enroll in Technical Training Courses, click on the titles listed below:


Course Categories

Computer/Google Basics
Project Management
Database Management
Desktop Publishing
Spreadsheets
Web Design
On-line Learning


Computer/Google Basics

Project Management

  • Project, Level 1:  Kerr Rm 8  -  $75
    December 3, 2015 & December 10, 2015; 9:00 am - 12:00 pm
    This course covers the critical skills necessary to create and modify a project plan in Microsoft Project. Create a project plan file containing tasks and resources. Organize these tasks in a work-breakdown structure containing task relationships, resource designations, and project finalization. Resolve resource conflicts, link dependent tasks, assign additional resources to a task, and identify deliverables. Learn to shorten the project duration and display project summary information. This course meets for two half-day sessions held over two consecutive weeks.
    Suggested prerequisites: Introduction to Macintosh or Microsoft Windows and an understanding of project management concepts.
    Topics Covered:
    • Creating a Project Plan File
    • Creating a Work Breakdown Structure
    • Creating and Assigning Resources
    • Finalizing the Project Plan
    Instructor: Frank Widman

  • Project, Level 2:  Kerr Rm 8  -  $75
    March 23, 2016 & March 30, 2016; 9:00 am - 12:00 pm
    This course covers the critical skills necessary to manage and customize a project plan in Microsoft Project. Create customized projects and reports. Learn to exchange Project Plan data with other applications. Learn to analyze and adjust the plan. Learn to work with reports and manage multiple projects. This course meets for two half-day sessions held over two consecutive weeks.
    Suggested prerequisites: Microsoft Project, Level 1 or strong Microsoft Project proficiency; an understanding of project management concepts.
    Topics Covered:
    • Using Templates and Importing Data
    • Managing a Project
    • Analyzing and Adjusting the Plan
    • Working with Reports
    • Customizing Project
    • Managing Multiple Projects
    • Exchanging Project Information
    Instructor: Frank Widman

[Back to Categories]

Database Management

  • Introduction to Relational Databases:  Kerr Rm 8  -  $75
    July 10, 2015 & July 17, 2015; 9:00 am -12:00 pm
    March 16, 2015 & March 8, 2016; 9:00 am -12:00 pm

    This lecture-only session has drawn rave reviews from UCSC staff, who have found it to be extremely informative. The goal is to learn how to properly design a relational database from the viewpoint of a database design architect without having to go to an engineering school. You'll learn about the fundamental principles of sound relational database design. Then you'll understand why information is usually stored in multiple tables, what data should be stored where, and how that information is accessed when it is needed. Using a pencil and paper, you'll put what you've learned into practice as you sketch out plans for the creation of a useful relational database system.

    Attend this lecture before you take your FileMaker or Access classes and the relational aspect of the classes will make more sense to you when it is introduced. Attend this lecture after you take your FileMaker/Access classes and you'll have a greater understanding of the relational topics that were covered in those classes. People who have attended this lecture have said they understand for the first time how relational databases work, why they are so useful, and now they are better prepared to use and improve existing databases on campus. This course meets for two half-day sessions held over two consecutive weeks.
    Instructor: Frank Widman

  • FileMaker Pro Level 1:  Kerr Rm 8  -  $75
    July 30, 2015 & August 6, 2015; 9:00 am - 12:00 pm
    November 12, 2015 & November 19, 2015; 9:00 am - 12:00 pm
    April 6, 2015 & April 13, 2016; 9:00 am - 12:00 pm
    This course introduces basic database concepts, as well as how to plan and create a new database in FileMaker Pro. Learn how to define and edit fields, how to use shortcuts to enter and edit data, and how to find and sort records. You'll learn the Layout mode to create reports and mail labels. You will be introduced to relational database theory, and you will build a relational database using lookups, repeating fields, and simple calculation fields.

  • FileMaker Pro Level 2:  Kerr Rm 8  -  $75
    January 13, 2016 & January 20, 2016; 9:00 am - 12:00 pm
    May 4, 2016 & May 11, 2016; 9:00 am - 12:00 pm
    This course begins where Level One ended - with a quick review and then more valuable information about setting up relationships between multiple tables. Key topics include: setting up relationships between multiple tables, resolving many-to-many relationships, placing a portal on a layout, and using calculation fields to manipulate numbers and text. You'll also learn to create summary reports and executive summary reports, import data into a FileMaker Pro (FMP) database, export from FMP to Excel and Word, save backup copies, and get an introduction to the power of scripts in FMP. This course meets for two half day sessions held over two consecutive weeks.
    Suggested prerequisites: FileMaker Pro, Level 1 or equivalent experience.
    Topics Covered:
    • Database Management
    • Relational Databases
    • Calculation Fields
    • Summarizing Data
    • Saving Copies and Clones
    • Exchanging Information
    • Scripts
    Instructor: Frank Widman

  • Excel Database Features:;  Kerr Rm 8  -  $42
    August 13, 2015; 9:00 am - 12:00 pm
    November 25, 2015; 9:00 am - 12:00 pm
    February 17, 2016; 9:00 am - 12:00 pm
    May 25, 2016; 9:00 am - 12:00 pm
    This class will teach you the basics of using Excel's database features. You will learn how to use filters, including setting up a criteria range. You will learn how to use the data form and get subtotals. You will get your hands on using Pivot Tables, and you will learn how to work with some database functions. Suggested prerequisite: Excel Basics or equivalent experience.
    Suggested prerequisite: Excel Basics or equivalent experience
    Topics Covered:
    • Setting Up a Database
    • Filtering Data
    • Using the Data Form
    • Setting Up a Criteria Range and Extracting Records
    • Using the Database Functions
    • Using Pivot Tables

[Back to Categories]

Desktop Publishing

  • InDesign Level 1:  Kerr Rm 8  -  $165
    December 2, 2015; 9:00 am - 12:00 pm
    InDesign is Adobe's newest page design application suite. Work with graphics, colors, shading, and gradient techniques to sharpen your department's publicity, newsletters, catalogs, and brochures. Perform stylish, complex text formatting with ease. Import MS Office, Photoshop, and Acrobat documents into your InDesign creation.
    Suggested Prerequisite: Introduction to Macintosh or Windows or equivalent experience.
    Topics Covered:
    • Getting to Know the Work Area
    • Setting Up Your Document
    • Working with Frames
    • Importing and Editing Text
    • Working with Typography

  • InDesign Level 2:  Kerr Rm 8  -  $165
    April 19, 2016; 9:00 am - 12:00 pm
    Learn to incorporate Vector Graphics into your InDesign creation. Sharpen your Typography skills, work with Transparency, and create and use graphics within a table. Learn to import and edit text, employ text threading, and apply character styles to imported text.
    Suggested Prerequisite: InDesign Level 1 or equivalent experience.
    Topics Covered:
    • Drawing Vector Graphics
    • Working with Typography
    • Working with Transparency
    • Creating Tables
    • Importing and Editing Text

  • You, Your Presentation and PowerPoint:  Kerr Rm 8  -  $42
    October 7, 2015; 9:00 am - 12:00 pm
    March 9, 2016; 9:00 am - 12:00 pm
    Whether leading a group session, presenting information to your department, or giving an orientation to a group of new students, the skills you learn in this session will prepare you to effectively communicate your message. This 3-hour class is designed to enable you to:
    • Understand the dynamics of your mind and body when making a presentation that will ease anxiety and open communication
    • Learn a 7-step preparation that will help to make your presentation powerful and compelling
    • Effectively use PowerPoint slides, including suggestions for animation techniques
    • Use lab time to try out some of these PowerPoint techniques
    Instructor: Frank Widman

  • Adobe Acrobat Basics**:  Kerr Rm 8  -  $165
    July 23, 2015; 9:00 am - 4:00 pm
    January 27, 2016; 9:00 am - 4:00 pm

    This class shows you how to use Adobe Acrobat to create documents that can be opened by anyone and then viewed and printed exactly as intended, with page layout, formatting, and images intact. You'll convert documents to Adobe Portable Document Format (PDF). PDF files can be opened by anyone who has Acrobat or Acrobat Reader and has become the standard for delivering documents to and sharing documents with others via the Web. You'll learn about a variety of ways for converting documents to PDF and the various methods and scenarios for publishing and viewing PDF documents on the Web. We'll show you how to use Acrobat Distiller to create your PDF files and how to add bookmarks and links to the document. Finally, you'll learn how to use Acrobat in a document review cycle.

  • Adobe Acrobat Creating Forms**:  Kerr Rm 8  -  $165
    May 19, 2015; 9:00 am - 4:00 pm
    August 12, 2015; 9:00 am - 4:00 pm
    May 24, 2016; 9:00 am - 4:00 pm

    This class shows you how to use the part of Adobe Acrobat called Acroforms. This one-day class gives you hands-on experience creating forms with the Form Wizard and using the form tools to create text fields, radio buttons, check boxes, combo boxes and text areas. The learner will also get experience in editing forms and distributing and tracking them.
    Suggested Prerequisite: Acrobat Basics
    Topics Covered:
    • Steps in creating, using, and updating Acrobat forms
    • Working in form edit mode
    • Creating form fields in Acrobat, including text fields, drop-down, lists, buttons, check boxes, radio buttons
    • Automating form creation in Acrobat
    • Enabling Reader users to save completed forms
    • Collecting responses

  • Creating Accessible PDFs with Adobe Acrobat XI:  Kerr Rm 8  -  $82.50
    February 12, 2015; 9:00 am - 12:00 pm

    This three hour class is designed to give the learner a practical workflow for creating a document in Microsoft Word (for Windows) and converting it into an accessible PDF document with the ability to be read by people using adaptive technology, mandated by the Americans with Disabilities Act. Select either the morning session or the afternoon session.

  • Creating Accessible PDFs with Adobe Acrobat XI:  Kerr Rm 8  -  $82.50
    February 12, 2015; 1:00 pm - 4:00 pm

    This three hour class is designed to give the learner a practical workflow for creating a document in Microsoft Word (for Windows) and converting it into an accessible PDF document with the ability to be read by people using adaptive technology, mandated by the Americans with Disabilities Act. Select either the morning session or the afternoon session.

[Back to Categories]

Spreadsheets

  • Excel Basics:  Kerr Rm 8  -  $75
    July 7, 2015 & July 14, 2015; 9:00 am - 12:00 pm
    October 21, 2015 & October 28, 2015; 9:00 am - 12:00 pm
    January 14, 2016 & January 21, 2016; 9:00 am - 12:00 pm
    April 7, 2016 & April 14, 2016; 9:00 am - 12:00 pm
    This course is designed to teach you how to create, edit, format, and print a document in Excel. You will learn to copy, move, insert, and delete data. You will create your own formulas, and will learn how to use some of Excel's useful built-in formulas. You'll get your hands on timesaving ways to format text, numbers, and dates. Learn to increase the impact and clarity of your data by using charts. The course will meet for two half-day sessions that are one week apart.
    Program highlights:
    • Navigate the Excel interface
    • The shape of the mouse
    • Selection techniques
    • Create a worksheet and enter data
    • Calculation operators
    • Using the AutoSum function
    • Formatting
    • Editing
    • Absolute and relative references
    • Print options
    • Basic charting techniques
    Instructor: Frank Widman

  • Excel Time-Saving Features:  Kerr Rm 8  -  $42
    August 5, 2015; 9:00 am - 12:00 pm
    November 17, 2015; 9:00 am - 12:00 pm
    February 10, 2016; 9:00 am - 12:00 pm
    April 27, 2016; 9:00 am - 12:00 pm
    This 3-hour class will give you more depth of knowledge in Excel. You will work with styles, workbook protection, manipulating toolbars, adding comments, using named ranges, and you'll learn how to add graphics to a worksheet.
    Suggested prerequisite: Excel Basics or equivalent experience
    Topics Covered:
    • Working with Format Options
    • Adding Worksheet Enhancements
    • Using Names
    • Adding Graphics to a Worksheet
    Instructor: Frank Widman

  • Excel Database Features:;  Kerr Rm 8  -  $42
    August 13, 2015; 9:00 am - 12:00 pm
    November 25, 2015; 9:00 am - 12:00 pm
    February 17, 2016; 9:00 am - 12:00 pm
    May 25, 2016; 9:00 am - 12:00 pm
    This class will teach you the basics of using Excel's database features. You will learn how to use filters, including setting up a criteria range. You will learn how to use the data form and get subtotals. You will get your hands on using Pivot Tables, and you will learn how to work with some database functions. Suggested prerequisite: Excel Basics or equivalent experience.
    Suggested prerequisite: Excel Basics or equivalent experience
    Topics Covered:
    • Setting Up a Database
    • Filtering Data
    • Using the Data Form
    • Setting Up a Criteria Range and Extracting Records
    • Using the Database Functions
    • Using Pivot Tables

  • Excel Charting & Linking:  Kerr Rm 8  -  $42
    May 21, 2015; 9:00 am - 12:00 pm
    December 1, 2015; 9:00 am - 12:00 pm
    February 24, 2016; 9:00 am - 12:00 pm
    May 18, 2016; 9:00 am - 12:00 pm
    This 3-hour class focuses on how to link worksheets to other worksheets or workbooks. You will learn how to add and remove documents in multiple workbooks. You will get chance to audit a worksheet. You will work with charts in more depth.
    Suggested prerequisite: Excel Basics or equivalent experience.
    Topics Covered:
    • Linking Worksheets
    • Working with Workbooks and Groups
    • Auditing a Worksheet
    • Working with Charts
    Instructor: Frank Widman

[Back to Categories]

Web Design

[Back to Categories]

On-line Learning

  • InfoView XI: Free
    Short on-line demonstrations on how to use the new version of InfoView.
  • Microsoft Office Tutorials: Free
    On-line tutorials on how to use the latest versions of Microsoft Office products.

[Back to Categories]


[Top of Page]