Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel3
maxLevel4
outlinefalse
typeflat
separatorpipe
printablefalse

Description

Excerpt
nameTableau - Active Descr

The Active Student Dashboard provides a summary of current “active students” (students are de-activated after 3 terms of inactivity). Use this dashboard to view a breakdown of students by program or degree, generate contact lists, or identify students with outstanding service indicators.

Users may use this dashboard as a template to build or customize their own versions of the dashboards for their needs.

The dashboard does not have enrollment details, historical enrollment data, or class enrollment data.

Key Business Questions

As mentioned, this dashboard can be used to answer a number of questions, such as:

Excerpt
nameTableau - Active?
  • How many students are currently enrolled across each of the majors offered in my school?

  • Which advisor(s) have the lowest / highest number of assigned students?

  • Who are the students assigned to a specific advisor? What are their demographics / test scores / grades?

  • Which students matriculated for the current term have not yet enrolled?

  • Which students have outstanding holds that will block enrollment?

  • What are the demographics of students associated with a specific school / degree program?

  • Which active students have not yet enrolled in the current / upcoming term?

  • Can I get a student mailing list?

Anchor
basic_usage
basic_usage
Usage Guide

Note

...

Jump to note about students with multiple academic programs (double, triple -degree, University Honors College students, etc.).

Navigating the Dashboard

The Active Student Dashboard has three separate tabs which can be accessed from the top of the view:

Table of Contents
includeexcludeclass
minLevel3
maxLevel64
outlinefalseindent
typeflat
separatorpipe
printablefalse

Active Student with Advisor

...

In the top right part of the dashboard (just below the filters), the “Number of Students” display counts each student exactly once. However, in the tables and charts, there may be more than one record per student, as some students are enrolled in multiple programs/plans.

...

Honors College filter/flag: Allows you to get a list of Honors College students in a specific program. Filter for a desired Academic Program and select “Yes” in Honors College filter. This will show students who are honors students and are in the selected academic program. Do not select an FHC option in the Academic Program filter as it will show all FHC students, in all Programs, in addition to the Program you selected.

...

Expand
titleWhat data fields are available in the table?

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.

  • Student Last Name

  • Student First Name

  • EMPLID

  • Preferred Email

  • Advisor Name

  • Advisor Email

  • Academic Program

  • Academic Plan

  • Academic Plan Type

  • Academic Subplan

  • Admit Term

  • Degree

  • Expected Graduation Term

  • Degree Checkout Status

  • Department

  • Major

  • Current Term

  • Current Term Enrollment

  • Current Residency Description

  • Next Upcoming Term

  • Next Upcoming Term Enrollment

  • Second Upcoming Term

  • Second Upcoming Term Enrollment

  • Citizenship Status

  • Gender

  • Ethnic Group Code

  • Cumulative Units

  • GPA Units Taken

  • Cumulative GPA

  • Units Passed to Progress

  • Units Taken to Progress

  • Total Units Taken GPA

  • Last Term GPA

  • Sum of Grade Points

  • Sum of Total Grade Points

Image Modified

On the “Students per Program/Plan” and “Advisor Load” visualizations, the Academic Program heading can be expanded additional detail at the Academic Plan and Subplan levels. Click on the ➕ sign that appears when hover over the Academic Program heading. Click on the ➖ sign “Academic Program” to collapse headings. Expanding these views may result in students being counted in multiple plans, such that the sum of individual bars will likely exceed the actual number of students within a given program.

...

This dashboard shows students with service indieecatorsindicators. By default, the dashboard selects Service Indicators that programmatically block enrollment (per the Registrar’s Office). Use the drop-down filter to select a different group of Service Indicators, and save your customized view, if you want to save your filtered values.

...

On this table, students will appear multiple times if they have more than one active academic program/plans, or more than one service indicator(s) applied in one or more terms. A student with three active plans and two active service indicators, each applied for the upcoming summer and fall terms will have 12 rows of data in the table (3 plans * 2 service indicators * 2 terms = 12).

Back to Top

Students with Multiple Academic Programs

It is important to note a wrinkle in the data due to the tie between the restricted performance data to the student’s primary academic program.

The data source captures active student data for each of their active academic programs (Schools). “Active” status does not include applicants in the admission pipeline and students who are discontinued or completed.

However, the restricted data in the tables are specific to the student’s primary academic program. In instances where students are active in multiple academic programs, you will experience some filtering and data limitations with respect to your students who are currently active under a different primary academic program.

If you begin your review of the dashboard with the “Academic Program” filtered to a single program, the results will include all active students, but cumulative unit and GPA data will show as ‘null.’

...

Meanwhile, if you do not filter on the “Academic Program” you will be able to see all active programs for every student but the restricted data will only show in the primary academic program row.

...

Beyond the missing cumulative units and GPA data, you’ll see conflicting Term GPA information in the image above (3.600 compared to 3.550). This conflict appears because the “Last Term GPA” pulls from the last term the academic program was active; the last time it was the primary academic program.

It is important to remember that the structure of the data source will result in different data representations. Always look to the data source catalog and dashboard documentation like this to determine the scope of the dashboard and the nuances of the data source.

What is the source of this information?

...

Insert excerpt
Student Data
Student Data
namest_mart_access
nopaneltrue
Insert excerpt
Student Data
Student Data
namest_mart_restricted
nopaneltrue

Latest Releases

September ,

  • Added a new field to the Active Student data source, expected graduation month. To use this field in a dashboard, please use the Web Edit.

  • Added hyperlinks for Federated Authorization community and dashboard documentation.

  • Reordered Admit Term drop-down filter from most recent term to oldest.

  • Official release of dashboard

Page Properties

Status

Status
colourGreen
titleproduction

...