Importing Course Enrollments
Provision users into courses at your school from the Course Enrollments tab on the Import page.
Step 1—Select file
The XLS or CSV file for import must contain the following columns:
Tip: You may export a CSV of course sections from the Export area for a list of courses in your school with both a course code and section code/section school code.
Use the Enrollment Type drop-down menu to determine whether the users in your spreadsheet are members (student) or admins (teacher) of a course. If your spreadsheet only has one type of user, you can select that type in the menu. For example, if the spreadsheet only has students, select Member in the menu.
If, however, your spreadsheet has users who will be assigned different enrollment types in Schoology, select Use Import File in the menu. The Schoology Enrollment Types (Admin or Member) display in the left column; enter the equivalent type from your spreadsheet in the fields in the CSV Value column.
In this example, Admins and Members are designated as 1 and 2, respectively, in the spreadsheet.
Select the grading period(s) with which the course sections listed in the import file are associated. Two options are available:
- Click Select Periods to choose from a list of your Schoology grading periods. In the following example, the selected enrollment types are applied to the three selected grading periods.
- Click Use Import File to match your Schoology grading periods to their equivalent values in your import file. In the following example, the existing Schoology grading periods display in the left column, and each equivalent from the spreadsheet has been added in the fields in the right column.
Tip: You may export a CSV of course sections from the Export area for a list of courses associated with a particular grading period. Please note that users are enrolled in course sections, and course sections are associated with grading periods. If a section is associated with multiple grading periods, enrolling a user in that section will enroll that user in all grading periods associated with the section. To create unique rosters by grading period(s), please create course sections associated with appropriate grading periods. See Importing Courses above for more information.
Clear Enrollments Not in File
Selecting this option will locate existing course sections by Course Code and Section Code/Section School Code, clear existing enrollment in the course, and replace admin and members with users from the XLS or CSV file. Adding the same user back into the course will restore content created by that user in the course.
Tip: To clear only the teacher in the course, import a file for the Enrollment Type, Admin. To clear only the students of the course, import a file for the Enrollment Type, Member.
Please select the XLS or CSV file that contains the enrollment information for import.
Step 2—Match Columns
In the second step of the import process, match the information from a Schoology Field to each column in the spreadsheet to provision users into course sections in Schoology.
Confirm the match by verifying the Preview columns list the correct information.
If you see a yellow message at the top of the screen, please adjust the information selected in Step 1 of the import process, and if needed, adjust your import file. If all information appears correct, click Run to complete the import process.