Skip to content

Competency-Based Course Grades

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type False Text Competency-Based Course 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 Term False Integer (Small) Must match school's calendar (e.g. if offering semesterly courses, use values 1-2; if offering trimesters, use 1-3)
11 Subject False Mapped ID Accepted Values:
  • ART
  • CTE
  • ELECTIVE
  • ENGLISH LANGUAGE ARTS
  • HISTORY
  • LANGUAGE
  • LITERACY
  • MATH
  • MUSIC
  • READING
  • READING LANGUAGE ARTS
  • SCIENCE
  • SOCIAL EMOTIONAL LEARNING
  • SOCIAL STUDIES
  • WORLD LANGUAGE
12 Course False Mapped ID Must match school's course offerings identified at the start of the school year

Accepted Values:
  • ACT/SAT PREPARATION
  • ALGEBRA 1A
  • ALGEBRA 1B
  • ALGEBRA I
  • ALGEBRA I A
  • ALGEBRA I A/B
  • ALGEBRA I B
  • ALGEBRA II
  • ALGEBRA II A/B
  • AMERICAN STUDIES A
  • AMERICAN STUDIES B
  • ANATOMY AND PHYSIOLOGY
  • ART APPRECIATION
  • BASIC COMPUTER APPLICATION I
  • BASIC COMPUTER APPLICATION II
  • BASIC COMPUTER APPLICATIONS
  • BASIC COMPUTER APPLICATIONS I
  • BASIC COMPUTER APPLICATIONS II
  • BIOLOGY
  • BIOLOGY A/B
  • BIOLOGY A/B (ADVANCED)
  • BUSINESS ADMINISTRATION AND COMMUNICATION
  • BUSINESS ADMINISTRATION COMMUNICATION
  • BUSINESS ALGEBRA
  • CALCULUS A/B (ADVANCED)
  • CAREER PATHWAY - HOSPITALITY
  • CAREER PATHWAY-HOSPITALITY
  • CAREER PATHWAY - IT
  • CAREER PATHWAY - SECURITY
  • CAREER READINESS I
  • CAREER READINESS II
  • CAREER READINESS III
  • CAREER READINESS IV
  • CAREER READINESS V
  • CAREER READINESS VI
  • CHEMISTRY
  • CHEMISTRY A/B
  • CHEMISTRY A/B (ADVANCED)
  • CHINESE I
  • CHINESE II
  • CIVICS A/B
  • COL - DUAL CREDIT - INTRO TO MARKETING
  • COL-DUAL CREDIT-INTRO TO MARKETING
  • COL - DUAL CREDIT - INTRO TO PSYCHOLOGY
  • COL-DUAL CREDIT-INTRO TO PSYCHOLOGY
  • COLLEGE, CAREER, AND LIFE READINESS III
  • COLLEGE, CAREER, AND LIFE READINESS IV
  • COLLEGE READINESS I
  • COLLEGE READINESS II
  • COLLEGE READINESS III
  • COLLEGE READINESS IV
  • COLLEGE READINESS V
  • COLLEGE READINESS VI
  • CONSUMER MATH
  • CURRENT EVENTS IN STEM
  • DC HISTORY
  • DC HISTORY AND GOVERNMENT
  • DC HISTORY AND US GOVERNMENT
  • DC HISTORY IS
  • DUAL CREDIT
  • EARTH AND SPACE SCIENCE
  • EARTH SCIENCE
  • EARTH & SPACE SCIENCE
  • ECONOMICS
  • ENGLISH 10 A/B
  • ENGLISH 11 A/B
  • ENGLISH 12 A/B
  • ENGLISH 9 A/B
  • ENGLISH I
  • ENGLISH II
  • ENGLISH III
  • ENGLISH IV
  • ENGLISH LITERATURE AND COMPOSITION (ADVANCED)
  • ENRICHMENT SEMINAR
  • ENVIRONMENTAL SCIENCE
  • FOUNDATION IN HUMANITIES IV
  • FOUNDATIONS IN HUMANITIES I
  • FOUNDATIONS IN HUMANITIES II
  • FOUNDATIONS IN HUMANITIES III
  • FOUNDATIONS IN HUMANITIES IV
  • FOUNDATIONS IN HUMANITIES V
  • FOUNDATIONS IN HUMANITIES VI
  • FOUNDATIONS IN MATHEMATICS I
  • FOUNDATIONS IN MATHEMATICS II
  • FOUNDATIONS IN MATHEMATICS III
  • FOUNDATIONS IN MATHEMATICS IV
  • FOUNDATIONS IN STEM I
  • FOUNDATIONS IN STEM II
  • FOUNDATIONS IN STEM III
  • FOUNDATIONS IN STEM IV
  • FRENCH 1 A/B
  • FRENCH 2 A/B
  • FRENCH I
  • FRENCH II
  • GEOMETRY
  • GEOMETRY A/B
  • GERMAN 1 A/B
  • GERMAN 2 A/B
  • HEALTH
  • HEALTH AND WELLNESS I
  • HEALTH AND WELLNESS II
  • HEALTH AND WELLNESS III
  • HEALTH AND WELLNESS IV
  • HEALTH AND WELLNESS V
  • HEALTH AND WELLNESS VI
  • HEALTHCARE
  • HIGH SCHOOL EARTH AND SPACE SCIENCE, SEMESTER A/B
  • HOSPITALITY
  • INFORMATION TECHNOLOGY
  • INTEGRATED ARTS I (ART)
  • INTEGRATED ARTS II (ART)
  • INTEGRATED ARTS III (ART)
  • INTEGRATED ARTS III (MUSIC)
  • INTEGRATED ARTS II (MUSIC)
  • INTEGRATED ARTS I (MUSIC)
  • INTEGRATED ARTS IV (ART)
  • INTEGRATED ARTS IV (MUSIC)
  • INTEGRATED ARTS V (ART)
  • INTEGRATED ARTS VI (ART)
  • INTEGRATED ARTS VI (MUSIC)
  • INTEGRATED ARTS V (MUSIC)
  • INTEGRATED MATH 1 A/B
  • INTEGRATED MATH 2 A/B
  • INTEGRATED MATH 3 A/B
  • INTEGRATED MATHEMATICS I
  • INTEGRATED PHYSICS & CHEMISTRY A/B 
  • INTO. TO SENIOR SEMINAR
  • INTRO. TO SENIOR SEMINAR
  • LIFE DESIGN I
  • LIFE DESIGN II
  • LIFE DESIGN III
  • LIFE DESIGN IV
  • LIFE DESIGN V
  • LIFE DESIGN VI
  • LIFE SCIENCE A/B
  • LIFE SCIENCES (NON - LAB)
  • MANDARIN CHINESE 1
  • MANDARIN CHINESE 2
  • MATH 8 A/B
  • MATH ENRICHMENT
  • MATH LAB A
  • MATH LAB B
  • MUSIC APPRECIATION
  • PHYSCIAL SCIENCES I
  • PHYSCIAL SCIENCES II
  • PHYSICAL EDUCATION
  • PHYSICAL SCIENCE A/B
  • PHYSICAL SCIENCES II
  • PHYSICS
  • PHYSICS A/B
  • PRE-ALGEBRA
  • PRE-CALCULUS
  • PRECALCULUS A/B
  • PROBABILITY AND STATISTICS
  • PUBLIC HEALTH
  • READING FOUNDATIONS A
  • READING FOUNDATIONS A-1
  • READING FOUNDATIONS A-2
  • READING FOUNDATIONS B
  • SCHOOL READINESS COURSE
  • SCIENCE FOR PATHOLOGY AND PUBLIC HEALTH PATHWAYS
  • SECURITY & PROTECTIVE SERVICES
  • SENIOR SEMINAR
  • SPANISH 1
  • SPANISH 2
  • SPANISH I
  • SPANISH I A/B
  • SPANISH II
  • SPANISH II A/B
  • SPANISH III A/B
  • STEM II: BIOLOGY (LAB)
  • STEM III: PHYSICAL SCIENCES I (LAB)
  • STEM I: LIFE SCIENCES I (NON-LAB)
  • STEM IV: PHYSICAL SCIENCES II (LAB)
  • STRATEGIC CRITICAL THINKING
  • STRATEGIC CRITICAL THINKING SEMINAR
  • TRANSPORTATION/UTILITY/CONSTRUCTION
  • U.S. GOVERNMENT
  • US GOVERNMENT IS
  • U.S. HISTORY
  • US HISTORY
  • U.S. HISTORY A/B
  • U.S. HISTORY A/B (ADVANCED)
  • U.S. HISTORY IS
  • WORLD GEOGRAPHY A/B
  • WORLD HISTORY A
  • WORLD HISTORY A/B
  • WORLD HISTORY B
  • WORLD HISTORY I
  • WORLD HISTORY II
  • WORLD HISTORY SURVEY A/B
  • WORLD LANGUAGE AND CULTURES I
  • WORLD LANGUAGE AND CULTURES II
  • WORLD LANGUAGES AND CULTURE I
  • WORLD STUDIES A
  • WORLD STUDIES B
  • WRITING LAB
13 Grade False Mapped Text Accepted Values:
  • A
  • A-
  • A+
  • B
  • B-
  • B+
  • C
  • C-
  • C+
  • D
  • D-
  • D+
  • F
  • INC
  • NC
  • P
14 Credit Value False Numeric Must match schools course offerings identified at the start of the school year

Shading Key

Primary Key Column Column(s) which uniquely define the row, and is required in all submissions
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.

  • No common errors