Class Schedule View

Using the public classroom data from U of M the follow spreadsheet parses through and filters out relevant classroom data in two different viewing formats.

IT Check-in Schedule

Day View Schedule

 

Process to update the spreadsheet data

Here are the steps to update the spreadsheet with newer data from the public university Academic Year class data.

  1. Visit https://ro.umich.edu/calendars/schedule-classes
  2. Download the "All classes (CSV)" for the relevant year
  3. Navigate to this spreadsheet
  4. Be sure you are on the Raw Class Data tab on the bottom
  5. Navigate to File > Import
  6. Select the Upload Tab and upload the CSV file
  7. Select "Replace current sheet" and "Comma" under the import location and Separator type respectively. Also, uncheck the Convert boxUploaded Image (Thumbnail)
Print Article