Help for Class Lists

The Class Lists application allows instructors to view their class list or retrieve an electronic version of their class list.  The electronic class list is sent to the instructor's Penn State Access Account (e-mail address).

Two different data formats are available: Spreadsheet and E-mail Distribution.

For detailed instructions on using the Class List data in a spreadsheet, database or e-mail distribution list, contact your department's technical support staff.

For additional information refer to Class Lists Frequently Asked Questions.
 

Spreadsheet Format

The Spreadsheet Format contains the following information:
 
Field
Description
Maximum Size
 
Student Id 
 
 
The student's Id. 
 
 
A9
 
 
Name 
 
 
The student's name in the format: 
LastName FirstName MiddleInitial. 
 
 
A40
 
 
Access Id 
 
 
The student's Penn State Access Account (e-mail address). 
 
 
A8
 
 
Campus Location 
 
 
The student's campus location code. 
 
 
A2
 
 
Semester Classification 
 
 
The student's semester classification code. 
 
 
A2
 
 
Major 
 
 
The student's major code. 
 
 
A5
 
 
Registration Status Message 
 
 
The student's registration status: 

   blank (student's registration is complete) 
   Registration Not Complete 
   Late Dropped on <late drop date> 
   Withdrew on <withdrawal date> 
 

 
A35
 
 
Course Credits 
 
 
The number of course credits for the student. 
 
 
A4
 
 
Course Audit Indicator 
 
 
A = student is taking the course for Audit 
 
 
A1
 
 
Graduating Indicator 
 
 
Y = student intends to graduate this semester 
 
 
A1
 
 
Local Telephone Number 
 
 
The student's local telephone number. 
 
 
A10
 
 
Gender
 
The student's gender
 
A1
 
 

The data from the Spreadsheet Format is delimited with quotes and commas and can be imported into a spreadsheet or database application.

General Instructions on Importing the Class List data into a Spreadsheet:

  1. Copy the Class List information from your e-mail message to your clipboard.  (Note: Turn off the "Wrap Long Lines" feature in your e-mail software.)
  2. Save your clipboard information to a text file.  (Notepad can be used for this function.)
  3. In EXCEL, select File and Open.
  4. Select the text file that you saved in step 2.
  5. Follow the Text Import Wizard instructions. (Choose Comma for the Delimiter and " as the Text Qualifier.  Set the Column Data Format for ALL columns to Text.)


General Instructions on Importing the Class List data into a Database:

  1. Copy the Class List information from your e-mail message to your clipboard.  (Note: Turn off the "Wrap Long Lines" feature in your e-mail software.)
  2. Save your clipboard information to a text file.  (Notepad can be used for this function.)
  3. In ACCESS, select File, Get External Data, and Import.
  4. Select the text file that you saved in step 2.
  5. Follow the Import Text Wizard instructions.  (Choose Comma for the Delimiter and " as the Text Qualifier.  Set the Data Type for ALL fields to Text.)

E-mail Distribution Format:

The E-mail Distribution Format contains the following information:
 
Field
Description
Maximum Size
 
Access Id 
 
 
The student's Penn State Access Account (e-mail address). 
 
 
A8
 
 
Name 
 
 
The student's name in the format: 
(LastName FirstName MiddleInitial.) 
 
 
A40
 
 
 

The data from the E-mail Distribution Format can be used for an e-mail distribution list.
 

General Instructions on using the Class List data for an E-mail Distribution List:

  1. Copy the Class List information from your e-mail message to your clipboard.  (Note: Turn off the "Wrap Long Lines" feature in your e-mail software.)
  2. Create a new e-mail distribution list.
  3. Paste the Class List information into your new e-mail distribution list.