Census by Multiple Fields Report
The Census by Multiple Fields report allows us to slice our census data by multiple demographic factors and academic categories. You can choose to display either headcounts or counts prorated for multiple majors.
Prompts
Use the prompts to filter your report by year and semester, undergrad/grad, college/school, division, department, and major.
Select Report Fields
This report is initially populated with four columns, three for ethnicity and one for gender, in addition to the Student Level field that’s always included. However, when you generate the report, you can use the Select Field drop-down list to select from demographic fields (e.g., Gender, First Gen College), as well as other data fields (e.g., College, Division, Department,or Major affiliation of the student).
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. 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 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).
-
Registrn Elig Status Desc indicates a student's registration eligibility status. Example data values for this field include: New, Continuing, Returning, or Visiting student status.
-
Derived Residency indicates official residency status from Campus Solutions regardless of whether the student pays in-state tuition or Nonresident Supplemental Tuition. Selections include CA Resident, International, Out of State Domestic, and Unknown.
-
Residency Fee Desc shows a student's tuition residency value. For tuition purposes, a student may be considered a California resident or a nonresident. A student may also have a Pending value in this field if they are in the process of determining residency, or an Unknown/blank value if they are in a program that doesn't need to determine residency for tuition purposes.
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
There are six data views that allow you to view the data by count or percentage. You can use actual counts or prorated counts.
-
Headcount Table counts a student as one whole count within each of their respective units, regardless of if they have a single or a multiple major.
-
Prorated Table counts each major as a fraction where the sum of all majors for a student equals 1.00, so a double-major will count each major as 0.5, a triple-major counts each major as 0.3333, and so forth. Note that this proration then sums at higher organizational levels. For example, a Math/Philosophy double major would count as 0.5 in the Math Department and 0.5 in the Philosophy Department, and then as 1 in the College of Letters & Science.
Sample Questions and Answers
How many new undergraduate students paid California resident tuition in Fall 2020?
Select the following prompts and Apply:
- Year & Semester: 2020 Fall
- Undergrad/Grad: U
The report has four columns, but we only need two columns to get our answer: Residency Fee Desc and Registrn Elig Status Des. To simplify the report, we can select Residency Fee Desc for fields 1, 2, and 3, and select Registrn Elig Status Desc for field 4. Now we can easily see that there were 6,631 new undergraduate students who were counted in the Fall 2020 census and assessedCalifornia resident tuition.
Another way to simplify the report is to move the Residency Fee Desc and Registrn Elig Status Desc columns to prompts, so we can select a single value in each of these fields.
