To complement data on respondents' educational experiences collected during the yearly interviews, NLSY97 staff collected transcripts directly from respondents' high schools once the youths graduated or left school. Once the transcripts were received from the schools, survey staff coded the transcript record into a standard format. The resulting created variables comprise a history of the respondent's terms in school, courses taken, and other academic indicators. This appendix describes the survey materials used during data collection and explains the procedures and criteria for data entry and coding. It also lists specific details about individual Transcript Survey variables.
Conducted in 1999-2000, Wave 1of the NLSY97 Transcript Survey sought hard copy transcripts from 1,622 NLSY97 respondents who had provided signed authorization for transcript collection, and who were no longer enrolled in high school in spring 2000. Non-enrollment occurred when the youth either graduated from high school or dropped out of school and was at least 18 years old. From Wave I, coded transcript data are available for 1,417 respondents.
To complete the Transcript Survey effort, a second and final wave of the NLSY97 Transcript Survey requested hard copy transcripts from 5,701 eligible NLSY97 respondents. Youth respondents eligible for the Wave 2 Transcript Survey had a signed Permission to Contact School form on file, a known high school reported during a previous interview, and did not have a transcript collected during Wave I. The vast majority of NLSY97 respondents finished their high school careers by the end of the 2004 academic year, resulting in complete transcript records submitted from the schools. Transcript data was collected and coded for 4,815 respondents during Wave 2. Transcript data combined from both waves are available for 6,232 respondents.
NORC mailed a transcript request packet to each school from which an NLSY97 youth received his or her high school diploma, or to the last school the youth reported attending in the Youth interview. The packet contained informational materials about the NLSY97 and a pamphlet describing the NLSY97 Transcript Survey. In addition, packets included the following items:
a cover letter addressed to the school principal
a one-page cover sheet questionnaire collecting school-specific grading and transcript policies
a Student Request list identifying the sampled students in the school
These documents are available in PDF form at the link below:
Collection of the Transcript Data, Wave 1 - example documents
Collection of the Transcript Data, Wave 2 - example documents
(To download Acrobat Reader for free, see the Adobe website: http://www.adobe.com/. For a hard copy version of this document, users should contact NLS User Services: phone: (614) 442-7366 or e-mail: usersvc@postoffice.chrr.ohio-state.edu )
Organization of the data. There are several different types of variables in the transcript data file. First, at the school level the variable TRANS_SCH_CAT reports whether a course catalog was received from the school to aid in coding. The highest number of schools reported for any respondent is 12, so this variable is repeated 12 times. This course catalog variable also functions as the identification number of the school. During the data entry process described below, each school attended by a respondent was assigned a unique sequence ID number between 1 and 12, with the school that provided the transcript always listed as school #01. These numbers were used in variables that report which school the respondent attended in each term-for example, if a respondent has a value of 4 for term 1, then he or she attended school #04 in the course catalog variables. This school ID number does not link to any variables in the main data file.
Second, the transcript file includes information about the respondents that is not associated with a specific term or course. For example, these variables present test scores on a variety of achievement tests (ACT, PSAT, SAT, SAT II, AP), information on absences and tardies, the student's school completion status, and dates of enrollment. Variables also indicate whether the respondent participated in programs such as gifted, bilingual, or special education.
A number of variables refer to the respondent's terms of enrollment. For up to 28 terms, these items report the beginning and ending dates of the term, the way in which the school year is divided (such as a season, entire year, or another term based system), the academic year of the term, the respondent's grade level that term, and the number of credits earned. A variable listing the school the respondent attended during that term can be linked to the course catalog variable as described above.
Finally, the transcript file provides details about each course appearing on a student's high school transcript. Course-specific variables include the course code from the Revised Secondary School Taxonomy (SST-R), the grade earned in the course, and the credit value of the course. Because schools use many different grading systems, the course grades were converted into a standard scale that can be compared across respondents. A series of variables called "Recoding Status of Grade" indicates how the grade earned variable for each course was created. This process is described in more detail below.
Data entry and processing procedures. The transcript data capture process involved several distinct data entry steps, tailored to the structure of the data, the cleaning and reconciliation needs for the relevant variables, and scheduling requirements of the data collection process. The basic data entry and processing steps utilized during Wave 1 were:
Each data entry and processing step is described in greater detail below. Enhancements to transcript processing developed specifically for the Wave 2 effort are noted following each section.
Wave 2 data entry and processing enhancements. Building on the Wave 1 model, the transcript data entry and processing steps were revised, improving the efficiency of the process and enhancing the quality of the data. The revised process included adding an edit and retrieval task at the beginning, streamlining the data entry instruments for a one-time, comprehensive entry task, utilizing an improved coding system separate from the data entry instrument, and building an auto-coding program.
Wave 2 transcript editing process. Due to the wide variation in the layout of high school transcript records, an editing and review task was implemented prior to data entry. Editing provided the first level of standardization of each transcript in preparation for data entry and also allowed clerks to identify problematic transcripts requiring a retrieval contact with the school. Editor staff identified key student level data elements, counted the number of transfer schools reported and sequenced term and course data as it appeared on the transcript. Editors highlighted terms and dates on the transcript, which created a series of reference points to maintain the sequence of courses and terms during data entry. Editor staff also reviewed the transcript for problematic or missing course and term data. If a potential data entry or coding problem existed, a retrieval form was completed and reviewed by a supervisor to determine whether a call to the school was necessary for further clarification.
Wave 1 course-level data entry. Course-level data include the course title, course number (assigned by school), grade earned, credits earned, and honors designation. For matching purposes, the school ID was assigned and term dates were captured during this phase of data entry. Entry was performed using an MSAccess data-capture system. All courses were independently entered twice. Where entry and re-entry matched perfectly, no further quality control was performed. If one or more discrepancies were found electronically between the entry and re-entry, a supervisor adjudicated the two data-entered versions with the original hard copy transcript to determine the accurate values. Courses were entered in the order that they appeared on the transcript. This order varied from school to school, with systems including chronologically, alphabetically by course title, numerically by course number, etc.
Wave 1 data entry of student-specific data down to the term level. All other student-specific data were captured in a SurveyCraft instrument for computer-assisted data entry. These variables include the student's enrollment in gifted, special education, or bilingual programs, standardized test scores, dates of enrollment at the school, class rank and cumulative grade-point average, term-level information on beginning and ending dates of terms, absences and tardies, and credits earned by term. The SurveyCraft program generated a single record for each youth, containing up to 18 terms of study. Term date information was used to match term-level data with the school attended during that term. All transcripts from a school were data entered at the same time to exploit clerk familiarity with transcript formats and school-specific abbreviations. All transcripts were independently entered twice. Where entry and re-entry matched perfectly, no further quality control was performed. If one or more discrepancies were found electronically between the entry and re-entry, a supervisor adjudicated the two data-entered versions with the original hard copy transcript to determine the accurate values. Terms were entered in chronological order when such sequence could be determined.
Wave 2 data entry system. A more comprehensive SurveyCraft computer-assisted data entry system was constructed for the Wave 2 data processing effort. The updated instrument allowed clerks to key all contents of the transcript at one time, capturing student, school, term and course level data in a series of loops. The editing process allowed a standard transcript sequence to be followed during data entry. Course and term data were reported in a chronological sequence whenever possible. The consolidated CADE system eliminated the need to match course level and term level data from two different systems, allowed data entry to sequence terms in chronological order by school for each youth record, and added another level of quality control through double entry and adjudication of both the data entry and coded items. The same rules for adjudication used during Wave 1 data entry were also applied.
Wave 1 course coding. Course-level data were used for coding courses into the Revised Secondary School Taxonomy (SST-R), a hierarchical framework for high school course offerings. After all course-level data from a transcript had been entered, re-entered, and adjudicated, the transcript was available for course coding. To maximize coder familiarity with school naming and catalog conventions, all transcripts from a school were usually coded together. Coding of all courses was done independently by two coders. If the two codes were not equal, a supervisor adjudicated the discrepancy and assigned a final code. Because many schools did not submit course catalogs or had indecipherable course titles (e.g., Course 1), clerks called some schools directly for assistance in coding, speaking to administrative or instructional staff who were able to clarify course content. The coding process used a menu-driven MSAccess system, which exploited the hierarchical structure of the code frame and prevented coders from inadvertently entering invalid codes. All 'uncodable' courses were reviewed by the coding supervisor and project director where necessary.
Wave 2 course coding. The course coding process in Wave 2 utilized a similar menu driven MSAccess system. After transcript records were entered, re-entered and adjudicated, a flag was set in the data entry system. Flagged transcript records were extracted from the SurveyCraft data on a regular schedule and loaded by batches into the coding system. Within each batch, transcript records were grouped by school to allow clerks to maximize familiarity with school naming and catalog conventions. Along with course level data presented on the coding screen, key term level information, including dates, term season, and grade level were also presented, allowing the clerks to easily reference course titles in the transcript record and course catalog. Mirroring Wave I, each course was coded independently by two different coders, and any discrepancies between the two codes assigned were reviewed by a supervisor responsible for assigning the final code.
Wave 2 auto-coding program. Using course description and coding matches from the Wave 1 coding effort, a list of course descriptions with codes assigned was developed for an auto-coding program. This matching program was run before courses were loaded into the MSAccess coding system. Approximately 25% of all courses coded were completed by the auto-coding program. Project staff reviewed all auto-coded course descriptions and codes assigned for consistency and flagged any discrepancies for manual coding.
Transfer data. Transcripts often included information about courses attended at other institutions. These data could appear either as an original hard copy attachment to the sampled school's transcript or as additional lines on the sampled school's transcript. These terms and courses were data entered during the appropriate stage of data entry, with a designation that the term or course pertained to a transfer school. Course and term-specific information about transferred work was generally complete, but information about the school from which work was transferred was often inadequate for coding purposes. As described above, all terms attended at the same school are associated with the same school ID.
Wave 2 transfer data and sequence of schools and terms. Building on lessons learned during the Wave 1 transcript processing, special effort was made to preserve a chronological sequence within the transcript for course, term and school data reported. The sequence established during the edit and data entry processes was used to order the terms chronologically. When preparing the term level data, the term year and season were used to confirm the sequence. For a small group of cases, the term sequence was difficult to assign when the transcript record indicated attendance at one or more institutions during similar term years. In these instances, attempts to sequence terms were based on the time period reported on the hard copy transcript whenever possible.
School 01 is always associated with the primary school or the school submitting the transcript. For the Wave 2 data, transfer schools are numbered in reverse chronological order as they appear on the transcript, often beginning with the most recent transfer school event moving in reverse order to the earliest transfer school event. In most instances, the school first attended by the student on the transcript will have the highest school number in the SCH_CAT.xx series.
Missing course catalogs and the Internet. For Wave 2 processing, if a series of transfer schools was present for a student, the SCH_CAT.xx variable was set to "no" indicating the catalog was not received. While a catalog for that school may have been received during the data collection period, it may not have been accessible to coding staff during the course of the transcript data collection. When available, online course catalogs were useful in clarifying particular types of coursework reported at a given school and were utilized by supervisors during the adjudication process.
Coursework reported below grade 9. Most transcripts entered and coded span a typical high school career from grades 9 or 10 through 12. For some districts and states, the transcript record includes middle school or junior high coursework, usually taken during grades 7 and 8. Other high school transcripts also record equivalency or classroom coursework eligible for high school credit that was earned while the student was in grade 8 or below. While no effort was made to collect middle school or junior high level coursework for the NLSY97 Transcript Survey, courses taken at these grade levels were coded and have been made available when provided as part of the hard copy transcript record.
School data. The one-page Transcript Cover Sheet provided information for assigning course grades to a uniform grade scale. During Wave 1 transcript processing, these data were entered into a SurveyCraft data capture instrument, once for each school submitting valid transcripts. Ten percent of schools were re-entered, and a supervisor referred to the original hard-copy to adjudicate discrepancies.
Wave 2 Transcript Cover Sheet procedures: Since a small percentage of schools during the Wave 1 effort reported unique grading scales, a data entry system was not built for Wave 2. Rather, the grade scale data were captured by a data processing clerk inside a spreadsheet containing high and low equivalents for each letter grade. An entry was made for each school submitting valid transcripts and a completed Transcript Cover Sheet. A supervisor reviewed the contents of the spreadsheet to ensure accuracy. When discrepancies reported on the Transcript Cover Sheet were discovered, the school was contacted as part of the retrieval process for clarification. The final grade scale spreadsheet was used in the standardized course grade procedures noted below.
Course grades. High school transcripts included a variety of systems for course grades, including letter grades or numbers. For ease of comparison, these were standardized into a uniform grading system. The standardized grading scale for the resulting CRS_GRADE variable ranges from 01 to 20. Table 1 lists the corresponding letter grades for each of the CRS_GRADE values.
Table 1. Grading system for coded transcript variables
|
CRS_GRADE |
Corresponding letter grade |
CRS_GRADE |
Corresponding letter grade |
|
|
01 |
A+ |
11 |
D |
|
|
02 |
A |
12 |
D- |
|
|
03 |
A- |
13 |
F |
|
|
04 |
B+ |
14 |
Pass, satisfactory or credit |
|
|
05 |
B |
15 |
Unsatisfactory or no credit |
|
|
06 |
B- |
16 |
Withdrew or dropped course |
|
|
07 |
C+ |
17 |
Incomplete |
|
|
08 |
C |
18 |
Non-graded course or audit |
|
|
09 |
C- |
19 |
Blank, no grade provided |
|
|
10 |
D+ |
20 |
Unrecodable grade |
In addition to the standardized grade variable, survey staff created a variable for each course called CRS_GRADE_RECODE_STATUS. This variable provides information on how the CRS_GRADE variable was created from the information provided by the school. The values of the recoding status variable are listed in Table 2.
Table 2. Values for CRS_GRADE_RECODE_STATUS
|
CRS_GRADE_RECODE_STATUS |
Recoding Status |
|
0 |
Directly recoded |
|
1 |
Recoded using grade specifications of own school |
|
2 |
Recoded using standard grade specifications |
|
3 |
Uncodable grade |
Each standardized grade was assigned using one of the following four methods:
Once again, to take into account the possibility of transcription errors, numeric grades below 15 were considered to be unrecodable. CRS_GRADE_RECODE_STATUS was assigned a value of 2 when recoding was done using the standard grade specifications. If the grades could not be recoded, then CRS_GRADE was given a value of 20 and CRS_GRADE_RECODE_STATUS was coded as 3.
Table 3. Standard numeric grading system
|
Wave |
Lower limit |
Upper limit |
CRS_GRADE |
|
1 |
91 |
100 |
02 |
|
2 |
90 |
100 |
|
|
1 |
82 |
Less than 91 |
05 |
|
2 |
80 |
Less than 90 |
|
|
1 |
73 |
Less than 82 |
08 |
|
2 |
70 |
Less than 80 |
|
|
1 |
65 |
Less than 73 |
11 |
|
2 |
60 |
Less than 70 |
|
|
1 |
15 |
Less than 65 |
13 |
|
2 |
15 |
Less than 59 |
Transcript Survey variables can be found in the NLSY97 data set by browsing through the "transcript survey" area of interest or by searching for question names with the prefix TRANS_. This section provides supplemental notes not included in the codebook about individual transcript variables.
Table 4. Additional information about Transcript Survey variables
|
Question name (all begin with TRANS_) and reference number(s) |
Variable title and notes |
|
CRS_CODE.xx |
Course Code xx |
|
CRS_CREDIT.xx |
Credits Earned for Course xx |
|
CRS_GRADE_RECODE_STATUS.xx |
Recoding Status of Grade for Course xx |
|
CRS_GRADE.xx |
Recoded Quality Grade xx |
|
CRS_TERM_NU.xx |
Course Term Number xx |
|
TERM_CREDIT.xx |
Credits Earned in Term xx |
|
TERM_START_DATE.xx |
Month, Year Term Started xx |
|
TERM_END_DATE.xx |
Month, Year Term Ended xx |
|
TERM_GRADE.xx |
Grade Level for Term xx |
|
TERM_SCH_NU.xx |
School Number for Term xx |
|
TERM_SEASON.xx |
Term Season xx |
|
TERM_YEAR.xx |
Term Year xx |
|
SCH_CAT.xx |
Course Catalog Received xx School numbers link only to TERM_SCH_NU.xx variable and not to other school IDs in the NLSY97 youth data. School number 01 indicates the school from which the transcript was received, generally the most recent school of enrollment. A school number greater than 01 indicates transferred coursework. |
|
SPECIAL_ED |
Participated in Special Ed |
|
BILING_ED |
Participated in Bilingual Ed |
|
GIFTED_CRS |
Participated in Gifted Courses Program |
|
TERM_TOTAL |
Total Number of Terms Reported |
|
SCH_START_DATE |
Month, Year Enrollment at School Started |
|
SCH_END_DATE |
Month, Year Enrollment at School Ended |
|
AB_AYxxxx |
Number of Absences in Academic Year xxxx |
|
AB-MISS |
Number of Absences if Year Not Assigned |
|
TARDY_AYxxxx |
Number of Tardies in Academic Year xxxx |
|
TARDY_MISS |
Number of Tardies if Year Not Assigned |
|
FLAG_MISS_AB_AYxxxx |
Enrolled, Missing Absences in Academic Yr xxxx |
|
FLAG_MISS_TARDY_AYxxxx |
Enrolled, Missing Tardies in Academic Yr xxxx |
|
AT_SCH |
Has R Left School |
|
LEFT_DATE |
Month, Year Left School |
|
LEFT_REASON |
Reason
Left School |
|
GPA |
GPA for Last Year |
|
CLASS_RANK |
Class Rank for Last Year |
|
CLASS_SIZE |
Class Size Category for Last Year |
|
PSAT_MATH |
PSAT Math Score |
|
PSAT_VERB |
PSAT Verbal Score |
|
ACT_COMP |
Composite ACT Score |
|
ACT_ENG |
ACT English Score |
|
ACT_MATH |
ACT Math Score |
|
ACT_READ |
ACT Reading Score |
|
SAT_VERBAL |
SAT Verbal Score |
|
SAT_MATH |
SAT Math Score |
|
SAT_DATE |
Month, Year SAT Was Taken |
|
AP_ART |
AP Art Score |
|
AP_BIO |
AP Biology Score |
|
AP_CALC |
AP Calculus
Score |
|
AP_CHEM |
AP Chemistry Score |
|
AP_CMPSCI |
AP Computer Science Score |
|
AP_ECON |
AP Economics Score |
|
AP_ENG |
AP English Score |
|
AP_HIST_EU |
AP European History Score |
|
AP_GOVT |
AP Government and Politics Score |
|
AP_INTENG |
AP International English Score |
|
AP_PHYS |
AP Physics Score |
|
AP_PSYCH |
AP Psychology Score |
|
AP_SPAN |
AP Spanish Score |
|
AP_STAT |
AP Statistics Score |
|
AP_HIST_US |
AP U.S. History Score |
|
OTH_AP1 |
Number Other AP 1 |
|
OTH_AP2 |
Number Other AP 2 |
|
OTH_AP3 |
Number Other AP 3 |
|
OTH_AP4 |
Number Other AP 4 |
|
OTH_AP5 |
Number Other AP 5 |
|
SATII_BIO |
SAT II Biology Score |
|
SATII_MATH1 |
SAT II Math I Score |
|
SATII_MATH2 |
SAT II Math II Score |
|
SATII_CHEM |
SAT II Chemistry Score |
|
SATII_ENG_LIT |
SAT II English Literature Score |
|
SATII_ENG_WRITE |
SAT II English Writing Score |
|
SATII_HIST_AM |
SAT II American History and Social Studies Score |
|
SATII_PHYS |
SAT II Physics Score |
|
SATII_HIST_WORLD |
SAT II World History Score |
|
SATII_SPANL |
SAT II Spanish Score |
|
OTH_SAT1 |
Number Other SAT 200400 |
|
OTH_SAT2 |
Number Other SAT 401500 |
|
OTH_SAT3 |
Number Other SAT 501600 |
|
OTH_SAT4 |
Number Other SAT 601700 |
|
OTH_SAT5 |
Number Other SAT 701800 |
As part of the NLSY97 Transcript Survey, project staff coded respondents' courses using the revised Secondary School Taxonomy of courses (SST-R). The SST-R codes use a combination of numbers and letters to create a unique identifier for each type and level of high school course content. Because the NLSY97 data base system requires that all data be in numeric form, it was necessary to convert the SST-R codes into numbers for use with the Transcript Survey data. The following table indicates the NLSY97 number assigned for each original SST-R code and course description. These codes were used in variables R97128.-R97251. (TRANS_CRS_CODE.01-.175) in the NLSY97 data set.
Table 5. Numeric Course Code, R-SST Codes and Code Descriptions
|
TRANS_ CRS_ CODE.xxx |
SST-R Code |
SST-R Description |
|
1 |
1_11A |
General Mathematics, ESE/Functional |
|
2 |
1_11B |
General Mathematics, Basic |
|
3 |
1_11C |
General Mathematics, Regular |
|
4 |
1_11D |
General Mathematics, Other |
|
5 |
1_12A |
Consumer Mathematics, ESE/Functional |
|
6 |
1_12B |
Consumer Mathematics, Regular |
|
7 |
1_13 |
Pre-Algebra |
|
8 |
1_14 |
Algebra 1 |
|
9 |
1_15 |
Geometry |
|
10 |
1_16 |
Algebra 2 through Pre-Calculus |
|
11 |
1_17A |
Advanced Mathematics, Calculus |
|
12 |
1_17B |
Advanced Mathematics, AP/IB |
|
13 |
1_17C |
Advanced Mathematics, Other |
|
14 |
1_18 |
Unified Mathematics |
|
15 |
1_19A |
Occupationally-Related Mathematics, ESE/Functional |
|
16 |
1_19B |
Occupationally-Related Mathematics, Regular |
|
17 |
1_21A |
Survey Science, Basic |
|
18 |
1_21B |
Survey Science, Specialized Topics |
|
19 |
1_21C |
Survey Science, Integrated/Unified Topics |
|
20 |
1_22A |
Biological Science, Basic |
|
21 |
1_22B |
Biological Science, Regular |
|
22 |
1_22C |
BIO II ; Biological Science, Advanced and Honors |
|
23 |
1_22D |
Biological Science, Specialized Topics |
|
24 |
1_22E |
Biological Science, AP/IB |
|
25 |
1_23A |
Chemistry, Basic |
|
26 |
1_23B |
Chemistry, Regular |
|
27 |
1_23C |
Chemistry, Advanced and Honors |
|
28 |
1_23D |
Chemistry, Specialized Topics |
|
29 |
1_23E |
Chemistry, AP/IB |
|
30 |
1_24A |
Physics, Basic |
|
31 |
1_24B |
Physics, Regular |
|
32 |
1_24C |
Physics, Advanced and Honors |
|
33 |
1_24D |
Physics, Specialized Topics |
|
34 |
1_24E |
Physics, AP/IB |
|
35 |
1_25A |
Earth Science, Basic |
|
36 |
1_25B |
Earth Science, Regular |
|
37 |
1_25C |
Earth Science, Advanced and Honors |
|
38 |
1_25D |
Earth Science, Specialized Topics |
|
39 |
1_26A |
Physical Science, Basic |
|
40 |
1_26B |
Physical Science, Regular |
|
41 |
1_26C |
Physical Science, Advanced and Honors |
|
42 |
1_26D |
Physical Science, Specialized Topics |
|
43 |
1_27 |
Engineering |
|
44 |
1_31A |
English Survey, Language Skills |
|
45 |
1_31B |
English Survey, Grades 7 and 8 |
|
46 |
1_31C1 |
English Survey, ESE/Functional, Grade 9 |
|
47 |
1_31C2 |
English Survey, ESE/Functional, Grade 10 |
|
48 |
1_31C3 |
English Survey, ESE/Functional, Grade 11 |
|
49 |
1_31C4 |
English Survey, ESE/Functional, Grade 12 |
|
50 |
1_31D1 |
English Survey, Basic, Grade 9 |
|
51 |
1_31D2 |
English Survey, Basic, Grade 10 |
|
52 |
1_31D3 |
English Survey, Basic, Grade 11 |
|
53 |
1_31D4 |
English Survey, Basic, Grade 12 |
|
54 |
1_31E1 |
English Survey, Regular, Grade 9 |
|
55 |
1_31E2 |
English Survey, Regular, Grade 10 |
|
56 |
1_31E3 |
English Survey, Regular, Grade 11 |
|
57 |
1_31E4 |
English Survey, Regular, Grade 12 |
|
58 |
1_31F1 |
English Survey, Advanced and Honors, Grade 9 |
|
59 |
1_31F2 |
English Survey, Advanced and Honors, Grade 10 |
|
60 |
1_31F3 |
English Survey, Advanced and Honors, Grade 11 |
|
61 |
1_31F4 |
English Survey, Advanced and Honors, Grade 12 |
|
62 |
1_31G |
English Survey, AP/IB |
|
63 |
1_32 |
Literature |
|
64 |
1_33 |
Composition and Writing |
|
65 |
1_34 |
Speech |
|
66 |
1_35 |
English as a Second Language |
|
67 |
1_41A |
American History, Basic |
|
68 |
1_41B |
American History, Regular |
|
69 |
1_41C |
American History, Advanced and Honors |
|
70 |
1_41D |
American History, Specialized Topics |
|
71 |
1_41E |
American History, AP/IB |
|
72 |
1_42A |
World History, Basic |
|
73 |
1_42B |
World History, Regular |
|
74 |
1_42C |
World History, Advanced and Honors |
|
75 |
1_42D |
World History, Specialized Topics |
|
76 |
1_42E |
World History, AP/IB |
|
77 |
1_43A |
Government & Politics, Basic |
|
78 |
1_43B |
Government & Politics, Regular |
|
79 |
1_43C |
Government & Politics, Advanced and Honors |
|
80 |
1_43D |
Government & Politics, Specialized Topics |
|
81 |
1_43E |
Government & Politics, AP/IB |
|
82 |
1_44A |
Economics, Basic |
|
83 |
1_44B |
Economics, Regular |
|
84 |
1_44C |
Economics, Advanced and Honors |
|
85 |
1_44D |
Economics, Specialized Topics |
|
86 |
1_44E |
Economics, AP/IB |
|
87 |
1_45A |
Behavioral Sciences, Basic |
|
88 |
1_45B |
Behavioral Sciences, Regular |
|
89 |
1_45C |
Behavioral Sciences, Advanced and Honors |
|
90 |
1_45D |
Behavioral Sciences, Specialized Topics |
|
91 |
1_45E |
Behavioral Sciences, AP/IB |
|
92 |
1_46A |
Geography, Basic |
|
93 |
1_46B |
Geography, Regular |
|
94 |
1_46C |
Geography, Advanced and Honors |
|
95 |
1_46D |
Geography, Specialized Topics |
|
96 |
1_46E |
Geography, AP/IB |
|
97 |
1_47A |
Social Science, Humanities, and Other, Basic |
|
98 |
1_47B |
Social Science, Humanities, and Other, Regular |
|
99 |
1_47C |
Social Science, Humanities, and Other, Advanced and Honors |
|
100 |
1_47D |
Social Science, Humanities, and Other, Specialized Topics |
|
101 |
1_47E |
Social Science, Humanities, and Other, AP/IB |
|
102 |
1_51A |
Visual Arts, Basic |
|
103 |
1_51B |
Visual Arts, Regular and Advanced |
|
104 |
1_51C |
Visual Arts, AP/IB |
|
105 |
1_52A |
Music, Basic |
|
106 |
1_52B |
Music, Regular and Advanced |
|
107 |
1_52C |
Music, AP/IB |
|
108 |
1_53 |
Dance |
|
109 |
1_54 |
Theater Arts |
|
110 |
1_61A |
Spanish, Year 1 |
|
111 |
1_61B |
Spanish, Year 2 |
|
112 |
1_61C |
Spanish, Year 3 |
|
113 |
1_61D |
Spanish, Year 4+ |
|
114 |
1_61E |
Spanish, AP/IB |
|
115 |
1_62A |
French, Year 1 |
|
116 |
1_62B |
French, Year 2 |
|
117 |
1_62C |
French, Year 3 |
|
118 |
1_62D |
French, Year 4+ |
|
119 |
1_62E |
French, AP/IB |
|
120 |
1_63A |
German, Year 1 |
|
121 |
1_63B |
German, Year 2 |
|
122 |
1_63C |
German, Year 3 |
|
123 |
1_63D |
German, Year 4+ |
|
124 |
1_63E |
German, AP/IB |
|
125 |
1_64A |
Latin, Year 1 |
|
126 |
1_64B |
Latin, Year 2 |
|
127 |
1_64C |
Latin, Year 3 |
|
128 |
1_64D |
Latin, Year 4+ |
|
129 |
1_64E |
Latin, AP/IB |
|
130 |
1_65A |
Italian, Year 1 |
|
131 |
1_65B |
Italian, Year 2 |
|
132 |
1_65C |
Italian, Year 3 |
|
133 |
1_65D |
Italian, Year 4+ |
|
134 |
1_65E |
Italian, AP/IB |
|
135 |
1_66A |
Non-English Language Other, Year 1 |
|
136 |
1_66B |
Non-English Language Other, Year 2 |
|
137 |
1_66C |
Non-English Language Other, Year 3 |
|
138 |
1_66D |
Non-English Language Other, Year 4+ |
|
139 |
1_66E |
Non-English Language Other, AP/IB |
|
140 |
1_67 |
Non-English Languages General/Survey |
|
141 |
2_AA |
Family and Consumer Sciences Education, 1st course |
|
142 |
2_AB |
Family and Consumer Sciences Education, 2nd (or later) courses |
|
143 |
2_AC |
Family and Consumer Sciences Education, Specialty courses |
|
144 |
2_B1 |
GLMP, Basic Keyboarding/Typewriting |
|
145 |
2_B2 |
GLMP, Industrial Arts |
|
146 |
2_B3 |
GLMP, Career Preparation/General Work Experience |
|
147 |
2_B4 |
GLMP, Technology Education |
|
148 |
2_B5 |
GLMP, Other |
|
149 |
2_C01A |
Agriculture and Renewable Resources, 1st course |
|
150 |
2_C01B |
Agriculture and Renewable Resources, 2nd (or later) courses |
|
151 |
2_C01C |
Agriculture and Renewable Resources, Specialty courses |
|
152 |
2_C01D |
Agriculture and Renewable Resources, Co-op/Work Experience |
|
153 |
2_C021A |
Business Management, 1st course |
|
154 |
2_C021B |
Business Management, 2nd (or later) courses |
|
155 |
2_C021C |
Business Management, Specialty courses |
|
156 |
2_C021D |
Business Management, Co-op/Work Experience |
|
157 |
2_C022A |
Business Services, 1st course |
|
158 |
2_C022B |
Business Services, 2nd (or later) courses |
|
159 |
2_C022C |
Business Services, Specialty courses |
|
160 |
2_C022D |
Business Services, Co-op/Work Experience |
|
161 |
2_C03A |
Marketing and Distribution, 1st course |
|
162 |
2_C03B |
Marketing and Distribution, 2nd (or later) courses |
|
163 |
2_C03C |
Marketing and Distribution, Specialty courses |
|
164 |
2_C03D |
Marketing and Distribution, Co-op/Work Experience |
|
165 |
2_C04A |
Health Care, 1st course |
|
166 |
2_C04B |
Health Care, 2nd (or later) courses |
|
167 |
2_C04C |
Health Care, Specialty courses |
|
168 |
2_C04D |
Health Care, Co-op/Work Experience |
|
169 |
2_C05A |
Public and Protective Services, 1st course |
|
170 |
2_C05B |
Public and Protective Services, 2nd (or later) courses |
|
171 |
2_C05C |
Public and Protective Services, Specialty courses |
|
172 |
2_C05D |
Public and Protective Services, Co-op/Work Experience |
|
173 |
2_C061A |
T&I, Construction Trades, 1st course |
|
174 |
2_C061B |
T&I, Construction Trades, 2nd (or later) courses |
|
175 |
2_C061C |
T&I, Construction Trades, Specialty courses |
|
176 |
2_C061D |
T&I, Construction Trades, Co-op/Work Experience |
|
177 |
2_C062A |
T&I, Mechanics and Repair, 1st course |
|
178 |
2_C062B |
T&I, Mechanics and Repair, 2nd (or later) courses |
|
179 |
2_C062C |
T&I, Mechanics and Repair, Specialty courses |
|
180 |
2_C062D |
T&I, Mechanics and Repair, Co-op/Work Experience |
|
181 |
2_C0631A |
T&I, Precision Production (Drafting/Graphics/Printing), 1st course |
|
182 |
2_C0631B |
T&I, Precision Production (Drafting/Graphics/Printing), 2nd (or later) courses |
|
183 |
2_C0631C |
T&I, Precision Production (Drafting/Graphics/Printing), Specialty courses |
|
184 |
2_C0632A |
T&I, Precision Production (Metals/Wood/Plastics), 1st course |
|
185 |
2_C0632B |
T&I, Precision Production (Metals/Wood/Plastics), 2nd (or later) courses |
|
186 |
2_C0632C |
T&I, Precision Production (Metals/Wood/Plastics), Specialty courses |
|
187 |
2_C0633A |
T&I, Precision Production (Other), 1st course |
|
188 |
2_C0633B |
T&I, Precision Production (Other), 2nd (or later) courses |
|
189 |
2_C0633C |
T&I, Precision Production (Other), Specialty courses |
|
190 |
2_C0634 |
T&I, Precision Production, Co-op/Work Experience |
|
191 |
2_C064A |
T&I, Transportation and Material Moving, 1st course |
|
192 |
2_C064B |
T&I, Transportation and Material Moving, 2nd (or later) courses |
|
193 |
2_C064C |
T&I, Transportation and Material Moving, Specialty courses |
|
194 |
2_C064D |
T&I, Transportation and Material Moving, Co-op/Work Experience |
|
195 |
2_C071A |
Computer Technology, 1st course |
|
196 |
2_C071BA |
Computer Technology, 2nd (or later) courses, non-AP/IB |
|
197 |
2_C071BB |
Computer Technology, 2nd (or later) courses, AP/IB |
|
198 |
2_C071C |
Computer Technology, Specialty courses |
|
199 |
2_C071D |
Computer Technology, Co-op/Work Experience |
|
200 |
2_C072A |
Communication Technology, 1st course |
|
201 |
2_C072B |
Communication Technology, 2nd (or later) courses |
|
202 |
2_C072C |
Communication Technology, Specialty courses |
|
203 |
2_C072D |
Communication Technology, Co-op/Work Experience |
|
204 |
2_C073A |
Other Technologies, 1st course |
|
205 |
2_C073B |
Other Technologies, 2nd (or later) courses |
|
206 |
2_C073C |
Other Technologies, Specialty courses |
|
207 |
2_C073D |
Other Technologies, Co-op/Work Experience |
|
208 |
2_C08A |
Personal and Other Services, 1st course |
|
209 |
2_C08B |
Personal and Other Services, 2nd (or later) courses |
|
210 |
2_C08C |
Personal and Other Services, Specialty courses |
|
211 |
2_C08D |
Personal and Other Services, Co-op/Work Experience |
|
212 |
2_C09A |
Food Service and Hospitality, 1st course |
|
213 |
2_C09B |
Food Service and Hospitality, 2nd (or later) courses |
|
214 |
2_C09C |
Food Service and Hospitality, Specialty courses |
|
215 |
2_C09D |
Food Service and Hospitality, Co-op/Work Experience |
|
216 |
2_C10A |
Child Care and Education, 1st course |
|
217 |
2_C10B |
Child Care and Education, 2nd (or later) courses |
|
218 |
2_C10C |
Child Care and Education, Specialty courses |
|
219 |
2_C10D |
Child Care and Education, Co-op/Work Experience |
|
220 |
2_C11 |
Specific Labor Market Preparation, Unidentified Subject |
|
221 |
3_1A |
Enrichment |
|
222 |
3_1B |
Assistance |
|
223 |
3_1C |
Service |
|
224 |
3_2 |
Health, Physical & Recreational Education Credits |
|
225 |
3_3 |
Religion and Theology Credits |
|
226 |
3_4 |
Military Science Credits |
|
227 |
4 |
Special Education Curriculum |
|
228 |
5_5 |
Supervisor verification requested |
The NLSY97 High School Transcript variables include credits earned for completed coursework as reported by the school submitting the transcript. Because credit systems vary considerably across schools, researchers may find it useful to use a transformation into Carnegie credit units, which are comparable across schools. One Carnegie credit is defined as the credits earned for a class that meets every day for one period for an entire school year. An NLSY97 Transcript Survey respondent's primary school is the school submitting the transcript record for processing; for the majority of transcript records processed, this is the last high school attended reporting coursework for the student. The effort to standardize course credits is based on the number of school course credits equal to one Carnegie credit as reported at the primary school. A multiplier was identified at the school level and applied to all school-based credits, creating a standardized credit system.
Carnegie Credit Conversion Method
The conversion of school-based course credits into a standardized Carnegie unit was established through three distinct approaches at the primary school level:
A standardized Carnegie credit measure was created through observation of school credits earned for coursework routinely taken over a full school year. Review of the transcript survey data indicates that English coursework is most often repeated over a year for the student's entire high school career, allowing a close approximation of the number of school-based credits earned over one full school year. If a school could not provide a Carnegie credit equivalent measure for school credits, the school was asked to provide the number of school credits a student earns for completion of English coursework across an entire school year.
Standardized Carnegie Credits based on School Reports. Initial transcript requests at schools did not include a series of questions regarding Carnegie equivalent credits. While recontacting schools during the 2004 wave, specific effort was made to define school credits earned in terms of Carnegie credits. Data processing clerks also reviewed course catalog materials submitted and identified schools with Carnegie Unit conversions reported or English credits earned by school year. In total, approximately 90% (n = 5,583) of the student transcripts submitted by primary schools either reported Carnegie equivalent credits or provided the number of English credits earned over one school year. The school-based reports were used to create a multiplier directly applied to course credits noted below.
School Reported Carnegie Credit Equivalencies. When a school provided the number of school course credits equal to one Carnegie credit unit, a credit multiplier was built based on the ratio: X school-based credits = 1 Carnegie credit unit. This multiplier was associated with the primary school. For student records associated with the primary school, the multiplier was applied to each course credit and captured in the CRS_CARNEGIE_CREDIT.xxx variable. The recode flag was set to 1 in each instance (see Table 1).
Standardized Carnegie Credits Based on School Reported English Credits. If a school provided the number of school-based credits earned for one full school year's English coursework, a credit multiplier was built based on the ratio: X English Credits Earned for One School Year = 1 Carnegie credit unit. This comparison was built on the underlying assumption that the number of school-based credits earned for English coursework completed over one school year was equivalent to one Carnegie credit unit. The multiplier was associated with the primary school. For student records associated with the primary school, the multiplier was applied to each course credit and captured in the CRS_CARNEGIE_CREDIT.xxx variable. The recode flag was set to 2 in each instance (see Table 1).
Standardized Carnegie Credits Based on Transcript Observations. For the remaining 10% of student records, a standard Carnegie credit equivalent was constructed by observing credit patterns across schools within transcript records. Again, English coursework was targeted as such coursework was more likely to be repeated across school years and have similar curriculum. Course credit patterns were first observed in English Survey coursework (1_31E*). If a credit pattern could not be detected, the program was expanded to observe a pattern across all English coursework (1_3*).
Standardized Carnegie Credits Based on English Survey Credits within Transcripts. Programs were built to observe English Survey course credit patterns across school years (where course codes = 1_31E*). Course credits were summed across school years to create a multiplier based on the ratio (X English Survey credits for 1 school year = 1 Carnegie credit unit). The multiplier was associated with the primary school. For student records associated with the primary school, the multiplier was applied to each course credit and captured in the CRS_CARNEGIE_CREDIT.xxx variable. The recode flag was set to 3 in each instance (see Table 1).
Standardized Carnegie Credits Based on Other English Credits within Transcripts. Programs were built to observe English course credit patterns across school years (where course codes = 1_3*). Course credits were summed across school years to create a multiplier based on the ratio (X English credits for one school year = 1 Carnegie credit unit). The multiplier was associated with the primary school. For student records associated with the primary school, the multiplier was applied to each course credit and captured in the CRS_CARNEGIE_CREDIT.xxx variable. The recode flag was set to 4 in each instance (see Table 1).
Unclassifiable Credits. In few instances, a credit system across schools could not be observed from reviewing English coursework credits earned. Reasons for not classifying school-based credits into a Carnegie credit equivalency include: credits were not reported (i.e., "missing") at the course level, zero credits were earned for all courses reported, not enough credits were reported to establish a Carnegie multiplier, and credits reported varied enough to prevent a standardized multiplier across student records. In such instances, CRS_CARNEGIE_CREDIT.xxx was set to a missing value (-3) and the recode flag was set to 5 (see Table 1).
Table 1: Values for CRS_CARNEGIE_RECODE.xxx
|
Carnegie Unit Recode Flag |
Recoding Status |
|
1 |
Directly recoded using school-reported Carnegie Units. |
|
2 |
Recoded using multiplier developed from school-reported English credits earned in one school year. |
|
3 |
Recoded using standardized multiplier observed in English Survey credits. |
|
4 |
Recoded using standardized multiplier observed in English coursework, other. |
|
5 |
Unclassifiable credits |
Additional Notes regarding the Carnegie Credit Assignment
Quality control checks were developed to evaluate the procedures using school-based credits earned for one year of English coursework in calculating a standard Carnegie multiplier. The three standardized calculations using English course credits were tested on the schools with direct Carnegie credit conversions reported. In addition, staff reviewed the total number of Carnegie credits earned by student to determine if the Carnegie credits reported seem reasonable. A range of 16 - 24 Carnegie credits earned for academic coursework was benchmarked. While a large majority fall within this range of credits, there are still outliers. Some reasons for these outliers are noted below.
Primary Schools and Credits Earned at Other/"Transfer" Schools. One key assumption is that the primary school calculated credits earned for coursework taken at other ("transfer") schools based on the primary school's credit system required for graduation. This assumption proved true in most cases, as the primary school would adjust the transferable credits from other schools into meaningful credits necessary to graduate. In some instances, however, it is clear that the conversion of credits earned at prior schools into equivalent credits at the primary school did not occur. When possible, a conversion based on English coursework observed across the transfer schools was used to standardize the credits across both schools. In the remaining instances, it was determined that a standardized set of Carnegie credits could not be established based on the information presented, and Carnegie credits for these transcripts were coded as unclassifiable. The CRS_CARNEGIE_RECODE.xxx variables indicate what steps were taken for each individual course.
Course Credit Reporting and Data Entry Errors. If a clear entry or reporting error was identified for a particular course credit (often a missing decimal point) and a correction could be identified from reviewing other course credits earned or total credits reported by term, the Carnegie credit reported in the data file was constructed to reflect the adjusted credit earned, rather than using the apparently erroneous course credit value. Approximately 100 courses were affected by these types of corrections. The original credit information remains in the CRS_CREDIT.xx variable series.
Grades 7 and 8. Student transcripts with high numbers of Carnegie credits often include grade levels outside of the typical grades 9-12 high school career. A number of district level transcripts report middle school and high school coursework. Coursework taken in grades 7 and 8 was assigned a Carnegie credit equivalent. Researchers can use the grade level variables in order to exclude these courses (and credits) from specific analyses as appropriate.
Vocational and Enrichment Coursework Credits. It is apparent from review of the transcript records that many schools apply a different credit weighting system to certain types of vocational coursework (where R-SST = 2_*) and enrichment coursework (where R-SST = 3_*) than to academic level coursework (where SST = 1_*). While Carnegie credits have been calculated for these vocational and enrichment courses, users should note the credits earned for vocational and enrichment courses inflate the total number of Carnegie credits earned for some transcripts.