# Family school records archive workflow

Use when archiving children's school reports, certificates, Zwischenberichte, Lernberichte, scans/photos, and producing longitudinal learning summaries.

## Durable structure

Recommended folder shape under the family/school area:

```text
Schule/Zeugnisse/
  README.md
  <school-year>/
    README.md
    Zeugnis_<Kind>_<Jahr>.pdf
    Zwischenberichte_<date>/
      README.md
      Zwischenbericht_<Kind>_<Jahr>_<date>.pdf
  Archiv_<range>_<children>/
    README.md
    Dokumente/<Kind>/<school-year>/<date>_<type>/
      *.jpg
      *.pdf
    Auswertung/
      Leistungsentwicklung_<Kind>.png
      Leistungsentwicklung_<Kinder>_Auswertung.pdf
    document_index.csv
    leistungsentwicklung_daten.csv
    leistungsentwicklung_daten.json
```

## Extraction and documentation

- Preserve original photos/JPGs and create A4 PDFs for each real document.
- Group multi-page reports by child, school year, date, and document type; keep duplicate/extra scans but do not include duplicate pages in the canonical PDF unless they are genuinely distinct.
- Create a human `README.md` plus machine-readable `document_index.csv` with: child, date, school year, class, document type, teacher, source/method, PDF path, SHA256.
- For longitudinal analysis, maintain `leistungsentwicklung_daten.csv/json` with one row per child/date/subject/value/source.

## Qualitative early reports

Swiss/Aargau early primary reports may use qualitative categories instead of numeric grades. For trend charts, explicitly mark the conversion, e.g.:

| Qualitative | Chart value |
|---|---:|
| sehr gut | 6 |
| gut | 5 |
| genügend | 4 |
| ungenügend | 3 |

Label these values as approximations for visualization only, not official grades.

## Verification

- Run `pdfinfo` on generated PDFs and confirm A4 page size/page count.
- Render all PDFs to PNG/contact sheets with `pdftoppm` and visually inspect that pages are complete and not cropped.
- For reports/charts, render the final PDF and inspect for clipped titles, legends, tables, and unreadable labels.