How to export data from D2L

When enrolling students on Education Perfect, you'll need to supply certain information which will allow us to create user accounts.

This article covers the process to export student information from D2L so that they can be enrolled on EP. 

Export your data

1. Start by logging in to D2L, and navigating to the course that you wish to export for enrolment.
2. Next, click the Grades tab.
   

3. Ensure you're toggled to the Enter Grades tab. Here, click the Export button.
   
4. You’ll be prompted to select your Export Options. On this page:
1. Set the first dropdown option to All users.
2. Key Field: Choose Both.
3. Sort By: Leave this option as Default.
4. Grade Values: Untick both options in this header, as this information is not required to enrol students on EP.
5. User Details: Tick all options.
6. Grades to Export: Untick all options.
5. Next, click Export to Excel. Your file will be generated, which you can then download. Open the file to check that the information is correct.
   
6. In the Excel file, add three additional columns:
   1. Class name: Enter a name for the class, including the Grade/Year level and subject (e.g. Grade 11 English).
   2. Teacher name: Enter the name of the teacher(s).
   3. Teacher email address: Enter the email address of the teacher(s) (if the teacher(s) already have EP accounts, you can skip this).
7. Once you're ready, your file(s) can be submitted to the EP Enrolment Portal.