grades_csv
Turn lecturer grade spreadsheets into CSV files ready for Moodle gradebook import, with marks, feedback, and a separate list of rows needing review.
Instructions
Writes files, not Moodle. For each lecturer's file, a CSV ready for Moodle's gradebook import (Grades > Import > CSV file) into the right course: one row per ready student, identified by ID number, with the mark and — always next to it, since Moodle wipes a grade imported without it — the feedback. Blocked rows go to _to_check.csv with the reason, for the academic office to raise with the lecturer. Marks are written with a decimal point, exactly as the lecturer gave them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | A lecturer's .xlsx/.csv, or a folder of them (the Drive folder, downloaded and unzipped) | |
| items | No | Only when a column cannot be matched to a grade item: {"midterm": "Midterm"} | |
| out_dir | Yes | Folder to write into (created if missing) | |
| courseid | No | Only for a single file whose name does not identify one course |