AP Student Datafile for Schools and Districts 2019 Layout Format

AP Student Datafile for Schools and Districts 2019 Layout Format

This document describes the layout and content of the AP Student Datafile for Schools and Districts for the 2018-19 school year. It is a 244-field comma separated value (CSV) file with each data value contained within double-quotes.

File Specification

Type # Field Name

Max Optional? Length

1 AP Number

No

8

2 Last Name 3 First Name 4 Middle Initial

No

15

No

12

Yes

1

5 Student Street Address 1

Yes

30

6 Student Street Address 2

Yes

30

7 Student Street Address 3

Yes

30

8 Student State

Yes

2

9 Student Zip Code

Yes

9

10 Student Province

Yes

32

11

Student International Postal Code

Yes

10

12 Student Country Code

Yes

3

13 Sex

No

1

Student Information

14 Date of Birth

Yes

6

15 Social Security Number

Yes

0

16 School ID

Yes

0

17 Education Level

Yes

2

18 Filler

Yes

0

19

Ethnic Group 2015 and Prior

Yes

2

? 2019 The College Board

Comment Student's UID, if available, or AP Number for this exam administration. The student's surname The student's given name The student's middle initial. First line of the student's street address. Second line of the student's street address. Third line of the student's street address. State code of the student's street address (Domestic Only). Nine-character Zip Code of the student's street address (domestic only). International only

International only

International only A code that represents the student's gender. Valid values include:

F = Female M = Male U = Unknown A = Another (new for 2019) The date the student was born (MMDDYY) Always blank Always blank A code that represents a grade level such as freshman, sophomore, junior and so forth. Valid values include: 3 = < 9th Grade 4 = 9th Grade 5 = 10th Grade 6 = 11th Grade 7 = 12th Grade 8 = No longer in high school 11 = Unknown Always blank Code representing the ethnicity the student has self-reported. See Ethnic Group 2015 and Prior table below.

Page 1 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Awards Information

Previous AI Information

Type

# Field Name

20 Student Search Indicator

21 Best Language

22 Previous AI Year 1

23 Previous AI Code 1

24 Previous AI Year 2

25 Previous AI Code 2

26 Award Type 1 27 Award Year 1 28 Award Type 2 29 Award Year 2 30 Award Type 3 31 Award Year 3 32 Award Type 4 33 Award Year 4 34 Award Type 5 35 Award Year 5 36 Award Type 6 37 Award Year 6

Optional?

No

Yes

Yes

Yes

Yes

Yes

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Max Length

1

1

2

6

2

6

2 2 2 2 2 2 2 2 2 2 2 2

Comment Identifies whether the student chose to participate in the College Board Student Search Service. Valid values include:

Y = Yes N = No Code representing the student's best language. 1 = English Only 3 = English and Another 4 = Another 0 = No Response The Year (YY) that the student attended a previous school. Unique code identifying the school that the student previously attended. Six digits, with leading zeros, if applicable. The Year (YY) that the student attended a previous school (2 schools prior). Unique code identifying the school that the student previously attended (2 schools prior). Six digits, with leading zeros, if applicable. The type (see below) and year (YY) of the student's most recentlyawarded AP Scholar Award, if any. The 2nd most recently-awarded AP Scholar Award. The 3rd most recently-awarded AP Scholar Award. The 4th most recently-awarded AP Scholar Award. The 5th most recently-awarded AP Scholar Award. The 6th most recently-awarded AP Scholar Award.

? 2019 The College Board Page 2 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Exam Information

College Institution Information

High School Information

Type

# Field Name 38 AI Code

39 Institution Name

40 AI Street Address 1

41 AI Street Address 2

42 AI Street Address 3

43 AI State

44 AI Zip Code

45 AI Province

46

AI International Postal Code

47 AI Country Code

48 College Code

49 Contact Name

50 Institution Name

51 DI Street Address 1

52 DI Street Address 2

53 DI Street Address 3

54 DI State

55 DI Zip Code

56 DI Province

57

DI International Postal Code

58 DI Country Code

59 Admin Year 01

60 Exam Code 01

61 Exam Grade 01

62 Irregularity Code #1 01

Optional?

No

Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes

Yes

Yes

Yes Yes Yes Yes Yes Yes Yes Yes No

No

Yes

Yes

Max Length

6

30 30 30 30 2 5 32 10 3

6

30

30

30 30 30 2 5 32 10 3 2

2

1

2

Comment Unique code identifying the school the student attended in the selected year. Six digits, with leading zeros, if applicable. Name of the school the student attended in the selected year. First line of the street address of the school. Second line of the street address of the school. Third line of the street address of the school. State code of the school. The 5-digit zip code of the school (domestic only). International only

International only

International only Unique code identifying the college, university, or scholarship program to which the student has requested to send AP scores in the selected year (Format = 00####). The contact within the institution to which the student has requested to send AP scores. The name of the institution to which the student has requested to send AP scores. First line of the street address of the institution. Second line of the street address of the institution. Third line of the street address of the institution. State code of the institution (Domestic Only). The 5-digit zip code of the institution (Domestic Only) International only

International only

International only The year (YY) of the student's most recent AP exam The exam code of the student's most recent AP exam. See Exam Code table below. The converted score (1-5) of the student's most recent exam. Code indicating the type of irregularity or event related to the student's most recent AP exam, if

? 2019 The College Board

Page 3 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Type # Field Name 63 Irregularity Code #2 01

64 Class Section Code 01

65 Admin Year 02 66 Exam Code 02 67 Exam Grade 02 68 Irregularity Code #1 02 69 Irregularity Code #2 02 70 Class Section Code 02

71238

Exams 3 through 30

239

Date Grades Released to College

240

Date of Last Student Update

241 Date of this report

242 Student Identifier

Reporting Dates

Student Information Continued

Race Ethnicity Student 243 Response 2016 and

Forward

Derived Aggregate Race 244 Ethnicity 2016 and

Forward

Optional?

Yes

Yes Yes Yes Yes Yes Yes Yes Same

Yes No No Yes

Yes

Yes

Max Length

2

1 2 2 1 2 2 1 Same

6 6 6 25

11

2

Comment any. See Irregularity Code table below. Code indicating the type of irregularity or event related to the student's most recent AP exam, if there is more than one. The section code the student designated on the answer sheet. Optionally used when a school has multiple classes and/or teachers for an AP exam. Assigned by the AP Coordinator.

The year, exam code, score, irregularity code(s), and section code of the student's 2nd most recent AP Exam.

The same set of 6 fields (including year, exam code, score, irregularity code(s), and section code) repeats for the student's 3rd through 30th most recent AP Exams, if applicable. The date (MMDDYY) on which the student designated the DI to receive scores. The date (MMDDYY) on which the student's record was last updated. The date (MMDDYY) this report was generated. An ID assigned to the student by the school, school system, state, or other entity. The student's self-reported race and/or ethnicities. All characters contain a value of `Y' or a 'N'. The letter `Y' indicates that this race/ethnicity value was selected by the student while the letter 'N' indicates it was not. One, multiple, or no race/ethnicities may be designated with a 'Y'. See Race Ethnicity Student Response 2016 and Forward table below. The student's aggregate race/ethnicity per federal reporting guidelines. See Derived Aggregate Race Ethnicity 2016 and Forward table below.

? 2019 The College Board Page 4 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Award Types table

Type

01 02 03 04 05 06 07 08 09 12 13 14

Description AP Scholar AP Scholar with Honor AP Scholar with Distinction State AP Scholar National AP Scholar National AP Scholar (Canada) AP International Diploma DoDEA AP Scholar International AP Scholar National AP Scholar (Bermuda) AP Capstone Diploma AP Seminar and Research Certificate

Exam Codes table

Code

7 13 14 15 16 20 22 23 25 28 31 32 33 34 35

36

37

40 43 48 51 53 55

Description

United States History Art History Studio Art: Drawing Portfolio Studio Art: 2-D Design Portfolio Studio Art: 3-D Design Portfolio Biology Seminar Research Chemistry Chinese Language and Culture Computer Science A Computer Science Principles Computer Science AB Microeconomics Macroeconomics English Language and Composition English Literature and Composition Environmental Science European History French Language and Culture French Literature Human Geography German Language and Culture

Discontinued

2010

2010

Code

57

58

60 61 62

64

66 68 69 75 76 77 78 80

82

83 84 85 87 89 90 93

Description

United States Government and Politics Comparative Government and Politics Latin Latin Literature Italian Language and Culture Japanese Language and Culture Calculus AB Calculus BC Calculus BC: AB Subscore Music Theory Music Aural Subscore Music Non-Aural Subscore Physics B Physics C: Mechanics Physics C: Electricity and Magnetism Physics 1 Physics 2 Psychology Spanish Language and Culture Spanish Literature and Culture Statistics World History

Discontinued 2010

2014

? 2019 The College Board Page 5 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Irregularity Codes table

Code

01 02 03 04 20 34 37 38 39 40 42 44 51 57 66 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98

Description Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score canceled - student's choice per options received School reported undertiming of 5 minutes or less School reported distraction during exam Portion of exam lost - score projected from remainder Media not scorable - score projected from remainder School started exam late School reported undertiming of more than 5 minutes Portion unscorable - score projected from remainder Score projected from multiple-choice section Score projected from free-response section Score projected from multiple-choice and free-resp. sections School reported overtiming of more than 5 minutes Score projected from 75% of exam Score projected from 80% of exam Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score canceled due to missing portion of exam Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible Score delayed - will be reported as soon as possible One Or More Performance Tasks Not Scored Score canceled Score delayed - will be reported as soon as possible Score canceled at student's request Second exam canceled - was not authorized In process - contact us if score not received by 9/1 Score delayed - will be reported as soon as possible Score withheld on college report at student's request

? 2019 The College Board Page 6 of 7

AP Student Datafile for Schools and Districts 2019 Layout Format

Ethnic Group 2015 and Prior table

Code

0 1 2 3 4 5 6 7 9 10

Description I do not wish to respond American Indian or Alaska Native Asian, Asian American, or Pacific Islander Black or African American Hispanic Mexican or Mexican American Puerto Rican Other Hispanic, Latino, or Latin American White Other

Race Ethnicity Student Response 2016 and Forward table

Note: starting in 2016, AP students have been able to select multiple races/ethnicities, requiring a field that reflects all of the student's selections. As a result, this field is position-based (not code-based) containing values of `Y' or `N' corresponding to each race/ethnicity. For example, if a student selects `Cuban' and `Puerto Rican, this field would contain the following value: "YNYNNNNNNNN" with values of `Y' in positions 1 and 3.

Position

1 2 3 4 5 6 7 8 9 10 11

Description Cuban Mexican Puerto Rican Other Hispanic Or Latino Non-Hispanic Or Latino American Indian Or Alaska Native Asian (Including Indian Subcontinent And Philippines Origin) Black Or African American (Including Africa And Afro-Caribbean Origin) Native Hawaiian Or Other Pacific Islander White (Including Middle Eastern Origin) Other

Derived Aggregate Race Ethnicity 2016 and Forward table

Code

0 1 2 3 4 8 9 10 12

Description No Response American Indian/Alaska Native Asian Black/African American Hispanic/Latino Native Hawaiian or Other Pacific Islander White Other Two Or More Races, Non-Hispanic

? 2019 The College Board Page 7 of 7

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download