Your  Account:

Tech Bites

banner with text: Tech Bites, with apple

Brownbag Lunch and Learn Series Spring 2020

Whether you're getting started in your academic career, are looking to revise an existing class, utilize technologies to support your students or  work more efficiently, there is something here for you. While we do not have many workshops scheduled for Spring 2020, we are happy to discuss your individual and/or department needs. Contact to schedule a 1:1 or small group consultation.

NOTE: Do you have an idea for a topic or want to present a topic, email with your idea.

Register for Spring 2020 Sessions

These workshops are in Kellogg Library 2414 in the Technology Resource Center (TRC) from 12-1:30pm

Degree Planner and Schedule Assistant

Managing the Course Schedule with Excel 

  • Thursday, Feb 20
  • Thursday, Feb 27
  • Thursday, March 12

Rick Fierro, Associate Dean of CSTEM will facilitate this session.

Chairs and Program Directors are typically responsible for building the schedule for their department each semester. We will offer workshop participants an opportunity to learn how to use a “copy-and-paste-and-enjoy” Excel file to help you manage the schedule, track assignments for instructors, and monitor enrollment/waitlists.   The Excel file (“Enrollment Summary”) processes the schedule from a Psoft query in a useful way that is easy to learn, remember, adapt, and maintain.

In this workshop, you will learn how to:

  • Access the schedule for your college and copy/paste the schedule into the Enrollment Summary file.
  • See unassigned courses.
  • See assigned courses. 
  • See courses assigned to a specific instructor. 
  • Monitor workload for each instructor. 

Each workshop participant will leave with an Excel file that they can use for their college. No previous experience with Excel is necessary to become proficient with the Excel file.