FROM E-MAIL TO THE MAC or PC (Using Microsoft Excel)

Electronic class lists can be sent to your e-mail account each quarter, which saves you the trouble of typing in student names and perm numbers. These step-by-step instructions show you how to download a class list to the Mac or PC, and then bring it into the Excel spreadsheet program.

Logon to your UNIX account and enter ELM

1. Double-click the Telnet icon on the desktop (or use Telnet and open psych.ucsb.edu in LSCF).
2. Enter your username and password when prompted.
3. Type "elm" and press Enter at the condor% prompt to startup the electronic mail program.

Save your class list using the "s" command within ELM

1. Highlight the mailbox entry of the file you want to save (using the arrow keys).
2. Tap the "s" key to indicate you want to save the message.
3. Type "class.unx" and press Enter (without the quotes) and with NO equal sign in front of it (if you use the equal sign it saves the class.unx file in the Mail subdirectory of your unix account, but we want it to go to your Home directory, so do NOT use the "=").
4. Type # and press enter (where # is the mailbox entry number to the left of your class list).
5. Tap "u" to undelete the class list (the mailbox entry you saved in Step 2 was previously marked "D" for DELETION from your mailbox, but now it will not be deleted).
6. Tap "q" to quit ELM.
7. Type "bye" at the condor% prompt to log off.

Login to your home drive

MAC instructions: Connect to YourHome(username@condor)

1. Go to the Apple icon and select Chooser.
2. Select AppleShare (top-left) and PSYCH-ENet 113 (bottom-left) and dbl-click ushare@condor (right).
3. Press the Tab key, then type your username, Tab again and type your password, then press Enter.
4. Double click on YourHome(username@condor).
5. Select the box at the top-left corner of the Chooser window to exit the Chooser program.

PC instructions: Login to your H: drive

1. Start the login routine from the Stut down menu.
2. Enter your username and password when prompted.

Bring the file into Excel

1. Start Microsoft Excel by locating and double-clicking the Excel icon.
2. Go to File and select Open.
3. Select the box below List Files of Type: (bottom-left) then select All Files.
4. Open the main directory of your home drive and dbl-click class.unx to open the class list into Excel .
5. Provide the necessary information to the conversion wizard to correctly format the file.
   Click on Delimited to select a delimited format, and then click Next > .
   In the Delimiter box, click on Tab to deselect it and click on Comma to select it, and then click Finish.

Delete unnecessary information and save as an Excel file

1. Select box 1 to the left of the first row and drag down to 2 rows above the first entry of your class list Leave one row immediately above the list of student names blank (it's for adding column labels later).
2. Go to Edit and select Delete.
3. Select box E above the fifth column and drag right until column K is selected.
4. Go to Edit and select Delete.
5. Go to File and select Save As...
6. Change the name of your file from class.unx to class.xls.
7. Select the file type to be saved as a Microsoft Excel Workbook and click Save when information is correct..

Note: You are now ready to use the class list in Excel. Consult the companion document Using Excel to Keep Grades for instructions on setting up formulas, sorting scores, printing postings, and printing graphs.

Department | Research | Graduate Studies | Undergraduate Studies
News & Events | People | Search | Home