How to use the Sheets Add-On

Get the Add-On

The Add-On is available through the Google Workspace Marketplace (go to sheets and then search for add-ons).

There are five functions available through the addon. All take a course department and catalog number as an input (e.g. CS 2100)

Return the title of the course

Returns the list of instructors for the course separated by commas

Returns the number of units for the course

Returns a meeting days shorthand for the course (e.g. MThFr or TuTh)

Returns the number of students enrolled in the course.

Note: data from this function is only available for the current semester and may be inaccurate.