You can upload courses from spreadsheets by logging into your educator account following these steps:

  1. Visit the educator dashboard. Click "Manage" under "Course Planner".
  2. Click "Upload"


3. Create your course file. There are two ways to create your file: 


  • Generate a course catalog file from your Student Information System: If you are generating a CSV text file by exporting data from your school or district’s Student Information System (PowerSchool, Tyler SIS, Infinite Campus, etc.), follow these steps:


      1. Select the records you would like to export (i.e. all active courses).
      2. Select the fields to include in your export file. You will need the following fields: Title of Course, High School name, Department, Course Rigor, Grade Level, Length, and Credits 
      3. Save the file to your hard drive in a comma-separated value (CSV) text format.



    • Manually prepare a spreadsheet: If you are preparing your text file manually using a spreadsheet program like Microsoft Excel or Google Docs, follow these steps:


      1. You may download a template CSV from the uploader page or create the file on your own. If you are starting with a blank document, place each field in a separate column. For example, one column could be for the course title, another would be for the course rigor, and another would be for the academic subject.
      2. Place each course in its own row.
      3. Save the file to your hard drive in a comma-separated value (CSV) text format.


Below is an example CSV that shows how the first row contains the headers and each additional row contains the data for one course. The actual file may look different depending on the fields you choose to import.


High School Title Department Course Rigor Length Credit Grade 9 Grade 10
Overgrad High School Honors Algebra I Mathematics Honors 2 0.5 Yes Yes
Overgrad High School English 101 English Regular 2 0.5 Yes No
Overgrad High School American History 101 History Regular 2 0.5 Yes Yes


Overgrad’s Bulk Course Uploader supports the fields as shown:

Field Required Description
Title Yes The name of the course
Description No

A description of the topics covered in the course and any other information that students should know about the course
High School Yes Name of the course's high school
Course Number No The number or code in your course handbook that corresponds to the course
Academic Subject Yes The subject area of the course (Math, English, Art, etc.)
Course Rigor Yes The difficulty of the course such as "regular", "honors", "AP", etc.
Offered to grade 9 Yes Is the course offered to students in grade 9?
Offered to grade 10 Yes Is the course offered to students in grade 10?
Offered to grade 11 Yes Is the course offered to students in grade 11?
Offered to grade 12 Yes Is the course offered to students in grade 12?
Length Yes The length of the course as the number of terms it lasts.
Credits Yes The number of credits awarded to the student each term the course was taken.

 

About Length and Credits

You should have already configured your school/district's settings. In those settings, you will set your Course/Grading terms (semester, trimester, quarters). If you are on semester terms, the course lasts a year long, and the student earns one credit for completing the course, the length = 2 (semesters) and credits = 0.5 (0.5 credits/semester * 2 semesters (length) = 1 annual credit).