Microsoft Entourage 2004
Using Getlist and Gradebook
The getlist and gradebook features are available to faculty and staff members at UW-Eau Claire through their Entourage Exchange email account. These features allow a faculty/staff member to receive a list of information about students in a particular class or members of a distribution list in an email message. This information can be put into a worksheet or word processing document to establish a gradebook, an attendance record, or another related document.
About Getlist and Gradebook
The gradebook and getlist features are very similar; however, the gradebook feature retrieves more information than the getlist command. The feature you choose will depend on how you plan to use the information in your gradebook. The commands return the following:
Getlist
Retrieves students' last names, first names, middle initials, and usernames.
Gradebook
Retrieves students' last names, first names, middle initials, usernames, university IDs, and classifications.
Obtaining a List of Students
In order to obtain a list of students in a particular class, you must send a message with the correct format as described below. For more information on list name formats, refer to Using Student Distribution Lists.
-
In the To text box, type gradebook or getlist
-
Press [return]
-
In the Subject text box, separated by periods, type the semester term, department name (in lowercase letters), course number, and section number of the class
NOTE: For more information on list name formats, refer to Using Student Distribution Lists.
EXAMPLE: Type 0671.math.109.005
-
Click SEND NOW
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 and word processors. The following tips provide some general guidance for moving the information into worksheets:
-
If you copy and paste an email message to a worksheet, the record for each student appears on a separate row. Information is divided into columns (e.g., column A will contain the full name, column B will contain the username, and so on) even though the columns may not have lined up correctly in the email response.
-
The email message can be saved as a text only file (.txt) and opened in Excel. If you choose to do this, Excel's Text Import Wizard will guide you through the process of converting the information.
-
Once the information is in the worksheet, you may need to adjust column widths and delete unnecessary information.
