Page Comparison

...

...

...

...

...

What is it?

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

This can be useful before the start of the session, when Portico enrolments may not yet have begun, but enrolments are required.

It does require that the students you are enrolling have already logged into Moodle, so for instance, it could not be used to enrol first year students before they had ever used Moodle.

...

This block will only be visible to course administrators or tutors on the course

1. Login to Moodle with your UCL username and password: http://www.ucl.ac.uk/moodle  
2. Navigate to your Moodle course 
3. Click on Turn Editing On in the top right hand corner of the page
4. Scroll down to the Add a block block and from the drop down menu, select Bulk Enrolments
   Image Removed
5. The block will now appear on your course, at the bottom of the right-hand column.

...

 It also allows you to add students to groups with ease - the process will auto-create groups if they do not already exist on your Moodle course.

Who can use it?

Course administrators and tutors can use this feature.

Before I start...

You will require an Excel file containing a complete list of the students' email addresses or user IDs in the first column. Subsequent columns contain the names of any groups you want to add each student to. 

How do I use it?

1. Create your CSV

In order to upload your students users successfully, you will need to create a CSV file with the students' details. If you also want to enrol staff you will need to create a second CSV file for this, as each bulk enrolment can only enrol a single type of role (e.g. either students or tutors).

CSVs are simple to create - one way is in a spreadsheet package like Excel, making sure to save it as a a .csv file file-type.

At As a minimum, your CSV file should contain one column for the main student identifier, usually their UCL email address, but it can also be their UCL userIDuser ID.
Ensure you have column labels - this is because Moodle anticipates these and so ignores the first row of the CSV file. In other words, don't put any actual student data in your file's top row. If you are using Email then put type 'email', if you are using user IDs then put type 'userid'.
If you want to enrol the students into into Groups, include a second column which gives the group name for each student. Be careful to type these exactly. Give it a column heading 'group'.

Image Removed

...

Image Added

 2. Enrol the Students

Image Removed

Go to the

...

Participants tab on the main course menu then choose Bulk enrolments in the drop-down menu. 

Image Added

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

You can also bulk unenrol unenroll students from your course by clicking on Bulk unenrolments in the block, and following the instructions abovegoing to the Participants tab on the main course menu, then choose Bulk enrolments in the drop-down menu and follow the steps.

Caution

The students you are enrolling must have already logged into Moodle, so this cannot be used to enrol first year students if they have never used Moodle.

Also, note the bulk unenrolment will not work for students who have been enrolled onto the course via Portico.  

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 set up 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.  Why am I getting an error message when I upload the CSV file to Moodle?

A.  Check the file is a .csv and not a .xls file, and ensure the First column contains field is set to UCL Userid or Email address.