Gifted Profile and Testing Data may be imported using the following CSV file formats. Naming convention for dates should always be MM/DD/YYYY (eg. 01/31/2018)

Gifted profile link

  • File Spec: gifted_profile.csv
  • Columns: Student Id is required, all other fields are optional.

Testing data link

Scores may be imported for a variety of assessments. Score files provided by testing vendor may need to be manually re-formatted to match the file specifications below. For each file, columns Student Id, Test Name and Test Date are required. All other columns are optional.

  • Achievement Scores (eg Terra Nova)
    • File spec: achievement_scores.csv
    • Columns: Student Id, Test Name, Test Date, Setting, Grade, Rdg, Lang, Math, Sci, Soc St, Core
  • Cognitive Scores (eg InView)
    • File Spec: cognitive_scores.csv
    • Columns: Student Id, Test Name, Test Date, Setting, Grade, CSI, NC, SS, Verbal, Non Verbal, Total
  • NWEA MAPS Scores
    • File Spec: maps_scores.csv
    • Columns: Student Id, Test Name, Test Date, Term, Grade, RIT, RIT to Reading, Lexile, Percentile
  • ACT, Explore, Aspire Scores
    • File Spec: act_explore_aspire_scores.csv
    • Columns: Student Id, Test Name, Test Date, English Sub Sc, English Percentile, Math Sub Sc, Math Percentile, Reading Sub Sc, Reading Percentile, Science Sub Sc, Science Percentile, Composite Sub Sc, Composite Percentile
  • SAT, PSAT Scores
    • File Spec: sat_psat_scores.csv
    • Columns: Student Id, Test Name, Test Date, Reading, Math, Writing, Composite
  • OAA Scores
    • File Spec: oaa_scores.csv
    • Columns: Student Id, Test Date, Reading, Math, Writing, Science, Social St, ExtraCol
  • OGT Scores
    • File Spec: ogt_scores.csv
    • Columns: Student Id, Test Date, Reading, Math, Writing, Science, Social St, ExtraCol
  • Miscellaneous Test Scores
    • File Spec: misc_scores.csv
    • Columns: Student Id, Test Name, Test Date, ExtraCol1, ExtraCol2, ExtraCol3, ExtraCol4, ExtraCol5, ExtraCol6


.
.
.