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.
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.
Below, we describe some of the frequently used and less intuitive columns. 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.
-
Gender
-
Entry Status Desc indicates how a student was admitted to UC Berkeley. The most common entry statuses for undergraduates are "New Freshmen" (students who enter directly from high school) and "Advanced Standing" (students who transfer from other institutions).
-
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 Asian Non-Underrepresented, undergraduate women in the College of Letters & Science that entered as New Freshmen earned a degree in the 2019-20 academic year?
1. Make the following selections in the prompts and Apply:
- Academic Year: 2019-20
- College/School: Clg of Letters & Science
- Entry Status: New Freshmen
- Degree Level: Bachelor
2. The default results provide three levels of ethnicity data and a gender column.
3. We need to filter the results on one level of ethnicity data and gender. Since we do not need Ucb Level2 Ethnic Rollup Desc or Short Ethnic Desc, we can exclude these columns. Move your mouse over the column heading, right-click, and select Exclude column.
4. To answer our question, we need to filter on Ucb Level1 Ethnic Rollup Desc and Gender Desc. To filter on a column in a results set, you can move it to Prompts. Then you may select one value from the drop-down list.
5. Move your mouse to the Gender Desc column heading and right-click.
6. Select Move / To Prompts.
7. Select Woman from the Gender Desc drop-down list above the results set.
8. Now move Ucb Level1 Ethnic Rollup Desc to prompts. (Right-click on the column heading and then select Move / To Prompts from the quick menu.)
9. Select Asian Non-Underrepresented from the Ucb Level1 Ethnic Rollup Desc drop-down list.
Now we can easily see that 910 Asian Non-Underrepresented women who entered the College of Letters & Science as New Freshmen earned Bachelor degrees in the academic year 2019-20.