Degrees by Multiple Fields Report

This report provides access to a customizable table of degree counts, by academic year, degree level, and campus unit.

Prompts

Use the prompts to filter data by Academic Year, College/School, Department, Entry Status, Degree Level, Division, and/or Major.

Degrees by Multiple Fields prompts

Select Report Fields

This report is initially populated with four columns, three for ethnicity and one for gender. When you generate the report, you can select any of the fields with demographic information in the drop-down list.

Select Fields 1-4 as presented above reports with multiple fields 

In addition to ethnicity and gender, you can select any of these columns. We describe the frequently used and less intuitive columns here. The Wiki data dictionary has descriptions of all columns.

  • There are 16 unique values for self-reported ethnicity data for students. These values roll up into a nine-value summary and a four-value summary. See Ethnicity in Student Data Dashboards for a chart showing the values in each of the three columns: Ucb Level1 Ethnic Rollup Desc, Ucb Level2 Ethnic Rollup Desc, and Short Ethnic Desc.

  • Gender
  • Entry Status Desc: for undergrads, choices include new freshman and advanced standing for transfer students
  • Derived Residency Desc: Description indicating official residency status from Campus Solutions regardless of whether the student pays in-state tuition or Nonresident Supplemental Tuition. Values include: CA Resident, Out of State Domestic, International, and Unknown.
  • Reporting Clg School Short Nm
  • Academic Division Short Nm
  • Academic Department Short Nm
  • Major Short Nm
  • Degree Desc

Customize the Report

You can include additional columns as desired and exclude columns as well to suit your reporting needs. See the Student Demographics Report Data Dictionary for definitions of the fields in the prompts and report. See the Customize Reports chapter in the Cal Answers Basic Navigation course for instructions on including, excluding, moving and sorting columns.

Data Views

You can choose to display either degree recipient headcounts or a prorated count of degrees awarded, by either academic year or semester. See Degrees Earned Dashboard for a description of how proration works in this dashboard.

Sample Question and Answer

How many Native American/Alaska Native, nonresident undergraduate women in the College of Engineering earned a degree in the 2019-20 academic year?

Make the following selections in the prompts and Apply:

  • Academic Year: 2019-20
  • College/School: Clg of Engineering
  • Degree Level: Bachelor

Degree Counts by Multiple Fields prompts with 2019-20 and Clg of Engineering selected 

We can find women with the Gender field and the Native American/Alaska Native with the Short Ethnic Desc field. To find the nonresidents, we will need to change one of the selected fields to Derived Residency Desc.

Multiple Fields with Derived Residency Desc selected for Field 2 

We don’t need the Ucb Level1 Ethnic Rollup Desc, so let’s exclude that column from the report. Right-click on the column heading and select Exclude column from the context sensitive menu.

Report column context sensitive menu with Exclude column highlighted 

We can filter the report data to make it easier to find our answer by moving columns to prompts and then selecting just the values we are interested in. Right-click on the Short Ethnic Desc column heading and select Move column / To prompts. Then select Native American/Alaska Native from the drop-down list.

 Degrees by Multiple Fields report with Short Ethnic Desc in prompt

Now it is easy to see that there was one Native American/Alaska Native woman non-resident that earned a Bachelor’s degree from the College of Engineering in 2019-20.