...
Course Demand Reports
Intro
...
The Course Demand reports provide university-wide course and course scheduling data with continuous updates from Banner. The reports offer a tool that can assist in developing courses and course schedules within and across USF colleges. These reports can be used, for example:
- To assist the Registrar's Office in reviewing the demand for classes by term to ensure the necessary classes are offered and enough seats are available by section.
- To identify students close to completion and view the courses these students have shown interest in taking.
- To identify courses that have had at least one instance of distant learning in the past five years.
Note: Security permissions are set to enable sharing of this data to appropriate users, i.e.,
The information below describes each of the four Course Demand reports , and provides tips on navigation, and identifies common tasks you can use to view the data.
Tip | ||
---|---|---|
| ||
Data are continuously updated to provide real-time information. |
Table of Contents | ||
---|---|---|
|
Report Elements Glossary Table
...
Report: Course Demand - College Scheduler Details
This report
Filter Panel
The left panel allows you to filter the information that displays in the data panel. Select to filter by one or more of the following options:
...
...
Banner Course Attributes |
---|
Banner Course Attributes (Codes and Descriptions)
Overview
The Course Demand reports contain information on university courses, course sections, student degree requirements, and student course selection. The display and navigation for each of the four reports is similar, with a data panel in the main work area and filter panels on the top and left side to help you narrow down the data in tables.
Filter Panels
Filters are listed on both the top and left panels of the report. Click the down arrow to select from options in the filters and narrow down your results.
Notes:
- If you select an item in one filter, the table adjusts immediately. In addition, the selections available in the remaining filters are narrowed down to correspond with the selected filter. For example, if you select Course Prefix = ADV, the Course Numbers selections are only those for Advertising.
- To "deselect" an item, click the option again.
- To select multiples in a filter, hold the Ctrl key as you check the boxes. Note that not all filters allow you to select more than one (Term Code for one).
Data Panel
The panel on the right is the main workspace and consists of five sections. These sections are described in detail below.
Notes:
- The displays for these sections are interactive; that is, if you select a component in one display, the numbers in the other sections adjust accordingly.
- To select an item in the display, click the segment of the pie or bar chart. To return to the full display, click the segment again.
Sample Tasks
The following are a few examples of ways you can view the data as well as explore the interactivity among the elements in the display.
Filters
Report Elements
Emailwork area and each report displays a table showing the filtered results. To work with data in this panel:
- Select a column header to sort by that value, such as Delivery Method or Current Enrollment.
- To export the data to a spreadsheet, click anywhere in the table and click the ellipses (...) in the top right corner. Select Export Data and follow the prompts. Note that different browsers may display different options for opening and saving the resulting spreadsheet.
- Select an individual row in the table to highlight the item. Select it again to return to the full table view.
The next sections break down the individual reports and include links to the definitions in the Report Elements Glossary Table.
Report: Course Demand - College Scheduler Details |
---|
The Course Demand - College Scheduler Details report lists undergraduate students and the courses they expressed interest in scheduling within College Scheduler. This report does not give information on past classes, but shows course selection by student for the term selected in the Filter panel.
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Report Elements
Report: Course Demand - Course Level |
---|
The Course Demand - Course Level report shows current student enrollment at the course level for the term selected. Data show max enrollment for the course as well as the number of interested students. The report also provides metrics for
Filters
Report Elements
Student Appointment Distribution
Currently Enrolled Students With No Appointmentsenrollment information for the five years prior to the current term.
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Report Elements
...
Report: Course Demand - Degree Works |
---|
The Course Demand - Degree Works report provides metrics for .
Filters
Campuslists undergraduate students and their progress toward their degree. The report provides overall progress toward the student's degree as well as progress made toward individual degree requirements, such as Civics Literacy or Foreign Language.
You can use this report for example, to identify students who are close to completing their degree to review the courses they will need to graduate.
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions. .
Filters
Report Elements
Students #
Record #
...
Report: Course Demand - Section Level |
---|
The Course Demand - Section Level report provides metrics for
Filters
Campusshows current student enrollment at the section level for the term selected. Data show max enrollment for the course as well as the number of interested students. The report also provides enrollment information for the five years prior to the current term.
Note that you can drill to College, Department, and Program Name to see courses linked to programs of study in Acalog.
Filters and Report Elements in the table are shown here; click on any item to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Report Elements
...
Anchor | ||||
---|---|---|---|---|
|
Report Elements Glossary Table
...
The table below lists all of the elements used in the Intelligent Communication Course Demand reports.
Note: To sort the table elements, click the up or down arrow in the column header. excerpt-include
...
Element | Source (System->Table->Column) | Description | Frequency of Update |
---|---|---|---|
Anchor | Advisor Appointments | Advisor Appointments | appiandb.AS_appointment ->appointmentid Calculated | The number of appointments for the advisor in the selected date range. | Daily |
Anchor | Advisor College | Advisor College | Advisor Collegeappiandb.AS_unitBookingTreeLogic->levelOneDesc | The advisor's home college. | Daily |
Advisor Email | (SID.HUB_CIMS_CURR_ID_V_Staging -> NETID) + "@usf.edu" | The email address of the advisor. | Daily |
Anchor | Advisor Name | Advisor Name | Crete.FIF_SPRIDEN_Staging -> SPRIDEN_LAST_NAME] + Crete.FIF_SPRIDEN_Staging -> SPRIDEN_FIRST_NAME | The name of the advisor. | Daily | Advisor UID
Anchor | Advisor UID | Advisor UID | appiandb.AS_attendee -> attendeeUId where attendeeTypeRefId = 17 | The advisor's university identification number. | Daily | Appointment Outcome
Anchor | Appointments by Outcome | Appointments by Outcome | appiandb.AS_reference -> displayValue in (20,21,22,23,24) | The result of the advisor appointment. Available values for this field are:
| Daily | Appointment Reason
Anchor | Appointment Reason | Appointment Reason | appiandb.AS_reference -> displayValue in (6,7,8,9,10,11,12,13,14,15) | The reason the student requested the appointment. Available values for this field are:
| Daily | Appointment Status
Anchor | Appointment Status | Appointment Status | appiandb.AS_reference -> displayValue in (18,19,25,26,28,29) | The status of the appointment. Available values for this field are:
The Appointment Status pie chart displays numbers for each of the above appointment statuses based on the filters selected. | Daily | Appointment Type
Anchor | Appointment Type | Appointment Type | appiandb.AS_reference -> displayValue in (typeRefId=1) | Need values (displays in table) | Daily | # Appts
Anchor | Advisor Appts | Advisor Appts | Count of (appiandb.AS_appointment -> appointmentId) where attendeeTypeRefId = 17 | The total number of appointments for this advisor. | Daily | Attendee UID
Anchor | Attendee UID | Attendee UID | appiandb.AS_attendee -> attendeeUId where attendeeTypeRefId = 16 | The appointment attendee is the student attending the appointment with the advisor. | Daily | Avg Daily Appts for Advisor
Anchor | Avg Daily Appts Advisor | Avg Daily Appts Advisor | Calculated: AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment -> appointmentId)) per day | The average number of appointments for all advisors per advisor working day in the selected time period. | Daily | Avg Daily Appts for College
Anchor | Avg Daily Appts College | Avg Daily Appts College | Calculated: | The average number of appointments for advisors within the college. The calculation averages the number of appointments per advisor divided by that advisor's number of working days. | Daily | Campus
Anchor | Campus | Campus | SID.IC_StudentList_Vw -> CampusTitle | The student's or advisor's home campus. | Daily | Capacity
Anchor | Capacity | Capacity | Calculated | Calculated as a percentage, this value represents the average number of appointments divided by the selected Daily Appointment Capacity target. The Daily Appointment Capacity is set by the user with a maximum of 200. | Daily | College
Anchor | College | College | SID. IC_StudentList_Vw -> CollegeTitle | The student's home college. | Daily | Contact Method
Anchor | Contact Method | Contact Method | appiandb.AS_appointment ->formatRefId in (2,3,4,5) | The method used to set up the appointment, such as Phone or Office. | Daily | Count of Appts
Anchor | Count of Appts | Count of Appts | Calculated: DISTINCTCOUNT(appiandb.AS_appointment -> appointmentId) where attendeeTypeRefId = 16 | The number of appointment records for this student. This includes all appointment statuses: Confirmed, Scheduled, Walk-In, Completed, and Canceled. | Daily | Currently Enrolled Students With No Appointments (count)
Anchor | Currently Enrolled | Currently Enrolled | count(SID. IC_StudentList_Vw->UID ) + Count(appiandb.AS_attendee -> attendeeUId where attendeeTypeRefId = 16) where Adviser College != Student college | The number of students who are currently enrolled who do not have a record of an advisor appointment. | Daily | Daily Appointment Capacity
Anchor | Daily Appointment Capacity | Daily Appointment Capacity | CalculatedThe targeted capacity for the number of appointments an advisor holds per day, established by the department and college. The default appointment capacity is set to 100 and can be adjusted by using the slider or by typing in a different value in the field. An upper limit of 200 is hard-coded. | Daily | Date
Anchor | Date | Date | Data Refreshed on this date | The date on which data has been loaded. | Daily | Date Recent Appt
Anchor | Date Recent | Date Recent | appiandb.AS_appointment -> startDate | This date represents the most recent appointment recorded for the student. | Daily | Department
Anchor | Department | Department | appiandb.AS_unitBookingTreeLogic->levelTwoDesc SID. IC_StudentList_Vw -> DepartmentTitle | Department to which the student or advisor belongs. | Daily | FIF Cohort
Anchor | FIF Cohort | FIF Cohort | Crete.IC_StudentList_Vw.FIFCohort -> | The Finish in Four (FIF) cohort to which the student belongs. | Daily | First Name
Anchor | First Name | First Name | SID.IC_StudentList_VwNAME_FIRST | The first name of the student. | Daily | Full Name
Anchor | Full Name | Full Name | SID.IC_StudentList_Vw.NAME_LAST + SID.IC_StudentList_VwNAME_FIRST | The full name (first name, last name) of the student. | Daily | Last Name
Anchor | Last Name | Last Name | SID.IC_StudentList_Vw.NAME_LAST | The last name of the student. | Daily | Major 1
Anchor | Major1 | Major1 | SID.IC_StudentList_Vw -> MAJORTITLE | The student's major or primary major if double-majoring. | Daily | Major 2
Anchor | Major2 | Major2 | SID.IC_StudentList_Vw -> MAJOR2 | The student's second major, if any. | Daily | Select Date
Anchor | Select Date | Select Date | appiandb.AS_appointment->startDate | The date range of appointments, used to filter the number of appointments to display in the data panel. | Daily | SRKALL Cohort
Anchor | SRKALL Cohort | SRKALL Cohort | SID. IC_StudentList_Vw -> SRKALLCohort | The SRKALL cohort to which a student belongs. | Daily | Student Appointments # Distribution
Anchor | Student Appt Distribution | Student Appt Distribution | DISTINCTCOUNT(IC[appointmentId]) | The distribution of advisor appointments across colleges. | Daily | Student Email
Anchor | Student Email | Student Email | SID. IC_StudentList_Vw -> GOREMAL_EMAIL_ADDRESS | The student's email address. | Daily | Student UID
Anchor | Student UID | Student UID | appiandb.AS_attendee -> attendeeUId where attendeeTypeRefId = 16 | The student's university identification number. | Daily | Total Appts
Anchor | Total Appts Advisor | Total Appts Advisor | Calculated: DISTINCTCOUNT(appiandb.AS_appointment -> appointmentId) where attendeeTypeRefId = 17 | The total number of advisor appointments for the selected date range. When selecting more than one advisor on the Supervisor Summary report, this represents a sum of the selected advisors' appointments. | Daily |
Anchor | Total Appts College | Total Appts College | Calculated: | The total number of appointments for all advisors in the selected college. | Daily | # Working Days
Anchor | Working days | Working days | appiandb.AS_appointment ->startDateTime | Number of days the advisor held advisor appointments. | Daily |
Gallery | ||||
---|---|---|---|---|
|
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | Count of SSBSECT_SEQ_NUMB | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_CAMP_CODE | Identifies the campus of the student or where the course is being taught. | Live | ||||||||||||
| BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | The specific classification for students, established for tracking and reporting. This report uses the following formatting/categorization: FTICYY08 – Full-time first time in college student entering in summer (continuing to fall) or fall semesters. SKRALLYY08 – Full- or part-time first time in college student entering in summer (continuing to fall) or fall semesters. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_COLL_CODE | College that is funding the course. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1 | Student's primary concentration in area of study. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2 | Student's second concentration in area of study. | Live | ||||||||||||
| BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. Click this link to see a full list of these values: | Live | ||||||||||||
| BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB BANNER->SSBSECT->SSBSECT_CRSE_NUMB | The code that includes the level of a course to identify the course in a systematic manner. | Live | ||||||||||||
| BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_PTRM_CODE | An indicator used by the university to uniquely identify a session of less than 10 weeks within a summer term OR less than full term for fall and spring terms. | Live | ||||||||||||
| BANNER->SCBCRSE_TITLE | Title or description of the course. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_INSTM_CODE | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course (AD) - 100% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs) that cannot be completed online can be completed off-campus. Primarily Classroom Learning Course (CL) - Less than 50% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. This designation can include activities that do not occur in a classroom (e.g., exams, internships, practica, clinicals, labs). Hybrid Course (HB) - 50-79% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. Primarily Distance Learning Course (PD) - 80-99% of the direct instruction of the course is delivered using some form of technology where the student and instructor are separated by time, space, or both. All special course components (e.g., exams, internships, practica, clinicals, labs) that cannot be completed online can be completed off-campus. | Live | ||||||||||||
| BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Flag indicating the status of the student's application toward his or her degree:
| Live | ||||||||||||
| BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | The term the student put in an application for his or her degree. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT>DGW_DEGREE | The degree being sought, such as BA or BS. | Weekly | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE | Student's overall completion percentage in satisfying the DegreeWorks credit requirements toward his or her degree, including major, minor, and concentration requirements as well as university requirements. | Weekly | ||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE | The completion percentage by DegreeWorks requirement. , i.e., the student's progress towards completing the individual credit requirements according to catalog hours. | Weekly | ||||||||||||
| CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | The individual DegreeWorks credit requirements, such as Civics Literacy or Credits Outside Major. | Weekly | ||||||||||||
| CRETE ->DIMDGWSTUDENT>EMAIL | The email for the student. | Weekly | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester one year prior for all campuses. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester two years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester three years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester four years prior for all campuses.. | Live | ||||||||||||
| SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester five years prior for all campuses.. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST | First name of the student. | Weekly | ||||||||||||
| CSCHED_REGCART | Number of students interested in taking the course from the College Scheduler tool for undergraduate students. Count of rows for the term_code, crn, pidm in CSCHED_REGCART table. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | The academic term in which the student was last enrolled. The format for this field is YYYYMM. | Weekly | ||||||||||||
| CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | Last name of the student. | Weekly | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | The student's primary major. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | The student's second major. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1 | The student's primary minor. | Live | ||||||||||||
| BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2 | The student's second minor. | Live | ||||||||||||
| BANNER->CSCHED_REGCART->PIDM | The internal identification number of the applicant. | Live | ||||||||||||
| Max Enrollment-Interest Student # | Calculated column = Max Enrollment - Interested Student #. | Live | ||||||||||||
| CRETE->TEMP_COURSEDEMAND->PROGRAMNAME | Name of the college program with which the course is affiliated. | Live | ||||||||||||
| Calculated based on filters. | Number of records showing in the report based on the filters selected. Each student has multiple records representing their selected courses. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_COLL_CODE | A code indicating the college to which this section is assigned. The code is an abbreviation for the college name, for example, ED = Education. | Live | ||||||||||||
| BANNER->SCBCRSE->SCBCRSE_DEPT_CODE | A code indicating the department to which the section is assigned. The code is an abbreviation for the department name, for example, FIN = Finance. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | Live | ||||||||||||
| BANNER->SSBSECT->SSBSECT_SCHD_CODE | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. Options for this field are:
| Live | ||||||||||||
| Calculated based on filters. | Number of students displayed in the table based on the filters selected. | Live | ||||||||||||
| CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | The undergraduate level of the student, with these options: 01 - Freshman | Weekly | ||||||||||||
| BANNER->STVSTYP->STVSTYP_CODE | Classification of student, with these options:
| Live | ||||||||||||
| BANNER->CSCHED_REGCART->TERM_CODE | The academic term in the format: YYYYMM - description. | Live | ||||||||||||
| BANNER->CSCHED_REGCART->STUDENTID | The unique University Identification number of the student. | Live |