- Banner SIS - Basics
- Banner SIS - Advising
- Banner SIS - Reports
- MySOU - Faculty SISWeb
- Data Warehouse
- SIS Data Warehouse
- Technology Classes
- Care and Feeding of My PC
- Windows 8
- Macintosh OS X
- Using "Clicker" Technology
- Google Apps
- Intro to Google Apps
- Calendar and Drive
- Microsoft Office 2010
- Excel - Level I
- Excel - Level II
- Excel - Formulas / Functions
- Excel - Pivot Tables
- PowerPoint - Introduction
- Word - Essentials
- Word - Tips and Tricks
- Word - Graphics
- Word - Track Changes and MailMerge
- Website Maintenance
- Web Publish Training
Banner SIS - Basics
Prerequisites: Faculty and Staff only. Must have a Banner account and basic Banner Student access. Pre-registration is required. *
The Banner Student Information System (SIS) is the software system used to administer student information. All other related Student Information System applications pull data from this system. It supports the full range of functions necessary for student administration including: creation of catalog information, scheduling of classes, recruitment, admissions, residential housing, registration, advising, academic history, degree audit reporting and accounts receivable. Almost all student information data entry is done in this system. Banner SIS consists of menus and forms (an online document where you can enter and look up information in the database). You can do all data maintenance functions in this system except enter grades (SISWeb for Faculty must be used by faculty to enter grades). In Banner SIS, you can change a student's advisor and/or major; assign a junior or senior plan to a student; print unofficial transcripts; view student information such as academic history, registration, demographic, and admission; view class rosters; view faculty schedules; view course enrollment, and more.
This course will introduce you to the Banner Student Information System (SIS). You will learn how to navigate through the Banner SIS forms, view a class roster, view a list of advisees or majors, view address information, view faculty and student schedules, and more.
Banner SIS - Advising
Prerequisites: Faculty and Advisors only. Must have a Banner account and faculty/advisor access. Pre-registration is required. *
This course will teach you to use the advising related forms available in the Banner Student Information System. You will learn how to enter advising plans, change a student's major/minor/concentration, change a student's advisor, view a list of advisees, view a list of majors, and print unofficial transcripts. You should have basic Banner SIS skills before taking this class.
Banner SIS - Reports
Prerequisites: Faculty and Staff only. Must have a Banner account. Pre-registration is required. *
In this class you will learn how to run different Banner SIS reports such as class roster reports, section tally reports, currently enrolled advisees reports and much more. You should have basic Banner skills before taking this class.
MySOU - Faculty SISWeb
Prerequisites: Faculty only. Pre-registration is required. *
MySOU Faculty SISWeb provides faculty with easy, secure, single sign on access (on campus or at home) to the Banner administrative data needed to manage instructor information and advise students. This class will teach participants how to access information such as a faculty member's schedule, a class list of students, a wait list of students, curriculum information about students, registration information, final grade entry and more. This class is restricted to faculty..
SIS Data Warehouse
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.
Care and Feeding of My PC
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.
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.
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.
Macintosh OS X - Beyond the Mouse
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.
Intro to Google Apps
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!
Calendar and Drive
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.
Excel - Level I
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.
Excel - Level II
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.
Excel - Formulas/ Functions
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.
Excel - Pivot Tables
When analyzing huge amounts of data in a spreadsheet you will find it a daunting task unless you use pivot tables. Find correlations, relationships and even graph them out. using this tool.
Pivot tables are like the Swiss army knife of data analysis. They are scary at first; but once understood they are easy to use.
PowerPoint - Introduction
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.
Word - Essentials
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.
Word - Tips and Tricks
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!
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.
Word - Track Changes and MailMerge
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.
Web Content Management System (Joomla) Training
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.