{"id":209,"date":"2023-01-28T14:39:31","date_gmt":"2023-01-28T20:39:31","guid":{"rendered":"https:\/\/boulderfieldconsulting.com\/?page_id=209"},"modified":"2023-02-18T16:11:17","modified_gmt":"2023-02-18T22:11:17","slug":"casestudy6","status":"publish","type":"page","link":"https:\/\/boulderfieldconsulting.com\/?page_id=209","title":{"rendered":"Scheduling Database"},"content":{"rendered":"\n

Case Study #6: Multi-Semester Course Scheduling Database<\/h2>\n\n\n\n

ISSUE:<\/em><\/strong><\/h3>\n\n\n\n

Curriculum Committees often are tasked with determining whether a course should be removed from the catalog if it appears to have no continuing value to the institution. This may be because of decreased enrollment or the reconstitution of a particular program of study. In addition, when developing a perpetual schedule (see a previous case study above) it is important to know the historical offerings of a course by semester to identify the most appropriate schedule to fit students\u2019 needs. Both of these exercises require a comprehensive chronological course scheduling database as a reference, which is often difficult or time-consuming to collect in a timely manner to support decision-making.<\/p>\n\n\n\n

SOLUTION:<\/em><\/strong><\/h3>\n\n\n\n

This Excel database was created from historical course offering data over several semesters extracted from the institution\u2019s archived ERP class scheduling system. A worksheet containing all class sections (offered, pending, cancelled) for every desired semester was created. A navigation dashboard was developed to allow the user to quickly extract all section instances over this time period for a given course (prefix & number). The purpose of this workbook is to instantly determine all historical offerings of a course, including instructor as well as final enrollments. This tool will support multiple tasks, including scheduling sections for the current semester, determining the last semester for which a course was offered (if looking to remove a course from the catalog), and the proposal of a perpetual schedule for a course, among others. The image below shows the dashboard page of the workbook for a sample course; the only user inputs are the Discipline Prefix and Discipline Course Number for the course.<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

Case Study #6: Multi-Semester Course Scheduling Database ISSUE: Curriculum Committees often are tasked with determining whether a course should be removed from the catalog if it appears to have no continuing value to the institution. This may be because of decreased enrollment or the reconstitution of a particular program of study. In addition, when developing […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-209","page","type-page","status-publish","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=209"}],"version-history":[{"count":5,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/209\/revisions"}],"predecessor-version":[{"id":532,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/209\/revisions\/532"}],"wp:attachment":[{"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}