Edline+-+Teacher+data

**OLD WAY TO GET:** Edline Teacher data file
You only have to do the Teacher Upload __once a year__ (unless your staffing changes drastically). You're going to get information from the "User Accounts" tab in STARS, so if you don't have access, find the STARS superuser in your building (//generally the Principal or an Assistant Principal)//. > **STARS LastName = Edline Teacher Last Name** //(column B)// > **STARS FirstName = Edline Teacher First Name** //(column C)//
 * 1) Login to STARS, from "School Admin," select "User Accounts" from the drop-down menu. //See the image to the right.//
 * 2) Copy and paste the first three columns to a new Excel File.
 * 3) The STARS "User Accounts" table columns correspond to the following **Edline Teacher File Upload** column headings
 * 1) The STARS User ID can be used as the Edline TeacherID for all __staff__ members, but for Teachers, you need to reindex.
 * 2) Save the Excel file as "STARS UserIDs.xls"

**Reindexing Teachers**
//Convert STARS UserID to STARS TeacherID so classes match properly// > //That formula should return the last name of the teacher, followed by the first two letters of the teacher's first name.// > **=CONCATENATE(TRIM(C2),", ",LEFT(TRIM(D2),2))** > //That formula should return the last name of the teacher, followed by the first two letters of the teacher's first name.//
 * 1) **Login** to STARS, and from "Reports," select "**Variable Reports**".
 * 2) Create a **New Variable Report** called "Edline Teacher Upload"
 * 3) Add the following **Report Fields**
 * 4) from the "Current Schedule" table, "**TeacherID**"
 * 5) from the "Current Schedule" table, "**Teacher Full**"
 * 6) In the "Format Output" section, select the "**MS Excel**" radio button, and click the "**Print**" button.
 * 7) **Save** the Excel file as "TeacherIDs.xls"
 * 8) **Open** the "STARS UserIDs.xls" file.
 * 9) Right-click on Sheet 1 in the "STARS UserIDs.xls" file and select "**Move or Copy**" from the pop-up menu.
 * 10) In the "Move or Copy" window, change the "To Book" to the "**Teacher IDs.xls**" book, and highlight the "**(move to end)**" option. Click "**OK**".
 * 11) **Close** the "STARS UserIDs.xls" file.
 * 12) **Rename** "Sheet 1 (2)" (//which contains the STARS UserIDs//) "STARS IDs".
 * 13) Delete rows 1, 2, and 4 of the "Sheet 1" worksheet (//to eliminate the unnecessary header info)//
 * 14) Highlight all data in columns A and B on the "Sheet 1" worksheet.
 * 15) From "**Data**," select "**Filter**" and then "**Advanced Filter**"
 * 16) In the "Advanced Filter" window, select the "**Filter the List, in place**" radio button, and then check the "**Unique Records Only**" checkbox. Click "**OK**".
 * 17) Click to select any cell in column A or B which has data. Use **Ctrl+A** to highlight all filtered data. Use **Ctrl+C** to copy all filtered data.
 * 18) From "**Insert**" select "**Worksheet**"
 * 19) Click to select cell A1. From "**Edit**," select "**Paste Special**". Select the "**Values**" radio button in the "Paste" section and click "**OK**"
 * 20) **Rename** Sheet 3 "Teacher IDs". //Depending on the size of your faculty, you should have somewhere around 150-200 teachers listed at this point.//
 * 21) Insert a new column to the left of Column A in the "Teacher IDs" worksheet.
 * 22) In the newly inserted Column A on the "Teacher IDs" worksheet, create an index using the following formula: **=LEFT(TRIM(C2),FIND(",",TRIM(C2))+3)**
 * 1) From "Edit", select "Fill Down" to repeat for the rest of the teachers in the "Teacher IDs" worksheet.
 * 2) Select the "Stars IDs" worksheet. Insert a new column to the left of Column A.
 * 3) In the newly inserted Column A on the "STARS IDs" worksheet, create an index using the following formula:

Upload to Edline
Go to your Edline site, and login as an Administrator.
 * 1) From "Command Center," select "QuickSync"
 * 2) Change the "Type of data" to "Standard Teacher Upload"
 * 3) find the ***.csv** file you created, and upload. //Make sure to check before you permanently upload!//