Grouping using an Excel file

Step A: Preparing a participant file by groups

Create an Excel file with three columns (the order of the columns is important):

1. Column 1: Student ID number (9 digits without dashes or spaces). In order to automatically create an ID column so that it has 9 digits in Excel, perform the following operation:
   
   • Select the column.
   • In "Format cells", select "Custom" and in "Type", type 000000000.
   • OK
2. Column 2: Group number (or name)
3. Column 3: The appropriate grouping

In the first row, write down the column headings (not values).

Save the file in CSV comma delimited format.

Please note: You can create a file with only column 1 if you only want to add participants to the course website without dividing them into groups. You can also create a file with only columns 1 and 2 if you do not need to make groupings.

Step B: Setting up the course for group activities

For group work, set up the site for group work according to the instructions here https://moodle25.technion.ac.il/mod/page/view.php?id=16645. If this step has already been completed - there is no need to do it again.

Step C: Adding participants into groups

• Go to the course website and in the tabs under the course title, select "Participants". Click on "Enrolled users" and select "Bulk enrolments".

The following page will open:

• Attach the file prepared in step A.
• Change the "Encoding" field to "windows-1252".
• Make sure the role is "Student".
• Click on "Enroll them my course".

For particularly large courses, the process can take a few minutes. An email will be sent confirming that the action has been completed.