DOWNLOADING ROSTERS INTO EXCEL FROM WEB ADVISOR

by Mary Dermody, DVC Faculty/Staff Development Center

Using Netscape Navigator   See below for Internet Explorer directions.

Log onto the Internet.

Go to the Contra Costa College home page at:

http://www.contracosta.cc.ca.us

Click on the WebAdvisor link

CCC main page

At the WebAdvisor site, click on Access Faculty Menu.

Then click on Class Roster.

WebAdvisor main menu

To login, click in the user name box. Type in your Colleague ID number and your password, then click on Submit.

Your Colleague ID number is listed on your paycheck stub.

Your date of birth is your password (unless you change it). Use the format MMDDYY to enter your birthdate. Example: 040149

WebAdvisor login screen

Next to Select A Term click on the drop down arrow and choose the semester you want.

Click on Submit.

Webadvisor term selection box

 

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.

WebAdvisor class selection screen

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.

Save box

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

 

Open File box

 

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

Your roster will now open in an Excel spread sheet.

Error message

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.

Excel screen

 

Using Internet Explorer

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.

Copy roster screen

Open Excel.

Go to the Edit menu and click on Paste.

Excel paste

You can now add, delete or expand columns.

Save your Excel file as an Excel Worksheet.

Excel ad function