Data Export Spec Sheet

LiteracyLens keeps every walkthrough, teacher record, and score on the device — see the On-Device Advantage for why. Exporting is the only way that data ever leaves the app, so this page documents exactly what's in every file it can produce: every column, every header, every filename pattern. Hand this to whoever has to approve the file before it lands in your evaluation system, board packet, or grant application.

1. How an export is triggered

Every file described here is generated locally on the device, from data already on the device, and only when a principal or licensed administrator taps a specific download button in the Export tab. Nothing exports on a schedule, in the background, or as part of signing in. See The On-Device Advantage for the full architecture.

Two one-tap presets pre-select sections for the Consolidated CSV: the Weekly Principal Packet (Observations + Gap Analysis) and the State Compliance Packet (Observations + Trends). Both are shortcuts to the same Consolidated CSV described in Section 8 — not separate file formats.

2. The five report types, at a glance

All five share the same 9 Science of Reading domains as columns or row values: Explicit Instruction Phonemic Awareness Phonics & Decoding Encoding & Spelling Fluency Vocabulary, Morphology & Syntax Comprehension Student Practice Intervention — the same 9 domains and 53 indicators documented in the User Guide.

3. Observations CSVPDF

One row per grade level served by the school (up to 6: K, 1st, 2nd, 3rd, 4th, 5th).

CSV columns (12)

PDF version: same 6 rows, but the 9 domain columns use compact single-word headers (Explicit, Phonemic, Phonics, Encoding, Fluency, Vocabulary, Comprehension, Student, Intervention) to fit print width, plus a KPI summary band above the table: school-wide alignment %, total observations, the lowest-scoring ("priority") domain, and the report date.

4. Teacher Profiles CSVPDF

One row per teacher on the roster, observed or not.

5. Gap Analysis CSVPDF

One row per domain × grade-level combination the app has flagged as below target — not every domain-grade pair, only the ones that need attention.

6. Trends CSVPDF

One row per month tracked, earliest first. Growth columns compare every month back to the first (baseline) month in the series.

CSV columns (19)

PDF version: same 19 fields with compact single-word domain headers, values suffixed with %.

7. School PD Plan CSVPDF

A budget-ready professional development plan generated from the current roster's gap data. The CSV has three labeled sections under one audit header; the PDF presents the same three groupings as formatted report pages.

Section 1 — Priority PD Needs (up to top 5 domains, ranked)

Section 2 — Teacher-to-PD Mapping (one row per teacher with a need)

Section 3 — Recommended Cohorts (teachers grouped for shared PD)

8. The Consolidated CSV

Combines any subset of Observations, Teacher Profiles, Gap Analysis, and Trends into a single file — one shared audit header, then each chosen section preceded by a marker line and followed by a divider:

## SECTION: OBSERVATIONS BY GRADE
Grade Level,Observation Count,...
K,4,85,72,...

## ============================================================

## SECTION: GAP ANALYSIS
Grade Level,Instructional Domain,Alignment Score %,Priority Level
3rd,Encoding & Spelling,20,Needs Support

This structure is deliberate: most platforms that accept CSV uploads for evaluation or observation data — including Frontline, Eduphoria, iObservation, and custom district data warehouses — expect a single file with clearly labeled sections and consistent column headers. A data coordinator can map each ## SECTION: block to the right import target, or strip the #/## header lines entirely and import the delimited data directly if the target system supports it. Check your platform's own import guide for its accepted format.

9. Walkthrough Summary Word (.doc)PDF

The one export that isn't a data table — a single observation, rendered as a narrative document, available immediately after you save a walkthrough. Both formats share the same content, built for two different moments: the editable Word file for the teacher's record, the PDF for the post-observation conference itself.

Format detail: the .doc file is a self-contained HTML document (UTF-8, with a leading byte-order mark) served with the application/msword MIME type — Microsoft Word opens it directly as a fully editable document. The PDF option opens the identical content in a new browser tab and triggers your browser's print dialog; save it from there.

10. Audit header, verbatim

Every export opens with a plain #-prefixed header block before the data begins — useful for a script or data coordinator scanning for where the real table starts. Two header lengths exist depending on the export:

Single-type CSV (Observations, Teachers, Gaps, Trends) — 8 lines

# LiteracyLens Export
# School: {your school name}
# Export Type: {observations | teachers | gaps | trends}
# Generated: {M/D/YYYY}
# Generated By: Principal — {account name}
# Anonymized: {Yes | No}
# © 2026 Sorvia LLC
#

Consolidated CSV — 10 lines

# LiteracyLens Consolidated Export
# School: {your school name}
# Sections: {comma-separated list of chosen sections}
# Generated: {M/D/YYYY}
# Generated By: Principal — {account name}
# Anonymized: {Yes | No}
# School-Wide SoR Alignment: {n}%
# Total Observations: {n}
# © 2026 Sorvia LLC
#

The School PD Plan CSV uses the same 10-line pattern with PD-specific fields (teachers analyzed, teachers with PD needs, both budget totals) plus the cost disclaimer from Section 7, in place of the alignment/observation lines above.

11. Anonymization

A single toggle in the Export tab, off by default. When on:

• Every teacher name in every export — CSV, PDF, and the Walkthrough Summary — is replaced with Teacher A, Teacher B, Teacher C… assigned by roster order.
• Scores, dates, grades, domains, and every other field are unchanged — only the name is substituted.
• The audit header records whether anonymization was applied to that specific file, so a downstream reviewer can tell at a glance.

12. CSV technical notes

• Encoding & delimiter: plain UTF-8 text, comma-delimited, one record per line.
• Quoting: RFC4180-style — any cell containing a comma, double quote, or line break is wrapped in double quotes, with internal double quotes doubled ("Smith, Dana").
• Formula-injection guard: any cell value starting with =, +, -, or @ is prefixed with a leading apostrophe before quoting, so a teacher name or note can never execute as a spreadsheet formula when the file is opened in Excel or Google Sheets.
• MIME type: served as text/csv.

13. PDF & Word file behavior

• "PDF" exports open a formatted report in a new browser tab and immediately trigger the browser's print dialog — choose Save as PDF (or your OS equivalent) to keep the file. Allow pop-ups for the LiteracyLens app if the tab doesn't open.
• The Word Walkthrough Summary downloads immediately as a .doc file and opens natively editable in Microsoft Word — no plugin or conversion step.

14. Filename reference

PDF exports are saved by your browser's print dialog, so their filename follows your browser's own "Save as PDF" default rather than a name LiteracyLens sets.

15. Related documents