Teaching · For Teachers

Every export column, mapped and accounted for.

Add a row for each field in the platform’s export: where it goes, what changes on the way and whether it carries personal information. The tool writes the mapping specification and lists what will break the load.

Start a mappingWhat you get
$19one-time · every device you sign in on
Buy · $19

Included with Caveat Classroom and Whole-school licenses. Or get it in the For Teachers toolkit, $79 for 84 items.

The data mapping tool

One mapping per export and destination. The example export is made up.

Loading the form. If nothing appears, turn on JavaScript.

What you get

Teaching · For Teachers$19 · included with Classroom and Whole-school licenses

What you finish with
A written mapping specification for one export: each field’s destination, type and rule, what is not mapped, and the checks to finish before the scores are used.
Who it is for
District data coordinators, assessment coordinators, school data teams and student information system staff.
Format
Browser tool. One saved mapping per export; printed with the specification or as a blank form; CSV of the field map; export and import a file.
Access
$19 one-time, yours on every device you sign in on; the tool opens once you are signed in with it. Included with Caveat Classroom and Whole-school licenses. Also in the For Teachers toolkit ($79) and the Teaching Suite pass ($199), and 1 more bundle. Everything you type stays in this browser; nothing is sent to Caveat.
Where it lives
The For Teachers space in Caveat Teaching.
Support
Questions about an order, access or a correction: team@caveatacademic.com.
IDDateWindowScoreNamestate_idtest_datetermscoreevery column has a place, or none
Drawn for this page. A mapping names the destination of every export column and the rule that changes it on the way, and leaves out what the destination does not need.

How to use it

  1. Open the platform’s export file and copy its header row, field by field.
  2. Write a rule for every recode, date change or calculation.
  3. Mark Do not load for fields the destination does not need.
  4. Run the load on a small file first and work through the checks.
  5. Keep the exported mapping with the load script so next season repeats it.

Start a mapping

What the mapping covers

Missing is not zero

Platforms mark students who were absent, exempt or not tested with codes or blanks. Loaded as zeros, they pull averages down and flag students who never sat the test.

Load less

The destination usually already holds names and demographics. Matching on an ID and loading only scores keeps personal information in fewer places.

What it is not

The tool does not read or convert files. It records the decisions so the person who builds the load, and next year’s team, can repeat them.

Sources

  1. National Forum on Education Statistics. Forum Guide to Data Governance, 2020, and Forum Guide to Planning for, Collecting, and Managing Data About Students, 2022.
  2. U.S. Department of Education, Privacy Technical Assistance Center. Data Security: Top Threats to Data Protection, and guidance on data minimization.
  3. Common Education Data Standards (CEDS), U.S. Department of Education: assessment and student identification elements.
  4. Family Educational Rights and Privacy Act, 34 CFR Part 99 (education records and disclosure).

The example export, field names and checks are made up. Support: team@caveatacademic.com.