September 5, 2002

EXECUTIVE VICE CHANCELLOR & PROVOST PAUL GRAY,

VICE PROVOST JAN de VRIES,

VICE PROVOST CHRISTINA MASLACH,

VICE PROVOST WILLIAM WEBSTER,

COLLEGE, SCHOOL & DIVISION DEANS,

In the last couple years, the Office of Planning and Analysis (OPA) has focused on making more information accessible via the web. In addition to Cal Profiles, Cal Profiles Plus, Performance Metrics, and the Common Data Set, OPA is posting ad hoc analyses that we believe will be useful to the campus over time. We currently have information on graduation and retention rates, graduate groups, student FTE conversions, and cohort data. These reports are available by clicking on the Analyses and Reports link on the OPA website (http://opa.vcbf.berkeley.edu).

Attached are two new reports on enrollment and Student Credit Hours (SCH) that we are adding to the OPA website. These spreadsheets incorporate data for the Fall 2001 term. The full report at the OPA web site provides data for each term back to 1993, and will be updated as each new semester becomes available. The web site also provides links to download the report to Excel allowing further analysis. Thus, it would be possible to look at trends, express the distributions as percentages or generate graphs of unit enrollment or SCH.

The first report displays course enrollments by the college offering the courses and by the college of the students’ majors. The second report displays SCH by college and by the college of the students’ majors. The enrollment analysis allows a School, College or Division to examine where students who enrolled in their courses were majors. In addition, a unit can determine where their own student majors were enrolled. This type of information has been used to consider the impact among units when planning expanded enrollment. Student credit hours can be translated to student FTE by dividing the SCH by 15 for undergraduates and 12 for graduates.

Each report displays the data by student level (all students, undergraduates only and graduates only). In the enrollment tables, a row of data shows the majors of a unit’s course enrollments. A column of data shows where a unit’s students were enrolled. Similarly in the SCH tables, a row shows a unit’s total credit hours by major, and a column shows how a unit’s student credit hours were dispersed among all units.

For example, in the course enrollment spreadsheet, in the first table (all undergraduates and graduates combined) the row of data for Business shows that the School had a total course enrollment of 7,847. Of the 7,847 students enrolled in Business courses, 6,045 were Business majors, 9 were Chemistry majors, 2 were Education majors, etc.

To see where Business majors took classes that term, read down the column under Business. Business majors produced a total of 7,089 course enrollments. Of the 7,089 course enrollments, 6,045 were in courses offered by Business, 2 were in courses offered by Chemistry, 44 were in courses offered by Education, etc.

Questions about the enclosed data or the full report may be directed to Alan Underwood (alanu@uclink4.berkeley.edu) in the Office of Planning and Analysis.

Sincerely,

Pamela H. Brown

Coordinator of Analytical Studies

cc: Vice Chancellor James A. Hyatt

Executive Director Dennis Hengstler

Analyst Cynthia Schrager

Analyst Alan Underwood

Enclosures