Data Export Spec Sheet

This specification describes the current working web demo’s export formats, checked against the application source on September 20, 2026. It is a reference for school leaders and data teams preparing reports or mapping files into another system.

1. How an export is triggered

In the current browser demo, report downloads are generated locally when the observer chooses a report and format in Export. The Walkthrough Summary is available from the walkthrough workflow. Review the content and any teacher-name substitution before downloading or printing.

Two one-tap presets pre-select sections for the Consolidated CSV: the Weekly Principal Packet (Observations + Gap Analysis) and the Implementation Evidence 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 56 indicators documented in the User Guide.

3. Observations CSVPDF

The current exporter writes six grade rows: K, 1st, 2nd, 3rd, 4th, and 5th. Check Observation Count before interpreting any row; a grade without recorded visits should not be treated as evidence of weak instruction.

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

The current exporter includes domain–grade values below 75%, sorted lowest first. It does not filter by observation count, so check evidence availability before using the list to set priorities.

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: the same domain and growth fields use shortened headers for printing. Use CSV header names for field mapping.

7. School PD Plan CSVPDF

A professional development planning report based on recorded observation patterns. Its three sections cover priority needs, teacher-to-program mappings, and learning cohorts. Export it as CSV or PDF using the shared report controls, or select it for inclusion in the consolidated CSV. Pricing, cost estimates, investment totals, and cost disclaimers have been removed.

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

Section 2 — Teacher-to-PD Mapping (one row per roster teacher)

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

8. Consolidated CSV

Select any of the five report types. The exporter writes selected blocks in this order: Observations, Teacher Profiles, Gap Analysis, Trends, then the three School PD Plan tables. The file has multiple header rows and different table widths.

The first four blocks use ## SECTION:; the School PD Plan uses the three distinct markers shown above. The current consolidated metadata block may be serialized as multiple comma-separated cells in one record. Do not rely on a fixed number of physical header lines.

Presets select reports; they do not download until you choose Download Consolidated CSV. LiteracyLens does not provide a vendor-specific import or automatic sync. Confirm your receiving system’s schema and test a sample.

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. Export metadata

The current individual CSV exporters identify the school, export type, generation date, demo generator label, anonymization setting, and copyright. They do not include a license ID.

# LiteracyLens Export
# School: {school name}
# Export Type: {observations | teachers | gaps | trends}
# Generated: {locale-formatted date}
# Generated By: Principal — Demo Account
# Anonymized: {Yes | No}
# © 2026 Sorvia LLC
#

School PD Plan uses School PD Plan as the export type and a blank record before its table markers. The consolidated file adds selected section keys, school-wide alignment, and total observations. Its metadata serialization differs from the individual reports; locate table markers rather than skipping a fixed line count.

Printable reports and Walkthrough Summary use formatted headings and an audit footer rather than the same CSV preamble. Metadata provides report context; it is not a verified identity, license check, or tamper-evident audit trail.

11. Teacher-name substitution and assessment boundaries

With Anonymize teacher names enabled, roster reports substitute labels such as Teacher A and Teacher B. The Walkthrough Summary uses the generic label Teacher and omits the teacher name from its filename. Scores, dates, grades, and other content remain.

Imported assessment data is for temporary reference only and does not live in the application. The file, student rows, raw scores, counts, percentages, and temporary analysis are not retained or exported. The confirmed focus can appear in Walkthrough Summary. Keep assessment values and identifiers out of free-text fields.

12. CSV technical notes

• Encoding: UTF-8 text, comma-delimited, MIME type text/csv; no BOM is added by the CSV functions.
• Quoting: Cells containing a comma, double quote, or newline are double-quoted; internal quotes are doubled. Record separators are LF. A quoted note may span physical lines, so use a CSV parser rather than splitting text on line breaks.
• Formula guard: Values starting directly with =, +, -, or @ receive a leading apostrophe. This also affects signed trend differences. This guard is not a guarantee that every spreadsheet application will treat all input safely; review exported free text before opening or sharing.
• Numbers and missing values: Inspect the specific report. Teacher scores are blank with no observations; missing trend values are blank and unavailable comparisons use an em dash. Do not convert every blank or em dash to zero.
• Dates: Generation dates and date-based filenames use the browser’s locale. Do not assume a fixed US date format.

13. PDF and Word behavior

• PDF: The web demo opens a formatted report in a new tab/window and invokes printing. Choose Save as PDF. Allow pop-ups if necessary, and inspect page breaks and wide tables before sharing.
• Editable summary: The .doc download contains Word-compatible HTML with a UTF-8 BOM and MIME type application/msword. It is not a binary Word document or a .docx file; Word may display a format/extension notice. Open and review it, then save in your preferred Word format if needed.
• Guide printing: Walkthrough Guide has its own Print / Save as PDF action. It prints guidance rather than school records and is separate from the five report types.

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