Agoge Platform — Sample Assignments

Every document below was produced by the assignment generators, not written by hand — 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 →

SQL 2

Complete instructor packages from the SQL assignment generator: the assignment students receive, the rubric that scores it, the full answer key, and a private TA guide. All four come out of one specification.

Assignment package · 8 questions · 100 points · MySQL

Sakila Video — Rentals and Revenue

Filtering, joins and aggregation over a DVD-rental database. Every solution is written in 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 for this assignment 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 for this assignment scores 100 / 100 against the same rubric.

Excel 2

The same package for spreadsheets, plus the workbooks themselves — a starter file with the answer cells highlighted, and a solution file 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. Ships with a starter workbook and a complete solution workbook.

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 for this assignment 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

53 / 100 F

XLSX16 KBPDF10 KBTXT11 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: 53 / 100 (F). The reference solution for this assignment scores 100 / 100 against the same rubric.

Each package is generated together from a single specification, so the rubric, the answer key and the TA guide cannot drift from the assignment. The Excel rubrics also carry machine-checkable assertions, which is how the grader distinguishes a hard-coded number from a calculated one, and a correct formula in the wrong cell from a missing one.