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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>"
},
"name": "grades_check"
}
}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 |