IT Connect

Information technology tools and resources at the UW

Tag Archive for: RPG

Posts

New Report Release: Study Abroad Students by Unit Report

The Report Prioritization Group is excited to announce the release of the new Study Abroad Students by Unit Report.

Summary: 

We are offering a new reporting tool on the BI portal that provides information about engagements in study abroad programs by students from your college or department.

The new report combines UW Study Abroad data with other EDW data for an easy to filter view of study abroad students and their program information. You can filter reports by academic year, college and department, as well as study abroad duration.

Questions? 

To run the Study Abroad Students by Unit 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: Study Abroad Students Report” in your subject line.

Report Update: Undergraduate Eligible to Register (Major/Minor Filter)

The Report Prioritization Group released an update to the Undergraduate Eligible to Register. This post summarizes those changes.

Change Summary:

    • The Major / Minor report  filter now list values for students Major and Minor.

Questions?

If you have questions about “Major” or “Minor” fields 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: Undergraduate Eligible to Register” in the subject line.

Report Update: Student Grade Report by Major (Gender Filter)

The Report Prioritization Group released an update to the Student Grade Report by Major. This post summarizes those changes.

Change Summary:

  • “Gender” Filter updated with an option to display blank values to:
    • include students who do not have a value in a gender field, i.e. it is blank
    • and to be consistent with other reports that have an option of a blank value

Questions?

If you have questions about “Gender” field 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: Current Student Information by Major” in the subject line.

Report Update: All Applications

The Report Prioritization Group released an update to the All Applications. This post summarizes those changes.

Change Summary:

    • SAT – a student’s SAT Scores are displayed in the report regardless of when they completed the test.
    • Last Institution Name – The applicant’s valid last institution name displays regardless of whether it was a high school, or other type of institution.
    • Other Email – The “other email” Columns to Display field label is updated to read “External Email” to be consistent with other Academic Reports.
    • Advising Type and Date fields are added by request from UW Bothell.
      • Advising Date – date assigned for student to attend new student orientation.
      • Advising type – all confirmed in-coming new students (FTFY and Transfer) are required to sign up for an orientation/advising. “Session Type” new student orientation D = DAY ONLY O = OVERNIGHT C = COMMUTER (NOT USED)

Questions?

If you have questions about the meaning of Advising Date or any other terms used in the report, please find more detail in the Knowledge Navigator.

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

Report Replacement: Learning Spaces Policy (previously known as Total Class Utilization by Hour)

The Report Prioritization Group released a new report, the Learning Spaces Policy report (Access to B.I. Portal report requires access to EDW and it is limited to Time Schedule coordinators.) This report replaces the Total Classroom Utilization by Hour report.

The Learning Spaces Policy report is intended to be used by time schedule coordinators to comply with the Learning Spaces Policy. Although the policy only applies to the Seattle campus, Tacoma and Bothell course distribution data is included. The chart and reference lines are intended to help time schedule coordinators to see when course distribution is out of alignment with the policy.

The Total Class Utilization by Hour report will be decommissioned from BI Portal on June 26, 2019.

Change Summary:

  • The report was redeveloped to correctly handle curricular joints and ad hoc joints ‘withers’.
  • The report also removes courses that are responsible by another scheduling unit.
  • A bug in the old report is being addressed in the new report where classrooms scheduled after 2:30 pm were not being counted.
  • The performance of the main dataset query has been greatly improved. The old query took more than 15 minutes to run with 2 curriculum abbrs. The new report can run the entire college of arts and sciences in 2 minutes.
  • A table with time blocks, primary instructors, SLN, courses and classroom locations has been added.

Questions?

If you have questions about the new report please write to help@uw.edu, and put “RPG: Learning Spaces Policy” in the subject line.

Report Update: Student Grade Report by Major (Intended Major Filter)

The Report Prioritization Group released an update to the Student Grade Report by Major. This post summarizes those changes.

Change Summary:

  • “Include Intended Major” Filter added: by request from UW Bothell and UW Tacoma, a filter was added to allow you to include/exclude students that have listed the selected major as an “intended major”. The filter has a Yes and No Option:
    • Yes = Returns “pending” and “real” majors and also includes students that have listed “intended” and “requested majors” for the selected major.
    • No = Only returns students with majors in “pending” status and “real” majors (a student that is already in a given major). (This is the default selection)

Questions?

If you have questions about the meaning of intended major, pending major, or major requested, 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: Current Student Information by Major” in the subject line.

Report Update: Current Student Information By Major (Intended Major Filter)

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

Change Summary:

  • “Include Intended Major” Filter added: by request from UW Bothell and UW Tacoma, a filter was added to allow users to include/exclude students that have listed the user’s selected major as an “intended major”. The filter has a Yes and No Option:
    • Yes = Returns “pending” and “real” majors and also includes students that have listed the selected major as an “intended” or “requested major”.
    • No = Only returns students with majors in “pending” status and “real” majors (a student that is already in a given major). (This is the default selection)

What’s Next:

Questions?

If you have questions about the meaning of intended major, pending major, or major requested, 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: Current Student Information by Major” in the subject line.

 

Report Update: Student Degree Information

The Report Prioritization Group released two updates to the Student Degree Information Report. This post summarizes those changes.

Change Summary:

  • Bug Fix: There was a bug in the report code that was causing valid majors to be excluded from the majors dropdown. This bug has been resolved.
  • First Generation Attributes added: by request two new student attributes have been added to the report:

FirstGenAttributes

To include these columns in the report, simply select them from the “columns to display” dropdown menu.

Questions?

If you have questions about the differences between these two First Generation Student definitions, 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 Report” in the subject line.

Report Update: Student Degree Information

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

Change Summary:

Based on user feedback, we added 2 new data elements to the report:

To include these columns in the report, simply select them from the “columns to display” dropdown menu.

Questions?

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

 

Report Update: Class List By Curriculum Course Section

The Report Prioritization Group released important updates to the Class List By Curriculum Course Section Report. This post summarizes those changes.

Change Summary:

Based on user feedback, we:

1. Added a new column to the report to display a student’s “historical class standing“:

  • Before this change, when you selected “Class” from the “Columns to Display” dropdown, the report displayed a student’s current class standing in the “Class” column.
  • After this change the report continues to display a student’s current class standing. We updated to label to now be called “Current Class”.
  • The report now also displays a column titled “Selected Qtr Class” that displays the student’s class standing for the quarter parameter(s) that you selected.

Params

ReportOutput

2. Bug Fix:

  • This update also included a fix to a bug reported by several users. When users ran the report for some curriculums across multiple quarters, the report would error out.
  • This issue has been resolved.

Questions?

If you have any questions, please write help@uw.edu and put “RPG: Undergraduates Eligible to Register Report” in the subject line.