Page Comparison

What is it?

Bulk enrolments allows you to enrol students or staff and add them to groups in a Moodle course using an excel file containing their UCL email address or userid. 

...

1. Select Choose a file and upload your CSV file.
2. Make sure Role to assign is left as student, or change it to tutor (if uploading staff).
3. Set First column contains to reflect they type of data you have used in your spreadsheet, either the students' email address or UCL userid.
4.  If you need to create groups, ensure Create group(s) if needed is set to Yes
5. If you would like to create groupings in your course, based on the groups that the students will been placed into, ensure Create grouping(s) if needed is kept to yes.  If you do not want to create groupings, ensure this is set to No
6. To receive an email report confirming which students have been enrolled and which groups they have been placed into, keep Send me a mail report set to Yes.
7. Click Enrol them to my course.
8. Check the students have been enrolled in their groups by going to the Settings menu and under Course Administration click on Users then Groups.
9. You should see the groups listed, followed by the number of students in each group in brackets.

...

Examples and case studies

Uploading students and their personal tutors to a departmental

...

Moodle course to enable them to schedule Personal Tutor meetings

You will need to create two excel files for this purpose.

1. Create an excel file (saved as .csv) that contains a list of all your personal tutors.
   1. The first column will contain the personal tutor's email address or UCL userid.
   2. The second column will contain the group they will belong to. In this case the group will contain their name - e.g. Jo Bloggs personal tutoring group.
      Note: although tutors can see all groups in Moodle, adding them to their own group will ensure this group is automatically selected on any activities with groups enabled. E.g. discussion forums.
2. Upload this file to Moodle (using the steps outlined above), making sure the Role to assign setting is changed to tutor.
3. Create a second excel file (saved as .csv) that contains a list of all your students, mapped to the personal tutor group.
   1. 1. The first column will contain the student's email address or UCL userid.
      2. The second column will contain the group they will belong to. In this case the group will contain their name - e.g. Jo Bloggs personal tutoring group.
         Note: students will need to be in the correct group in order to see any activities that are visible only to those group members. E.g. the scheduler tool that allows them to schedule an appointment with their tutor.
         
4. Upload this file to Moodle (using the steps outlined above), making sure the Role to assign setting is left as student.
   
5. Now you can setup any resources or activities (such as the scheduler tool) for each group and Restrict access, so only students in that group see the item.

Questions & Answers

Q.  I am getting an error message when I upload the CSV file to Moodle?

...