L0166 -- Spreadsheet Assessments

Languages
1

L0166 is a Graffiticode language for creating interactive spreadsheet-based assessments. Learners fill in cells and receive automated validation against expected values.

What it does

L0166 lets educators and assessment creators build quizzes and exercises using a familiar grid-based spreadsheet interface with built-in grading. Think of it as a way to author auto-graded spreadsheet homework without needing a full spreadsheet application.

Key capabilities

  • Cell validation with expected values
  • Formula functions including SUM, AVERAGE, ROUND, and IF
  • Parameterized templates for randomized assessments (so each student gets a unique variant)
  • Rich styling options for fonts, colors, and borders

Sample program

Here is a simple example of a arithmetic assessment:

columns [
  column A width 100 align "center" {}
] cells [
  cell A1 text "10" {}
  cell A2 text "20" {}
  cell A3 text "" assess [
    method "formula"
    expected "=SUM(A1:A2)"
  ] {}
] {
  v: "0.0.1"
}..

Links

Here is a simple example of a single celled spreadsheet with a validation:

columns [
  column 'A' width 50 {}
] cells [
  cell A1 text '20' assess [
    method 'value'
    expected '20'
  ] {}
] {
  v: '0.0.3'
}..