Microsoft Outlook 2007
Using Getlist and Gradebook
The getlist and gradebook features are available to faculty and staff members at UW-Eau Claire through Outlook email. The commands allow a faculty/staff member to receive a list of the students in a particular class or members of a distribution list as an email message. This information can be put into a worksheet or word processing document for establishing a gradebook, an attendance record, etc.
About Getlist and Gradebook
The gradebook command is similar to the getlist command and provides additional information beyond the getlist command. The one you use to obtain a list of students will depend on your needs and how you are using the information in your gradebook. Each command returns the following:
- The getlist command will return email name, last name, first name, middle initial.
- The gradebook command will return last name, first name, middle initial, email name, University ID, classification.
Obtaining a List of Students
In order to obtain a list of students in a particular class, you must indicate the list name in the correct format. For more information on list name formats, refer to Email Distribution Lists for Students.
-
Create a new message
-
In the To... text box, type gradebook or getlist
-
In the Subject text box, type the semester term, class department, course number, and section number, separated by periods
EXAMPLE: 0675.math.110.001 -
Click SEND
The results will be sent to you via email.
Using the List Results in a Worksheet
Lists obtained by using either getlist or gradebook may be used in a variety of applications and formats, including worksheets (e.g., Microsoft Excel). The following tips provide some general guidance for moving the information into a worksheet. The same principles apply to moving the information into a word processing application (e.g., Microsoft Word).
-
The email message can be copied and pasted into a worksheet. If you do this, the record for each student appears on a separate row. Information is not divided into columns (i.e., column A will contain all information for one student.). You can use the text to columns command to separate the information into separate columns.
-
The email message can be saved as text only (.txt) and opened in Excel. If you do this, Excel's Text Import Wizard will guide you through the process of converting the information to a tab-delimited format.
-
Once the information is in the worksheet, you may need to adjust column widths and delete unnecessary information, (e.g., names and social security numbers of instructors).
Electronic Gradebook Submission
Faculty who have questions about electronic gradebook submission should contact Donna Raleigh (36-5162, draleigh) in the Network for Excellence in Teaching (NET).
