Skip to Content

Project Success

students.csv

The students data file will provide demographics information and other characteristics for each student of the institution. This file should be provided each requested academic period to track new students as they enter the institution. Students should only be included when they first enroll in the institution under a distinct status (i.e. entry_academic_period = Requested Academic Period). Definitions for status are provided in the table below. This file should include one row per student ID and distinct status.

Examples can be found for each column in the image above or here in the sample file.

Note that column names are case sensitive and must be listed exactly as shown below.

Column Name Acceptable Values
id Student ID provided by the institution
first_name
  • Student's first name
  • No commas
  • Use "NoFirstName" if student does not have an associated first name on file
last_name
  • Student's last name
  • No commas
  • Use "NoLastName" if student does not have an associated last name on file
date_of_birth
  • Student's day and year of birth
  • dd/yyyy* (may use 00/0000 if student DOB has not been provided)
    *Please click here for instructions to format this column correctly.
ethnicity
  • Student's ethnicity
  • One of (must be exact as shown below):
    • American Indian or Alaska Native
    • Asian
    • Black or African American
    • Hispanic
    • Native Hawaiian or Other Pacific Islander
    • White
    • Two or more races
    • Race/ethnicity unknown
    • Nonresident alien
gender
  • Student's gender
  • One of:
    • M
    • F
    • Unknown
    • Other
  • Empty cell
status
  • Student entry status indicator where:
    • FTFT (First-time full-time student)
    • FT (First-time only student) (for first-time part time)
    • FTGRAD (First-time graduate student)
    • TRANSFER (Transfer student)
    • OTHER (Other status)
entry_academic_period
  • Academic period of initial enrollment for this student under the specific status code
    • One of Winter yyyy, Spring yyyy, Summer yyyy, Fall yyyy. Where yyyy is the 4-digit year format
exclusion_type
  • IPEDS cohort exclusion type
  • This should only be provided if a student should be excluded from the graduating cohort. IPEDS states that an exclusion can only happen if one of the documented exclusion types occurs within 150% of normal time to completion for their program
  • One of:
    • Deceased
    • Armed_Forces
    • Foreign_Aid_Service
    • Church_Mission
  • Empty cell
exclusion_academic_period
  • Academic period in which an IPEDS cohort exclusion might have occurred
    • One of Winter yyyy, Spring yyyy, Summer yyyy, Fall yyyy. Where yyyy is the 4-digit year format
  • Empty cell
act_composite
  • Student composite ACT score
  • a whole number between 1-36 without commas or quotes
  • Empty cell
act_math
  • Student math ACT score
  • a whole number between 1-36 without commas or quotes
  • Empty cell
act_english
  • Student english ACT score
  • a whole number between 1-36 without commas or quotes
  • Empty cell
act_reading
  • Student reading ACT score
  • a whole number between 1-36 without commas or quotes
  • Empty cell
sat_combined
  • Student combined SAT score
  • a whole number between 400-1600 without commas or quotes
  • Empty cell
sat_math
  • Student math SAT score
  • a whole number or decimal between 200-800 without commas or quotes
  • Empty cell
sat_verbal
  • Student verbal SAT score
  • a whole number or decimal between 200-800 without commas or quotes
  • Empty cell
sat_reading
  • Student reading SAT score
  • a whole number or decimal between 200-800 without commas or quotes
  • Empty cell
hs_gpa
  • Student high school GPA
  • a decimal between 0.0-5.x without commas or quotes
  • Empty cell
hs_city
  • City where student attended high school
  • Empty cell
hs_state
  • State where student attended high school
  • Empty cell
hs_zip
  • Zip Code where student attended high school
  • Blank or empty
email
  • Student's email address assigned by the college
entry_age
  • Student entry age in years
  • a whole number between 1-110 without commas or quotes
  • Empty cell
ged
  • Student received GED indicator
  • One of:
    • TRUE
    • FALSE
  • Empty cell
english_2nd_language
  • English as a second language indicator
  • One of:
    • TRUE
    • FALSE
  • Empty cell
first_generation
  • Student first generation indicator
  • One of:
    • TRUE
    • FALSE
  • Empty cell

Questions?

What file format does my file need to be in?
When is my file due?
Where do I drop my file?