Skip to content

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

education-data-source-scorecard

Verified

College Scorecard — post-enrollment outcomes linking aid records to IRS/Treasury earnings. Earnings, loan repayment, debt via six Portal sub-datasets. Use when tax-record-based earnings needed. Tracks only Title IV aid recipients, not all students.

references/completion-rates.md

View on GitHub
# Completion Rates

College Scorecard provides completion metrics from several sources: some reproduce IPEDS graduation rates, while NSLDS-based measures differ significantly from them. Understanding these differences is critical for valid analysis.

> **Portal note:** Completion rate variables (e.g., `C150_4`, `C150_4_POOLED`) are from the original Scorecard naming scheme. The Portal mirror datasets do not include a separate completion rates dataset. Completion data may be embedded in other Scorecard bulk downloads available at `collegescorecard.ed.gov`. The Portal's 6 Scorecard datasets focus on earnings, default, repayment, institutional characteristics, and student body characteristics. For completion rates, consider using the IPEDS graduation rates dataset (`ipeds/colleges_ipeds_grad-rates`).

## Scorecard Completion Measures Come From Different Sources

| Measure family | Source | Population |
|---|---|---|
| `C100_*`, `C150_*`, `C200_*` (incl. `_POOLED`, race and Pell/loan splits) | IPEDS Graduation Rates / 200% GR | Full-time, first-time degree/certificate-seekers — the same cohort as IPEDS GR |
| `OMAWDP8_*`, `OMENRAP8_*`, `OMENRYP8_*`, `OMENRUP8_*` | IPEDS Outcome Measures | FT/PT × first-time/non-first-time entering cohorts |
| NSLDS-based completion/transfer outcomes (e.g., `COMP_ORIG_YR*_RT` = completed at the original institution, at 2/3/4/6/8 years; not calculated in the most recent data file) | NSLDS | Title IV aid recipients; enrollment dates estimated from FAFSA |

`C150_4` is NOT a Title IV-recipient rate and excludes part-time and transfer-in students; it should equal the IPEDS 150% graduation rate for the same cohort.

## Scorecard Completion Cohorts

### Who Is Included (NSLDS-based measures only)

Students in Scorecard completion cohorts:
- Received Title IV aid
- Placed in an entry cohort from first Title IV aid receipt plus FAFSA grade level (not restricted to first-time students)
- Both full-time AND part-time
- All entry terms (not just fall)

### Who Is Excluded (NSLDS-based measures only)

| Excluded Group | Why |
|----------------|-----|
| Non-Title IV students | Not in NSLDS |
| — | Transfer students appear in both cohorts: separately for each institution where they received Title IV aid (transfer-ins join the receiving institution's cohort in the year first aided there) |

## Completion Time Frames

### Standard Metrics

| Variable | Time Frame | Applicable To |
|----------|-----------|---------------|
| `C150_4` | 150% of normal time | 4-year institutions |
| `C150_L4` | 150% of normal time | Less-than-4-year institutions |
| `C200_4` | 200% of normal time | 4-year institutions |
| `C200_L4` | 200% of normal time | Less-than-4-year institutions |

### What "150% Normal Time" Means

| Program Length | 150% Time | Example |
|---------------|-----------|---------|
| 4-year degree | 6 years | Bachelor's: 6 years to complete |
| 2-year degree | 3 years | Associate's: 3 years to complete |
| 1-year certificate | 1.5 years | Certificate: 18 months |

### Extended Time Frames

| Variable | Description |
|----------|-------------|
| `COMP_ORIG_YR2_RT` | Completion rate within 2 years |
| `COMP_ORIG_YR3_RT` | Completion rate within 3 years |
| `COMP_ORIG_YR4_RT` | Completion rate within 4 years |
| `COMP_ORIG_YR6_RT` | Completion rate within 6 years |
| `COMP_ORIG_YR8_RT` | Completion rate within 8 years |

## Completion Variables

### Institution-Level

| Variable | Description |
|----------|-------------|
| `C150_4` | 150% completion rate, 4-year |
| `C150_L4` | 150% completion rate, <4-year |
| `C150_4_POOLED` | Pooled 150% rate, 4-year |
| `C150_4_POOLED_SUPP` | Pooled 150% rate, 4-year, suppressed for small n (a rate, not a flag) |

### By Student Characteristics

| Variable Pattern | Description |
|-----------------|-------------|
| `C150_4_WHITE` | Completion by race |
| `C150_4_HISP` | Hispanic students |
| `C150_4_BLACK` | Black students |
| `C150_4_2MOR` | Two or more races |
| `C150_4_PELL` | Pell Grant recipients |
| `C150_4_LOANNOPELL` | Direct Subsidized Loan recipients that did not receive a Pell Grant (first-year status) |
| `C150_4_NRA` | Non-resident aliens |

### By Completion Status

| Variable | Description |
|----------|-------------|
| `COMPL_RPY_*` | Completers repayment rate |
| `NONCOM_RPY_*` | Non-completers repayment rate |
| `COMP_ORIG_YR*_RT` | Completion by year |

## Pooled vs Annual Cohorts

### Annual Cohorts

- Single entry year
- Higher suppression rates
- More volatility

### Pooled Cohorts

- Multiple entry years combined
- Lower suppression rates
- More stable estimates
- Variables contain `_POOLED`

**Recommendation:** Use pooled cohorts when available for more reliable estimates.

## Transfer-Adjusted Completion

### Transfer Tracking

Scorecard's NSLDS-based measures can track completion at ANY institution because NSLDS follows students (the IPEDS-sourced `C150_*`/`C200_*` rates cannot):

| Scenario | IPEDS | Scorecard NSLDS-based measures |
|----------|-------|-----------|
| Start at CC, complete at 4-year | Counts as non-completer at CC, not counted at 4-year | Counted as completion |
| Start at School A, transfer to School B, complete | Non-completer at A, not in cohort at B | Counted as completion |

### Transfer-Out Rate

| Variable | Description |
|----------|-------------|
| `TRANS_4_POOLED` | Transfer rate, 4-year |
| `TRANS_L4_POOLED` | Transfer rate, <4-year |

## Completion by Pell Status

Critical for equity analysis:

| Variable | Description |
|----------|-------------|
| `C150_4_PELL` | Completion rate, Pell recipients |
| `C150_4_LOANNOPELL` | Completion rate, Direct Subsidized Loan recipients without a Pell Grant |
| `C150_4_NOLOANNOPELL` | Completion rate, students who received neither a Direct Subsidized Loan nor a Pell Grant |
| `PELL_COMP_ORIG_YR*_RT` | Pell completion by year |

The data dictionary (fetched 2026-10-19) has no single non-Pell `C150_4` variable; non-Pell students are split across `C150_4_LOANNOPELL` and `C150_4_NOLOANNOPELL`.

### Pell Completion Gap

Most institutions show completion gaps:
- Pell recipients typically complete at lower rates
- Gap size varies by institution type
- Closing this gap is policy priority

## Outcome Measures Beyond Completion

### Completion OR Transfer

| Variable | Description |
|----------|-------------|
| `OMACHT6_FTFT` | Completed or transferred within 6 years, FTFT |
| `OMACHT8_FTFT` | Completed or transferred within 8 years, FTFT |

### Still Enrolled

| Variable | Description |
|----------|-------------|
| `ENRL_ORIG_YR*_RT` | Still enrolled at N years |

### Withdrawal

| Variable | Description |
|----------|-------------|
| `WDRAW_ORIG_YR*_RT` | Withdrawal rate by year |

## Interpreting Completion Rates

### Low Completion Rate May Indicate

| Possibility | Implication |
|-------------|-------------|
| Poor student support | Negative |
| Serves at-risk population | Context needed |
| High transfer-out rate | May complete elsewhere |
| Part-time student body | Takes longer to complete |
| Open admissions | Broader access mission |

### High Completion Rate May Indicate

| Possibility | Implication |
|-------------|-------------|
| Strong student support | Positive |
| Selective admissions | Prepared students |
| Traditional student body | Full-time, on-campus |
| Favorable demographics | May not be replicable |

## Comparing Completion Rates

### Valid Comparisons

- Similar institution types (4-year public to 4-year public)
- Similar missions (open-access to open-access)
- Same time frame (150% to 150%)
- Same cohort definition (NSLDS-based to NSLDS-based; Scorecard `C150_*` to IPEDS GR is the same cohort)

### Invalid Comparisons

| Comparison | Problem |
|------------|---------|
| Scorecard NSLDS-based measures to IPEDS GR | Different cohort definitions (`C150_*` is the IPEDS GR cohort) |
| 4-year to 2-year | Different time expectations |
| Selective to open-access | Different student preparation |
| Annual to pooled | Different aggregation |

## Suppression in Completion Data

### When Suppression Occurs

| Condition | Action |
|-----------|--------|
| < 30 students in the combined (pooled) cohort | `*_POOLED_SUPP` versions suppressed; the base `_POOLED` measure uses a four-year cohort instead (see `POOLYRS*`) |
| Small subgroup cells | Disaggregated rates suppressed |
| Very small programs | May lack any completion data |

### Variables Indicating Suppression

> **Note:** Completion rate variables from the original Scorecard use various suppression indicators. In Portal mirror data, check the actual data for suppression patterns — some datasets use `null`, others use `-3`. Always verify against the codebook (use `get_codebook_url()` from `fetch-patterns.md`).

| Data Pattern | Meaning | Notes |
|--------------|---------|-------|
| `null` | Suppressed or missing | Common in rate columns |
| `-3` | Suppressed for privacy | Common in earnings/count columns |
| Valid rate (0-1) | Actual completion rate | Valid data |

## Recommended Practices

### For Completion Analysis

1. **Know your cohort** - `C150_*`/`C200_*` = IPEDS GR cohort; NSLDS-based measures differ
2. **Use pooled rates** when available for stability
3. **Consider transfers** - Low completion may mean high transfer
4. **Check suppression** - Small cohorts may lack data
5. **Note Title IV limitation** - NSLDS-based measures include only aid recipients

### For Equity Analysis

1. **Disaggregate by Pell status** - Critical equity indicator
2. **Compare gaps within institution types**
3. **Consider context** - Access vs completion trade-offs
4. **Use multiple years** - Single-year data volatile

### Reporting Recommendations

```
Adequate: "The 6-year graduation rate is 65%"

Better: "The 6-year completion rate for full-time, first-time students 
        (150% time) is 65%, per College Scorecard (C150_4)"

Best: "The 6-year completion rate for full-time, first-time students is 65% 
      (150% of normal time; Scorecard C150_4, which reports the IPEDS 
      graduation-rate cohort and excludes part-time and transfer-in 
      students). Completion rates for Pell recipients (55%) trail students 
      who received neither a Pell Grant nor a Direct Subsidized Loan (72%)."
```

## Common Pitfalls

| Pitfall | Why It's Wrong |
|---------|---------------|
| Comparing Scorecard NSLDS-based rates to IPEDS rates | Different populations tracked (Scorecard `C150_*` is the IPEDS GR cohort) |
| Ignoring transfer-out rates | Students may complete elsewhere |
| Treating all institutions equally | Mission and selectivity vary |
| Using annual rates for small schools | High volatility, suppression |
| Ignoring equity gaps | Overall rates mask disparities |
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