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 (email address).

Two different data formats are available: Spreadsheet and Email Distribution.

For detailed instructions on using the Class List data in a spreadsheet, database or email 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 (email 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 email message to your clipboard.  (Note: Turn off the "Wrap Long Lines" feature in your email 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 email message to your clipboard.  (Note: Turn off the "Wrap Long Lines" feature in your email 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.)

Email Distribution Format:

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

The data from the Email Distribution Format can be used for an email distribution list.
 

General Instructions on using the Class List data for an Email Distribution List:

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