Edline+-+Schedule+data

Edline Schedule upload data file

This is one of the two files (//the other is the Students upload)// I upload every other day during the school year. It's a reasonably clean export, from STARS to Edline's "**Schedule Upload**" QuickSync option, with only one concatenate/delete needed. See below.



> **=CONCATENATE(A1,"_",B1) > **
 * 1) Save the STARS Export file as "**Creating Schedule.xls**"
 * 2) To the right of Columns A and B, insert a new Column C.
 * 3) Create the Edline CourseID from Columns A and B using the following formula:
 * 1) Highlight the data in columns C and D only. Copy it.
 * 2) Insert a new worksheet, and paste the __values__ (//From "Edit," select "Paste Special" and then select "Values only"//)
 * 3) Save the new worksheet as a **Schedule.csv** file.

Upload to Edline

 * 1) Login as an Administrator
 * 2) From "Command Center," select "**QuickSync**"
 * 3) Change "Type of Data" to "**Standard Schedule Upload**", find the "**Schedule.csv**" file, and upload.