...
- "First Name"
- "Last Name"
- "MIT affiliation?": Match the slugs used in SquaresDB (https://squaresdb.mit.edu/admin/membership/mitaffil/) – "none", "undergrad", "grad", "alum", "staff", "community" (eg, spouse of a grad student or of staff)
- "Email"
- "Grad year": expected or actual MIT graduation year, if available
- "PE": whether they took the PE class this semester, "TRUE" or "FALSE"
Export the spreadsheet as a CSV file.
Log in to SquaresDB (choose the login dropdown at the top right, and choose either "MIT" or "Google"). If you haven't gotten your account set up before, you'll need to get a SquaresDB maintainer to give you permissions (if you're not sure, visit the import page – if it asks you to log in again, you need account permissions). Once you're logged in, go to the class import page, filling out the form as:
- Label: <semester> <year> – for example, Spring 2022
- Start date: first night of class
- End date: graduation
- Coordinator: the class coordinator – if there are multiple, pick one
- Student csv: upload the CSV file you exported before
If you have issues, contact a SquaresDB maintainer.