grades_check
Check lecturer grade files for import readiness: match columns to Moodle grade items, identify blocked rows with reasons, and list missing student enrolments.
Instructions
Reads only. For each lecturer's grade file (or every file in a folder): which Moodle course its name points at, which gradebook item each mark column goes to (Final, resit, ...) and where the feedback goes (Evaluation / Feedback ...), and for every student whether the row is ready or blocked, with the reason (not a number, student not enrolled in that course, duplicate row...). Also lists enrolled students missing from the file. Marks written 57,5 or 57.5 are both read as 57.5.
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"} | |
| courseid | No | Only for a single file whose name does not identify one course |