Creating Courses in Batches (Copia Back Office)

BUILDING YOUR SPREADSHEET

Courses can be created in batches using a spreadsheet in .csv format.   

A .csv template is available for download from this page.

Required Fields:

1. ID: A unique identifier created by the admin (can be left blank).  
   1. The ID for each session must be unique.  
      1. If you have multiple course sessions sharing the same ID, you may want to put "-1", "-2", etc. at the end of each session's ID number.
      2. If you used the same ID in a previous term or school year, you should add the year number to your ID. You should not reuse the same (identical) ID from year to year.
2. Course Name: This is the basic name of the course (e.g., Biology).
3. Term: Select the Corresponding Term Period.

4. Session Name: This is a unique name for this specific section.

   1. Example:
      1. Biology – Period 1 
      2. Biology – Period 2

Please mirror all column headers (case sensitive) and fill in the rows as pictured below. (All spreadsheets must be saved as a .csv comma delimited file type.)

IMPORTING YOUR SPREADSHEET

Once your spreadsheet is complete and formatted correctly, follow the steps below to import your .csv file into the back office.

1. Go to Manage -> Course Sessions/Classes.
2. Click Bulk Operations.
   1. 
3. Click Import Sessions.
4. Click Upload, then select the spreadsheet containing the required Course information.
   
5. Click Continue. The system will begin uploading your file.
6. Once the batch import is complete, you will see a results section showing the number of courses created successfully, as well as any error messages.
   1. Example I: Successful upload 
      
   2. Example II: Unsuccessful upload
      1. In this example, the upload was unsuccessful, because the system does not contain a Teacher account with the Instructor Email address(es) entered in the left column.
         
   3. In the event of a failed upload, you can download and edit your spreadsheet by clicking Export Results.