TutorAIRS

TutorAIRS.com

Project Description

TutorAIRS is an acronym for "Tutor Automated Intake and Report System". It's role is to act as a booking system for appointment-based tutorial sessions, keep track of drop-in tutorial sessions, manage payroll and timesheets, and host embedded video tutorial sessions.

Responsibilities

I authored all of the files that comprise TutorAIRS.com and the associated SQL databases, and am responsible for creating and implementing new features, as well as maintaining the integrity of the site and of the data it collects.


Merrimack College Google Web Apps

Project Description

I created a series of Google Web Apps for my department (Academic Success Center of Merrimack College) to streamline freshman registration, retention initiatives, and academic support.

Responsibilities

I authored the Google Apps Scripts to create

  1. a web interface for visualizing student schedules based on CX data
  2. a live freshman registration dashboard to keep track of students from each school (engineering, business, etc.) and cohort (honors, at-risk, etc.), the number of credits they are registered for, which courses they are currently (not) registered for, etc.
  3. a web interface for sending individual, personalized emails from a Google Sheet
  4. a web interface and corresponding script for taking a large spreadsheet (like an advising spreadsheet) and automatically splitting that spreadsheet into several smaller sheets based on a column (like the name of the academic advisor) and automatically sharing each new sheet with the appropriate personnel (the advisor for that group of students) along with a personalized follow-up message explaining the purpose of the sheet that was just shared


Scholars Beyond the Tower

SBTT Webpage

Project Description

Scholars Beyond the Tower is the podcast hosted by Erin Becker and Caroline Propersi-Grossman, in which they interview academically-trained scholars regarding their work outside of or adjacent to academia.

Responsibilities

I authored all of the files that comprise ScholarsBeyondTheTower.com and the associated SQL databases, and am responsible for creating and implementing features for the website.




Questions? Email Me © 2012-2024 Jonathan L. Grossman