Class Lists

What you need to know about E-class lists

The Electronic Class List System through AccessPlus allows Iowa State University instructors and designated department personnel to view class lists, individual student information (including his/her photo and contact information), and section add/drop activity. In addition, the class lists can be downloaded and imported into a software program such as Excel, Word, or a database.

E-class list highlights

  • Student photo
  • Active e-mail link
  • Graduation indicator
  • Add/drop activity by date
  • Downloadable comma-delimited file
  • Access for instructors and (by request) departmental personnel

 

Logging into AccessPlus

Information about your university ID and password can be found by clicking on “Login Method” link on the AccessPlus screen. AccessPlus is available most hours of the day, although there are some exceptions.

Accessing the files

Please note the following when accessing your class lists:

  • Instructors must sign onto AccessPlus using a university ID and password.
  • Class lists are available to instructors teaching the classes as coded on the Registrar's instructor files (departmental offices are responsible for loading instructor information to the Registrar’s files).
  • Class lists are generally available on AccessPlus one month ahead of the first day of classes.
  • You will be logged out after a ten-minute period of inactivity.
  • FERPA and ISU confidentiality guidelines apply to downloading, viewing and printing class lists.

 

Confidentiality guidelines

Iowa State University follows requirements of the Family Educational Rights and Privacy Act (FERPA). The link, “Confidential Information Policies” on any of the class list screens provides more information about FERPA and Iowa State University’s guidelines. Also note: a padlock icon notes those students who have requested that some or all of their information not be released. When e-mailing to several students, use the BCC (blind copy) field for their e-mail addresses to shield the e-mail address from other recipients and guard against a “no information released” e-mail from being displayed to other students. Also see E-mail lists below.

Importing class list files

The class list file downloaded to your computer is comma/quote delimited and can easily be imported into popular desktop software. To import the file, open up the software package. Next use the "file/open/import" option to open and import the file. The columns in the file are separated by commas and each field is delimited by double quotes ("). The file is text, not numeric. For further assistance, please consult with your department’s computer support staff.

Saving the download file

When downloading a class list, your first step is to save the file. When saving class list files to your computer, name the file something that you can easily remember. If the file location is unknown, locate the file by using the Find or Explore options that are included in your workstation operating system. File names all begin with the semester name and year such as FALL2010, SPRING2011, or SUMMER2011, and end with the course and section. Example: FALL2010FCEDS3011 (fall 2010 class list for FCEDS 301, section 1).

Creating e-mail lists

After you've saved your class list, you can create an e-mail list in your e-mail program. Copy and paste the list of e-mail addresses from your saved file (exclude the column header) into your e-mail program. Just be sure to use the BCC line (blind carbon copy) to ensure that the e-mail names are hidden from the recipients. (See "Confidentiality guidelines" above. For more detail about creating an e-mail list choose E-mail your Class.

Classlist Layout

Column Heading

Column Length

Description

Semester 6 Summer, Fall or Spring
Year 4 4-digit year of term
Teach 5 Teaching dept. abbreviation; Typically the dept. responsible for the course
Offer 5 Offering department abbreviation; For cross-listed courses, offering department may be different than teaching department
Crse 4 Course number
Sect 2 Section identifier
Common List 1 A "Y" in this column indicates that the section is a combination section. For example, Acct 284 sections A1, A2, and A3 all meet in the same room at the same time and are combined into a single section "A".
Chng Date 10 The date the schedule change was processed; Format is YYYY-MM-DD
Chng Time 8 The time the schedule change was processed; format is HHMMSS.T where HH represents hours, MM represents minutes, SS represents seconds and T represents tenths of a second; time is recorded using a 24-hour clock
Chng Type 13 Description for the change. Values are: "credit change" "add" "withdrew" or "drop"
Efctv Date 10 The effective date of the schedule change; format is YYYY-MM-DD
Crdt Type 1 The type of credit; F-fixed, R-required, A-audit, Z-zero
Credit 4 The number of credits for which the student is enrolled in the course
Univ ID 9 The student's University ID number
No Info Rel 30 Students may choose to restrict the use of their directory information. Possible messages in this field include NO EMAIL/ADDR/PHONE RELEASE, NO EMAIL RELEASE, NO ADDR/PHONE RELEASE or NO INFORMATION RELEASE.
Name 25 Student name - last name followed by first name then middle name
Name Chng 1 A "Y" in this field indicates the student's name has recently changed.
First Name 20 Student's first name - upper/lower case
Middle Name 20 Student's middle name - upper/lower case.
Last Name 30 Student's last name - upper/lower case
Major 5 Student's curr/major abbrv. For graduate students, this is the student's dept.
College 1 College of curriculum/major - A-Agriculture, C-Design, E-Engineering, H-Human Sciences, M-Business, S-LAS, V-Vet Med, U-Interdisciplinary
Clsfn 1 Classification or year-in-school; 1-Freshman, 2-Sophomore, 3-Junior, 4-Senior, 5-non-degree seeking undergrad, 6-graduate student, 7-off-campus graduate student, 8-non-degree seeking off-campus undergrad
2nd Major 5 Student's second curriculum/major
2nd College 1 College of second major. See college codes listed above
Email 50 Student's e-mail address
Grad Ind 1 Graduation term. Values are "S" "1" "F"
In Street 26 Student's in-session street address
In City/St 26 Student's in-session city and state
Zip 9 Student's in-session zip code
Home Phone 10 Student's home phone #
Day/Night 1 Is home phone # student's day or evening number? D-Day, E-Evening
Work Phone 20 Student's work phone # (if available)
Day/Night 1 Is work phone# student's day or evening number? D-Day, E-Evening