Downloading Rosters Into Excel From Web Advisor

Using Explorer

Using Netscape

Locating Your Roster in WebAdvisor

1. Go to the WebAdvisor address at: http://207.62.211.227/openweb/index.html.   
       Be sure that you type the URL correctly.  The address is not case sensitive. 

2.  At the WebAdvisor site, click on login.

3.  Type in your user name on the first line, and your date of birth or password on the second line, and click submit.
       If you are entering your date of birth use the format MMDDYY.

4.  Click on Access Faculty Menu.

5.  Click on Class Roster.

6.  Next to Select A Term click on the drop down arrow and choose the semester you want to work with, and click on Submit.
       You don't need to enter anything in the date range.

7.  Click in the box next to the class roster you want to work with and click on Submit.
       You can only choose one class at a time.

8.  You will now see your class roster.

Using Internet Explorer

1. When your roster is open, click drag your cursor across and down the entire roster (include student name, ID, etc.)
   
   

2.  Go up to your menu and click on Copy.
   
   

3.  Open Excel and go to your menu and click on Paste.
   
   

4.  You can now add, delete or expand columns. Save your Excel file as an Excel Worksheet.

 If you are using Netscape Navigator

1. Go up to your menu at the top of the page and under File choose and then Save As. 

2. Choose where you want to save your file. 

3. If you get a message that says, “This Web page may not save correctly”, just click on OK. 

4. Also, in the box that says “Save as Type” your file says HTML file, just click on Save. 
        You can choose your Floppy A Drive, your desktop, or any other place where you save your files
   

5. Open Excel.

6. On your menu, click on File and Open. 

7. When the window opens that says Look In choose the location where you have saved your roster. 

8. Click on your file and then Open. The file will end with  .WebAdvisor 
       If you do not see your file, click on Files of Type and choose All Files
   .

9. You will probably get an error message…Don’t Worry, just click on OK.
    

10. Your roster will now open in an Excel spreadsheet.
     

11. At this point, you can do several things to format your roster.

12. You can choose columns or rows that you don’t want and either Cut or Delete them. 

13. Or, you can Select and Highlight the information you want, go up to Insert on the menu, choose Worksheet and paste the information on the new, blank worksheet. 

14. Save your Excel file as an Excel Worksheet.