Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-ipeds

education-data-source-ipeds

Verified

IPEDS — primary federal postsecondary data (~5,800 Title IV institutions, administrative offices, and U.S. service academies, 5,829 in the 2024-25 collection; 1979-present in the mirror; IPEDS replaced its predecessor HEGIS in 1986, so the earliest mirror years predate IPEDS): enrollment, completions, graduation rates, finance, aid, admissions, HR. For college/university analysis. Grad rates = first-time full-time; finance needs GASB/FASB care.

references/enrollment-data.md

View on GitHub
# IPEDS Enrollment Data

Understanding the different enrollment measures in IPEDS and when to use each.

> **CRITICAL: Portal Integer Encoding**
>
> The Education Data Portal uses **integer codes** for categorical variables. Key enrollment codes:
>
> | Variable | Code | Meaning |
> |----------|------|---------|
> | `level_of_study` | 1 | Undergraduate |
> | | 2 | Graduate |
> | | 99 | Total |
> | `ftpt` | 1 | Full-time |
> | | 2 | Part-time |
> | | 99 | Total |
> | `degree_seeking` | 0 | No |
> | | 1 | Yes |
> | | 99 | Total |
> | `class_level` | 1 | First-time |
> | | 2 | Other (transfer-ins) |
> | | 3 | Other (continuing) |
> | | 4 | Other (total) |
> | | 99 | Total |

## Contents

- [Two Enrollment Surveys](#two-enrollment-surveys)
- [Fall Enrollment (EF)](#fall-enrollment-ef)
- [12-Month Enrollment (E12)](#12-month-enrollment-e12)
- [Full-Time Equivalent (FTE)](#full-time-equivalent-fte)
- [Enrollment Categories](#enrollment-categories)
- [Distance Education](#distance-education)
- [Retention Rates](#retention-rates)
- [Common Analysis Issues](#common-analysis-issues)

## Two Enrollment Surveys

IPEDS collects enrollment data through two separate surveys:

| Survey | Timing | Purpose | Best For |
|--------|--------|---------|----------|
| Fall Enrollment (EF) | Point-in-time (fall census) | Traditional headcount | Institution size comparison |
| 12-Month Enrollment (E12) | Full academic year | Unduplicated total | True scope of students served |

**Key Difference**: A student enrolled in both fall and spring is counted ONCE in E12 but appears in fall EF only.

## Fall Enrollment (EF)

### When Collected

Spring collection period (December-April) for the previous fall semester.

### Census Date

- **Academic year reporters**: Institution's official fall reporting date
- **Program reporters**: Students enrolled between August 1 and October 31

### What Is Counted

Total students enrolled in credit-bearing courses as of the census date.

### Key Breakdowns

| Dimension | Categories |
|-----------|------------|
| Attendance status | Full-time, Part-time |
| Level | Undergraduate, Graduate (First-professional only through 2008) |
| Undergraduate type | First-time, Transfer, Continuing, Non-degree |
| Race/ethnicity | 9 categories |
| Gender | Men, Women |
| Residence (even years) | State of residence for first-time students |
| Age (odd years) | Age distribution |
| Distance education | Exclusively DE, Some DE, No DE |

### Limitations

- Point-in-time snapshot
- May not capture students in short-term programs
- Doesn't show full year enrollment patterns
- Different institutions have different census dates

## 12-Month Enrollment (E12)

### When Collected

Fall collection period (August-October) for the prior academic year (July 1 - June 30).

### What Is Counted

**Unduplicated headcount**: Each student counted only once regardless of number of terms enrolled.

### Key Components

1. **Unduplicated headcount** by level, race/ethnicity, gender
2. **Instructional activity** (credit hours attempted)
3. **Full-time equivalent (FTE)** enrollment

### Advantages Over Fall Enrollment

| Fall EF | 12-Month E12 |
|---------|--------------|
| Misses spring-only enrollees | Captures all enrollees |
| Misses summer enrollees | Captures summer |
| May undercount at non-traditional schools | Better for year-round schools |
| Snapshot can be misleading | Full picture |

### When to Use Each

| Use Case | Recommended Survey |
|----------|-------------------|
| Comparing institution sizes | Fall EF |
| Calculating per-student metrics | E12 or FTE |
| Traditional 4-year institutions | Either (similar) |
| Community colleges | E12 (captures more students) |
| For-profit institutions | E12 (rolling enrollment) |
| Year-round programs | E12 |

## Full-Time Equivalent (FTE)

FTE standardizes enrollment across institutions with different full-time/part-time mixes.

### FTE Calculation Methods

**12-month FTE (E12)**: total 12-month instructional activity ÷ a standard full-time load. For semester-calendar institutions, undergraduate credit hours ÷ 30 and graduate credit hours ÷ 24 (Portal enrollment-full-time-equivalent documentation). Divisors differ for quarter-calendar and clock-hour reporting; check the E12 instructions for the reporting year. Institutions may report their own FTE instead (`rep_fte` vs derived `est_fte`).

### FTE vs Headcount

| Measure | When to Use |
|---------|-------------|
| Headcount | Counting individuals |
| FTE | Comparing across institutions |
| FTE | Per-student calculations |
| FTE | Resource allocation analysis |

### FTE Data Quality Issues

1. **Different calculation methods**: Credit vs clock hour
2. **Part-time estimation**: Not always precise
3. **Cross-sector comparison**: Different student intensity patterns
4. **Program mix**: Short programs vs degree programs

### FTE in Per-Student Metrics

Common calculations using FTE:

```python
# Expenditure per FTE
exp_per_fte = total_expenditures / total_fte

# Revenue per FTE  
rev_per_fte = total_revenue / total_fte

# Faculty to student ratio (uses fall enrollment)
ratio = fall_enrollment / instructional_faculty
```

```r
# Expenditure per FTE
exp_per_fte <- total_expenditures / total_fte

# Revenue per FTE
rev_per_fte <- total_revenue / total_fte

# Faculty to student ratio (uses fall enrollment)
ratio <- fall_enrollment / instructional_faculty
```

## Enrollment Categories

### By Attendance Status

| Status | Definition |
|--------|------------|
| Full-time | Enrolled for 12+ semester hours or equivalent |
| Part-time | Enrolled for fewer than 12 semester hours |

Note: Definition varies by institution and term type (semester vs quarter).

### By Student Level

| Level | Definition |
|-------|------------|
| Undergraduate | Enrolled in bachelor's or lower program |
| Graduate | Enrolled in master's or doctoral program |
| First-professional | Enrolled in professional degree (JD, MD, etc.) (through 2008 only) |
| Unclassified | Not classified by level |

### By Enrollment Status (Undergraduates)

| Status | Definition |
|--------|------------|
| First-time | Never previously enrolled at ANY postsecondary institution |
| Transfer | Previously enrolled at another institution |
| Continuing | Enrolled previous year at same institution |
| Returning | Previously enrolled at same institution but not last year |

### Degree-Seeking Status

| Status | Definition |
|--------|------------|
| Degree-seeking | Enrolled in program leading to award |
| Non-degree-seeking | Taking courses but not in a program |

## Distance Education

### Definitions (since 2012-13)

| Category | Definition |
|----------|------------|
| Exclusively distance education | All courses are distance education |
| Some but not all distance education | Mix of DE and in-person |
| Not enrolled in any distance education | All in-person |

### Distance Education Definition

A course where instruction is delivered:
- Using one or more technologies to deliver instruction to students separated from instructor
- Supports regular and substantive interaction between students and instructor
- Synchronous or asynchronous

### Data Availability

- Fall enrollment by DE status: 2012-13+
- Completions by DE status: 2012-13+
- COVID impact: 2020-21 data shows dramatic shifts

### Common Uses

```python
# Percent of students in distance education
pct_de_any = (exclusively_de + some_de) / total_enrollment * 100

# Percent exclusively online
pct_exclusively_online = exclusively_de / total_enrollment * 100
```

```r
# Percent of students in distance education
pct_de_any <- (exclusively_de + some_de) / total_enrollment * 100

# Percent exclusively online
pct_exclusively_online <- exclusively_de / total_enrollment * 100
```

## Retention Rates

### Definition

Percentage of first-time students who return to the same institution the following fall.

### Calculation

```
Retention rate = (First-time students returning in fall Y+1) / 
                 (First-time students in fall Y) * 100
```

### Full-Time vs Part-Time

IPEDS reports separate retention rates:
- Full-time first-time student retention
- Part-time first-time student retention

### Limitations

- Only tracks first-time students (not transfers)
- Only at same institution (transfer = not retained)
- Full-time/part-time status based on initial enrollment

### Using Retention Data

| Use | Caution |
|-----|---------|
| Institutional effectiveness | Reflects student selection too |
| Early warning indicator | Better than 6-year lag of grad rates |
| Peer comparison | Compare within peer groups |

## Common Analysis Issues

### Issue 1: Comparing Enrollment Across Institution Types

**Problem**: Different institutions serve different populations.

| Institution Type | Typical Pattern |
|-----------------|-----------------|
| Research university | FT undergrad, FT grad heavy |
| Community college | PT heavy, year-round enrollment |
| For-profit | Rolling enrollment, PT common |

**Solution**: Compare within peer groups; note composition differences.

### Issue 2: Year-Over-Year Changes

**Problem**: Single-year changes may reflect data issues, not trends.

**Solution**: 
- Look at multi-year trends
- Check for institutional changes
- Verify with other sources

### Issue 3: First-Time Student Definition

**Problem**: "First-time" means never attended ANY college, including:
- Dual enrollment in high school
- Summer programs

**Impact**: Some students counted as "transfers" were actually first-time college students.

### Issue 4: FTE vs Headcount for Per-Student Metrics

**Problem**: Using headcount when FTE is more appropriate (or vice versa).

| Metric | Recommended Denominator |
|--------|------------------------|
| Instruction spending per student | FTE |
| Student services per student | Headcount or FTE |
| Graduation rate | Cohort count |
| Room & board revenue per student | Residential headcount |

### Issue 5: COVID-19 Impact

**2020 and 2021 data** show significant disruptions:
- Enrollment declines
- Shift to distance education
- Changed retention patterns

**Recommendation**: Note pandemic years when analyzing trends.

## Variable Reference

> Verify these variable names against the live codebook. Use `get_codebook_url()` from `fetch-patterns.md`. Portal variable names may differ from NCES documentation.

### Fall Enrollment Key Variables (Portal Names)

The `fall-enrollment-race` (yearly) dataset provides the main fall enrollment data. Key columns:

| Portal Variable | Description |
|-----------------|-------------|
| `enrollment_fall` | Fall enrollment count |
| `race` | Race/ethnicity (integer codes: 1-9, 99=Total; some 1986-1997 files also carry 20=Other) |
| `sex` | Sex (1=Male, 2=Female, 99=Total; 3=Gender Not-Identified from 2022; 9=Unknown in 2023 and 2024; the 2022 file has an undeclared 4 and no 9) |
| `level_of_study` | 1=Undergraduate, 2=Graduate, 99=Total |
| `ftpt` | 1=Full-time, 2=Part-time, 99=Total |
| `class_level` | 1=First-time, 2=Transfer, 3=Continuing, 4=Other total, 99=Total |
| `degree_seeking` | 0=No, 1=Yes, 99=Total |

To get institution-level totals, filter to `race == 99`, `sex == 99`, `ftpt == 99`, `level_of_study == 99`.

#### NCES Raw File Names (for reference only)

| NCES Name | Portal Equivalent | Notes |
|-----------|-------------------|-------|
| `EFTOTLT` | `enrollment_fall` (filtered to totals) | Portal uses disaggregated rows |
| `EFFT` | `enrollment_fall` where `ftpt == 1` | Full-time subset |
| `EFPT` | `enrollment_fall` where `ftpt == 2` | Part-time subset |
| `EFDEEXC` | Not in fall-enrollment-race | Check separate dataset |

### 12-Month Enrollment Key Variables

The `enrollment-fte` dataset provides FTE and headcount data. Consult the codebook for the current variable list:

```python
url = get_codebook_url("ipeds/codebook_colleges_ipeds_enrollment-fte")
```

```r
# get_codebook_url() is a Python helper; in R, construct the URL directly
# or use the codebook path from datasets-reference.md
```

> **Note:** The variable names below are from NCES documentation and may differ in the Portal. Always verify against the actual data or codebook.

| NCES Name | Description |
|-----------|-------------|
| `efytotlt` | Total 12-month unduplicated headcount |
| `efyug` | Undergraduate 12-month |
| `efygr` | Graduate 12-month |
| `fteug` | Undergraduate FTE |
| `ftegr` | Graduate FTE |
| `ftetot` | Total FTE |

### Retention Variables

The `fall-retention` dataset provides retention rates. Consult the codebook:

```python
url = get_codebook_url("ipeds/codebook_colleges_ipeds_fall-retention")
```

```r
# get_codebook_url() is a Python helper; in R, construct the URL directly
# or use the codebook path from datasets-reference.md
```

> **Note:** Variable names below are from NCES documentation and may differ in the Portal.

| NCES Name | Description |
|-----------|-------------|
| `ret_pcf` | Full-time retention rate |
| `ret_pcp` | Part-time retention rate |
| `ret_nmf` | Full-time students in retention cohort |
| `ret_nmp` | Part-time students in retention cohort |
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall