| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Course Demand ReportsIntro
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.,
...
Report: Course Demand - College Scheduler Details |
|---|
...
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:
- Term Code:
- Course Prefix:
- Course Number:
- Course Section:
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
EmailThe 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
Report Elements
Student Appointment Distribution
Currently Enrolled Students With No AppointmentsProgram 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 .
Filters
...
Report: Course Demand - Section Level
The Course Demand - Section Level report provides metrics for
Filters
...
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.
...
Source
(System->Table->Column)
...
appiandb.AS_appointment ->appointmentid
Calculated
...
The number of appointments for the advisor in the selected date range.
...
Crete.FIF_SPRIDEN_Staging -> SPRIDEN_LAST_NAME] + Crete.FIF_SPRIDEN_Staging -> SPRIDEN_FIRST_NAME
...
appiandb.AS_reference -> displayValue in
...
The result of the advisor appointment. Available values for this field are:
- Attended
- No Show
- SSP Canceled
- Student Canceled – Fault
- Student Canceled – No fault
- Walk-In
...
appiandb.AS_reference -> displayValue in
...
The reason the student requested the appointment. Available values for this field are:
- Academic Dismissal/Reinstatement
- ACR Petitions
- Career Advising
- Change of Major/Major Re-selection
- Form Completion
- General Advising
- Holds
- Minor & Certificates
- Not Available
- Pre-Orientation/Transfer Advising
- Scheduling/Course Planning/Degree Progression
...
appiandb.AS_reference -> displayValue in (18,19,25,26,28,29)
...
The status of the appointment. Available values for this field are:
- Canceled
- Completed
- Confirmed
- Scheduled
- Walk-In
The Appointment Status pie chart displays numbers for each of the above appointment statuses based on the filters selected.
...
appiandb.AS_reference -> displayValue in
...
Calculated:
...
Calculated:
AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment -> appointmentId)) per College per day
...
SID.IC_StudentList_Vw -> CampusTitle
...
The 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.
...
appiandb.AS_unitBookingTreeLogic->levelTwoDesc
SID. IC_StudentList_Vw -> DepartmentTitle
...
DISTINCTCOUNT(IC[appointmentId])
...
Calculated: DISTINCTCOUNT(appiandb.AS_appointment -> appointmentId) where attendeeTypeRefId = 17
...
Total Appts for College
...
Calculated:
DISTINCTCOUNT(appiandb.AS_appointment -> appointmentId) per College
...
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
...
| Anchor | ||||
|---|---|---|---|---|
|
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.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|---|---|---|
| # of Sections | |||
| Campus | |||
| Cohort | |||
College | College that is funding the course. | ||
| Conc1 | Concentration | ||
| Conc2 | Concentration | ||
| Course Attributes | Course level attributes from Banner. | ||
| Course Number | The code that includes the level of a course and is assigned to identify the course in a systematic manner. | ||
| Course Prefix | The alpha abbreviation assigned to a course by Common Course Numbering. | ||
| Course Section (=Section Number) | A unique identifier assigned by the institution for each section of a course offered during the term reported. | ||
| Course Session | |||
| Course Title | Course title. | ||
| Current Enrollment | Current student enrollment, updated regularly when registration is open. | ||
| Delivery Method | 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 | |||
| Enrollment # Year-1 | Actual enrollment number for the course in the same semester one year prior for all campuses. | ||
| Enrollment # Year-2 | Actual enrollment number for the course in the same semester two years prior for all campuses.. | ||
| Enrollment # Year-3 | Actual enrollment number for the course in the same semester three years prior for all campuses.. | ||
| Enrollment # Year-4 | Actual enrollment number for the course in the same semester four years prior for all campuses.. | ||
| Enrollment # Year-5 | Actual enrollment number for the course in the same semester five years prior for all campuses.. | ||
| Interest Student # | Number of students interested in taking the course from the College Scheduler tool for undergraduate students. | ||
| Last Enrolled Term | |||
| Major | |||
| Major2 | |||
| Max Enrollment | Indicates the total number of available seats in the current semester for all campuses. | ||
| Minor1 | |||
| Minor2 | |||
| Name First | |||
| Name Last | |||
| PIDM | |||
| Potential Deficit | |||
| Program Name | |||
| QM Flag | This flag indicates the course has a Quality Matters or equivalent designation. | ||
| Section College | |||
| Section Department | |||
| Section Number | |||
| Section Type | |||
| Student Level | |||
| Student Type | |||
| Term Code | |||
UID | |||
| Gallery | ||||
|---|---|---|---|---|
|
...