nlsy97 schooling data
DESCRIPTION
NLSY97 Schooling Data. Cohort Overview. NLSY97 Schooling Objectives. Correct NLSY79 seam problem Re-reporting enrollment status for a particular month Event history format Correct NLSY79 grade reversals Verify/correct status from last interview HGC, HGA, & enrollment status - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/1.jpg)
NLSY97 Schooling NLSY97 Schooling DataData
![Page 2: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/2.jpg)
Cohort OverviewCohort Overview
NLSY791957-64
NLSY971980-84
1st round: year1st round: age
197914-21
199712-16
Latest round Latest yearAgesNext interview
22200641-512008
10200721-272008
Middle SchoolHigh SchoolCollege
NoneSomeYes
SomeYesYes
![Page 3: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/3.jpg)
NLSY97 Schooling NLSY97 Schooling ObjectivesObjectives
• Correct NLSY79 seam problem– Re-reporting enrollment status for a particular
month– Event history format
• Correct NLSY79 grade reversals– Verify/correct status from last interview
• HGC, HGA, & enrollment status– Event history of schools
• Account for inconsistencies due to changing schools – Event history of grade attendance (loops)
• Account for skipping/repeating grades– Collect/confirm data from other sources
• Parent questionnaire• Transcript data
• Collect detailed information on schools
![Page 4: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/4.jpg)
NLSY97 Questionnaire NLSY97 Questionnaire StructureStructure
(YSCH-, NEWSCHOOL_)(YSCH-, NEWSCHOOL_)• Confirm status at last interview date
– Highest grade attended/completed & enrollment • Confirm and correct prior round data• Report information for current round
• Report schools attended since last interview– Enrollment periods at each school
• Survey program creates NEWSCHOOL roster– Schools listed in the order reported
• ‘Loop’ though questions specific to each school– Primary & secondary schools– Colleges
![Page 5: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/5.jpg)
Data Collected on Each Data Collected on Each Primary/Secondary SchoolPrimary/Secondary School
• For each school – School type– Grades and dates attended
• Gaps in attendance• Suspensions
– Program of study in high school
• General Schooling data– SAT/ACT scores– Expected graduation date– Diploma/GED receipt
![Page 6: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/6.jpg)
Data Collected for Each Data Collected for Each CollegeCollege
• School information – Public/private– IPEDS code in Geocode data
• Credit progression– Number began at school with
• Sources
– Attempted per term– Earned per term– Number required to graduate
![Page 7: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/7.jpg)
Each College…Each College…
• Per term information (loops)– Beginning date– 1st and 2nd majors– Full/part time status– GPA– Cost and financing
• Degree – Type received – Date received
![Page 8: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/8.jpg)
Other Schooling InformationOther Schooling Information• YSCH: School-based learning programs
– Enrolled in grades K-12– Time spent on work site
• Days or weeks & hours
– Amount if paid– Classes taken in conjunction with school
• YCOC: College choice section (round 7+)– 1983 & 1984 birth cohorts– Term & year of applications– Applied for financial assistance– Acceptances including financial aid offered– IPEDS code in Geocode data
![Page 9: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/9.jpg)
Parent Questionnaire (PC8-)Parent Questionnaire (PC8-)• Relevant ages
– Age at 1st grade– Age at 7th grade– Age attended head start
• Historical schooling information – Skipped and/or repeated grades– Gaps in attendance (1 month+)– Took classes during break
• Special programs– Remedial, Special, Gifted, or Bilingual
Education
• Parent interviews for 88.4% respondents– Collected in 1997
![Page 10: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/10.jpg)
Transcript Survey (TRANS_)Transcript Survey (TRANS_)• School information
– Summary information• If, when, and why left school• GPA, class rank• Graduation requirements
– Participation in programs• Special, Gifted, or Bilingual Education
– Scores on standardized tests• PSAT, ACT, SAT, AP, other
• Academic year information– Absent & tardy spells– Credit weighted GPA – % New Basics credits earned
![Page 11: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/11.jpg)
Transcript Survey…Transcript Survey…• Term information
– Month/year enrolled, academic year– Credits earned & Grade level (e.g., 7th, 8th)
• Course information– Subject Code– Credits earned and standardized grades
• Notes– Collected from last school attended– 2 waves
• 1999-2000 & 2004 [TRANS_STATUS]• Survey year for both=1999
– Transcript data for 69.4% respondents
![Page 12: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/12.jpg)
Data Source SummaryData Source Summary• Pre-survey schooling history
– Parent Questionnaire– YCHR section in NLSY97 interview
• R6-R9: Grades skipped/repeated
• Current schooling history– NLSY97 Interview
• Single Item Verification• Event History
• Retrospective high school history– Transcript Survey
• High school course history• Final outcome
![Page 13: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/13.jpg)
NLSY97 Intended Results NLSY97 Intended Results • More complete picture of educational
history– Transition from middle to high school [for some]– Transition between schools
• E.g., high school to high school
– Transition out of high school
• Additional data on schools attended• Additional data on types of courses taken• Information on alternative trajectories
– Alternative schools/home schooling– Unique situations
• Incarceration• Pregnancy
![Page 14: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/14.jpg)
Desired OutcomesDesired Outcomes
• Within the survey round– HGA>=HGC– Grade level changes only if enrolled
• Between survey rounds & other sources– HGC never decreases– The highest degree received never
decreases– Grade consistency
• Prior round survey grades• Transcript grades
![Page 15: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/15.jpg)
NLSY97 Unintended ResultsNLSY97 Unintended Results
• More sources=more chances for conflict– Within surveys
• E.g., HGC doesn’t match event history grade
– Between surveys• E.g., R8 HGC<R7 HGC
• Reporting problems in the event history– Unknown dates
• Problematic for grade confirmation
– Report 1st grade at school not since DLI
• Data harder for researchers to use
![Page 16: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/16.jpg)
NLSY97 Schooling DataNLSY97 Schooling DataPUBID=3807PUBID=3807
![Page 17: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/17.jpg)
PUBID=3807PUBID=3807
• Data from Parent Questionnaire– Age entered 1st grade=6 – Year entered 1st grade=1990 – Age entered 7th grade=12
• 1996-1997 school year
– Didn’t repeat/skip any grades
• Projected graduation date– 2001/02 school year
![Page 18: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/18.jpg)
PUBID=3807PUBID=3807HGA
[YSCH-2857]
HGC[YSCH-3112]
Enrollment[YSCH-3878]
Round 1 7 7 1
Round 2 9 8 1
Round 3 10 9 1
Round 4 11 10 1
Round 5 12 11 1
Round 6 12 12 1
Round 7 12* 12 1
Round 8 14 13 1
![Page 19: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/19.jpg)
Round School idNEWSCHOOL_
Grade completed
Grade began
Expected graduation
date
2101 [1]
201202
7th
(6/97)
8th (6/98)
8th
(8/97)
9th (8/98)
6/02
3 202 9th
(6/99)
10th
(8/99)6/02
4 202 10th
(6/00)
11th
(8/00)6/02
5 202 11th
(5/01)- 5/02
6 202 12th
(5/02)- n/a
![Page 20: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/20.jpg)
Transcript Survey Transcript Survey (TRANS_TERM_)(TRANS_TERM_)
Term #
GRADE START_DATE END_DATE
.01 9 8/1998 6/1999
.02 10 8/1999 6/2000
.03 11 8/2000 5/2001
.04 12 -3/2001 -3/2002
![Page 21: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/21.jpg)
PUBID=3807PUBID=3807
• Youth Questionnaire– High school graduation date
• May 2002 reported in r6• YSCH-11900
– Highest degree received • High school degree [3] in rounds 7 & 8• YSCH-3113
• Transcript data– TRANS_LEFT_REASON=Graduated [1]– TRANS_LEFT_DATE~M/~Y=-3/2002
![Page 22: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/22.jpg)
Which Source Is Correct?Which Source Is Correct?
PUBID=3807• Enrollment in School 201 never ends• Mismatch between HGA and loops
– HGA=12– Loop report never attended 12th – R5
• Mismatch between reported HGA– R7 HGA=12– R8 HGA verification R7 HGA=13
![Page 23: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/23.jpg)
NLSY97 Schooling DataNLSY97 Schooling DataPUBID=7746PUBID=7746
![Page 24: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/24.jpg)
PUBID=7746PUBID=7746
• Data from Parent Questionnaire– Age entered 1st grade=7– Year entered 1st grade=1989– Age entered 7th grade=14
• 1996/97 school year
– Repeated 6th grade– Didn’t skip any grades
• Projected graduation date– 2001/02 school year
![Page 25: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/25.jpg)
PUBID=7746PUBID=7746
HGA[YSCH-2857]
HGC[YSCH-3112]
Enrollment[YSCH-3878]
Round 1 7 6 1
Round 2 9 8 1
Round 3 9 8 1
Round 4 10 9 1
Round 5 12 11 1
Round 6 12 12 1
Round 7 12 12 0
Round 8 12 12 0
![Page 26: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/26.jpg)
Round School idGrade
completed Grade began
Expected graduation
date
2101 [1]
201
7th
(6/97)
8th (6/98)
8th
(8/97)
9th (8/98)
6/01
3 201 - - 5/02
4 201 9th
(6/00)
10th
(8/00)5/02
5201
501 [1]
11th
(5/01)
12th
(2/01)
11th
(2/01)
5/02
6 201 12th
(5/02)n/a
![Page 27: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/27.jpg)
Transcript Survey Transcript Survey (TRANS_TERM_)(TRANS_TERM_)
Term #
GRADE START_DATE END_DATE
.01 8 -3/-3 -3/1998
.02 9 -3/-3 -3/1999
.03 10 -3/-3 -3/2000
.04 11 -3/-3 -3/2001
.05 12 -3/-3 -3/2002
![Page 28: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/28.jpg)
PUBID=7746PUBID=7746
• Youth Questionnaire– High school graduation date
• May 2002 reported in r6• YSCH-11900
– Highest degree received • High school degree [3] in rounds 7 & 8• YSCH-3113
• Transcript data– TRANS_LEFT_REASON=Graduated [1]– TRANS_LEFT_DATE~M/~Y=5/2002
![Page 29: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/29.jpg)
Which Source Is Correct?Which Source Is Correct?
PUBID=7746• Mismatch between transcripts & data
– 9th grade• Transcripts give a completion date of -
3/1999• Completion date of 6/00 in survey data
– 10th grade• Transcripts give a completion date of -
3/2000• No completion date listed in survey data
![Page 30: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/30.jpg)
Round 9 High School Data Round 9 High School Data ReviewReview
• Most raw data are mostly consistent over time
• Resources– 10 years of respondent reported data– Transcript data– Parent questionnaire
• High school careers mostly completed– Received high school diploma/GED– Enrolled in a degree college without a
diploma/GED• Not in a GED program
– Aged out of high school (age 20+)
![Page 31: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/31.jpg)
Resolving Raw High School Resolving Raw High School DataData
More sources=more conflicting data• Use sources from all rounds
– Parent Questionnaire– Transcript Data– Corrections
• Verification questions• Comments
– Expected graduation date
![Page 32: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/32.jpg)
Resolving High School Data…Resolving High School Data…
More sources=more conflicting data…• Use data from rounds after left high
school– Diploma question (r7 and beyond)– Long term out of school status &
verification• Bad grade progression, graduated on
time– Impute if graduate on time given the
grade reported at the 1st interview
![Page 33: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/33.jpg)
Resolving High School Resolving High School Data…Data…
Reporting problems in event history• Unknown dates and grade completion
– Impute if enrolled in the next grade sequentially
• Unexplained grade reversal then progression– Impute when 1st grade reported was completed
before at the same school & verification supports this
Raw data harder for researchers to use• Created variables summarize raw data
– Created after conflicts resolved
![Page 34: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/34.jpg)
R9 Collapsed Variables R9 Collapsed Variables (CVC_)(CVC_)
• Status variables– CVC_HGC_EVER– CVC_HIGHEST_DEGREE_EVER
• Degree dates– CVC_HS_DIPLOMA & CVC_GED– CVC_AA_DEGREE & CVC_BA_DEGREE– CVC_MA_DEGREE– CVC_PROF_DEGREE– CVC_PHD_DEGREE
• Standardized scores– CVC_SAT_MATH_SCORE– CVC_SAT_VERBAL_SCORE– CVC_ACT_SCORE
![Page 35: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/35.jpg)
Created Variables (CV_)Created Variables (CV_)• CV_ENROLLSTAT• High school experience
– CV_GRADES_REPEAT_EVER– CV_GRADE_SKIP_EVER– CV_SCH_ATTEND– CV_PIAT_PERCENTILE_SCORE
• High school variables– CV_SCHOOL_TYPE– CV_SCHOOL_SIZE– CV_STUDENT_TEACHER_RATIO
• College variables– CV_BA_CREDITS– CV_ASSOC_CREDITS
![Page 36: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/36.jpg)
Event History Variables (SCH-)Event History Variables (SCH-)Month-by-Month ArraysMonth-by-Month Arrays
• SCH_STATUS_yr.mo– Enrollment status
• SCH_TERM_yr.mo– School type – Grade or term
• Grade if high school• Term if college
• ID_yr.mo– Links SCH_ arrays to questionnaire data – Same as the NEWSCHOOL_PUBID from
NEWSCHOOL_ roster
![Page 37: NLSY97 Schooling Data](https://reader035.vdocuments.us/reader035/viewer/2022062309/56813b44550346895da41dac/html5/thumbnails/37.jpg)
More InformationMore Information• User’s Guide
– Section 4.1• Achievement test scores• CAT-ASVAB• PIAT Math test
– Section 4.2• Schooling Experience• College Choice• School-based learning programs• Transcript survey
• Codebook Supplement– Appendix 11, Transcript Surveys