Spreadsheet templates
Zoom attendance tracking spreadsheet - template
Attendance for students who attend class online has to be input manually by professors for each meeting of the class. To make this process easier, instruct your students to add their student IDs to their Zoom display name, then paste the Zoom log data into this spreadsheet template.
More detailed instructions and a video walkthrough of the process is available on the attendance page.
SolBridge grading spreadsheet - template
If you'd like to use a grading spreadsheet that's set up to accommodate SolBridge specific situations (such as the grading curve system and attendance scoring), a template is available here. If you have suggestions or feedback for the spreadsheet, please contact Prof. Daniel Corks.
Random student picker
The spreadsheet linked here can be used to:
Select a random student
Creating a list of students in a randomized order
Creating student groups with randomized members
This is useful if you want to quickly create multiple random groupings
If you want to have students submit assignments on SMART as a group (and grade them as a group), then it might be better to create groups directly in SMART and use the random grouping function that's provided there. The instructions here (see Note 1) explain how to do that.
