Body
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.
- Visit https://ro.umich.edu/calendars/schedule-classes
- Download the "All classes (CSV)" for the relevant year
- Navigate to this spreadsheet
- Be sure you are on the Raw Class Data tab on the bottom
- Navigate to File > Import
- Select the Upload Tab and upload the CSV file
- Select "Replace current sheet" and "Comma" under the import location and Separator type respectively. Also, uncheck the Convert box
