Software Skills

Advanced Formulas and Functions in Excel

Facilitator: Keith Kennedy
Target Audience: This class is designed for Excel 2010 users with a solid understanding of the basics of spreadsheets who wish to perform more complex operations.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT002

Overall Objectives: Understand and solve math equations, determine which formula/function to use, enter formulas and functions into Excel, understand and use the subtotal, text to columns and concatenation features.

Learning Outcomes:

• Interpret data and choose appropriate function or formula to achieve desired results
• Construct basic formulas to perform calculations
• Practice the Subtotal, Text to Columns, and Remove Duplicate features
• Practice common functions: CONCATENATE, UPPER, COUNT, TODAY
• Demonstrate use of mathematical operators
• Construct formulas that calculate across several worksheets

Pre and Post-Class Actions Required

Basic Excel, Level One

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning or basic user.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT001

Overall Objectives: To instruct basic users on how to enter, format and manage data in MS Excel.

Learning Outcomes:

• Know the terms associated with MS Excel including Ribbons, Tabs, Groups and Back Stage View
• Create worksheets and apply basic formatting to achieve data organization goals
• Describe specific components of Excel Worksheet software
• Edit data and worksheets to fit specific needs
• Practice Excel skills utilizing real-world examples

Pre and Post-Class Actions Required

Basic Excel, Level Two

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Basic Excel Level 1 or who have scored higher than 17 on the self-evaluation.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT023

Overall Objectives: To instruct basic users how to create and manage multiple worksheet workbooks.

Learning Outcomes:

• Create a workbook with multiple worksheets
• Modify data across the entire workbook
• Know the commands on the page layout tab
• Review, print and email workbooks
• Practice Excel skills using real world examples

Pre and Post-Class Actions Required

Basic Excel, Level Three

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Level 1 and 2 or who have scored higher than 30 on the self-evaluation.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT015

Overall Objectives: To instruct basic users how to create and manage data in worksheets and workbooks.

Learning Outcomes:

• Create a custom template
• Add and modify headers on a worksheet
• Add and modify footers on a worksheet
• Sort Data
• Complete a complex sort
• Use a filter
• Apply a password to a cell or a worksheet
• Allow multiple users to access and update worksheets simultaneously

Pre and Post-Class Actions Required

Basic Formulas in Excel

Facilitator: Brett Neal
Target Audience: Experienced Excel users interested in learning how to create basic formulas in Excel.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT017

Overall Objectives: Understand and create basic formulas in Excel.

Learning Outcomes:

• Practice basic calculation order to build a formula
• Define mathematical operators and demonstrate proper use
• Compose basic formulas to perform calculations on data in Excel
• Troubleshoot formula errors
• Use formulas across worksheets

Pre and Post-Class Actions Required

Basic Macros in Excel

Facilitator: Brett Neal
Target Audience: Experienced Excel users who wish to learn how to create simple Macros.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT005

Overall Objectives: This course will provide you with basic skills related to building and troubleshooting Macros in Excel.

Learning Outcomes:

• Describe common uses for Macros
• Discuss timesaving benefits of Macros
• Construct a basic Macro utilizing your own data
• Troubleshoot common Macro problems

Pre and Post-Class Actions Required

Basic PowerPoint

Facilitator: Brett Neal
Target Audience: Basic or beginning users of PowerPoint
Time Allotted: 2 hours
PeopleSoft Course Number: CPT020

Overall Objectives: Create professional, effective presentations using Microsoft 2010 PowerPoint.

Learning Outcomes:

• Recognize how PowerPoint is organized
• Create, modify and format slides
• Review a slide presentation
• Apply a password to a presentation
• Allow multiple users access to a presentation
• Demonstrate how to print, save, email and print a presentation

Pre and Post-Class Actions Required

Basic Word, Level 1

Facilitator: Brett Neal
Target Audience: Basic or beginning uses of Word
Time Allotted: 3 hours
PeopleSoft Course Number: CPT028

Overall Objectives: To instruct basic users on how to create, format and manage documents in MS Word.

Learning Outcomes:

• Know the terminology associated with MS Word including Ribbons, Tabs, Groups, and Back Stage View
• Create documents and apply basic formatting
• Describe specific components of Word software
• Apply Word templates to quickly create documents
• Practice Word skills utilizing real-world examples

Pre and Post-Class Actions Required

Beginning Access

Facilitator: Carley Tillinghast
Target Audience: Beginning Microsoft Access Users
Time Allotted: 3.5 hours
PeopleSoft Course Number: CPT029

Overall Objectives: To give an overview of basic database concepts, and instruct new users on Access navigation, table and field creation, primary keys and indexing, table relationships, queries, and reporting.

Learning Outcomes:

• Define what a databases are and how they are used
• Understand the layout and components of Access
• Create new tables and fields
• Manage database data
• Create queries and generate or modify Access reports

Pre and Post-Class Actions Required

Blackboard and Learning Services

Facilitator: Brett Neal
Target Audience: UVM staff who enroll in or will enroll in certificate programs through Learning Services
Time Allotted: 2 hours
PeopleSoft Course Number: CPT031

Overall Objectives: Learn how Blackboard is used by Learning Services to enable staff enrolled in certificate programs to access presentations, assessments and homework.

Learning Outcomes:

• Locate scheduled Learning Services certificate courses
• Access assigned homework for these programs
• View program presentations and other course materials

Pre and Post-Class Actions Required

Creating Accessible PDFs

Facilitator: Nick Hall, Sharon Mone, Nick Ogrizovich
Target Audience: All faculty and staff who create PDF documents
Time Allotted: 2 hours
PeopleSoft Course Number: CPT034

Overall Objectives: Do you want to make your printed materials more accessible to all users? In this session we will demonstrate accessible PDFs and discuss factors that contribute to inaccessibility.

Learning Outcomes:

• List three common mistakes and how to avoid them
• Describe the characteristics of accessible and non-accessible PDFs
• Examine existing PDFs and analyze possible changes

Pre and Post-Class Actions Required

Intermediate Excel

Facilitator: Brett Neal
Target Audience: Users who are interested in building on basic Excel knowledge.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT016

Overall Objectives: Gain experience using advanced formatting skills in Excel.

Learning Outcomes:

• List the types of charts and graphs available in Excel and describe their functions
• Compare types of charting tools and choose the best for your data
• Construct various charts and graphs using Microsoft Excel
• Analyze and correct errors in how data is displayed in a chart or graph
• Customize the way data is displayed through the use of conditional formatting
• List advanced data formatting features and describe their use (text to columns, remove duplicates, and subtotals)
• Create and use customized templates

Pre and Post-Class Actions Required

Intermediate SharePoint

Facilitator: Greg MacKinnon
Target Audience: Users who are interested in building on basic Microsoft SharePoint knowledge.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT033

Overall Objectives: Gain experience using advanced skills in Microsoft SharePoint. Create pages to creatively present content and use libraries to manage links.

Learning Outcomes:

• Create customized content
• Practice building customized pages using Microsoft SharePoint
• Create documents and interact with other Office products without leaving SharePoint

Pre and Post-Class Actions Required

Introduction to Prezi

Facilitator: Brett Neal
Target Audience: Basic or beginning Prezi users
Time Allotted: 3 hours
PeopleSoft Course Number: CPT022

Overall Objectives: Transform standard PowerPoint presentations into dynamic and interactive presentations using Prezi. This hands-on workshop will demonstrate important techniques, discuss helpful tips for working with the software, and allow time for practice.

Learning Outcomes:

• Define important components of Prezi software
• List three tips for working with the Prezi software
• Employ tips for efficient and effective use of Prezi
• Practice transferring an existing PowerPoint into a Prezi presentation

Introduction to Visio

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning Visio user.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT026

Overall Objectives: To instruct beginning users on how to create, modify and manage Visio diagrams.

Learning Outcomes:

• Navigate a Visio drawing
• Select, scale and resize objects
• Connect shapes in a diagram
• Work with text in Visio
• Format shapes and lines

Pre and Post-Class Actions Required

It's Windows 8: Do Not Panic

Facilitator: Geoff Duke
Target Audience: Anyone who is curious or worried about making the transition to Microsoft's latest operating system, Windows 8.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT035

Overall Objectives: We'll provide an overview of the features and improvements in Windows 8, as well as tips and suggestions for making the switch as easy as possible.

Learning Outcomes:

• Recognize and use the new Start screen and live tiles
• Demonstrate switching between applications, the desktop and the Start screen
• Find well-known tools and new functionality with the Charm bar
• Describe some differences between Windows 7 and Windows 8
• Dispel rumors and calm fears about Windows 8

Pre and Post-Class Actions Required

Learning Services eCommunity

Facilitator: Brett Neal
Target Audience: UVM staff who would like to connect with Learning Services through our social network community.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT030

Overall Objectives: Understand Learning Services social network community offerings, and learn about the advantages of UVM staff members connecting with Learning Services through forums, blogs, groups, chats and videos.

Learning Outcomes:

• Know how to log on and navigate around the community.
• View, reply, and create new postings related to Learning Services offerings.
• Add comments or submit questions to Learning Services.

Pre and Post-Class Actions Required

Lime Survey

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning Lime Survey user.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT027

Overall Objectives: Learn how to quickly create and easily administer intuitive, powerful online question-and-answer surveys.

Learning Outcomes:

• Create online surveys
• Utilize LimeSurvey's tiered approach to survey structure
• View survey results in statistical and graphical analysis forms

Pre and Post-Class Actions Required

Manage Your Files Effectively

Facilitator: Geoff Duke
Target Audience: Anyone who wants to learn strategies and tips for managing collections of computer files.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT036

Overall Objectives: Learn how to create and organize collections of folders and files on your computer that enable you to access and share the information you need, effectively and securely.

Learning Outcomes:

• Recognize the problems created by poor file management
• Produce a consistent method of naming files and folders
• Explore different locations for saving and accessing files
• Add useful, descriptive details to files
• Use the search features of your computer to quickly find the files you need
• Understand UVM file-related services

Pre and Post-Class Actions Required

SharePoint for Beginners

Facilitator: Greg MacKinnon
Target Audience: This class is designed for the beginning or basic user
Time Allotted: 2 hours
PeopleSoft Course Number: CPT032

Overall Objectives: Learn how Microsoft SharePoint can enhance the productivity of teams through a web-based environment. The basics of how to use, modify and create customized SharePoint sites will be covered in this workshop.

Learning Outcomes:

• Know the terminology associated with SharePoint
• List three uses for SharePoint in your regular work
• Create a SharePoint site
• Describe specific components of SharePoint software

Pre and Post-Class Actions Required

Don't see the class you need? We're open to suggestions—take a moment and share yours.