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 GENERAL, then 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.
|