The second tab in the Import area enables you to import courses into your school.
Step 1—Select file
The XLS or CSV file for import must contain at least the following columns:
Course codes and Section School Codes must be unique within your entire school or district. Section codes must be unique across courses and grading periods. For example, if you have a course section with the following codes in Grading Period 1:
You may also have another course section with the same course and section codes the following Grading Period 2. This system allows you to have the same classes in following years without duplicating courses listed in Course Listing.
If there is more than one school in your Schoology account (For example, Schoology District, Schoology High School, and Schoology Middle School), you’ll see a field for the School, into which you may import users. If you do not see this field in your import area, you may ignore this section.
The school designated in this field will associate courses in your file to the selected school. Alternatively, you may add a School column in your file to associate courses to a particular school by selecting Use Import File.
If you have selected Select Periods in the Grading Period(s) area of this screen, the grading periods listed are the grading periods you’ve created through System Settings > Grade Settings. The grading periods you select during this import will associate the courses in the file to all selected grading periods.
Alternatively, you can select Use Import File to map values in your .CSV file to the Grading Periods you have created in Schoology through System Settings> Grade Settings.
A Note About Grading Periods and Sub-Periods
If you have sub-periods within any of your grading periods, you only need to map your .csv file to the main grading period(s). For example, mapping your file to the year-long period will automatically associate the course with all sub-periods such as semesters and quarters.
So, if your school's grading periods include one year-long grading period, with semester-long sub-periods, like this:
Then, in your import file, you can add only the year-long period:
And you can map the file only to the year-long grading period in the Import screen:
When the course is created via import, it will be associated with the year-long grading period AND the subperiods:
Please select the XLS or CSV file that contains the course information for import.
Update existing records
Selecting this option will locate existing course sections by Course Code and Section Code/Section School Code, and update new information from the XLS or CSV file. Importing an empty column will not remove information from Schoology. For example, if you import a file with no course description, the update will not remove existing course descriptions from Schoology.
Note: The school and grading period with which the course is associated cannot be updated through an import. Schools and grading periods must be updated or added manually from Edit Users or Course Listing, respectively.
Step 2—Match Columns
New courses and sections will be indicated by an orange label, new. If you see a yellow message at the top of the screen, please adjust the course and/or section information in your school account, and if needed, adjust your import file. If all information appears correct, click Confirm to complete the import process.