Edline+-+Class+data

Edline Class data upload file

The "**Standard Class Upload**" option in Edline's QuickSync requires the following:

Edline TeacherID**
 * Edline CourseID**
 * EdlineCourseName

I used the STARS variable report below, with the following modifications:



To get the TeacherID, open the resultant Class Upload workbook, > //An underscore "_" separates the course and the section numbers.// > //This puts the meeting time in brackets, then the class name, then the Room number after a dash. Example: "[MOD 1] English 12 - Rm 111"// >
 * 1) Add two new columns in the **Class Upload worksheet** between columns E (Room) and F (Teacher ID)
 * 2) In the new Column G, create the Edline CourseID using the following formula: **=CONCATENATE(TRIM(A2),"_",TRIM(B2))**
 * 1) In the new Column H, create the Edline Class Name using the following formula: **=CONCATENATE("[",TRIM(C2),"] ",TRIM(D2)," - Rm ",TRIM(E2))**
 * 1) From "Edit," select "Fill down" in both columns G and H.
 * 2) Highlight only the data in Columns G, H and I. //Hint: select the first cell, hold down the Shift and Ctrl keys. Press the down arrow to jump to the last cell in that row. Press the right arrow to move to the right--you'll have just the data in Columns G, H and I highlighted. For our school, this was cells G2 through I11057//
 * 3) **Copy the __values__ to a new worksheet** (Sheet 2). //If you select "Edit" and then "Copy" when the data is highlighted, and then from "Insert," select "Worksheet," and then from "Edit select "Paste Special", you can select the "Values Only" radio button.//
 * 4) Because of the way data was exported from STARS, there is a line for each student enrolled in each class. To eliminate duplicates, in **Sheet 3**, highlight the data, and from "**Data**", select "**Advanced Filter**" from the drop-down menu. Check the "**Unique records only**" box.
 * 1) //You'll notice the further down the worksheet you scroll, the more rows were skipped.// Click on any cell with data. Use "**Ctrl+A**" to select all the filtered data, and then from "Edit," select "Copy".
 * 2) Insert a **new worksheet** (Sheet 3) and from "**Edit**," select "**Paste**". __Only__ the filtered data should be pasted. Scroll down to the bottom to check. //Our high school has 599 unique classes, for example. If you still have 11000 or so, go through steps 8-12 again!//
 * 3) Save the workbook as "**Creating Classes.xls**".
 * 4) __THEN__, while (Sheet 3) is displayed, save that sheet as a **Classes.csv** file. //From "File," select "Save As" and then change the "Save as Type" from "Microsoft Excel Workbook (xls)" to "Comma Delimited File (csv)"//. Microsoft will pitch a fit--answer all the prompts with "OK" or Yes". Close the workbook.

Upload to Edline

 * 1) Login as a school Administrator
 * 2) Under "Command Center," select "QuickSync"
 * 3) Change the "Type of data" to "Standard Class Upload" and find the ***.csv** file you created. //Edline will not accept multiple-page Excel workbook uploads, so if you have a "Creating Classes.xls" file and a "Classes.csv" file, you need to upload "Classes.csv". You'll see an error message if you try to upload the "Creating Classes.xls" file.//