Courses
All credit and non-credit courses are pulled directly from the Banner database by either using the SZMCRSE or SZMECT parameters.
Automating the course listing
Most course listings are pulled directly from Banner by the department with SZMCRSE.
For example, if the program is Photography, we display all courses with a department matching “Photography”.
This is automated using the standard Level 3 Program Courses Template, which uses the Course Listings by Department widget, widget174. This template does not allow for any custom content on the page.
e.g., for Anthropology, the widget looks like this:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_DEPARTMENT=Anthropology</arg>
</widget>
However, some programs don’t conform to this general search pattern. Some programs require courses from multiple departments; other programs require a handful of specific courses. These situations require a custom solution.
Customizing the course listing
- Go to the page details and change the page template to Level 3 - Program Courses Page (editable).
- Then edit the page and select the source code button to add widgets with custom arguments.
Refer to this table to see all the course data from Banner »
Once the customized course listing has been added to the courses page, you need to add it to the College Catalog.
You will need FTP access to the server.
- Open the College Catalog courses include located at: /_ingredients/templates/includes/college-catalog/courses.php
- Add a new conditional statement for the program by following the existing examples.
- Add the same customized courses widget and the “Courses” title inside the conditional (the same widget you just added to the program courses page).
-
Scroll up to the top of the file and add a new not_equals statement to the first conditional, following the existing ones. It should look like this:
<if var="program" type="GET" not_equals="Your Program Name"/>
To show courses from a specific department:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_DEPARTMENT=</arg>
</widget>
To show courses listed under a specific subject:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=</arg>
</widget>
To show courses with a specific subject and number:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=</arg>
<arg id="search">SZMCRSE_NUMBER=</arg>
</widget>
To show courses in a specific range:
<widget id="174_data_source_course_listings_by_department">
<arg id="search”>SZMCRSE_NUMBER>1000</arg>
<arg id="search”>SZMCRSE_NUMBER<2000</arg>
</widget>
For example, to show the Studio Production undergraduate composition courses, enter the following into the page source code:
<h3>Composition: Undergraduate</h3>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=1010</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=1020</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=2010</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=2020</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=3020</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=MCO</arg>
<arg id="search">SZMCRSE_NUMBER=3030</arg>
</widget>
Please note that as of 2023, Global Studies, formerly Liberal Studies (LBS), and Law and Justice Studies (LEG) each have new fields to pull related, also known as Plus, courses.
Global Studies: SZMCRSE_PLBS=Y
Law and Justice Studies: SZMCRSE_PLEG=Y
Also, Global Studies and Law and Justice Studies, as well as some other departments, require finessing to avoid course duplication. See examples below.
Global Studies:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=CAP</arg>
<arg id="search">SZMCRSE_DEPARTMENT=Liberal Studies</arg>
<arg id="search">SZMCRSE_COLLEGE=School of Liberal Arts & Sciences</arg>
<arg id=”search_mode">all</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=LBS</arg>
<arg id="search">SZMCRSE_DEPARTMENT=Liberal Studies</arg>
<arg id="search_mode">all</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_DEPARTMENT=Liberal Studies</arg><arg id="search">SZMCRSE_PLBS=Y</arg>
<arg id="search_mode">all</arg>
</widget>
Law and Justice Studies:
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_SUBJECT=LEG</arg>
<arg id="exclude_search">SZMCRSE_DEPARTMENT=Arts Management</arg>
</widget>
<widget id="174_data_source_course_listings_by_department">
<arg id="search">SZMCRSE_DEPARTMENT=Legal Studies</arg>
<arg id="search">SZMCRSE_PLEG=Y</arg>
<arg id="search_mode">all</arg>
</widget>
Additional Table: SZMSECT
The “SZMSECT” table allows for more details on each course and is also used for the automation of Continuing Education (CE) courses. CE courses utilize the following widgets.
- Widget 396: CE Credit Courses: Default Closed
- Widget 366: CE Noncredit Courses: Default Closed
- Widget 365: CE Noncredit Courses: Default Open
*Please note that if you are pulling all CE courses by prefix, such as IDC (Interior Design Certificate), you must reference the SZMCRSE table. Use Widget 174 to pull all courses by prefix with the SZMCRSE table.
To build a SZMSECT widget:
- For the input “Widget type” select: “data source” from the drop down.
- For the input “Show data from the table:” add the table name: SZMSECT
Other inputs like “Show data matching the search pattern” and “Sort data using the field:” can be customized using the data from this table.
Refer to this table to see all the Banner course data available from the SZMSECT table shown live »
Table with SZMSECT Data Parameters with Examples and Notes
SZMSECT Data Parameters | Example(s) | Notes |
---|---|---|
SZMSECT_TERM | 202347 | Term is code with number. |
SZMSECT_TERM_DESC | Fall 2023 or Summer 2023 non credit | Syntax must be exact. Case must be exact. Non-credit is “non credit” |
SZMSECT_SUBJECT | PSY | Prefix |
SZMSECT_NUMBER | 1090 | Level of course, such as MAT 1500 for Calc 1 and MAT 1510 for Calc 2. |
SZMSECT_CRN | 70013 | Course Registration Number used to identify the specific section of the course. |
SZMSECT_TITLE | Basic Painting (Traditional) | Course Title |
SZMSECT_COURSEDESC | Design and compose a still life using objects of your choice. Learn the importance of composition, design, value, color, light, rendering and modeling the form, and how all of these elements harmonize to create a solid and cohesive painting. | Course Description in Banner |
SZMSECT_PREREQ | ASL1000 | Prerequisite |
SZMSECT_INSTRUCTMETHOD | Traditional | Display contingent on banner input. |
SZMSECT_STARTDATE | 8/28/2023 | Will need to reformat dates in LiveWhale. See widget 396 for Day of Week, Month, Date implementation. |
SZMSECT_ENDDATE | 12/15/2023 | Will need to reformat dates in LiveWhale. See widget 396 for Day of Week, Month, Date implementation. |
SZMSECT_CREDITS | 3 | Display contingent on banner input. |
SZMSECT_INSTRUCTORS | Lattimore, Andrew | Can be one or many. |
SZMSECT_MEETINGS | T @ 06:30 PM-09:30 PM in Visual Arts 2016 | Display contingent on banner input. |
SZMSECT_FEES | 475 | Display contingent on banner input. No dollar sign. |
SZMSECT_CLOSED | *Closed* | All courses that are closed due to full enrollment or cancelled, appear as *Closed* |
SZMSECT_SESSION | Session 3 | To display Continuing Education session if applicable. |