DOWNLOADING ROSTERS INTO EXCEL FROM WEB ADVISOR
Using Netscape Navigator See below for Internet Explorer directions.
|
Log onto the Internet. Go to the Contra Costa College home page at: Click on the WebAdvisor link |
|
|
At the WebAdvisor site, click on Access Faculty Menu. |
|
|
To login, click in the user name box. Type in your Colleague ID number and your password, then click on Submit. |
|
|
Next to Select A Term click on the drop down arrow and choose the semester you want. |
|
|
Click in the box next to the class roster you want and then click on Submit. You can choose only one class at a time. You will now see your class roster. |
|
|
Go up the browser menu at the top of the page and click on File, then on Save As. |
|
|
Choose where you want to save your file. You can choose your Floppy A Drive, your desktop, or any other area where you save your files. If you get a message that says, "This Web page may not save correctly", just click on OK. In the box that says "Save as Type" your file will say HTML file. Just click on Save. |
|
|
Open Excel. (You don’t have to exit from WebAdvisor)On its menu, click on File and Open. When the Look In window opens, choose the location where you have saved your roster. If you do not see your file, click on Files of Type and choose All Files Click on your file and then Open. Note that the file will end with the extension .WebAdvisor |
|
|
You will probably get an error message…Don’t Worry. Just click on OK Your roster will now open in an Excel spread sheet. |
|
|
At this point, you can do several things to format your roster. You can choose columns or rows that you don’t want and either Cut or Delete them. 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. Save your Excel file as an Excel Worksheet. |
|
|
This is even easier!!! Follow the previous directions to get to and open your roster in WebAdvisor. When your roster is open, drag your cursor across the roster (include student name, ID, etc.) Go up to the browser menu and click on Copy. |
|
|
Open Excel. Go to the Edit menu and click on Paste. |
|
|
You can now add, delete or expand columns. Save your Excel file as an Excel Worksheet. |
|