| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Course Demand Reports
Intro here: To provide information about “courses” as well as “sections within courses”, with continuous Banner updates. tools The Course Demand reports provide university-wide course data with continuous updates from Banner. The reports offer a tool that can assist in the development of developing courses and course schedules within and across colleges and campuses
As a member of the registrar's office I would like to find out the demand for summer classes and other terms based so that we can offer the necessary classes to the students
help registrar's office make decisions regarding course offerings in summer and upcoming terms using data from Banner, DegreeWorks and Course Scheduler.
...
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 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 TableGeneral Intro
...
The navigation for each of the reports is similar, with a data panel in the main workspace and filter panels on the top and left side to help narrow down the data in tables.
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.
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 shown 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 work area and 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, and select Export Data.
- Select an individual record to highlight (select it again to view all contents).
Report: Course Demand - College Scheduler Details |
|---|
The Course Demand - College Schedule Details report provides metrics for identifies undergraduate students and the courses they are interested expressed interest in scheduling . 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. This is not for past classes. Doesn't give number of students or number of total records. This report does not give information on past classes.
See Report Elements below to view the fields included in this table; click on any element to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Campus
Cohort
College
...
The Course Demand - Course Level report provides metrics forshows current student enrollment at the course level for the term selected.
See Report Elements below to view the fields included in this table; click on any element to link to the Report Elements Glossary Table for detailed descriptions.
Filters
College
Department
Program Name
...
This is a listing of students with all of their requirements for their degree. Includes total number of students and total number of records.
Lots of filters
See Report Elements below to view the fields included in this table; click on any element to link to the Report Elements Glossary Table for detailed descriptions.
Filters
Campus
Cohort
College
...
The Course Demand - Section Level report provides metrics forshows current student enrollment at the section level for the term selected.
- 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.
See Report Elements below to view the fields included in this table; click on any element to link to the Report Elements Glossary Table for detailed descriptions.
Filters
College
Department
Program Name
...
| 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 | Identifies the campus of the student or where the course is being taught. | Live | |
| Cohort | 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. | ||
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 | 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. | ||
| 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 | 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. | |
| Degree App Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | |||
| Degree App Term | BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | |||
| Degree Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | Flag indicating the status of the student's application toward his or her degree:
| ||
| Degree Type | CRETE ->DIMDGWSTUDENT>DGW_DEGREE | |||
| Department | BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | ||
| DGW Overall % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE | |||
| DGW Req Comp % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE | |||
| DGW Requirements | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | |||
| CRETE ->DIMDGWSTUDENT>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 | CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | |||
| Major | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | |||
| Major2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | |||
| Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | ||
| Minor1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1 | |||
| Minor2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2 | |||
| Name First | CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST | |||
| Name Last | CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | |||
| PIDM | BANNER->CSCHED_REGCART->PIDM | |||
| Potential Deficit | Max Enrollment-Interest Student # | Calculated column | ||
| Program Name | CRETE->TEMP_COURSEDEMAND->PROGRAMNAME | Name of the college program the course is affiliated with. | ||
| 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 | BANNER->SSBSECT->SSBSECT_SCHD_CODE | Classification of student from these options:
| Live | |
| Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | |||
| Student Type | BANNER->STVSTYP->STVSTYP_CODE | |||
| Term Code | BANNER->CSCHED_REGCART->TERM_CODE | Live | ||
UID | BANNER->CSCHED_REGCART->STUDENTID |
...