Printing the WebCT gradebook

1) On the "Manage Students " page, in the top right hand corner of the page, find “OPTIONS:RECORDS.Select action DOWNLOAD, then click GO. 
 

2) You should then see a screen that says "Download student records". In the box next to where it says "record separator" you should see the word COMMA in the box. Select COMMA. Then click on the word download again. 
 

3) A box will appear which says "Would you like to open or save it to your computer?".Below that statement. Select the phrase "SAVE ". Then click the OK button. 

4) Another window opens which is entitled SAVE AS. The recommended method is to select 3½ Floppy A so as to guarantee that you do not save the file to a hard drive where it may need to be deleted (especially in the lab). If you save it to a floppy disk you do not have to worry about deleting the file off of the computer when you are finished. You then need to give the file a name. To do this you would type the name of the file in the box next to the words "File name". A sample name could be something like GRADES105015 (grades for section 105.015). Then choose in the SAVE AS TYPE box "ALL FILES".  When you have finished all of these steps click on SAVE.

5) The computer will then show a picture of a file folder moving paper from one file to another and the download is complete. Close this box. Now to open the file go to EXCEL . After you have opened EXCEL, go to FILE and then to OPEN. In the box next to the words LOOK IN, choose the location of your file (preferably on a 3½ Floppy). Next to FILES OF TYPE, choose "All Files". Now select the name you gave the file and click on OPEN.

6) A window will now open that says "Text Import Wizard step 1 of 3" Check the bubble next to the word DELIMITED, then click on the word NEXT

7) In the next window entitled "Text Import Wizard step 2 of 3", you need to check the small square box next to the word COMMA and then click on NEXT

8) A third window appears "Text Import Wizard step 3 of 3". Under the heading "Column data format", select the word GENERALthen click on the word FINISH

9) You will now see an EXCEL version of the data from the WebCT gradebook, to print this document go to FILE. Then choose PRINT. To print in landscape format, go to the box marked PROPERTIES and click on it. Go to PAPER and then click on the bubble next to Landscape and then click OK. You now return to the PRINT window, click OK and the data will print out. If landscape printing is not important to you in the PRINT box just go directly to OK instead of clicking on PROPERTIES. 

10) YOU HAVE NOW SUCCESSFULLY PRINTED YOUR WebCT gradebook, if you did not save the file to a 3½ Floppy disk, make sure to delete file from the hard drive of the computer on which you were working. If you saved the file to a floppy disk, take the floppy with you. Remember this information is confidential.

 
Don't hesitate to ask if you have any questions or problems following these instructions.