Import learning group

Last modified by Carina Enke on 15.01.2024

Icon_Gruppe.png The function Import learning groups allows the user to import and create several learning groups at once by copying data from an Excel file.

Import learning group

Learning groups can also be created via an import function. This function is particularly useful when you want to create several similar groups. You will need to prepare data in an Excel spreadsheet format.

Explanation of the data preparation for the import ...

Preparation of the Excel file

To prepare your data in a file, proceed as follows:

  1. Create an overview of the learning groups to be created in an Excel file. Each row corresponds to a learning group.

Kurs-Beispieldatei Gruppen importieren_en.png

2. Organise the information for the learning groups into columns, e.g.: name, date, time, content, note, teacher/instructor, location, etc. The column names and content can be freely chosen.

Presorting the columns in title and description is not necessary within the Excel file. In the wizard, columns can be assigned to an option regardless of their position. This means that any number of columns can be assigned to the options Title and Description of a learning group.

The given example is for orientation only and can be adapted to different content and individual institution requirements.

 

To import the learning groups with the prepared data, proceed as follows:

  1. Open the group management of the course.

Kurs-Gruppenmanagement öffnen_en.png

2. The overview Groups in the course opens. The upper table area contains the buttons for the available group management functions.

Kurs-Gruppenmanagement Funktionen_en.png

3. Select Advanced and then Import groups .

Gruppenmanagement-Gruppen importieren_en.png

4. The page Group management of this course opens, and the view switches to the old user interface. Select the entry that begins with " Groups of the course ... ".

If no cross-curricular groups are used in the course, you will immediately see the page List of all learning groups in this course . If this is the case, you can directly continue with the next step.

Alte GUI-Gruppenverwaltung dieses Kurses_en.png

5. The List of all learning groups in this course opens. On the right is the function box Group management . Select the entry Import learning groups .

Alte GUI-Lerngruppe importieren_en.png

6.  The group import wizard opens.  

Kurs-Assistent Gruppen importieren1a_en.png

7. Open your Excel file with the data of the learning groups to be created (further information can be found in the section Explanation of the data preparation for the import ... at the beginning of this page). Copy the required data to the clipboard.

8. In Step 1 of the wizard, paste the data from the clipboard to the field Values .

9. Click on Step 2 for the interpretation of the columns.

Kurs-Assistent Gruppen importieren1b_en.png

10. You will now be asked to select the columns which are supposed to be used for the group title and description when creating the groups.

Kurs-Assistent Gruppen importieren2_en.png

11. Select the columns which should be used for the title. Select the option title from the drop-down menu. Confirm your choice with Apply . The columns are now marked with "title" in the list of values.

12. Select the columns which are supposed to appear in the description field of the groups. Select the option description from the drop-down menu. Confirm your choice with Apply . In the value list, these columns are now marked with "description".

13. Click on Step 3 (summary).

Kurs-Assistent Gruppen importieren3a_en.png

14. A summary of the learning groups to be created opens including the assignment of the respective column content for title and description.

15. Click on Step 4 (configuration of the learning group tools).

Kurs-Assistent Gruppen importieren3b_en.png

16. The overview of the group tools, which can be enabled for the learning group, opens. Select all desired tools. Further information is provided in the section Group tools.

17. Click on Step 5 (configuration of learning group participants).

Kurs-Assistent Gruppen importieren4_en.png

18. In the last step of the wizard, an overview of the learning groups' configuration settings opens. Select the desired options for the learning groups to be created. More detailed information on the individual options is provided in the section Edit and manage learning group.

Close the wizard by clicking on Finish .

Please note

The in step 4 and 5 selected configurations will be applied to ALL learning groups to be created within this wizard. Later, they can be changed at any time via the edit function of the group.

Kurs-Assistent Gruppen importieren5_en.png

19. The data values from the Excel table as well as all performed settings are automatically converted into learning groups. The window of the wizard closes, and you will automatically be returned to the group management. All newly created groups will immediately appear in the list overview, ready for use in the course.

Kurs-Assistent Gruppen importieren6_en.png