DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-scorecard
education-data-source-scorecard
VerifiedCollege 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 22.3 KB |
| references/completion-rates.md | markdown | 10.5 KB |
| references/data-quality.md | markdown | 11.5 KB |
| references/debt-repayment.md | markdown | 11.6 KB |
| references/earnings-data.md | markdown | 11.6 KB |
| references/field-of-study.md | markdown | 12.4 KB |
| references/population-coverage.md | markdown | 9.5 KB |
| references/variable-definitions.md | markdown | 25.3 KB |
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 |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |