If you have multiple sections in your course, you can repeat this for all sections, but this does not always lead to the best results. For example, if you enter the multiple CRNs, you lose the section designation for all students, and Syncronize Rolls funtions do not work. In order to retain section designations for all students, you need to create your own student data file, and import the data into WebCT later on. If you are not interested in retaining section designation or updating WebCT records from your Excel files, you don't have to read the rest of this file.
Passwords can be anything the instructor chooses for each student.
If they appear on the right as numbers, something you did converted the text into numbers. Make sure you have 4 characters in the password including the leading zeros for all students. Then do a Copy-Paste operation to paste this cell into all the other cells as explained above. The first row must be the labels. Excel removes all formating information automatically if you save it as a tab-delimited text file .