Course Demand Reports
To provide information about “courses” as well as “sections within courses”, with continuous Banner updates. tools that can assist in the development of course schedules within and across colleges and campuses
- Features
Note: Security permissions are set to enable sharing of this data to appropriate users, i.e.,
The information below describes each of the Course Demand reports, provides tips on navigation, and identifies common tasks you can use to view the data.
Report Elements Glossary Table
Report: Course Demand - College Scheduler Details |
|---|
The Course Demand - College Schedule Details report provides metrics for students and the courses they are interested in.
It shows the courses that the students have showed interested in signing up for within College Scheduler. Other attributes from Banner like the degree status and the cohort information are available as filters. Also included are the QM flags and program filters to look for specific required courses.
Filters
Campus
Cohort
College
Degree Status
Department
Major
Program Name
Student Type
Term Code
Report Elements
PIDM
UID
Campus
College
Dept
Major1
Conc1
Minor1
Major2
Conc2
Minor2
Degree Status
Course Prefix
Course Number
Section Number
Section Type
Course Session
Course Attributes
Report: Course Demand - Course Level |
|---|
The Course Demand - Course Level report provides metrics for
Filters
College
Department
Program Name
Term Code
Course Prefix
Course Number
Report Elements
Course Prefix
Course Number
Course Title
Delivery Method
QM Flag
Course Attributes
# of Sections
Max Enrollment
Current Enrollment
Interest Student #
Potential Deficit
Enr # Year-1
Enr # Year-2
Enr # Year-3
Enr # Year-4
Enr # Year-5
Report: Course Demand - Degree Works |
|---|
The Course Demand - Degree Works report provides metrics for .
start with the Degree Works report and identify students close to completion and then using this new report to see what courses they want to take. Once identified, the courses can be looked up on the course level and section level reports to ensure enough seats are available. I’m sure you can think of other options as well.
Filters
Campus
Cohort
College
Degree App Status
Department
Major
Report Elements
UID
Name Last
Name First
Last Enrolled Tern
Campus
College
Dept
Major 1
Concentration 1
Minor 1
Major 2
Concentration 2
Minor 2
Degree App Status
Degree App Term
Degree Type
DGW Overall %
DGW Requirements
DGW Req Comp %
Report: Course Demand - Section Level |
|---|
The Course Demand - Section Level report provides metrics for
- Note that you can drill to College, Department, and Program to see courses linked to programs of study in Acalog
This report shows all information above except “number of sections” and with the addition of “Section Names” and “Section Types”.
Filter Panels
Filters are listed on both the top and left side of the report. Click the down arrow to select from options in the filters and narrow down your results.
- The top filters pertain to the university classifications: College, Department, and Program Name.
- The side filters pertain to program specifics, such as term and course number.
Notes:
- If you select an item in one filter, the table adjusts immediately. In addition, the selections available in the remaining filters narrow to show those options that correspond with the selected filter. For example, if you select Course Prefix = ADV, the Course Numbers shown are only those for Advertising.
- To "deselect" an item, click the option again.
- Term Code: Select one term
- Course Prefix: Select one or more Course Prefixes. To select multiples, hold the Ctrl key as you check the boxes.
- Course Number: Select one or more Course Numbers. To select multiples, hold the Ctrl key as you check the boxes.
- Course Section: Select one or more Course Sections. To select multiples, hold the Ctrl key as you check the boxes.
Data Panel
The panel on the right is the main work area and displays a table showing the filtered results.
Notes on how to drill.
Filters
College
Department
Program Name
Term Code
Course Prefix
Course Number
Course Section
Report Elements
Course Prefix
Course Number
Section Number
Section Type
Course Title
Delivery Method
QM Flag
Course Attributes
Course Session
Max Enrollment
Interest Student #
Potential Deficit
Enr # Year-1
Enr # Year-2
Enr # Year-3
Enr # Year-4
Enr # Year-5
Section College
Section Department
Report Elements Glossary Table
The table below lists all of the elements used in the Intelligent Communication reports.
Note: To sort the table elements, click the up or down arrow in the column header.
| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|---|---|---|
| # of Sections | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | Count of SSBSECT_SEQ_NUMB | Live |
| Campus | BANNER->SSBSECT->SSBSECT_CAMP_CODE | ||
| Cohort | BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | ||
College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | College that is funding the course. | |
| Conc1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1 | Concentration | |
| Conc2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2 | Concentration | |
| Course Attributes | BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. | Live |
| Course Number | BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB BANNER->SSBSECT->SSBSECT_CRSE_NUMB | The code that includes the level of a course and is assigned to identify the course in a systematic manner. | |
| Course Prefix | BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | |
| Course Section (=Section Number) | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | |
| Course Session | BANNER->SSBSECT->SSBSECT_PTRM_CODE | ||
| Course Title | BANNER->SCBCRSE_TITLE | Course title. | |
| Current Enrollment | BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | |
| Delivery Method | SID_Instructional_Activity->delivery_method_ind | Online delivery method = AD | |
| Degree App Status | |||
| Degree App Term | |||
| Degree Status | |||
| Degree Type | |||
| Department | Department that is funding the course. | ||
| DGW Overall % | |||
| DGW Req Comp % | |||
| DGW Requirements | |||
| CRETE ->DGWSTUDENT_REQUIREMENTS->EMAIL | |||
| Enrollment # Year-1 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester one year prior for all campuses. | |
| Enrollment # Year-2 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester two years prior for all campuses.. | |
| Enrollment # Year-3 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester three years prior for all campuses.. | |
| Enrollment # Year-4 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester four years prior for all campuses.. | |
| Enrollment # Year-5 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester five years prior for all campuses.. | |
| Interest Student # | 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. | |
| Last Enrolled Term | |||
| Major | |||
| Major2 | |||
| Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | |
| Minor1 | |||
| Minor2 | |||
| Name First | |||
| Name Last | |||
| PIDM | |||
| Potential Deficit | Max Enrollment-Interest Student # | Calculated column | |
| Program Name | |||
| QM Flag | CRETE -> temp_qmcourses | This flag indicates the course has a Quality Matters or equivalent designation. | |
| Section College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | ||
| Section Department | BANNER->SCBCRSE->SCBCRSE_DEPT_CODE | ||
| Section Number | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | ||
| Section Type | |||
| Student Level | |||
| Student Type | |||
| Term Code | |||
UID | |||
Doc Images |
|---|
| There are no images attached to this page. |