IT Connect

Information technology tools and resources at the UW

Archive for month: June, 2019

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.


If you have questions about the new report please write to, 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)


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 and put “RPG: Current Student Information by Major” in the subject line.