UAB Logotip del Campus Virtual

How to assign students to groups from a file

The steps to follow are:

  1. CREATE EMPTY GROUPS IN THE CLASSROOM
  2. PREPARE THE FILE WITH THE INFORMATION OF THE GROUPS
  3. STUDENT ASSIGNMENT (UPLOADING THE FILE TO THE CLASSROOM)

 

1. CREATION OF EMPTY GROUPS AND THE GROUPING CONTAINING THEM

You will first need to create the number of (empty) groups you need:

 

2. PREPARATION OF THE FILE WITH THE INFORMATION OF THE GROUPS

Prepare the file that will be used to carry out the massive load. this file must have the extension “.csvseparated by ;.

The file must have 4 fields, each of which will be a column:

  • first field – NAME of the student,
  • second field – SURNAME,
  • third field – NIU and
  • the forth, the NAME OF THE GROUP assigned (and that you have previously created empty in the classroom).

excel

NOTE. The information in the first three columns can be obtained by accessing Sigma and downloading or exporting the student lists.

 

Finally, from excel, save the file as a document in CSV (delimited per comes) (*.csv) format.

excel1

 

3. ASSIGNMENT OF STUDENTS TO GROUPS (UPLOADING THE FILE TO THE CLASSROOM)
  • In the classroom, turn editing on and click the + Add an activity or a resource button.

Add an activity or a resource

 

 

  • Select the Group self-selection activity.

Add an activity of group self-selection

  • Fill in only the required field: Name.
  • In the General section look for Select groups from grouping to indicate the grouping to which the groups belong to.

Grouping select

  • Save the changes.

Save changes button

 

IMPORTANT. Hide the activity, since it does not have to be seen by the students – it only has to be used to upload information to the classroom.

  • Click on the name of the activity.

Example of activity Group self-selection

 

  • Click on Seleccionar archivo (Choose a file), to select the .csv file that contains the student data. Once the file has been uploaded, click on Importa.

Selection of the file

Each student will automatically be enrolled in the group that has been assigned to them.

To top