WeBWork class roster import

One way to import classroster into WeBWork (at SU):

  1. Download the roster from Blackboard Grade Center and import it into a spreadsheet
  2. The first four columns A,B,C,D will be Last Name, First Name, UserName, Student ID.
  3. Append the column with the function
    =CONCATENATE(D2,",";A2,",",B2,",C,,,,",C2,"@syr.edu,",C2)

    (second row shown). Or

    =CONCATENATE(D2;",";A2;",";B2;",C,,,,";C2;"@syr.edu,";C2)

    if using OpenOffice.

  4. Using WeBWork file manager, create a file roster.lst and paste this new column into it.
  5. Use the Import Users command under Classlist editor.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s