Student Information System
Proper training is key to understanding software, minimizing error, eliminating user frustration and ensuring systems are used appropriately. Enterprise Systems has been focusing on updating and improving training opportunities around the Student Information System. We recently completed an upgrade to our User Productivity Kit (UPK) application and are now in the process of expanding the training that is available in the User Productivity Kit (UPK). We also hold two instructor lead courses that focus on educating users on some of the more difficult tools provided in the Student Information System.
User Productivity Kit (UPK)
Within the Student Information System portal (portal.wsu.edu) individuals can access a library of UPKs that cover academic planning, admissions, advising, faculty center student records and other areas within the portal. These training documents can be found in the main menu under myWSU training.
This Business Intelligence Data Warehouse (BI-DWH) 11g Analytics training will prepare end users to use the full range of analysis and reporting capabilities within the 11g environment. After completing the training session, participants will be able to create a new analysis, add filters and functions, build a compound layout to include title, table, pivot table, and graph views of the data. This training is intended for those who had access to 10g Answers and completion of the training will renew their access to the 11g Analytics. Those who do not have access to 10g Answers will need to have their area approver request access to the 11g Analytics for them prior to attending a training session.
This is the first in a series of two Query training courses. This instructor led class will focus on basic functions of the query tool and participants will gain hands on experience in creating and running simple queries. The following concepts will be addressed:
- Common Elements Used in Query
- Query Preferences
- Understanding Query Types
- Selecting Records
- Joining Records
- Adding Fields
- Defining Selection Criteria and Relating Multiple Criteria
- Defining Prompts
- Changing Columns and Sort Orders
- Viewing and Editing Field Properties
- Viewing and Editing Query Properties
- Viewing Underlying SQL Code
- Previewing Query Results Before Saving
- Saving Queries
- Running Queries
- Using Lookups and Prompts
Downloading Query Results. Participants are expected to pass a written examination and complete a final query activity before moving on to attend the Advanced Query Techniques course.
Advanced Query Techniques
This is the second in the Query training sequence and the Query Foundations course is a prerequisite to participating in the Advanced Query Techniques class. This instructor led class will focus on more advanced functions of the query tool and participants will build upon what they learned in Query Foundations. Participants will be expected to have a working knowledge and understanding of basic query concepts and more time will be spent on authoring, running and validating query results. The following concepts will be addressed:
- Having Criteria
- Aggregate Functions
- Sub Queries
- Standard Joins
- Left Outer Joins
Unions Participants are expected to pass a written examination and complete a final query activity to complete the class.