Skip Navigation

Southern Oregon University

Click each label below to show more details.

Prerequisites: Faculty and Staff only. Must have a Banner SIS account. Pre-registration is required. *

The SIS Data Warehouse contains a subset of data from the Banner Student Information System and combines it with a user friendly, graphical query/reporting tool (Cognos). This class will teach participants to perform queries and create reports on the Warehouse. Resulting reports can be ran as web pages (html), Adobe PDF files and Excel spreadsheets (xls). Users will be able to get information such as how many students originate from each state, how many English majors graduated last year, list the students with priority registration, and more.

This class applies to personal as well as SOU Windows equipment and is open to students and staff. We'll explore tips and tricks to secure your computer, speed it up, virus, malware, and phishing. We'll also look at browser tune-up, defragmentation, recommended utilities and much, much more.

Learn to organize your files using Windows Explorer. We'll look at the features this important program provides including; Navigation, Libraries, Breadcrumb navigation, Search, Views and how to create folders. We'll also explore copying and moving files, the save-as dialog box and how to find files when you think they are lost.

Acrobat Pro is now available to anyone on campus. Use this product in combination with Office or directly create your own pdf documents and edit them. We'll look at features and tips to make your use of this software easy and logical.

Qualtrics is a flexible software for designing surveys and replaces our previous software which was Survey Monkey. It goes beyond multiple-choice questions and includes many different kinds of prompts. There are also multiple ways for users to provide responses. It's all about versatility.  In this class you'll learn the details of how to design, present and view reports of your surveys.

Take your knowledge a step farther and explore reports, analysis, and in-depth features of Qualtrics.

This class is for students or staff who have recently purchased a personal computer with Windows 8 or are considering doing so? Don’t be confused with the new start menu or frustrated by what does what. We’ll make sense out of this so you can enjoy a new interactive and touch capable world on your new device.  You’ll learn about the new Start page, the difference between apps and programs, where all the old things are, recommended setup and configuration, as well as how to sync with other devices. You’ll walk away with a new respect for Windows 8. If you have a windows 8 device please bring it with you so you can work hands-on.

Mac curious? You’re not alone. Learn tips and tricks, best practices, troubleshooting techniques, and new or commonly unknown features of OS X. From neophyte to experienced user, you’ll get introduced to something helpful in a friendly and fun environment.

Engage your audience with interactive "clicker" technology. This program and the associated devices, allow you to gather "real-time" responses to your questions. Everyone participates and interest goes up. Use it for humor or use it anonymously, to get reactions to controversial subjects. You must know PowerPoint to use this technology. Participation in this class is required before you may check out "clickers" from the Media Services/ Help Desk.

In this class you will learn how to read, reply, forward, attach files, and search for messages. Learn to organize documents with labels and use the sent items folder. Explore adding graphics. You will also be introduced to the Address Book, Google docs, the calendar and sites. We'll look at the latest changes and how to manage them. There are a lot of exciting features in Google Apps; you don't want to miss this class!

An in-depth look at the calendar in which you will learn about adding, removing, editing and sharing calendars. We’ll look at using the “find a time” feature to setup appointments and meetings by looking at other people’s available times.

Next we’ll look at Google Drive which serves as a real-time, collaborative tool to create and edit documents (word processing, spreadsheets, presentations, drawings and  forms) with others while storing them for access on the “cloud”. They are then available on all your devices and from anywhere in the world.

Google Sites is a web-page and wiki-creation tool included with Google Apps. Sites are ideal for committees, workgroups, and project management. This class will teach you how to create, manage, and update a Google Site.

There are a number of "hidden gems" in the new version of Office. We'll look at; pickup where you left off, the backstage view, easy word wrap, take the background out of pictures, the navigation view, and much more. In Excel you'll also see new features including the ability to easily concatenate items in cells. You'll wonder how you ever got along without these great new features.

Get comfortable with Excel's capabilities. You will experience hands-on creation of a new spreadsheet and learn about auto-fill, formulas, functions, formatting and charts. This powerful program is easy to use and easy to learn.

We’ll work with several different worksheets as we explore tips and tricks to make your work in Excel more productive and efficient. We’ll include a look at: how to freeze the top row/column; relative and absolute cells; adding comments; printing tips; formatting and outlines.

Explore the formula tab of Excel. Hands-on work with spreadsheets to explain the difference between relative and absolute cells. Learn about IF, VLOOKUP, and other common functions and how to use 3-d formulas. Learn also, how to protect your formulas from being changed by adding cell protection.

When analyzing huge amounts of data in a spreadsheet you will use these tools; Formatting, Sorting, Grouping and Sub-Totals. The one tool you'll find most helpful is the pivot table. With it you'll find correlations, relationships and even graph them out.
Pivot tables are like the Swiss army knife of data analysis. They  are scary at first; but  once understood they are easy to use. We'll explore it all in this session.

OneNote is a little known gem within the Office suite. It is an organizational tool that synchronizes with all your devices, allows sharing with others and eliminates "forgetting those important things" . Similar to an electronic filing cabinet; it helps you to organize everything. It also makes it searchable. This works with PCs, Macs, cell phones and tablets (and it's free) You'll LOVE OneNote!

PowerPoint is a great tool to enhance your presentations. Learn effective ways to engage your audience and how to avoid classic errors. We'll also cover 6 x 6  design, animation, backgrounds, and how to set up with a laptop. See how easily you can add audio and video to your PowerPoint.  This is a suggested prerequisite for the "Using Clicker Technology" class.

Learn how to make Microsoft Word work for you. This class covers basic features and customization, including formatting, copy/paste and page layout. Also learn about styles and effective use of the ruler. One of the most reported frustrations by users is outlines. In this course you'll learn how to effectively make lists, bullets and outlines.

Explore little known but effective ways to make quick work of your Word documents. Learn the best way to develop a document. This includes modifying styles, creating a table of contents, in-depth creation of tables, and quick fixes for default settings. You’ll be amazed at how much more productive you can be!

Styles are probably the most overlooked but functional part of Word. Document creation, navigation and modification become easier and more efficient. Many of Words other features depend on Styles such as tables of contents, the navigation pane, the Design Tab, and the triangles used for expanding and collapsing sections of the document. We'll explore all this and how to create and modify your own styles in this class.

In this class you’ll learn how to control graphics and use word wrap to create layered documents for newsletters, brochures, flyers or articles. You’ll learn how styles extend to graphics, clipart and pictures. We’ll also explore how to crop and compress pictures, create borders and add shapes.

Use Word's Track Changes feature to collaborate with others. Learn how to accept and remove changes, see the document in different modes, view changes by person and much more. Learn to use Mailmerge for labels, envelopes and documents.

This class is for faculty/staff that manage their department's website.  Learn how to modify and post department web pages using the Joomla Web Content Management System.