Create JSON datasets for the CBA Score Validator Extension. Upload a learner roster or photograph a filled assessment sheet — everything runs locally, nothing leaves your computer.
🖨️Print a Blank Template
Enter school & subject details, download an Excel sheet to print
📋Method 1 — Learner List
Upload your roster, set tasks & scoring rules, generate JSON
These fill the sheet header. Everything is printed in capitals to match the official layout.
2 Number of tasks
Every subject has a different number of tasks, so set them here — the sheet will size itself to fit. Paste max scores separated by commas (e.g. 10, 10, 10, 10, 10) and click Set tasks. Or add rows individually below.
Task
Max score
3 Blank rows to print
How many learner rows should the printed sheet have? Leave some spare rows if your class size may change.
4 Generate
Downloads an .xlsx file with the KNEC-style header, logo, and a blank scoring grid — sized portrait or landscape automatically based on the number of tasks. Print it, fill it in by hand, then scan it and use Method 2 — Score Sheet Photo to turn it into a dataset.
1 Roster
Upload the learner list as a PDF, Excel (.xlsx / .xls), or Word (.docx) file. You can also paste Assessment Numbers and names directly into the box below.
No roster loaded yet.
⚠️ Some scores weren't readable
2 Subject details
3 Tasks and max scores
Quick-fill from the page header — paste all max scores separated by commas (e.g. 4, 9, 5, 4, 4, 4) and click Set tasks. Or add rows individually below.
Task
Max score
4 Scoring rules by max value
Add one rule per distinct max score you have. Any task whose max isn't covered falls back to the default rule below.
When max =
Rule
Value
5 Generate
1 Subject details
2 Max scores per task
Enter the max scores printed on the sheet header before uploading the photo. OCR uses these to validate each score it reads.
No tasks set yet.
3 Upload or capture the assessment sheet
Upload a clear photo, or use your camera. Tips: good lighting, sheet flat on a table, no shadows across the table rows.
Rotate:0°⚠ If the photo is sideways, rotate until learner names appear on the LEFT and scores on the RIGHT
Ready. Rotate the image above if needed so names are on the LEFT, then click Start OCR.
4 Review extracted data
Green = high confidence.
Yellow = uncertain — check it.
Red = invalid or missing — must fix.
Click any cell to correct it directly. Assessment Number cells with an orange border were blank on the sheet — fill them in if you have the numbers.