{"id":102,"date":"2023-01-27T16:34:29","date_gmt":"2023-01-27T22:34:29","guid":{"rendered":"https:\/\/boulderfieldconsulting.com\/?page_id=102"},"modified":"2023-02-19T16:50:13","modified_gmt":"2023-02-19T22:50:13","slug":"casestudy2","status":"publish","type":"page","link":"https:\/\/boulderfieldconsulting.com\/?page_id=102","title":{"rendered":"Faculty Load Calculation"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Case Study #2:  Faculty Load Calculation<\/h2>\n\n\n\n<h3 class=\"has-medium-font-size wp-block-heading\"><strong><em>ISSUE:<\/em><\/strong><\/h3>\n\n\n\n<p class=\"has-medium-font-size\" style=\"padding-left:20px;line-height:1.5\">Determining the teaching load for individual faculty is frequently complicated when faculty teach across disciplines and different divisions, if communication between the division Deans is not clear. In addition, managing the overall teaching faculty load on an annual basis requires information from all semesters, as well as considering release time for administrative activities if counted in their teaching load. A better way of viewing scheduled (and completed) faculty course instructional sections was required to better ensure that faculty met their desired teaching loads without unintended overloads.<\/p>\n\n\n\n<h3 class=\"has-medium-font-size wp-block-heading\"><strong><em>SOLUTION:<\/em><\/strong><\/h3>\n\n\n\n<p class=\"has-medium-font-size\" style=\"margin-bottom:50px;padding-left:20px;line-height:1.5\">In this situation, the college-wide scheduling Excel tool was also employed to provide the necessary data for this function. Many possible additional reports can be generated once the college-wide course section data are imported into the course scheduling Excel workbook. In the case below, all faculty assigned to teach one or more courses in the master spreadsheet are added to a simple dropdown list by pushing the button labeled \u201cCreate Faculty Dropdown\u201d. Then when a specific faculty member\u2019s name is chosen from the dropdown list, all course sections taught by that faculty are populated in the table, along with the total number of credits assigned. This feature is useful for supervising faculty members who teach in different disciplines within a division, or even across different academic divisions. When updates are made to the master schedule import file, the results here will also automatically refresh.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1019\" height=\"544\" src=\"https:\/\/i0.wp.com\/boulderfieldconsulting.com\/wp-content\/uploads\/2023\/01\/FacultyInstructionalWorkload.png?resize=1019%2C544\" alt=\"\" class=\"has-border-color has-ast-global-color-0-border-color wp-image-103\" style=\"border-width:5px\" srcset=\"https:\/\/i0.wp.com\/boulderfieldconsulting.com\/wp-content\/uploads\/2023\/01\/FacultyInstructionalWorkload.png?w=1019&amp;ssl=1 1019w, https:\/\/i0.wp.com\/boulderfieldconsulting.com\/wp-content\/uploads\/2023\/01\/FacultyInstructionalWorkload.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/boulderfieldconsulting.com\/wp-content\/uploads\/2023\/01\/FacultyInstructionalWorkload.png?resize=768%2C410&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Case Study #2: Faculty Load Calculation ISSUE: Determining the teaching load for individual faculty is frequently complicated when faculty teach across disciplines and different divisions, if communication between the division Deans is not clear. In addition, managing the overall teaching faculty load on an annual basis requires information from all semesters, as well as considering [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":6,"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-102","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\/102","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=102"}],"version-history":[{"count":5,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/102\/revisions"}],"predecessor-version":[{"id":542,"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=\/wp\/v2\/pages\/102\/revisions\/542"}],"wp:attachment":[{"href":"https:\/\/boulderfieldconsulting.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}