ALLOCATED STUDENT FTE BY TERM		DEGREES AWARDED
ASSIGNED MAJORS BY TERM		STUDENT CREDIT HOURS BY TERM
COURSE ENROLLMENTS BY TERM		SUMMER ENROLLMENTS AND SCH

Organization and Navigation

Cal Profiles Plus consists of six applications that allow you to view certain academic data in more detail than is available through Cal Profiles. In five of the applications, you can view data on a semester-by-semester basis, while the other (Degrees Awarded) contains data on more degree types than Cal Profiles currently reports. Each Profiles Plus application follows the same general navigation rules:

1. On the first page of each Profiles Plus application, you can choose the semesters (or academic years) and the level of data detail that you want to see.
2. On the next page of each application, you'll see data for each college, school, and Letters & Science division, along with a campus total at the bottom. Because of chart limitations, the college/school/division names that you see are 20-character short names; to see the full name, hover your mouse pointer over the short name. As is the case with each of the following pages, the top of the page contains a set of instructions detailing where you can click and what you'll see.
3. Clicking on a college/school/division name will display data for each of the departments within that unit.
4. In some cases, clicking on a department name will display data for each sub-department within that unit.
5. Finally, some Profiles Plus applications allow you to view even finer levels of detail. As noted above, you'll find in bold blue text at the top of each page instructions for accessing additional detail.

The remainder of this page is a content overview and description of the methods that we use to collect data for each Cal Profiles Plus application. You can click one of the links above or simply scroll down to view this information.

    Allocated Student FTE By Term

Allocated student FTE is a measurement that gives credit for teaching workload to the departments that pay the instructors of courses, regardless of which departments offer the courses. The following provides a description of how we calculate allocated student FTE for inclusion in Cal Profiles Plus.

FTE students are derived from student credit hours -- i.e. the unit values of courses. (Note, however, that the student credit hours data in Cal Profiles Plus appears by course level, while allocated student FTE numbers are calculated by student level.) Undergraduate students must average 15 credit hours per term in order to graduate in eight semesters, so we define their FTE as their credit hours divided by 15. Similarly, we use a divisor of 12 for graduate students not advanced to candidacy. Students advanced to candidacy are counted as 1 FTE each during the first six semesters of their registration, regardless of how many credit hours they take, and as 0 FTE thereafter. The enrollment data employed in these calculations pertains to students who are recorded in the official campus enrollment file, which reflects their classes and credit hours at the end of the fifth week of classes.

In mid-2004, the Vice Provosts for Academic Affairs & Faculty Welfare and Academic Planning & Facilities approved the following business rules for calculating allocated student FTE within the context of reporting teaching activity by instructor rank:

1. For team-taught classes, we split the allocated student FTE equally among all instructors who are actually teaching the class.
2. If the instructor for a class has only one pay department that is a valid academic department, and that pay department matches the course-offering department, then all student FTE for that class goes to the pay/course-offering department. For example, if an instructor is paid by Astronomy and teaches an Astronomy class, all of the student FTE for that class goes to Astronomy.
3. If the instructor for a class has only one pay department that is a valid academic department, and it does not match the course-offering department, then all student FTE for the class goes to the instructor’s pay department. For example, if an instructor is paid by History and teaches a Political Science class, all of the student FTE for that class goes to History.
4. If the instructor for a class has multiple valid academic pay departments, and one of them matches the course-offering department, then all student FTE goes to the pay department that matches the course-offering unit. For example, if an instructor is paid by Civil Engineering and Mechanical Engineering and teaches a Civil Engineering class, all of the student FTE for that class goes to Civil Engineering.
5. If the instructor for a class is not paid by a valid academic department, then all allocated student FTE for the class goes to the course-offering department. For example, if an instructor is paid by the California Institute for Quantitative Biomedical Research and teaches an Integrative Biology class, all of the student FTE for that class goes to Integrative Biology.
6. If the instructor has multiple valid academic pay departments, and the course-offering department doesn’t match any of those pay departments, then we allocate the student FTE among the instructor’s pay departments based on the payroll distributions. For example, if English pays 60% of an instructor’s salary and Comparative Literature pays 40%, and the instructor teaches a Rhetoric class, 60% of the student FTE goes to English and 40% goes to Comparative Literature.

We obtain student credit hour data from the same enrollment file used in the Course Enrollments By Term and Student Credit Hours By Term Profiles Plus applications; the campus Student Information Systems department produces this file. The Class Schedule & Instructional Record (CSIR) system identifies the instructor(s) who teach each class, and the BIS Data Warehouse payroll tables provide us with faculty appointment and pay department data.

On the home page of this application, you can choose:

• Semesters - Any combination of semesters, from Fall 1993 to the present.

You can then view allocated student FTE data at the college/school/division and department levels. By clicking on a detail line you can also view a bar chart of the relevant data. Instructions appear at the top of each page in bold blue text.

    Assigned Majors By Term

Assigned majors are students who initiated registration by the 15th day of classes in a given term and completed that registration by the 25th day of classes. To be counted in a particular major, students must have officially declared that major at the time of the census count. We calculate all assigned major data in Cal Profiles Plus using a student census extract file provided by the Student Information Systems department.

We prorate assigned majors data so that double majors count as .5 in each relevant unit and triple majors count as .33333 in each unit.

On the home page of this application, you can choose from among the following options:

• Semesters - Any combination of semesters, from Fall 1993 to the present.
• Student Level - All students, undergraduate students only, or graduate students only.
• Data Detail - All students, or by class level.

You can then view assigned majors data at the college/school/division, department, and sub-department levels. If you choose Data Detail of "All Students," you can also view bar charts of the data. Instructions appear at the top of each page in bold blue text.

    Course Enrollments By Term

This application displays course enrollments by course level--lower division, upper division, and graduate--for all non-secondary courses (both primary and independent studies courses, including those that are non-unit bearing).

We calculate figures in this application using the official course enrollment files provided by the Student Information Systems department. Course enrollment counts reflect course loads as of the 15th day of classes each term, plus any adds processed through the 25th day of classes.

On the home page of this application, you can choose:

• Semesters - Any combination of semesters, from Spring 1993 to the present.

You can then view course enrollments data at the college/school/division, department, sub-department, course, and course enrollee levels. By clicking on a detail line, you can also view bar charts of the data. Instructions appear at the top of each page in bold blue text.

    Degrees Awarded

This application displays annual degrees awarded figures derived from official degree lists approved by the Berkeley Division of the Academic Senate and maintained by the Office of the Registrar.

We prorate degrees awarded data so that double degrees count as .5 in each relevant unit and triple degrees count as .33333 in each unit. Keep in mind that an academic year consists of a summer, fall, and spring, in that order.

On the home page of this application, you can choose from among the following options:

• Academic Years - Any combination of academic years, from 1993-1994 to the present.
• Degree Type - Any one of four different degree types.

You can then view degrees awarded data at the college/school/division, department, and sub-department levels. You can also view bar charts of the data at the bottom of each page. Instructions appear at the top of each page in bold blue text.

    Student Credit Hours By Term

The student credit hours (SCH) workload measure is defined as the number of enrollments in a class multiplied by the number of units for which a class is taken (e.g., fifty enrollments in a two-unit course generate 100 student credit hours). Like course enrollments, SCH data appears by course level (rather than student level)--lower division, upper division, and graduate--and falls under the unit sponsoring the course.

The rules we use for handling team-taught courses may result in decimal values in this data. We split team-taught classes equally among the instructors teaching them.

We calculate figures in this section using enrollment files provided by Student Information Systems.

On the home page of this application, you can choose:

• Semesters - Any combination of semesters, from Spring 1993 to the present.

You can then view student credit hours data at the college/school/division, department, sub-department, and course levels. By clicking on a detail line, you can also view bar charts of the data. Instructions appear at the top of each page in bold blue text.

    Summer Enrollments and Student Credit Hours

This application displays the course enrollments and student credit hours for the aggregate of all sessions each summer. We calculate figures in this section using a special Summer enrollment file provided by the Student Information Systems department, beginning with Summer 2002.

Unlike the regular terms, Summer course enrollments and student credit hours are summarized by level of student rather than by level of course. When showing the major programs of students enrolled in particular courses, we also differentiate by the students' home institution (Berkeley, Other University of California, and Non-UC).

On the home page of this application, you can choose from among the following options:

• Summer Terms - Any combination of summer academic terms.
• Data Source - Either course enrollments or student credit hours.

You can then view summer course enrollments data at the college/school/division, department, sub-department, course, and course enrollee levels. You can view student credit hours data at the college/school/division, department, sub-department, and course levels. By clicking on a detail line, you can also view bar charts of the data. Instructions appear at the top of each page in bold blue text.