Student+Logins+-+Modifying+Class+Lists+(VoiceThread)

Please see the Tech Liaison if you do not have a class list of student logins in CSV format.
 * Modification of "Student Logins, Class List" for VoiceThread Account Creation**

**Modify the Student Logins, Class List CSV file**
> //This is the **default** if you or the Tech Liaison followed the directions on this wiki here.//
 * 1) Put your class list of student logins in the following **column order**:
 * **Column A:** Last Name, First Name
 * **Column B:** BCPS AccountID (//students' username)//
 * **Column C:** BCPS Password
 * **Column D:** CourseNo
 * **Column E:** ClassSection
 * **Column F:** TeacherFull
 * 1) As of 05/28/2009, based on [|this sample file] on VoiceThread's Manage Class page, the **desired import order** is as follows:
 * **Column A:** Student Name
 * **Column B:** Student Identity (//alias)//
 * **Column C:** Student Email (//can be fake)//
 * **Column D:** Student Password
 * 1) Keep **Column A**, and **insert** a new column to the right of it--enter the following formula in the first cell (//**B2** if you're keeping a header row//) to generate a "Student Identity" for VoiceThread with just the First name and the Last initial: **=CONCATENATE(RIGHT(TEXT(A2,""),LEN(A2)-FIND(",",A2)-1)," ",LEFT(A2,1))**
 * 2) **Fill Down** to populate the rest with student identities.
 * 3) **Insert** a new column to the right of Column B (//the new "Student Identity" column you created in Step 3)//. Create a fake BCPS email for the students to login using the following formula: **=CONCATENATE(TRIM(D2),"@bcps.org")**
 * //where// **D2** is the cell containing the StudentIDs for the first student (//STARS seems to add leading and/or training spaces to the StudentIDs--dunno--so to avoid errors, use the **TRIM** function to remove them//)
 * 1) **Fill Down** to populate the rest with //fake// student email addresses.
 * 2) **Save** the sheet as a CSV file (//ignore the warnings about the four horsemen of the apocalypse)//. **Close** the file. **Re-open it** (//you'll notice the formulas have been erased and now you just have values.//
 * 3) **Delete** the unnecessary columns--the StudentID, CourseNo, ClassSection, and TeacherFull (//If you didn't save and close the CSV in Step 7, you'll end up with #REF errors...//)
 * 4) **Save** the sheet as a CSV file, and **Close** it.

Upload the //Modified// class list to VoiceThread
> > //You will have the opportunity to preview and then print if you'd like.// > //Side note for building and/or district uploads...it appears possible to add another column ([|Getting your Classroom Started] VoiceThread) with "educator" and "student" distinctions...maybe call VoiceThread Tech Support if interested in this option.//
 * 1) **Login** to VoiceThread, click your username, and select "**Manage Class**" from the list
 * 1) Click on the "**Add Members**" link, click "**Browse**," find your //modified// class list CSV file, and "**Upload**" it.
 * 1) **Follow the rest of the directions** to upload.