...
...
...
...
Description
| Excerpt | ||
|---|---|---|
| ||
The Student Graduation Basic Dashboard provides academic and degree information for students who graduated in a selected Fiscal Year/Academic Term. Use this dashboard to view the graduation numbers by degrees and academic plans , by or demographic metrics or generate a list of students with their respective graduation addresses. Users may also use this dashboard as a template to build or customize their own versions of the dashboards for their needs. |
Key Business Questions
This dashboard can be used to answer a number of questions, such as:
| Excerpt | ||
|---|---|---|
| ||
|
...
Usage Guide
Student Graduation Basic Dashboard contains two three tabs
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Info |
|---|
Viewing data per Academic Year Users should note that the fiscal year filter drives the other filters within the grey filter bar. The Academic Year occurs across two Fiscal years therefore, to view data by the Academic Year, select more than one Fiscal Year and then reduce the Academic Term filter according to your needs. |
Student Graduation
In this view you will find the list of students who were awarded degrees as well as and bar charts of degrees by types and by academic plans. All visualizations are dependent on the filter selection at the top of the screen.
Clicking on one or more bar(s) in the bar charts will also filter the page to include data only for the selected bar(s). Filter settings can be saved using a custom view.
...
In the top right part of the dashboard (just below the filters), the “Number of Students” displays unique number of students based on the filter selection. However, in the tables and charts, there may be more than one record per student, as some students are graduated with multiple degrees/certificates.
| Info |
|---|
Accurately reporting Degrees Awarded Due to such diversity of study at the University of Pittsburgh, when a student selects a major that combines different degree types, the student must choose which type of degree they would like to receive. In a case when only one degree is awarded, one of the plans is indicated as “primary” using the |
...
"not primary" ( |
...
Graduation data source). This Degree Count field is used in the Degrees by Type visualization. |
In the top left part of the dashboard, the “Number of Degrees” displays unique number of degree types based on the filter selection.
The Download button next to the row of filters will allow you to download each chart/table data in .XLSX or .CSV format. When the download menu pop ups, select the sheet which data you want to copy, select the Format, and then click Download. The file will be automatically saved in the Downloads folder on your PC.
...
The blue cells above highlight restricted fields. If you see empty (Null) values in these columns, see How Do I get access? section of this document.
In the bottom left corner of the view, you can see the date and time the tableau data extract was refreshed.
Graduation Demographics and Performance
In this view, you will find different demographic and performance metrics of the graduated students. The demographic visualizations on at the left side top of the view only (Citizenship, Ethnicity, Sex, and Gender) apply to students with Baccalaureate Degrees, meaning all students regardless of the degree they received.
The performance metrics are split by the Degree Award Type. This means that Degree Award Type and Degree Award filters at the top of the view will not filter these left visualizations, as them. On the bottom left, you can see average and median GPA for the baccalaureate degrees, where both visualizations have the Degree Award Type filter is preset to ‘BACC’ and there is separate BACC Degree Award filter for the GPA, Honors and Time to Graduation charts.
The Years to Graduation chart also does not use the Fiscal Year and Graduation Term filters.
...
The visualizations on the right (Citizenship, Ethnicity, Sex, and Gender) apply to all students regardless of their received degree.to refine data for a particular degree. The values for the undergraduate degree average and median GPA are coming from Degree GPA field.
On the bottom right, the average and median GPA are for the advanced certificate, graduate, doctorate, and professional degrees. You can use Degree Award filter to view data for a particular degree. The values for the advanced degrees average and median GPA are coming from Last Enrolled Cumulative GPA field.
...
If you don’t see most of the visualizations on this page, it means that you don’t have access to the demographic and performance indicators data. See How Do I get access? section of this document.
Years to Graduation
The Years to Graduation view is also split into two sections: Years to Undergraduate Degree and Years to the Advanced Degrees. The filters at the top of the view will apply to both sections. The filters immediately above each chart will filter that chart only. The visualization on the left uses the First Time Freshman Term as a starting point of the student journey. The term when a student was admitted to the graduate, doctorate, or professional program is a starting point for the visualization on the right.
...
What is the source of this information?
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 Student Graduation Tableau Data Source. Data available today reflect the PeopleSoft data from one day prior. New data entered in PeopleSoft today will be reflected in the Student Graduation data source and accompanying dashboard tomorrow.
...
...
For Cognos Users: this data source is a close replica of the existing Cognos “St Graduation Query” package and is built from the student data mart (UD_DATA).
How do I get access?
| Anchor | ||||
|---|---|---|---|---|
|
Anyone with access to the student mart (ST) will have access to the Student Graduation Basic Dashboard. Users will only see their RC, unless otherwise approved on their Federated Authorization form.
...