Page Comparison

Insert excerpt

	_DraftNote
	_DraftNote
nopanel	true

...

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:

...

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.

...

The navigation for each of the reports is similar, with a data panel in the main workspace work area and filter panels on the top and left side to help users narrow down the data in tables.

...

Filters are listed on both the top and left side panels of the report. Click the down arrow to select from options in the filters and narrow down your results.

...

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 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 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 . 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 record row in the table to highlight (select the item. Select it again to return to view all contents)the full table view.

The next sections are broken down by individual report and includes links to the definitions in the Report Elements Glossary Table.

Report: Course Demand - College Scheduler Details

The Course Demand - College Schedule Scheduler Details report identifies 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.

See Filters and Report Elements below to view the fields included in this tablein the table are shown here; click on any element 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. See Report Elements below to view the fields included in this tableData 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.

Filters and Report Elements in the table are shown here; click on any element 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 .

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.

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 lists 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 #

Last Enrolled TernTerm

Report: Course Demand - Section Level

The Course Demand - Section Level report shows 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

...

This report shows all information above except “number of sections” and with the addition of “Section Names” and “Section Types”.

See Report Elements below to view the fields included in this table.

Filters and Report Elements in the table are shown here; click on any element item to link to the Report Elements Glossary Table for detailed descriptions.

Filters

Report Elements

...

Anchor

	Report Elements Glossary
	Report Elements Glossary

...

Interest CRETE ->DIMDGWSTUDENT->PERSONNAMELAST

Element

Source

(System->Table->Column)

Description

Frequency of Update

Anchor

	Number Sections
	Number Sections

# of Sections

BANNER->SSBSECT->SSBSECT_SEQ_NUMB

Count of SSBSECT_SEQ_NUMB

Live

Anchor

	Campus
	Campus

Campus

BANNER->SSBSECT->SSBSECT_CAMP_CODE

Identifies the campus of the student or where the course is being taught.

Live

Anchor

	Cohort
	Cohort

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.

Anchor

	College
	College

College

BANNER->SCBCRSE->SCBCRSE_COLL_CODE

College that is funding the course.

Anchor

	Conc1
	Conc1

Concentration 1

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1

Concentration

Anchor

	Conc2
	Conc2

Concentration 2

BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2

Concentration

Anchor

	Course Attributes
	Course Attributes

Course Attributes

BANNER->SCRATTR->SCRATTR_ATTR_CODE

Course level attributes from Banner.

Live

Anchor

	Course Number
	Course Number

Course Number

BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB

BANNER->SSBSECT->SSBSECT_CRSE_NUMB

The code that includes the level of a course assigned to identify the course in a systematic manner.

Anchor

	Course Prefix
	Course Prefix

Course Prefix

BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE

BANNER->SSBSECT->SSBSECT_SUBJ_CODE

The alpha abbreviation assigned to a course by Common Course Numbering.

Anchor

	Course Section
	Course Section

Anchor

	Section Number
	Section Number

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.

Anchor

	Course Session
	Course Session

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.

Anchor

	Course Title
	Course Title

Course Title

BANNER->SCBCRSE_TITLE

Course title.

Anchor

	Current Enrollment
	Current Enrollment

Current Enrollment

BANNER->SSBSECT->SSBSECT_ENRL

Current student enrollment, updated regularly when registration is open.

Anchor

	Delivery Method
	Delivery Method

Delivery Method

SID_Instructional_Activity->delivery_method_ind

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.

Anchor

	Degree App Status
	Degree App Status

Degree App Status

BANNER->SHRDGMR->SHRDGMR_DEGS_CODE

Anchor

	Degree App Term
	Degree App Term

Degree App Term

BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD

Anchor

	Degree Status
	Degree Status

Degree Status

BANNER->SHRDGMR->SHRDGMR_DEGS_CODE

Flag indicating the status of the student's application toward his or her degree:

AP - Applied
AW - Awarded
DE - Denied
SO - Sought

Anchor

	Degree Type
	Degree Type

Degree Type

CRETE ->DIMDGWSTUDENT>DGW_DEGREE

Anchor

	Department
	Department

Department

BANNER->SGBSTDN->SGBSTDN_DEPT_CODE

Department that is funding the course.

Anchor

	DGW Overall %
	DGW Overall %

DGW Overall %

CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE

Anchor

	DGW Req Comp %
	DGW Req Comp %

DGW Req Comp %

CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE

Anchor

	DGW Requirements
	DGW Requirements

DGW Requirements

CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS

Anchor

	Email
	Email

Email

CRETE ->DIMDGWSTUDENT>EMAIL

Anchor

	First Name
	First Name

First Name

CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST

Anchor

	Year 1
	Year 1

Enrollment # Year-1