students.csv

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?