UPLOADING CLASSROLLS FROM eLC TO WEBWORK.

Click here to return to the main page.
  • First, log into eLC. Scroll down and click on the correct class.
  • Click on "Grades", then "Enter Grades", then "Export".
  • Make sure the following options are selected:
  • Click "Export to Excel." This will open a popup message.
  • Click the course link in the Export Grades pop up window. (That should save the file to your downloads folder, or wherever your download files save.)
     
  • Open the excel file that you just saved. Your excel file should have these four columns: OrgDefinedId, Username, Last Name, First Name. If it doesn't, then go back to step 3 and make sure the correct options are selected. This is a good time to save your file. Click File, then Save As. It might be a good idea to save the file on the desktop and name it something shorter and more meaningful.
     
  • You are now ready to edit your excel file. If you cannot do so, you might have to click "Enable Editing" at the top of the page. For all these steps, leave the first four columns alone. Please also type everything that is listed below in bold, and type it verbatim, including quotes. Also, column spacing is not important.
     
  • In cell E1, type: =CONCATENATE(A1,",",C1,",",D1,",","C",",,,,"," ",B1,"@uga.edu",",",B1) (You can copy everything in bold and paste it onto that cell.) Your excel file should now look like this.  If you have multiple sections, please click here.


     

  • If you have n number of students, highlight cells E1 to E(n+1). Then push Control+D. This should now populate your cells. Your file should look like the image below.

     
  • Now log into your WebWork class and go to File Manager.
     
  • Click on New File, then give your new file a name. Suggestion: Class.lst (That's an L, not a one.)
     
  • Click New file. Then go to your Excel file and copy cells E2 to E(n+1). Yes, that's E2, not E1.
     
  • Paste those cells onto the file manager on WebWork, then click save.
     
  • Back under Instructor Tools, click on Classlist Editor2, then select Import. Pick your new file from the dropdown menu and click Take Action!.
     
  • This will populate your class. Their username is their myID and their password is their student number.

 

 

Uploading Class Rolls with Multiple Sections.

 

  • In Cell E1, type your class call number. Then populate that column.
  • In cell F1, type: the code below.
    =CONCATENATE(A2,",",C2,",",D2,",","C",",,",E2,",,"," ",B2,"@uga.edu",",",B2)  
    (You can copy everything in bold and paste it onto that cell.) 
  • If you have n number of students, highlight cells F1 to F(n+1). Then push Control+D. This should now populate your cells. Your file should look like the image below.

     
  • Now log into your WebWork class and go to File Manager.
     
  • Click on New File, then give your new file a name. Suggestion: ClassA.lst (That's an L, not a one.)
     
  • Click New file. Then go to your Excel file and copy cells F2 to F(n+1). Yes, that's F2, not F1.
     
  • Paste those cells onto the file manager on WebWork, then click save.
     
  • Back under Instructor Tools, click on Classlist Editor2, then select Import. Pick your new file from the dropdown menu and click Take Action!.
     
  • This will populate your class. Their username is their myID and their password is their student number.
  • Repeat as necessary to import more sections.