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 4

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 · AI-designed schema · seeded rows

Cross-Grain Brewing — Craft Brewery

Brewing, wholesale distribution and taproom sales in one schema. Backs the second SQL assignment, whose reference answers were executed against exactly these rows.

Pipeline Backs an assignment with verified expected_rows

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 · MariaDB

Pedal Works — Service and Sales Analysis

Filtering, joins and aggregation across a bicycle retail and repair chain. Every reference solution was executed against the generated data, so the rubric records the exact row count each correct answer returns.

Generated by SQL Assignment Generator · Pedal Works dataset

Graded example · Marcus Webb · synthetic

83 / 100 B

SQL2 KBPDF4 KBTXT4 KB

Pedal Works — Service and 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: 83 / 100 (B). The reference solution scores 100 / 100 against the same rubric.

Assignment package · 8 questions · 100 points · MariaDB

Cross-Grain Brewing — Distribution Analysis

Subqueries, CASE expressions and multi-table analysis across brewing, distribution and taproom operations, weighted toward the harder end.

Generated by SQL Assignment Generator · Cross-Grain dataset

Graded example · Aisha Lund · synthetic

81 / 100 B-

SQL2 KBPDF4 KBTXT4 KB

Cross-Grain Brewing — Distribution 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: 81 / 100 (B-). 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

Verdant Grounds — Job Costing Workbook

Lookup, conditional logic, summarisation and charting over a season of commercial landscaping jobs.

Generated by Excel Assignment Generator

Graded example · Jordan Ellis · synthetic

76 / 100 C+

XLSX19 KBPDF11 KBTXT11 KB

Verdant Grounds — Job Costing 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: 76 / 100 (C+). The reference solution scores 100 / 100 against the same rubric.

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

Riverbend Transit — Ridership 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

47 / 100 F

XLSX18 KBPDF11 KBTXT11 KB

Riverbend Transit — Ridership 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: 47 / 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 · Bean & Bloom dataset

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 · Northlake dataset

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.