% Class Filled is the enrolled student count as a percentage of the enrollment limit for a class (course section).
% Full is a measure of total course demand. It's calculated as ((enrollment + waitlist) / enrollment limit) for each course or class.
% Full Greater Than is a filter that you can use on the Course Demand tab in order to set a lower limit on % Full for the courses that appear in the report.
The "Student Contact" geographic address fields that appear in the Student Curriculum subject area include three fields from the ALL_PP_HIST_D table, in a flattened format: Location_Cd_Id (1-5), Full_Postal_Cd_Id (1-5), and First_Five_Zip_Cd_Id (1-5). We map these fields to the different types of addresses as follows:
Total grade points assigned to students in the class, divided by the number of letter grades awarded.
Avg. Class Size is the average total enrollment count for all the classes (course sections) selected.
This is count of classes taught per actively-teaching instructor. In the Departmental Teaching Workload dashboard this is the ratio of class share to instructor headcount.
This is the number of classes taught by instructors for a credited (or pay) department. It is pro-rated for team teaching, where the class is divided according the number of instructor hours taught per week for each member of the teaching team. In the case of crosslisted and roomshared classes, the bundle of listings is equal to one class so the instructor(s) will receive a fraction of a class for each listing which will total to 1 for the bundle. An instructor associated with the class must be
A Course (e.g., Computer Science 10) is a discrete study unit within a course subject (e.g., Computer Science) offered by an academic unit (e.g., Electrical Engineering & Computer Science). A course is approved by the Academic Senate, but may or may not be offered in a given semester. It can be comprised of different instructional formats (e.g., lecture, discussion, laboratory), with separate class offerings (course sections) for each format type. This field may also be labeled Course Subject N
The Course Control Number (CCN) is a unique identifying number assigned to each class section meeting during a term. Course Control Numbers can be different from term to term for a class section.
A course department is the academic department that offers a given course.
A course division is the academic college, school, or L&S division to which that course rolls up for reporting purposes.
There are three Course Levels: Lower Division (LD) undergraduate, Upper Division (UD) undergraduate, and Graduate (GR). Lower Division courses are meant for freshmen and sophomores and have course numbers ranging from 0-99. Upper Division courses are meant for juniors and seniors and have course numbers in the range 100-199. Graduate courses are meant for graduate students and have course numbers of 200 or higher.
Course Level Detail is a lower-level grouping associated with Course Level. Each Course Level has four associated Course Level Detail groupings, based on course number, as follows:
A course section is an instance of a course. This is sometimes known as a class. While a course can exist in the catalogue without being offered in a given term, if a course section appears in the data it will always have a meeting time, location and instructor. There are different categories of course sections or what we refer to as Offering Types which include primary, secondary, and independent study. There are also different instructional formats for course sections such as lecture, laborato
A Course Subject is an area of study (e.g., Dutch) offered by a Department (e.g., German). In the course academic hierarchy, a Class is an instance of a Course, Courses are organized by Course Subject, and Course Subjects belong to Departments.
Course Title Nm is a short description of the contents of a specific course.
This is the academic department that has received credit for the enrollments, SCH and classes taught by an instructor. While the credited department is typically the pay department of the instructor, the assignment of the teaching activity can be complicated in certain situations. For this reason, the "crediting" or "assignment" of enrollments, classes and SCH by unit follow a well-defined set of allocation rules http://opa.berkeley.edu/algorithms-calculating-teaching-workload-and-course-activit
Cross-listed courses are offered jointly by more than one department. These courses must have identical title, description, instructional format, grading option, units, final exam status, and University and campus requirement status. Prerequisites and restrictions may differ.
This flag indicates when a course is officially cross-listed which means that it is a single course but it is offered jointly by more than one department. A value of “Y” means that the course is cross-listed and a blank value means that it is not. By “officially” cross-listed we mean that the Committee on courses of Instruction (COCI) has approved that the course can be cross-listed. Cross-listed courses have identical title, description, instructional format, grading option, units, final exam s
Course at Capacity Count is the count of classes (course sections) where the Enrolled Student Cnt >= the Enrollment Limit (excluding cases where either value is 0).
Enrollment + Waitlist is a measure of total demand for a course. It's simply the sum of the enrollment and the waitlist counts.
Enrollment Count is a count of the number of seats occupied in a course for a specific term.
Enrollment Cnt Greater Than is a filter that you can use on the Course Demand tab in order to set a lower limit on Enrollment Count for the courses that appear in the report.
Enrollment Limit is the maximum number of students who can be enrolled in a particular class (course section) for a specific semester. This value is set by the department listing the course.
The enrollment share by credited (or pay department) is the sum of class enrollments taught by the instructor that fall under the credited unit, which in most cases is the unit that pays the instructor for teaching the class (prorated for team-teaching), regardless of where the class is listed. The rules we use for handling team-taught classes may result in decimal values in this data. We credit the enrollments for team-taught classes according to the instructor hours per week for each member of
HCM Home Dept is the primary/home department identified for an instructor in the Human Capital Management (HCM) system which is Berkeley’s human resources information system. HCM is used to create and update personnel information and actions for members of the UC Berkeley workforce of employees and affiliates. The HCM Home Dept is the administrative home for the employee’s file. This is not necessarily the department that is paying the instructor for teaching the class, the department that will
Instructional Format indicates the method of instruction used in a class (course section), and by inference the amount of student and faculty participation required.
The instructor function describes the instructor’s role for the class. It distinguishes between an instructor's teaching and administrative duties.
This is a headcount (HC) of instructors that were actively teaching and who's teaching activity is recorded in the Departmental Teaching Workload dashboard.
The average number of hours per week the instructor is teaching the class. This does not include preparation time, office hours, etc. Instructor hours for single instructor classes will be defaulted to the total scheduled hours unless they are greater than 8. If scheduled hours are greater than 8, departments must manually enter instructor hours. Instructor hours for team taught classes will default to the total scheduled hours (unless they are greater than 8) divided by the number of instructor
The name of the instructor teaching a particular class (course section).
A 'Job' is an employee's position in a single Organizational unit (usually a Department or Discipline/Group) with a single job code/title. An employee can change job codes over time (i.e., an Assistant Professor gets promoted to Associate Professor), and can also hold more than one job code simultaneously.
Count of all letter grades awarded in a class.
Offerings Count is the total number of classes (course sections) offered, where Student Enrollment Count is > 0.
There are three Offering Types: primary, secondary, and independent study. Grades and student credit hours are only associated with primary and independent study offerings. Primary sections are regularly-scheduled classes, including lectures, seminars, etc. Secondary sections are always associated with a primary class and include discussions, labs, etc. Independent study classes are student-initiated, individualized, supervised educational activities.
Pct of Instructor Hrs Taught shows the percentage of the class instructor hours per week associated with the instructor. A value of 100% indicates that there is only one instructor teaching the course section/class. A value of less than 100% indicates that the instructor is team-teaching the course section/class.
This is a count of class enrollments by the enrolled student’s major program. For a student with multiple majors, the seat in the class that they are enrolled in is divided or prorated amongst their affiliated major programs. For example the enrollment seat in a Math 1A class that is taken by a student who is a double major in Applied Mathematics and Physics will count as an enrollment of .5 Math and .5 Physics. When Math looks at their course offerings and wants to know how many of the student
Prorated Instructor Enrollment Cnt is the course enrollment count that we associate with the instructor for that course and that we prorate for team-teaching. The proration of the enrollment count for a course is based on the instructor hours per week for each member of the teaching team. For example, if there is only one instructor for the course, this metric will associate all of the enrollments in that course with the single instructor. However, if a course has a total of 3 instructor hours p
Prorated Instructor SCH Nbr is the number of student credit hours for a course that we associate with the instructor for that course and that we prorate for team-teaching. Because individual students can take some classes for differing credit, Student Credit Hours (SCH) is the sum of each enrolled student's units. This SCH Number for a given class is prorated for team-teaching and the proration is based on the instructor hours per week for each member of the teaching team for the course. For exa
Rejected Student Count tells you how many students tried to get into a class, but were not allowed to enroll because they did not meet requirements, or the class was full, among other possible reasons. It is not a count of all the unsuccessful attempts to register per student. Instead, it is an unduplicated count of students who were rejected for the given class, as of the given snapshot week.
The roomshare bundle id number is generated by Cal Answers and is only unique to a semester. This ID allows Cal Answers to use the same ID to tag listings in the same cross-listed or roomshared bundle so that the the system can support reporting by bundle as well as individual listings. All classes are tagged with this ID. In the case of classes that are not crosslisted or roomshared, this ID is the same as the class CCN. For cross-listed and roomshared bundles this ID will be a number different
Roomshared classes occur at the same place, day and time as another class section in a given semester. Cal Answers checks all class sections in a given semester to identify roomshared classes. Cal Answers does not consider studios, clinics, or labs to be roomshared unless they have been designated as cross-listed by the academic senate. Roomshared classes are sometimes referred to as "unofficial cross-listed courses".
The student credit hours (SCH) share by instructor pay unit metric is defined as the sum of credit hours for all students enrolled in a class (e.g., fifty enrollments in a two-unit course generate 100 student credit hours). This SCH data falls under the unit that pays the instructor of the course (prorated for team-teaching), regardless of where the course is listed. The rules we use for handling team-taught classes may result in decimal values in this data. We credit the SCH for team-taught cla
Session Nbr indicates the specific Summer session to which data belongs, such as "6W1" (first 6-week session) or "8W" (8-week session). Note that in Fall and Spring terms, this field always has the values "8" and "2" (from the SIS source system), respectively.
Snapshot refers to a particular point in time at which Cal Answers extracted data from the source system. "CEN" is the census snapshot that happens every Fall and Spring semester on the 25th day of instruction (10th day of instruction for Summer sessions), which is also the deadline for undergraduates to add/drop classes. At the census, most enrollment activity has frozen for the remainder of the semester (with the exception of graduate students, who are able to drop classes up to the final da
Student credit hours are the total number of credits that are earned by the students enrolled in a class. Because individual students can take some classes for differing credit, this value is the sum of each enrolled student's units, rather than simply the product of enrolled students x units. For instance, a variable-unit class with three students enrolled for 1 unit, 3 units, and 3 units, would generate a total of 7 student credit hours.
Waitlist Count is the number of students on the waitlist for a class.
Waitlist Limit is the maximum number of students that can be on the waitlist for a class.
Year & Semester is the combination of Academic Year and Semester Name. These may be displayed as two different fields or as a single, combined one. Valid Semester Names are Summer, Fall, and Spring, which together make up an Academic Year. Summer is the first semester in an Academic Year, followed by a Fall and Spring (e.g., Summer 2010, Fall 2010, and Spring 2011 comprise the 2010-2011 Academic Year).