Skip to content

International Baccalaureate Grades

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type True Text International Baccalaureate Grades
1 LEA ID True Integer (Small)
2 LEA False Text
3 Campus ID True Integer (Small)
4 Campus False Text
5 School Year True Text YYYY-YYYY
6 USI True Integer (Big)
7 First Name False Text
8 Last Name False Text
9 Assessment Grade False Text
10 Course True Mapped ID Accepted Values:
  • BIOLOGY HL
  • BIOLOGY (HL)
  • BIOLOGY SL
  • BIOLOGY (SL)
  • BIOLOGY SL IN ENGLISH
  • CHEMISTRY HL
  • CHEMISTRY (HL)
  • CHEMISTRY SL
  • CHEMISTRY (SL)
  • CHINESE B HL
  • CHINESE B SL
  • DP BIOLOGY (HL)
  • DP BIOLOGY (SL)
  • DP CHEMISTRY HL
  • DP CHEMISTRY SL
  • DP CHINESE (HL)
  • DP CHINESE (SL)
  • DP FILM (HL)
  • DP FRENCH AB INITIO (SL)
  • DP PHILOSOPHY SL
  • DP PHYSICS (HL)
  • DP PHYSICS (SL)
  • DP PSYCHOLOGY (HL)
  • DP SPANISH (HL)
  • DP SPANISH LANG/LIT (SL)
  • DP SPORTS, EXERCISE, & HEALTH SCIENCE
  • DP VISUAL ART (HL)
  • DP VISUAL ART (SL)
  • ENGLISH A HL
  • ENGLISH A LAL SL
  • ENGLISH A: LANG AND LITERATURE HL IN ENGLISH
  • ENGLISH A: LITERATURE SL IN ENGLISH
  • ENGLISH A: LIT HL
  • ENGLISH A SL
  • FILM HL
  • FILM SL
  • FRENCH AB SL
  • FRENCH AB. SL
  • FRENCH A HL
  • FRENCH B HL
  • FRENCH B SL
  • GLOBAL POLITICS SL
  • GLOBAL POLITICS (SL)
  • GLOB. POL SL
  • HISTORY HL
  • HISTORY (HL)
  • HISTORY OF AMERICAS HL
  • HISTORY SL
  • HISTORY (SL)
  • HISTORY SL IN ENGLISH
  • HL BIOLOGY
  • HL ENGLISH
  • HL HISTORY
  • HOA-PEACE HL
  • INFORMATION TECHNOLOGY IN A GLOBAL SOCIETY (HL)
  • INFORMATION TECHNOLOGY IN A GLOBAL SOCIETY (SL)
  • ITGS IN ENGLISH
  • ITGS SL
  • LANGUAGE AB INITIO (SL)
  • LANGUAGE A: LANGUAGE AND LITERATURE (HL)
  • LANGUAGE A: LANGUAGE AND LITERATURE (SL)
  • LANGUAGE A: LITERATURE (HL)
  • LANGUAGE A: LITERATURE (SL)
  • LANGUAGE B (SL)
  • MANDARIN AB. SL
  • MATH AA HL
  • MATH AA SL
  • MATH AI HL
  • MATH AI SL
  • MATH ANALYSIS HL
  • MATH ANALYSIS SL
  • MATH APPS HL
  • MATH APPS SL
  • MATHEMATICAL STUDIES SL
  • MATHEMATICS: ANALYSIS AND APPROACHES (HL)
  • MATHEMATICS: ANALYSIS AND APPROACHES (SL)
  • MATHEMATICS: APPLICATIONS AND INTERPRETATION (HL)
  • MATHEMATICS: APPLICATIONS AND INTERPRETATION (SL)
  • MATHEMATICS SL
  • MATHEMATICS (SL)
  • MATH SL
  • MATH STUDIES SL IN ENGLISH
  • PHILOSOPHY SL
  • PHYSICS HL
  • PHYSICS SL
  • PSYCHOLOGY HL
  • PSYCHOLOGY SL
  • PSYCHOLOGY (SL)
  • PSYCHOLOGY SL IN ENGLISH
  • SL BIOLOGY
  • SL ENGLISH
  • SL HISTORY
  • SL MATH STUDIES
  • SL PSYCHOLOGY
  • SL SPANISH
  • SPANISH AB. SL IN ENGLISH
  • SPANISH AB: SL IN SPANISH
  • SPANISH A LAL SL
  • SPANISH A SL
  • SPANISH B HL
  • SPANISH B SL
  • SPORTS, EXERCISE, AND HEALTH SCIENCE SL
  • SPORTS EX SCI SL
  • THEORY OF KNOWLEDGE
  • VISUAL ARTS HL
  • VISUAL ARTS SL
11 Score True Integer (Small)
12 Accountability Numerator False Integer (Small) 0 (Negative Outcome) or 1 (Positive Outcome) A student is considered to have a positive outcome if their Score is greater than or equal to 4.
13 Review Status ID False Mapped ID Accepted Values:
  • 0
  • 1
  • -1
  • 2
  • -2
  • EXCLUDED: PENDING DC PCSB STAFF REVIEW
  • EXCLUDED: RESULT DOES NOT MEET BENCHMARK
  • EXCLUDED: SUPPORTING DOCUMENTATION DOES NOT MATCH RESULTS
  • EXCLUDED: SUPPORTING DOCUMENTATION REQUIRED
  • INCLUDED: RESULTS PROVIDED BY PUBLISHER
  • INCLUDED: RESULTS PROVIDED BY THE OFFICE OF THE STATE SUPERINTENDENT OF EDUCATION
  • INCLUDED: VERIFIED BY DC PCSB STAFF

Shading Key

Primary Key Column Column(s) which uniquely define the row, and is required in all submissions
Expected Column Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank
Calculated Column Column which is calculated based on other data (provided in submission or otherwise); these columns can be left blank
Non-Loaded Column Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions

Common Errors

Click on the error type to get more information.