Agoge Platform — Sample Assignments

Every file below was produced by the generators, not written by hand — datasets included — and every graded example was scored by the same graders that run against real submissions. No student data appears anywhere on this page; the datasets, names and submissions are synthetic.

Looking for the tutorial videos?

Lesson and solution walkthroughs, generated by the tutorial engine and recorded against a live database.

Watch the videos →

Datasets 3

A business context in a sentence or two becomes a working relational dataset: schema, realistic skewed data, a runnable SQL script, zipped CSVs and a narrative that matches the data. The model designs the schema; a seeded generator writes the rows, so the same brief and seed reproduce the same dataset byte for byte.

Seed brief · deterministic · no AI call

Pedal Works — Bicycle Shop Chain

Built from a bundled worked brief, so it needs no model at all. 8 tables, camelCase, MariaDB. This is the shape the ITM 209 exams used.

Pipeline Brief → schema → seeded rows

One-sentence brief · AI-designed schema · seeded rows

Bean & Bloom — Specialty Coffee Roastery

From a single sentence: 9 tables, 5,852 rows, farm-to-cup lineage with batch and order line junctions. camelCase, MariaDB.

Pipeline Rich field complexity, 7–10 tables

One-sentence brief · snake_case · PostgreSQL

Northlake Therapy — Physical Therapy Clinics

The same pipeline in a different house style and dialect — 8 tables, 4,404 rows, snake_case identifiers, PostgreSQL DDL.

Pipeline Naming style and dialect are inputs, not rewrites

SQL 2

Complete instructor packages: the assignment students receive, the rubric that scores it, the full answer key, and a private TA guide — all from one specification.

Assignment package · 8 questions · 100 points · MySQL

Sakila Video — Rentals and Revenue

Filtering, joins and aggregation over a DVD-rental database. Solutions follow the house style — schema-qualified tables, table-qualified columns, no aliases.

Generated by SQL Assignment Generator

Graded example · Marcus Webb · synthetic

81 / 100 B-

SQL2 KBPDF4 KBTXT4 KB

Sakila Video — Rentals and Revenue

A synthetic submission written with specific, deliberate mistakes, then run through the production grader. The score is whatever the grader returned — nothing was adjusted for presentation.

Deliberate mistakes

  1. Dropped the required ORDER BY clause
  2. Removed a WHERE filter, so the query returns every row
  3. Abandoned the schema.table / table.field house style
  4. Left one question blank

Result: 81 / 100 (B-). The reference solution scores 100 / 100 against the same rubric.

Assignment package · 8 questions · 100 points · MySQL

Chinook Music Store — Sales Analysis

Subqueries, CASE expressions and multi-table analysis over a digital music store, weighted toward the harder end.

Generated by SQL Assignment Generator

Graded example · Aisha Lund · synthetic

71 / 100 C-

SQL2 KBPDF4 KBTXT4 KB

Chinook Music Store — Sales Analysis

A synthetic submission written with specific, deliberate mistakes, then run through the production grader. The score is whatever the grader returned — nothing was adjusted for presentation.

Deliberate mistakes

  1. Dropped the required ORDER BY clause
  2. Removed a WHERE filter, so the query returns every row
  3. Abandoned the schema.table / table.field house style
  4. Left one question blank

Result: 71 / 100 (C-). The reference solution scores 100 / 100 against the same rubric.

Excel 2

The same package for spreadsheets, plus the workbooks themselves — a starter with the answer cells highlighted, and a solution with every formula, named range and chart already in place.

Assignment package · 8 tasks · 100 points · xlsx

Northwind Traders — Sales Analysis Workbook

Lookup, conditional logic, summarisation and charting over a year of regional sales orders.

Generated by Excel Assignment Generator

Graded example · Jordan Ellis · synthetic

59 / 100 F

XLSX13 KBPDF11 KBTXT11 KB

Northwind Traders — Sales Analysis Workbook

A synthetic submission written with specific, deliberate mistakes, then run through the production grader. The score is whatever the grader returned — nothing was adjusted for presentation.

Deliberate mistakes

  1. Hard-coded a total instead of using a formula
  2. Put a correct formula in the wrong cell
  3. Misspelled a required worksheet as “Dashbaord”
  4. Never built the required pivot table

Result: 59 / 100 (F). The reference solution scores 100 / 100 against the same rubric.

Assignment package · 9 tasks · 100 points · Python in Excel

Campus Energy Audit — Analysis with Python in Excel

Native formulas and Python in Excel side by side. The =PY() tasks read the grid with xl(), aggregate with pandas, and return a matplotlib figure into the cell.

Generated by Excel Assignment Generator

Graded example · Priya Raman · synthetic

54 / 100 F

XLSX16 KBPDF10 KBTXT10 KB

Campus Energy Audit — Analysis with Python in Excel

A synthetic submission written with specific, deliberate mistakes, then run through the production grader. The score is whatever the grader returned — nothing was adjusted for presentation.

Deliberate mistakes

  1. Left the Python visualisation task blank
  2. Typed a text note instead of a =PY() formula
  3. Hard-coded a computed ratio
  4. Never built the required pivot table

Result: 54 / 100 (F). The reference solution scores 100 / 100 against the same rubric.

Tableau 1

Worksheet-by-worksheet specifications with required shelves, filters and caption minimums, plus the extract and a typed .tds datasource.

Assignment package · 5 views + dashboard · 100 points

Bean & Bloom Roastery — Sales Dashboard

Five worksheets and a dashboard over the roastery's 1,200 roast batches. The .twbx starter carries the data inside it, with every field typed, roles assigned, and the required worksheets pre-named and pre-marked.

Generated by Tableau Assignment Generator

Power BI 1

Report pages and DAX measures, plus a .pbip starter project carrying the semantic model and relationships.

Assignment package · 3 pages · 4 DAX measures · 100 points

Northlake Therapy — Clinic Performance Report

A three-page report with DAX measures and drill-through. The starter is a .pbip project: the 8-table model, its relationships and the named report pages are already built, so students build visuals rather than plumbing.

Generated by Power BI Assignment Generator

Each assignment package is generated together from a single specification, so the rubric, the answer key and the TA guide cannot drift from the assignment. Rubrics are validated against their own reference solutions before release — a requirement the reference answer would fail is a defective requirement, not a student error.