Description
| Excerpt | ||||
|---|---|---|---|---|
The Class Schedule Basic dashboard is a “Basic” dashboard, meaning it’s a starter dashboard that answers basic questions about class schedule and can be used as a starting point to create other reports in Web Edit. The dashboard provides information about class schedule. It does not have data of individual students enrolled in a class. For cases requiring analysis of student enrollment in courses, please use Class Enrollment data (still in development).The dashboard excludes offers a summary of classes offered by the University, including information on number and frequency of offerings, enrollment capacity, waitlist capacity, and assigned instructors so that users can analyze trends in class demand and instructor load.
|
Key Business Questions
Class Schedule Basic gives allows users the ability to analyze classes offered, and get information about classes. No individual student data is in this dashboard.
Basic Usage
Class Schedule Basic has three separate dashboards/tabs
Class Schedule
This dashboard provides a breakdown of classes (excluding College in High School and cancelled classes) listed in Peoplesoft for the Academic Term selected and aggregate enrollment and other characteristics.
...
Sample questions answered by this dashboard:
...
to generate lists of historical class offerings and associated characteristics and metrics, such as enrollment capacity, instructor(s), meeting patterns, and accompanying labs or recitations. It can be used to answer questions such as:
What Accounting undergraduate classes are offered in the Fall term of 2023 for Accounting?
what What classes are offered by School of Education?
how How many students are enrolled in my classes and what is the class ? How full are classes compared to enrollment capacity?
what Which classes are listed as online classes? (select Instructional Delivery Method in Class Attribute drop-down filter)
what is the Status of my classes (Open/Closed)?
how many students are enrolled by Academic Organization?
show me under enrolled classes, or classes enrolled at 100% capacity.
show me all Independent Study classes in ARTSC
what
Which classes have less than 50% enrollment capacity?
What are the meeting days/times for my classes?
...
Which instructors have the highest/lowest course loads last semester?
| Anchor | ||||
|---|---|---|---|---|
|
Class Schedule Basic contains three different tabs:
| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Class Schedule
This dashboard provides a breakdown of classes (excluding College in High School and cancelled classes) listed in Peoplesoft for the Academic Term selected and aggregate enrollment by class characteristics. Use the drop-down filters : per academic term, subject, etc.; by typing in a catalog number; or by clicking on a blue bar in a visualization. We strongly recommend applying at least one of the filters to optimize performance. You can reset the filters by clicking on a Revert button:
...
Distinct Classes Shown counts in the first row to select a specific set of classes. Filter settings can be saved using a custom view.
Class counts treat every class component and combined class instance separately. For as a separate class. So, for example, the class CS 1510/2012, which includes one lecture and one recitation, is counted as four classes (CS1510 Lecture, CS1510 Recitation, CS2012 Lecture, and CS2012 Recitation). In other way, it counts the distinct number of “class numbers” in an “academic term”. Distinct Classes Shown total may not match the number of rows in the table, as a single class may be associated the table at the bottom of the dashboard, classes may appear multiple times for courses with multiple instructors, meeting day/time patterns, etc.
Instructor Load
This textbooks, and unique meeting patterns.
...
| Expand | |||
|---|---|---|---|
| |||
The list below shows fields visible in the table at the bottom of the dashboard. The Tableau Data Source offers many additional fields. Users can utilize Tableau’s Web Edit feature to customize the table and add new fields for their own purpose(s). Because you are exposing new columns, and not applying filters, this cannot be done using the custom view functionality described above.
|
...
We strongly recommend applying at least one of the filters to optimize performance. You can reset the filters by clicking the Revert buttonin the top left part of the browsers window (see screenshot).
Instructor Load
This dashboard is split into two parts: the top half of the dashboard summarizes the profile of university instructors and details of their teaching load. University instructors; and the bottom half allows users to zoom-in and view details of a specific instructor. Use the drop-down menus to limit instructors per academic term, academic organization, etc.Click on an instructor name in the table (left of the screen) to view a specific summarize the breakdown of instructors for a specific term, school, or program assignment; or, to limit types of courses by grad/undergrad or lecture/seminar/recitation. To update the instructor-specific view, click on the desired instructor name from the table in the top-left section of the dashboard. The bottom half of the screen should update to show the selected instructor’s full teaching load across all Schools and Course Components and instructor's historical teaching load.
...
Course Instructor
This dashboard lists courses and their instructors, and basic information about instructors. It can be adapted to your specifications by using Tableau's Web Edit.
...
The table shows a row for each instructor listed in a class offering in a term. Use the drop-down menus to select one or more Academic Terms and Schools/Offering Units (Academic Group/Academic Organization).
...
What is the source of this information?
Class Schedule Basic Dashboard is created from a Tableau The primary source of these data is the PeopleSoft Student system. This data is copied, transformed, and loaded into the data warehouse nightly, and subsequently loaded onto the Tableau Server as the Class Schedule Tableau Data Source. Data available today reflects the PeopleSoft data from one day prior. New data entered in PeopleSoft today will be reflected in the Class Schedule data source . This and accompanying dashboard tomorrow.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
For Cognos Users: this data source is a close replica of an existing Cognos “St Class Schedule Query” package and is built from the student data mart (UD_DATA) |
...
. |
How do I get access?
Anyone with access to the student mart (ST) will have access to the Class Schedule Basic Dashboard. All users can see all classes; however some instructor fields are restricted. The restricted fields are citizenship, education level, employee number, ethnic group, tenure, full-part time status, gender.
To request access to the restricted instructor fields please fill out Student Mart Federated Authorization and ask for Instructor Demographics restricted access:
...
Page Properties
Status
| Status | ||||
|---|---|---|---|---|
|
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||||||||
|---|---|---|---|---|---|---|---|---|
|