Draft in Progress
The content on this page is still in draft status. Treat with caution...thanks!
Semester Seats Analysis – End of Term Report
This report provide a summary of the number of sections, course section enrollment, seats available and gross SCH by funding campus, college, department and course level. Current numbers are shown in comparison to the previous year end of term numbers.
Data Source: Banner
Refresh schedule: Thrice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.
Semester Seats Analysis – End of Term report has four pages.
- Page 1: Sections by Term Campus College and Level -> Provides a summary of the number of sections, seats filled, seats available and gross SCH by funding campus, college, department and course level.
- Page 2: PTRM Summary View ->Provides the summary numbers by part of term
- Page 3: Course Level Summary View ->Provides the summary numbers by course level
- Page 4: Section Type Summary View ->Provides the summary numbers by section type
Please note: Filters are available on each page to view number by semester, part of term, active/held sections (by default active sections are selected), funding campus and college.
Report Page | Data Element | Data Source | Description |
---|---|---|---|
All | Active/Held Sections | Active sections are the sections currently active. Held sections are those with an (H) and may be opened/activated, if needed. | |
All | Funding Campus | The Funding campus of the course section. (Operating unit from the Chartfield) | |
All | College | Course override college, if it exists, or the college of record, as listed in Banner Catalog. | |
1 | Department | Course override department, if it exists, or the department of record from Banner Catalog. | |
1,3 | Course level | Course Level Definition: UGLL=1000-2999 Courses UGUL=3000-4999 Courses GR1=5000-69999 Courses GR2> 7000 Courses GR3 = Medical sections Placeholder (INTO, Intl Exch, Palazzi, Semester) | |
All | Sections | Count of sections – active or held as filtered. Active sections are selected by default. | |
All | PTRM | Part of the term | |
4 | Section Type | The section type of the course section (i.e., Class Lecture) | |
All | Section Enrl | Number of section enrollments or seats filled | |
All | Seat Avail | Total seats available in the course sections. For the previous year, this category includes sections with enrollment only. Current year numbers include sections with or without enrollment. | |
All | SCH | Total gross student credit hours generated | |
All | Sec Diff | Current year – Previous year numbers | |
All | % Diff | Percentage change over one year difference | |
All | Enrl Diff | Current year – Previous year numbers | |
All | % Enrl Diff | Percentage change over one year difference | |
All | SCH Diff | Current year – Previous year numbers | |
All | % SCH Diff | Percentage change over one year difference | |
All | Avail Diff | Current year – Previous year numbers | |
All | % Avail Diff | Percentage change over one year difference | |
All | %Prev Yr Seats Filled | Section Enrl/Seats Available | |
All | %Curr Yr Seats Filled | Section Enrl/Seats Available |
Filter Panels
Filters are listed on top panel of the report.
Notes:
- Click the down arrow to select from options in the filters and narrow down your results.
- To deselect an item, click on the option again.
- Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons .
- Some filters allow multiple selections. To select multiples in a filter, hold the Ctrl key as you check the square boxes .
- Filters for this report do not have Blank as an option.
Data Panel
This panel displays the filtered results. To work with data in this panel:
- Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
- You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears , you can sort that column in ascending or descending order by clicking on your mouse.
Select a column header to sort by that value, such as College or Department.
Tasks
Export Data to Excel
To export the data results to Excel:
- Hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar will pop up. Click the ellipses in the top right corner of the table display.
The report displays a menu with 'Export data' as a choice: - Select Export Data, then work with the data in Excel. Please be aware that the data in Excel may not look exactly like the screen.
Drill through
To export the data results to Excel:
- All of the pages within this report allow drilling down to the underlying section level data. To do this, right click on a data point and menu will pop up.
- Select drill-though and another window will open up with the details.
Reset to Default
If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image in the Report Header: