Create groups and assign students to them (for large courses)

Updated 19 Feb 2024

Instructors can create groups and assign students to them in Mastering using a .csv spreadsheet. This "batch" method is best for large classes. For fewer students and groups, see Organize students into groups.

Assign students to groups using a spreadsheet:

1. Select Mastering Student IDs & Groups from your LMS course.
2. Choose  Export/Import Roster Details.

   This option becomes available after at least one student has joined your course and signed in.

3. Select Export to export the Roster details as a .csv file to your computer.
4. Open the .csv file and make changes.

   To assign students to existing groups —
   Copy and paste group names in the Groups column. To add a student to more than one group, separate the group names with a comma: Lecture A, Lab 1

   To create new groups —
   Type a new name in the Groups column.

5. Save the edited .csv file.
6. Select  Export/Import Roster Details again.
7. Browse to identify the location of the edited .csv file on your computer, and then choose Import.
8. During the import process, you are asked to confirm the changes that will be made. You can always edit student details from within the course, including after you import a file.

See also: Organize students into groups | Batch edit student IDs