Remix

Make your own version of Demo Learner Cleanup

Edit the prompt below and generate a customized version in seconds.

Original by NEW GENERATION ORIENTATE VISION LEARNERSHIP PROJECTS

Describe your app

# Demo data cleanup — NGOVLP_LMS_Master

Remove the 8 seeded demo learners and everything hanging off them, keep the course content and the installation record intact.

## Recommendation

**Keep the AuditLog and append a cleanup entry.** It is the record of what the installer built, not learner data — only 3 of its lines mention demo students, and it is the only place holding the Drive root folder ID needed for Stage 2. The demo learners are fictional (example.org addresses), so there is no personal data in the log that needs erasing.

**Take a backup snapshot first.** It costs one extra tab and makes the deletion reversible. You can delete the backup tab yourself once you are satisfied.

## Verified current state

Confirmed by reading the workbook directly:

| Tab | Data rows | Demo? |

|---|---|---|

| Students | 8 (rows 2-9) | all demo, STU-0001 to STU-0008 |

| Enrolments | 8 (rows 2-9) | all demo, one per student |

| Gradebook | 160 (rows 2-161) | all demo, 8 students x 20 items |

| Progress | 0 | nothing to clean |

| AuditLog | 19 (rows 2-20) | installation record, keep |

| CourseMeta / Curriculum / Lessons / Quizzes / Assignments / Resources | 22 / 10 / 30 / 10 / 10 / 30 | real content, no student references |

Every Gradebook row follows `GRD-<StudentID>-...` with blank Score, Passed, GradedAt and Grader — placeholders only, no marks are lost.

```text

Students (8)  ->  Enrolments (8)  ->  Gradebook (160 = 8 x 20)

Progress (0)

AuditLog (19) — installation record, retained

```

## Steps

1. **Snapshot** — create a `_DemoBackup_2026-08-19` tab holding the current Students, Enrolments and Gradebook rows, each block under a labelled header.

2. **Gradebook** — clear rows 2-161 (all 160 placeholders). Header row untouched.

3. **Enrolments** — clear rows 2-9 (all 8).

4. **Students** — clear rows 2-9 (all 8).

5. **Progress** — no action, already empty.

6. **AuditLog** — append one row: timestamp, `INFO`, stage `cleanup`, message `Demo data purged`, details listing the removed counts (8 students, 8 enrolments, 160 gradebook rows) and the backup tab name.

7. **Verify** — re-read every tab and confirm Students, Enrolments and Gradebook have 0 data rows, headers and formatting survive, and CourseMeta / Curriculum / Lessons / Quizzes / Assignments / Resources counts are unchanged at 22 / 10 / 30 / 10 / 10 / 30.

## Technical notes

- Clearing is done with `values:batchClear` on exact ranges (`Gradebook!A2:Z161`, `Enrolments!A2:Z9`, `Students!A2:Z9`), which empties cells and keeps the frozen header row, column widths and grid size. No row deletion, so nothing shifts.

- The backup tab is created with `batchUpdate` `addSheet`, then filled with `values:update`.

- The AuditLog entry is added with `values:append` so it lands on the first free row.

- All calls go through the linked Google Sheets connection; no app code changes are involved.

## Out of scope

Stage 2 (Google Drive folder `1Ay5YL2hlG_bJmMGEjoVQAqq4wXqFZXSl`) is not touched here. The Drive connector is not connected yet and will need linking when you are ready.

Free to use. No credit card required.