top of page

Upload groups from Excel to course website

The course staff can create new groups on the course website by uploading all the groups at once, from an Excel file.

After uploading the groups to the course website, extended time can be set for each group as needed.

prepare-excel

How to prepare an Excel file with a list of students and groups?

1. Create a new Excel file.

2. Create a column of ID numbers titled "idnumber" (type in lowercase letters). You can use the downloaded list of students as a basis. Click here for the guide to download a list of students.

image.png

3. Create a column of the names of the groups titled "group" (type in the first line  in lowercase letters).

image.png

4. Make sure that each line shows an ID number as well as a group name.

5. The columns must be copied from Excel. This can be done by selecting all the cells in both columns and copying them (Ctrl+C).

upload file

How to upload the excel file to the course website?

1. Enter the course website.

2. Click on "More" in the main toolbar of the course. Choose "Groups" in the menu that will open.

Coursemenuopen.png

3. On the screen that opens, click on "Enrolling participants - Paste from spreadsheet". 

2.png

4. On the next screen paste (Ctrl+V) the columns in the Data box 

5. In order to create the groups, click on "Enrolling participants to groups"

image.png

6. To finish, click on "Continue".

image.png
image.png

In the right box you can see all groups in the course

In the left box you can see a list of students in the selected group

If the group in the Excel file already existed on the course website, the students will be added to the existing group.

If the group did not exist - a new group will be created and the students listed in the Excel file will be added to it.

extended time

How to allow extended time in an assignment or quiz to a group?

In Assignment and Quiz activities, extended time can be allowed for specific groups of students.

1. Enter the quiz or assignment activity on the course website.

2. In the activity top menu, click on "More". In the menu that opens, click on "Overrides".

image.png

3. In the page that opens, click on the "User overrides" dropdown menu and select "Group overrides". To finish, click on "Add group override".

image.png

4. In the "Override group" field, select the group to which you would like to give a time extension.

Screenshot 2024-02-12 115806_edited.jpg

5. In the "Open the quiz", "Close the quiz" and "Time limit" sections, the times defined in the quiz settings for all students will appear.

image.png

Define the Quiz closing time according to the desired extended time:

The original end time + the defined time increment

6. In the "Attempts allowed" section it is advisable not to change it. If the group submitted the test and needs an additional answer (timeout/late start, etc.), the whole group can be granted another attempt.

image.png

7. To finish, click "Save".

image.png

8. After saving, you will see the group override in the quiz main page.

image.png

9. By clicking on the group override in the brackets, a new page opens. It shows the extended time granted to the group. It is recommended to make sure that the time set corresponds to the need.

image.png

Overrides must be set for each group separately

bottom of page