JCL Convention Grading

Everything for one convention, in order: build the answer sheet, write the key, print and scan, grade, and settle anything the reader could not read. Your work is kept in this browser only. Scans are sent to the grading server, processed, returned, and discarded — nothing is stored there.

1 Connect to the grading server Not connected

You only do this once per computer. Both values are remembered in this browser.

2 Design and print the answer sheet Default wording

Only the wording changes. The bubbles, the corner marks and the grid are fixed — the reader finds them by measurement, so moving them would stop it working. You may rename the seven Latin levels, but not add or remove any.

Latin levels

Seven names, in the order they are printed down the page. Whatever you write here is what a key file must use in its Excluded row.

Write-in lines

Directions

Printing

Print double-sided, flipping on the long edge, at 100% scale. "Fit to page" also reads correctly, but it shrinks the bubbles for no benefit. Do not print two pages to a sheet.

3 Write the answer key No tests yet

One column per test. Add the tests here, then either type the answers in below or download the file and fill it in a spreadsheet.

Test name Test ID Levels that may not sit it

Answers

Paste 80 answers per test — separated by spaces, commas or newlines, or as one unbroken string like ABCDE…. Several letters together mean all of them are required (ABD); a | separates alternatives (A|BD); an empty answer leaves the question unscored.

4 Thresholds Automatic

How dark a bubble has to be before it counts. Leave this alone unless you have a reason: the server measures it from each batch of scans, so a different scanner needs no adjustment.

5 Scan the sheets Read this before scanning
  • Scan double-sided, front page first, so every sheet is two consecutive pages.
  • 200–300 dpi. Colour, grayscale or black and white all work.
  • Turn off auto-rotate, deskew, auto-crop and blank page removal. Blank page removal will quietly drop a lightly-marked page and throw the whole batch out of order.
  • Save one PDF per batch of about 25 sheets. Your scanner can usually do this for you — set it to start a new file every 50 pages.

6 Grade the batches Nothing graded

Marked-up copies ring every bubble the reader acted on. They make a run noticeably slower and much larger to download, so leave them off unless you are checking the grading or showing someone how it works.

7 Settle anything unclear Nothing to review

Two kinds of thing reach this step. Unclear is a bubble too faint to call — the reader neither counts it nor ignores it, and asks instead. Missing is a required field it could not read at all. A question left blank is not an error: that is the student's choice.

Set the spreadsheet up, once

  1. Make a Google Sheet you will reuse all convention.
  2. Extensions → Apps Script, paste in review_sheet.gs, and Save.
  3. Click the Triggers (clock) icon → Add Trigger: function onSpreadsheetChange, source From spreadsheet, type On change. Save and accept the prompt.

For each review file

  1. File → Import → Insert new sheet(s) and pick the CSV. It has to create a new sheet — "Replace current sheet" will not trigger the script.
  2. The script adds the checkboxes, restores leading zeros, fits the columns and trims the blank rows. Several people can work at once.
  3. Tick every box in Done. A row that is not ticked will be refused — an untouched row means nobody has looked at it.
  4. File → Download → Comma-separated values, and bring it back below.