Welcome to the Office of Planning & Analysis

At the Office of Planning & Analysis (OPA), our purpose is to create decision support that helps Berkeley better fulfill its teaching, research and public service mission and live up to our campus goal of promoting access and excellence. Our core values that define how we contribute to the campus community include creativity, integrity, collaboration, excellence and stewardship. And our goal is to transform OPA from a standard institutional research office to one of the most trusted, innovative, and influential advisory groups on the campus.

Planning & Analysis Highlights

Super User Brown Bag Lecture: Translating Analysis into Visualizations

9/23/2016 - As part of a continuing series of brown bag lunch lectures, Cal Answers Student Data Super Users joined Andrew Eppig, Institutional Research Analyst, Office of Equity & Inclusion, for a presentation on Translating Analysis into Visualizations. Andrew provided an introduction to picking the best visualization to communicate messages clearly, gave an example one of his visualizations, and presented basic visualization designs that can be done in Excel. Review the PDF of the presentation.

Trends in cost and distance of berkeley student residences

According to the 2014 University of California Undergraduate Experience Survey, ​​88% of undergraduates lived within 2 miles of campus and 84% walk or bike to campus. These numbers are stable from 2011 to 2014. Based on US Census data on areas where undergraduates lived, median rents increased in real dollars from 2011 to 2014. In 2014, students had to live farther from campus to pay the same amount of rent as in 2011. Please see the OPA briefing notes on Where Berkeley students live and Cost and distance of Berkeley student rentals, 2011 and 2014.

using survey data to understand the first year experience

What do new undergraduates report on the Survey of New Students regarding their transition into UC Berkeley, and the resources they feel aided their transition? How do the perspectives of these students change over the course of their first year when examining topics such as the cost of attendance, and campus climate for diversity and inclusion?  Using data from the 2013 Survey of New Students and the 2014 UC Undergraduate Experience Survey, an unprecedented view at changes in the student experience across the first year is examined in this Stay Day conference presentation.

Cal Answers Top Ten Dashboard Tips

3/26/16 - Cal Answers Top Ten Dashboard Tips from our newest OPA Institutional Research Analysts, Audrey Thomas and Malcolm Quon. As they were on-boarding to the team and learning Cal Answers they created a list of tips they wanted to share with the campus Cal Answers community.

Check it out and thank them if you find it helpful


1/26/2016 - We're excited to announce three new dashboard reports in the Student Demographics and Outcomes subject area: Undergraduate Graduation Rates by Multiple Fields, Retention by Multiple Fields, and Time to Degree. These dashboards make it easier to compare student data, find answers to questions about student graduation and retention rates, and see trends. The first two expand on the existing "UG Grad Rates" and "UG Retention" tabs and allow for a more detailed breakdown of the data by different student characteristics simultaneously. The third includes undergraduate time-to-degree data, which is new to Cal Answers and available down to the major level. Watch the new Cal Answers video, Determining Undergraduate Time to Degree, for more information about that new report.


1/25/2016 – OPA actively led, supported, and engaged in the UC Summit on predictive analytics at the Clark Kerr Campus on January 7-8, 2016. Conversations from conference participants (including faculty and representatives from student advising, undergraduate education, educational technology, and institutional planning & analysis from all UC campuses and UCOP) highlighted the use of data and analytics in enrollment, advising, and curriculum management. Discussions also encompassed topics such as data ethics and privacy, data access and standards, and analytic approaches to identifying “at-risk” students and providing interventions. See the Summit Program here.

Berkeley Pell Grant recipient counts decline in 2013-14

11/6/2015 - UC Berkeley experienced a 1% decline in the number of Pell Grants awarded to undergraduates between 2012-13 and 2013-14. While Berkeley had nearly as many Pell recipients as the entire Ivy League combined, Berkeley's 36% of undergraduates receiving Pell Grants is well above the Ivy League's 17%. Among other UC campuses, only UC Santa Barbara (32%) is lower than Berkeley, while Merced (62%) and Riverside (60%) are highest. This is the continuation of a slow but consistent trend; as our selectivity increases the number of Pell students decreases.  Berkeley is committed to remaining a major engine of economic mobility and will continue to find ways to further our commitment to access and equity. Please see the OPA briefing here.


UCUES Data Used to Support UC Berkeley’s African American Initiative

In September 2015, Chancellor Dirks announced a critical initiative to address the underrepresentation of African American students, faculty, and staff at UC Berkeley. Analysis conducted by the Division of Equity & Inclusion and the Office of Planning & Analysis highlighted the need to address campus climate for African Americans, drawing on data from the UC Undergraduate Experience Survey (UCUES) and the UC Campus Climate Survey. These efforts demonstrate how survey data can be used to inform decision-making and advocate for a better experience for all members of the campus community. For more information, see The Intersection of Campus Climate and the Student Experience, The UC Berkeley Campus Climate Survey: From Analysis to Action, and the African American Initiative.