Uploading Your Excel Grade Book into WebCT

Once you've created your roster file in Excel, you need to upload the file to your WebCT course. Remember that you need to upload the text version of your file (.txt for tab-delimited or .csv for comma delimited) not the Excel version (.xls). This text file will be imported into your Manage Student database so it is accessible to the students.

Watch a video on this process created by Tony Basilico

Step 1	Log in to your WebCT course.
Step 2	Click on Designer Links in the far left corner of your home page. Note: If you do not see Designer Links, click on the grey Control Panel button.
Step 3	Click on Manage Files.
Step 4	Under the Options: Files menu on the right, click on the Upload button.
Image 1
Step 5	Click on the Browse button next to the Upload File area at the bottom of the window to locate your text file on your computer or disk. Make sure you select the text version of your file (either .txt or .csv - usually has a little notepad symbol next to it ) and NOT the Excel workbook file (.xls - which has the green Excel symbol ). Click on the Open button.
Image 2
Step 6	Once the filename is listed in the Filename: box, click on the Upload button. This will put a copy of your file in the WebCT File Manager area called My-Files. Your file is now ready to be linked to the Manage Student database.
Step 7	Next, click on Manage Course under Designer Links on the left side of the window. Note: If you don't see Designer Links, click on the grey Control Panel button.
Step 8	Under Manage Students, click on the Add or Import students link
Image 3
Step 9	Once the Add or Import students window opens, scroll down to the Import From File section. Click on the Browse button to locate the file you just uploaded into the My-Files folder. Click in the circle next to the file to select it and then click on the Add selected button.
Image 4
Step 10	When the file is showing next to the Filename: box, click on the Import button. (Make sure you select either the Comma or Tab Separator to match your file format).
Image 5
Step 11	WebCT may respond in different ways depending on the circumstances. The first time you upload this file you will see WebCT confirm the column names that match those automatically included in the Manage Student database. For example, First Name, Last Name and User ID. When you upload the file after adding new grades each week, you will see WebCT confirming that it sees a new column. The system should only adjust the database to show new information. It should leave any existing information in the course intact. Also note that any grades that are added by students taking electronic quizzes within WebCT cannot be adjusted from Excel.
Step 12	If everything matches correctly, you can click on the grey Continue button at the bottom of the Import Confirmation screen. You should see a progress bar as WebCT imports the revised data into the Manage Students grade book. Note that it may take a little longer as your grade book file grows from week to week, especially if you are doing this from home. That's it! Once the grades have been imported into the WebCT Manage Student database your students just click on the My Grades icon and they will see their own grades. Note that if you want to see what a student sees, you must log in from a student account. The My Grades icon won't work if you are logged in as the instructor.

To add the My Grades Icon:

Click on Add Page or Tool from the menu on the right side of the home page
Under the Student Tools column, click on My Grades
Type in a title that will be easy to understand for the students, like Check My Grades
Click in the box next to On an Organizer Page to select where to display the icon (the default is the Homepage but you can change that if you wish)
Click on the grey Add button at the bottom of the window
That’s it! You should now see the My Grades icon on your course home page

Tip: If students complain that they can't see their latest grade and you can see the grades in your Manage Students grade book, check to make sure you released the column.