August 29, 2012

Fall Cleaning of Academic Reports

By Matt Saavedra

The Enterprise Data Warehouse (EDW) provides access to many different online reports for UW Staff. Online reports include information on registration, transcript detail, time schedule, student counts by department, and much more. Currently, 30 Academic Reports are available on EDW for use by business analysts and other university staff.

I know I saw that report somewhere...

The Office of the Registrar has begun the process of enhancing descriptions and titles of each report to make it easier for you to find the information you are looking for. New report names and descriptions will be applied by the end of Fall quarter 2012. Some report names have not been changed.

If you are having difficulty locating a report, let us know by contacting Randy Byers.

Report names and descriptions can be located on the UWIT Decision Support Report Catalog.

View updated names and descriptions in the table below.

Old/Existing NameNew NameOld DescriptionNew Description
Class List By Curriculum Course Section (ACAD1034)n/a For the selected year/quarter, this list displays students who are either registered or have withdrawn from the course/section, depending on the user selections made.Current roster of registered or no longer registered students for each course by curriculum, course and section. Useful to view satisfactory progress issues, managing curriculum, determining course overload issues. This report does not include grade information. Required selection criteria: Year, quarter, college, dept, curriculum, course no, course section.
Student Transcript Detail (ACAD1013)n/aThis report displays UW transcript detail information for a single student. Data can be displayed for all courses taken or for an individually selectable subset. Data are sortable by clicking on the column heading. The information in the report is up to 24 hours old and is typically refreshed nightly.UW transcript information for an individual student. Lists all transcript information for a student. Useful for reviewing student academic progress, displays snapshot of complete student record. Excludes transfer credits. Required selection criteria: Student number.
Current Student Information (ACAD1026)Current Student Information by MajorThis report allows users to view, filter and sort on a variety of information about students registered for the current* quarter. Users can filter on college, department, major, gender, class, residency, NCR status, ethnicity and underrepresented status, and can also choose which columns to display and whether the report renders with full report details or in a raw data version for export into Excel. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Creates a roster of currently registered students with contact information for a specific major. Displays student demographic information, majors, and GPAs for.... Required selection criteria: college, dept, major
Student Degree Information (ACAD1028)n/aDisplays students who have applied for and/or been granted a degree and their contact information. Report filters include degree quarter, college, department, degree, status and various demograhic information. Quarters available include the current quarter, any future quarter in which a degree application exists, and the 4 quarters preceding the current quarter. Users can select which columns of data appear on the report. Note: The contact information may be stale for records from prior quarters. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Creates a roster of students who have applied for and/or been granted a degree for one or more years or quarters. Displays contact information, demographics, and performance indicators. Required selection criteria: quarter, college, dept, degree.
Time Schedule Courses, Meetings, Instructors (ACAD1033)Time Schedule - ComprehensiveDisplays course information in a particular curriculum by quarter and year. Report filters include course number, instructor, section, and various parameters related to course offerings including meeting time and day, credits, room assignment, enrollment and meeting type. Users can select which columns of data appear on the report. Note: Instructor data is not sortable by type, such as faculty, graduate student, instructor, but includes all personnel attached to a particular curriculum Note: Data includes all meetings for one course. An example is a lecture with quiz or lab sections. All meetings will be listed as separate entries.This report displays time schedule, meeting and instructor data for selected quarters, curricula, instructors, courses and sections. Useful for planning next year's courses. Required parameters are Quarter, College, Department, Curriculum, Instructor, Course Number, and Section.
How Many Students Do I Have (ACAD1007)Department Headcount TrendThis report displays the unduplicated count of students registered for credit on Census Day. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day.This report displays the unduplicated count of students registered for credit on Census Day by department. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day. Required selection criteria: quarter, college, department
Current Student Minor Information (ACAD1029)n/aThis report displays current* students holding the selected minor(s). The departments visible in the drop down selection box are limited to those currently or ever having offered minors. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Creates a roster of currently registered students with contact information for a specific minor. Displays student demographic information, majors, and academic information. Required selection criteria: college, dept, minor.
Current Student Transcript Courses (ACAD1027)n/aThis report allows users to view, filter and sort transcript, transfer and extension courses for students registered for the current* quarter. Users can filter students on college, department, major, gender, class, residency, NCR status, ethnicity and underrepresented status, and can also choose which columns to display and whether the report renders with full report details or in a raw data version for export into Excel. Users can also filter courses by type. For transcript summary information for a specific student, click on the student's name. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Displays transcript information for all students in a selected major. Useful for satisfactory progress and tracking progress in a major. Required parameters include: college, department, major.
Contact Information - Majors (ACAD1015)Email Contact Information by MajorThis report provide contact information for all students who are registered for credit in a given year/quarter and who have a given major. The user may select the year/quarter and the major. Contact information include local and permanent mailing addresses and phone numbers as well as email address. A clear notation is made of those students who have placed a FERPA block on their recordsThis report provides an email address for all students registered for a selected quarter who have a selected major. Useful for creating email lists. Required parameters include: year, quarter, and major
Current Student Registration Courses (ACAD1030)n/aThis report allows users to view, filter and sort registration courses for students registered for the current* quarter. Users can filter on college, department, major, gender, class, residency, NCR status, ethnicity and underrepresented status, and can also choose which columns to display and whether the report renders with full report details or in a raw data version for export into Excel. For transcript summary information for a specific student, click on the student's name. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Displays current registration information for all students in a selected major. Useful for tracking majors and satisfactory progress . Required parameters include: quarter, college, department
How Many Students Do I Have (ACAD1008)Count of Students by Department and MajorThis report displays the unduplicated count of students registered for credit on Census Day, sorted by Major within the selected Department. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day. The blue header displays the major name, major code and pathway, and the number of students falling into that class group (Undergraduate, Graduate, Professional or Non-Matriculated). Click on the + symbol to display the list of students.This report displays the unduplicated count of students registered on Census Day, sorted by Major within the selected Department. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day for that quarter. Required selection criteria include: Year, Quarter, Collge, Department
Current Student Transcript Quarterly Summary (ACAD1031)n/aThis report allows users to view, filter and sort quarterly transcript summary information for students registered for the current* quarter. Users can filter students on college, department, major, gender, class, residency, NCR status, ethnicity and underrepresented status, and can also choose which columns to display and whether the report renders with full report details or in a raw data version for export into Excel. For transcript detail information for a specific student, click on the student's name. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.This report displays quarterly transcript summary information for students in a selected major for a selected quarter. Useful for tracking quarterly progress, and you can click through to full transcript information for an individual student. Required parameters are Quarter, College, Department, and Major.
Degree Codes (ACAD1021)n/aThis report contains information about degree codes. Unique degrees are identified by campus code, college code, degree major abbreviation, pathway, level, and type.The report displays information about degree codes for selected departments. Useful for finding a code when filling out a change of major form or filing a graduation application, or for looking up a degree's tuition category. Required parameters are College and Department.
Undergraduate Degree Applicants (ACAD1012)n/aThis report displays students who have an active degree application with a major in the specified department. Information on this list is sortable by clicking on the column heading. The information in the report is up to 24 hours old and is typically refreshed nightly.Creates a roster of undergraduate students within a selected department who have filed a graduation application for an upcoming quarter. Useful for monitoring graduation applications and for creating e-mail lists to contact graduating students. Required parameters are College and Department.
How Many Students Do I Have (ACAD1001)College Headcount TrendThis report displays the unduplicated count of students registered for credit on Census Day having a major that belongs to the respective college/school. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day.This report displays the unduplicated count of students registered for credit on Census Day having a major that belongs to the respective college/school. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day. Required selection criteria include: quarter, college
How Many Degrees Have I Granted (ACAD1016)Degrees Granted by CollegeThis report displays the count of degrees granted by a school or college over the past ten completed academic years. Degrees are aggregated by level.This report displays the count of degrees granted within a College or School for the past ten years. Useful for trend analysis in graduation rates. Required parameter is College.
Contact Information - Unmet Requests (ACAD1017)n/aThis report provide contact information for all students who have attempted to register for a selected course in a specified year/quarter and been denied for lack of space. The user may select the year/quarter, the curriculum and the course number . Contact information include local and permanent mailing addresses and phone numbers as well as email address. A clear notation is made of those students who have placed a FERPA block on their recordsThis report provides contact information for all students who have attempted to register for a specified course and been denied for lack of space. Useful for contacting students when new sections are opened. Required parameters are Curriculum and Course Number.
Current Student Transfer Summary (ACAD1032)n/aThis report allows users to view, filter and sort quarterly transfer summary information for students registered for the current* quarter. Users can filter students on college, department, major, gender, class, residency, NCR status, ethnicity and underrepresented status, and can also choose which columns to display and whether the report renders with full report details or in a raw data version for export into Excel. For transcript detail information for a specific student, click on the student's name. * For a given quarter, current is defined as the day prior to the start of a quarter through the Thursday prior to the start of the subsequent quarter. Note: This report is not designed to facilitate large data extracts. Large selections will generate slowly, and may fail on export attempt. Contact the Academic Data Management Office at reptreq@u.washington.edu should you need assistance.Creates a roster of currently-registered transfer students within a selected major and provides a summary of information about the students' prior schools. Useful for a quick overview of prior academic work, and also allows access to full transcript details for individual students. Required parameters are College, Department, and Major.
Curriculum Codes (ACAD1045)n/aThis report displays curriculum codes for specified departments.The report displays information about curriculum codes for selected departments. Useful for seeing what curricula are controlled by a department or for seeing what CIP code is associated with a curriculum. Required parameters are College and Department.
How Many Credit Hours Are Being Taught (ACAD1005)Credit Hours by CollegeThis report displays the number of credit hours taught by quarter by college for the last 10 years. Only those credits actually instructed are included and credits hours that were otherwise dropped or cancelled are excluded.This report displays the number of credit hours taught by quarter by college for the last ten years. Useful for trend analysis. Required parameters are Quarter and College.
How Many Students Do I Have (ACAD1003)All University Headcount TrendThis report displays the unduplicated count of students registered for credit on Census Day. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day.This report displays the unduplicated count of students at the University of Washington (all campuses) registered for credit on Census Day. Excluded from these counts are foreign study students, on leave students, and students who register for the first time after Census Day. Required selection criteria: quarter
Major Codes (ACAD1039)n/aThis report shows the valid major codes for a specified department or group of departments. The Classification of Instructional Programs (CIP) code is a national system for identifying the academic content of the major.The report displays information about major codes for selected departments. Useful for seeing what majors are controlled by a department or finding the CIP code associated with a major. Required parameters are College and Department.
Top Academic Statistics (ACAD1004)n/aThis report displays trends across years. The years included are displayed in blue, directly below this summary on the left side of the page. The two leftmost columns of graphs, Majors and Credits, are reported as of Autumn quarter, Census Day. The right column, Degrees Awarded, reports the total degrees awarded for the academic year running from Summer through Spring quarters.This report displays graphs of headcounts by majors, credit hours instructed and degrees conferred, by college. Useful for trend analysis or comparison between colleges.

Leave a Reply