So, you’ve got your password and email address set. Now it’s time to set up the course for your students.

In order to populate your course with the students who are enrolled, and the easiest way is to download your roster from MyInfo. If you use BlackBoard or CUNYFirst, you will not get all the student information that we require. Note: CUNY MyInfo will require your PORTAL login credentials, not your CUNYFirst login.

I’ve created an Excel spreadsheet that will automatically generate the spreadsheet you’ll need. Download it here: ClasslistTemplate.xls. Follow the directions included in the file and you should be all set! You’ll need your students’ names, CUNY IDs and their email addresses. All of which you should have gotten when you downloaded your rosters from MyInfo. Paste the columns of information into their appropriate places and the sheet will warn you of any potential problems before you proceed. If you see any cells turn red or purple, then the included instructions will tell you how to fix it. Once all the cells turn green, save the sheet that says “SAVE THIS SHEET AS A .CSV FILE” (as a .csv file, of course!), upload it, import it, and you’re all set!

The following steps are included if for some reason the ClasslistTemplate does not work for you. (In which case, please contact me and let me know, or leave a comment on this page.)

Create a new spreadsheet and copy-paste the necessary information into the columns as follows:
colA: this will be the student’s password (student passwords should match their CUNY ID number)
colB: Last name.
colC: First name.
colD: “c” for all rows.
colE: The student’s CUNY ID number – download your roster from CUNYFirst to retrieve this information.

colF,&G: empty.
colH: student’s email address
colI: student’s login name (I recommend using students’ first initial followed by their last name, no capitalization, no punctuation)
colJ: blank
colK: 0 for all students.

The final outcome should look like this for each student:

Note: make sure that your name is not included in the classlist file.

Save the file as a .csv (comma-separated values) file.

Login to your course on the WeBWorK server.

Find the ‘File Manager’ link on the left side of the page and click it.

You’ll see a greyed out button for Upload: and next to it a button for ‘Choose File’ or ‘Browse’ – click it and find your .csv file, then click upload (which will no longer be greyed out).

Your .csv file will now appear somewhere in the list of files (you may have to scroll down to find it). Find it in the list, and click it, then click the ‘Rename’ button to the right of the list. Replace the “.csv” at the end of the filename with “.lst” instead.

Confirm that the filename is now .lst instead of .csv, then click “classlist editor” in the lefthand column.

Select the circle next to “Import users from …” and select your filename.lst from the dropdown menu, then click “Take Action!”

Congratulations! You should now see all of your students listed in a grid at the bottom of the page.

Inform your students of their login names and passwords – advise them to change their passwords to something they’ll be sure to remember, and change their email to an address that they check regularly (only necessary if you’re planning on sending them email).