Estimated Units Needed Summary Report

This article covers how to run and interpret the Estimated Units Needed Summary report on the Degree Progress dashboard.

This user guide assumes basic knowledge of Data Warehouse. View the Data Warehouse Basics guides for more information.

What does this report show?

The Estimated Units Needed Summary shows an estimate of the units needed for students to complete their degree.

  • The Business Intelligence dashboard Degree Progress Analysis tool can be used to determine a broad number or ‘population’ that have fulfilled or unfulfilled a specific requirement based on the search criteria determined by the User.
  • The units fulfilled and unfulfilled are an estimate based on search filters pulled from an audit batch process at the beginning and end of a semester and correlate to the Dashboard ‘audit’.  
  • The Business Intelligence dashboard Degree Progress Analysis tool is not used for official Grad Check and is not directly connected to the official ‘Titan Degree Audit’.
  • Advisors are recommended in running a TDA in u.achieve for up to date requirement information if needed on reviewing a specific student.

Estimated Units Needed is the approximate number of units a student must take, to satisfy all degree requirements for the student’s declared degree program. If the student takes a course or courses that can satisfy multiple requirements, then the student can potentially complete all degree requirements with fewer units than the Estimated Units Needed. The formula used for calculating the Estimated Units Needed works for majority of the degree programs. However, there are unique/complex situations where the Estimated Units Needed calculation requires special handling or supplemental rules to be able to provide a sound estimate. The degree programs needing special handling have been identified. There may be ‘special case’ degree programs though that haven’t been recognized yet, as the list of degree requirements/sub-requirements is enormous, which can be modified at any given point in time. If it is observed that the Estimated Units Needed is not accurate, please report the issue to IT Helpdesk helpdesk@fullerton.edu or 657-278-7777.

Accessing the Report

1. Log in to the CSUF Data Warehouse (OBIEE).

2. Click on Dashboards and select Degree Progress.

dashboard selection
  1. Click on the Dashboards menu in the CSUF Data Warehouse.
  2. Select Degree Progress.

3. Click the Estimated Units Needed Summary tab on the Degree Progress dashboard.

Estimated Units Needed Summary selection

Report Overview

By default, the Estimated Units Needed Summary report will show students whose catalog year is 6 years ago for the majors that you have access to view and the remaining requirements to graduate.

When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate.

Above the table is a series of drop-down menus that allow you to change which columns appear and the order in which they appear.

Estimated Units Needed Summary report

Report Filters

The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.

Filter Descriptions
Filter Description
College The Academic college on campus.
Department
The Office or area of Major student is enrolled in.
Major
The subject of study declared by student.
Student ID
Campus Wide Identification (CWID) number of the student.
Current Academic level
The student’s class level (e.g., freshman, sophomore, etc.)
Notes Available
Indicates whether Advisor Notes are available for the student.
URM Grouping Underrepresented/Minority
First Generation The student is first generation to attend college.
Pell Eligibility Flag An indicator that student can be eligible for a financial aid Pell grant.
Cohort Flag
Identifies whether to include Cohort or Non-Cohort students.
Cohort Description
Students grouped together on the basis of who matriculate in the same term under in the same admissions basis category, such as for full-time first-time freshmen or undergraduate transfers.
Enrollment Status
Active enrolled, graduated or non-graduated students.
Enrollment Type
Freshman or Transfer student(s).
Degree Program
Academic Program in a specific discipline
Degree Program Status
Completion status of Degree Program.
Expected Graduation Term
Student’s anticipated graduation term/year.
Service Indicator Code
An Admissions, Records, or Registration code on a file for the student.
Units Earned
Number of completed units
Units Needed
Number of units that are still needed to complete the requirement/sub-requirement.

Reading the Table

When a column contains a hyperlink, you can click on the link for additional detail.

Available Columns
Column
Description
Cohort Description
Students grouped together on the basis of who matriculate in the same term under in the same admissions basis category, such as for full-time first-time freshmen or undergraduate transfers.
Enrollment Type
Freshman or Transfers status for the student.
Latest College
The academic college that the student’s major is currently in.
Latest Major
The academic program and concentration the student is enrolled in.
Enrollment Status
Active enrolled, graduated or non-graduated status for the student.
Current Academic Level
The student’s class level (e.g., freshman, sophomore, etc.)
URM Grouping
Underrepresented/Minority
Notes Available
Indicates whether Advisor Notes are available for the student.
Audit Run Date
Run date of the audit used to extract degree progress data
Expected Graduation Term
Student’s anticipated graduation term/year.
Degree Program
Academic Program in a specific discipline
Courses Current/Future
List of courses that the student is currently enrolled in.
GPA
GPA of all units attempted
Table results section 2
Available Columns
Column
Description
Units Earned
The total number of completed units.
Units Attempted
The total number of enrolled units.
Transfer Units Earned
The total number of units completed from a transfer institution(s).
Units Attempted Future
The total number of planned or in-progress units
Estimated Units Needed
The total number of estimated units still needed to complete degree program
Requirement Completed
The total number of satisfied Degree Program Requirements
Requirement Not Completed
The total number of unsatisfied Degree Program Requirements.
Degree Program Status
Completion status of Degree Program
CERT
Certificate program
Grad Check Stat
Degree Checkout Status
Default
Ignore (internal code)

Viewing Degree Dashboard Audit

The Business Intelligence Degree Dashboard Audit is not used for official Grad Check and is not directly connected to the official ‘Titan Degree Audit’. Advisors are recommended in running a TDA in u.achieve for up to date requirement information if needed on reviewing a specific student.

 

1. If you want to convert to an audit, click on the blue cwid in the left column.

2. Click on the DARS Detail Report pop-up in order to access the student's Titan Degree Audit.

DARS Detail Report

Need More Help?

For technical assistance with the Data Warehouse, please contact the IT Help Desk at helpdesk@fullerton.edu or 657-278-7777.

For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at ittraining@fullerton.edu or 657-278-5647.