Skip to content

Spark 3000

Key Information

Collection Template

Position Column Name Required Format Description
0 Data Type True Text Spark 3000
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 Subject True Mapped ID Accepted Values:
  • LITERACY
  • MATH
11 Start GE False Numeric Grade level equivalent, expressed as grade.fraction; for example, 12.2 is 2/10 through grade 12
12 End GE False Numeric Grade level equivalent, expressed as grade.fraction; for example, 12.2 is 2/10 through grade 12
13 Start Lexile False Integer (Small)
14 End Lexile False Integer (Small)
15 Accountability Numerator False Integer (Small) 0 (Negative Outcome, Excluded from Rates) or 1 (Positive Outcome) A student is considered to have a positive outcome if their End GE minus their Start GE is greater than or equal to 1. Students with a Start GE greater than or equal to 12 are excluded from rates, and their outcome is set to 0.
16 Accountability Denominator False Integer (Small) 0 (Excluded from Rates) or 1 (Included in Rates) Students with a Start GE greater than or equal to 12 are excluded from rates; all other students are included in rates.
17 Accountability Universe ID False Mapped ID This field denotes if a record is included in a school’s Accountability Measure or Charter Goals metric calculations.

Accepted Values:
  • EXCLUDED: ALTERNATIVE ACCOUNTABILITY CAMPUS
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN CURRENT YEAR
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN PRIOR YEAR
  • EXCLUDED: DID NOT MEET MINIMUM ENROLLMENT REQUIREMENTS
  • EXCLUDED: ENROLLED LESS THAN 30 DAYS AFTER 10TH DAY OF SCHOOL
  • EXCLUDED: INCOMPLETE TEST
  • EXCLUDED: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INELIGIBLE PARTICIPANT
  • EXCLUDED: INVALIDATED SCORE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: MISSING OR INSUFFICIENT SUPPORTING EVIDENCE
  • EXCLUDED: NEW TO US EXEMPTION
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT A CERTIFIED GRADUATE
  • EXCLUDED: NOT AUDITED AT LEA IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT ENROLLED ON ROSTERING DATE
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: OFF-GRADE TEST
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PENDING DC PCSB REVIEW
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PRIOR TO SY 2022-2023 DATA NOT COLLECTED
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • EXCLUDED: SCORE/OUTCOME DOES NOT MEET PASSING REQUIREMENT
  • EXCLUDED: STUDENT DECEASED
  • EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
  • EXCLUDED: STUDENT EXPELLED FOR FEDERALLY RECOGNIZED REASON
  • EXCLUDED: STUDENT IN NON-PUBLIC PLACEMENT
  • EXCLUDED: STUDENT RECEIVED CREDENTIAL IN PREVIOUS YEAR
  • EXCLUDED: STUDENT TRANSFERRED TO ANOTHER CAMPUS IN SAME LEA
  • EXCLUDED: STUDENT WITHOUT ENROLLMENT PERIOD, SCHEDULED TO BE DELETED
  • EXCLUDED: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: TEST NOT TAKEN
  • EXCLUDED: THREE-YEAR GRADUATE
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: CONDITIONAL/PROVISIONAL ACCEPTANCE
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: EVIDENCE/DOCUMENTATION NOT PROVIDED
  • INCLUDED: INSUFFIENCT EVIDENCE/DOCUMENTATION
  • INCLUDED: MIDDLE GRADES
  • INCLUDED: NOT IN SECTOR PARTICIPATION UNIVERSE
  • INCLUDED: NOT IN SECTOR REPORTING UNIVERSE

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.

  • No common errors