IT Connect

Information technology tools and resources at the UW

Archive for month: September, 2019

Report Update: “Current Application Count by Department and Major” and “Freshman Applications Scores and Ethnicity”

The Report Prioritization Group released an update to

This post summarizes those changes.

Change Summary:

  • Both reports are impacted by an update that added two new values to the  sr_adm_appl.appl_status table:

    • 25 DCC DECLND CONF
    • 26 ECX EC TRANSFER
  • In the previous release, both reports had appl_status values hard-coded.
  • The query logic was changed to dynamically gather all applicable status codes.

Questions?

These reports reference a number of terms that can be found in a new tab, “Definitions”.  The source for this tab is Knowledge Navigator.

As always, if you have any questions, please write help@uw.edu and put “RPG: Current Application Count by Department and Major” or “RPG: Freshman Applications Scores and Ethnicity” in the subject line.

Helpful New Tool: UW Calendar Lookup

This morning you probably arrived at work and thought to yourself, “what Biennium are we in?” Or maybe you already knew that, but got hung up on the fact that the 2020 FY is in the 2019 Biennium (WHAT!?). You panicked, feverishly googled, got frustrated, lost confidence, and moved on to an easier pursuit, like contemplating infinity.

If you’re thinking, “there’s got to be a better way!” Well, now there is, with a new calendar lookup tool built by Data Architect, Courtney Drake, in Office of Planning and Budgeting (OPB).  It’s using EDW data and is hosted on our Tableau servers. Check it out yourself, and never get confused by the 5 overlapping UW calendars again!

You can find it in a couple of places –

Report Update: Class List By Curriculum Course Section (removed Pending Major)

The Report Prioritization Group released an update to the Class List By Curriculum Course Section report. This post summarizes those changes.

Change Summary:

  • Temporarily removed Pending Major Column: 

    • In early August 2019 we released an update to the report to add a student’s Pending Major as a column in the report. 
    • The initial response to this release was positive, but we recently learned that the update was causing the report to fail to run when users selected to view multiple quarters of data. 
    • Removing the column resolved the bug, but we are now investigating a resolution for how we can provide this data. 

Please Provide Feedback: 

  • The challenge with providing this data in the Class List report is that “Pending Major” is an attribute of a student at the current point in time. However, this report allows users to view data across time. This time dimension is what caused the report to fail. 
  • If you are a user who finds value in the Pending Major data, can you please write us to share how you use it in your work? We especially want to know:
    • Do you need to know a student’s historical pending majors?
    • Or, are you mostly interested in a list of students for the current quarter that are in your Department’s classes and have a pending major that you advise?
    • What do you do with this data? 
  • To provide feedback please write help@uw.edu with “RPG: Class List Report Pending Major Feedback” in the subject line

Questions?

This report references the term Pending Major. If you have questions about the meaning of this or any other term, please explore the link above or find more detail in the Knowledge Navigator

As always, if you have any questions, please write help@uw.edu and put “RPG: Class List By Curriculum Course Section” in the subject line.

 

New Report Release: Immunization Report

The Report Prioritization Group is excited to announce the release of the new Immunization Report.

Summary: 

We are offering a new reporting tool on the BI portal that provides information about students and their immunization status. The report is intended to be used by Hall Health and Health Sciences Immunization Program (HSIP) to identify students who have or have not fulfilled their immunization requirements.

Questions? 

To run the Immunization Report or any report on the BI Portal, you will need permission to access data in the Enterprise Data Warehouse (EDW). If you do not already have EDW access, follow this link to the enterprise data site to find your authorizer and request access. 

As always, if you have any questions or feedback about the report please email help@uw.edu and include “RPG: Immunization Report” in your subject line.

RPG: Student Degree Information (Departmental GPA)

The Report Prioritization Group released an update to the Student Degree Information report. This post summarizes those changes.

Change Summary:

  • Departmental GPA Columns Added:

    • 3 columns were added to the report to display a student’s GPA for all classes taken within the department that administers the student’s major(s). For more detail on the calculation, please see the Departmental GPA definition in Knowledge Navigator.
    • Users can sort these columns in the report to rank order students by GPA. This data was requested by departmental advisers to be used as a reference when conferring department awards based on GPA.
    • The columns are labeled [First, Second, Third] Major Dept GPA, and are included in the default columns to display.
  • Academic Year Column Added:

    • The Academic Year column was added so that users no longer have to infer the academic year from the filter selection. The Academic Year is now an explicit data element in the report.
  • Enhancement to “Degree, Major or Minor” Filter Order:

    • Previously, there was not a logical ordering of the options displayed in this filter dropdown
    • Now the options in the dropdown are grouped by Major, Minor, and Degree to make it easier to find what you are looking for.

Questions?

This report references two GPA calculations: Cumulative GPA and Departmental GPA. If you have questions about the meaning of these concepts and how they differ from Major GPA, please explore the links above or find more detail in the Knowledge Navigator.

As always, if you have any questions, please write help@uw.edu and put “RPG: Student Degree Information” in the subject line.