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:
Please read the following article for best practices with these fields: What's the difference between Section Code and Section School Code?
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 can ignore this section.
The school designated in this field associates 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 School Management: Grade Settings. Check the box next to a grading period to associate all the courses in the file to all of the selected grading periods.
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 automatically associates the course with all sub-periods such as semesters and quarters.
So, if your school's grading periods include semester-long grading periods, with sub-periods for each quarter, like this:
Include only the semester periods in your import file:
Then, map the file to the year-long grading period in the Import screen:
When you run the import, the courses will associate with the semester-long grading periods and the quarter sub-periods:
Select the XLS or CSV file that contains the course information for import.
Update existing records
Selecting this option locates existing course sections by Course Code and Section Code/Section School Code, and updates new information from the XLS or CSV file. Importing an empty column does not remove information from Schoology. For example, importing a file with no course description does not remove existing course descriptions from Schoology.
Step 2 — Match Columns
- In the second step of the import process, match the information listed in each column to create courses in Schoology.
- Match each Schoology Field to a column in the XLS or CSV file.
- Once you've matched each field to the appropriate column, click Preview.
Step 3 — Preview/Confirm
New courses and sections display under Created Courses and any courses you're updating display under Updated Courses. Adjust courses under the Errors heading according to their error message. Click Run to complete the import process when all information appears correct.