Faculty Course Mapping & D2L Utility

Overview

This Python-based utility streamlines post-scheduling administrative tasks by generating reports that map faculty assignments across campuses and courses, and automates the creation of upload-ready files for populating Desire2Learn (D2L) course templates.

Designed to reduce redundancy and enable precise communication, this tool addresses critical inefficiencies in cross-campus coordination and Learning Management System (LMS) setup.

Key Goals

Identify which faculty are teaching at which campuses (Alpharetta, Online, Clarkston, etc.)
Track who is teaching each individual course (e.g., MATH 1001, MATH 1111)
Generate reverse lookups: given a campus, what courses are being taught and by whom
Support targeted communication (e.g., emailing all instructors of a specific course)
Create upload-ready .txt files for bulk addition of faculty to shared D2L course templates

Core Features

Schedule Ingestion: Converts CSV schedule report into finalized Excel report of faculty teaching assignments with contact information
Campus/Course Indexing: Generates multi-level groupings by instructor, campus, and course
D2L Uploader Integration: Outputs formatted text files for batch upload to D2L LMS course templates
Multi-Campus Compatibility: Handles instructors teaching at multiple sites and in online sections
Comms Utility: Enables selective contact lists for distribution of syllabi updates, curricular memos, assessment procedures, etc.

Tools Used

Python (pandas, numpy, xlsxwriter)
Google Colab (cloud notebook interface)
Excel (input/output formatting)

Impact

Eliminated repetitive manual entry of faculty into D2L templates across 6 campuses.
Accelerated faculty coordination workflows for curriculum committee communications.
Ensured accurate and consistent instructor tracking across course offerings.
Created a reusable system that now supports every term’s onboarding and communication needs with minimal updates.

Try It Yourself

This tool is built for department chairs, schedulers, and admins who want fast, reliable faculty assignment reports and D2L rosters.

You can launch it live or explore the full project on GitHub.

Launch in Google Colab

📁 View the code, sample outputs, and screenshots on GitHub