Skip to main content
Glama

Zovo Gradebook

Generate progress reports

generate_progress_reports
Read-onlyIdempotent

Use this when the user wants a progress report template filled in for students; list ID and info columns (student number, StudentID, email, SIS, section) in ignore_columns so they stay out of the grades. Examples: printable progress reports, grade reports for parents, 'make a progress report for each student'. Takes the same roster and grading settings as calculate_class_grades plus optional teacher comments per student, class name, teacher, term, report date and a subset of students. Returns one PDF with one page per student (current grade and letter, category scores, each assignment with excused/missing/dropped marks, missing work list, comment) and the Excel gradebook. Does not email or post reports, and does not store data.

Input Schema

NameRequiredDescriptionDefault
fileNoA gradebook export as CSV or XLSX, e.g. the Google Classroom grades CSV or the Canvas gradebook export. One row per student, one column per assignment.
termNoGrading period, e.g. Fall 2026 Quarter 1.
paperNoletter (default) or a4.
rosterNoThe scores, one row per student: a pasted table (CSV, tab-separated or a markdown table) with a header row of assignment names, e.g. "Student, HW1, HW2, Quiz 1, Test 1\nAna Diaz, 18, 20, 9, 45\nBen Ito, 15, EX, 7, M". Also accepts a list of rows or [{"name":"Ana Diaz","scores":{"HW1":18,"Quiz 1":9}}]. Send this or file.
blank_asNoHow to treat empty cells: not_graded (default, left out) or zero (count as 0). EX means excused (left out); M or missing counts as 0.
commentsNoOptional teacher comment per student, e.g. {"Ana Diaz":"Strong quiz scores; turn in HW 3."} or lines "Ana Diaz: Strong quiz scores".
studentsNoSame as roster (either name works), e.g. [{"name":"Ana Diaz","scores":{"HW1":18}}].
id_columnNoThe header of the student ID / student number column, if any, e.g. "StudentID". It is ignored (same as ignore_columns).
categoriesNoCategory weights, e.g. "Homework 20%, Quizzes 30%, Tests 50%" or [{"name":"Quizzes","weight":30,"drop_lowest":1}]. Assignments are matched to categories by name (HW 3 -> Homework, Quiz 2 -> Quizzes, Unit Test -> Tests). Leave out for a total-points grade.
class_nameNoClass name for the files, e.g. Algebra 1, Period 3.
plus_minusNotrue for +/- letters (A+ 97, A 93, A- 90, ...). Default false.
assignmentsNoOptional details per assignment when names do not show the category or the points: [{"name":"Unit 1","category":"Tests","points_possible":50}], or lines like "Unit 1, Tests, 50". Mark bonus work with "extra_credit": true.
drop_lowestNoDrop each student's lowest scores per category, e.g. {"Quizzes": 1} or "Quizzes 1, Homework 2". A plain number applies to every category.
report_dateNoDate printed on the reports, e.g. October 26, 2026. Default: today (US Eastern).
letter_scaleNoLetter cutoffs. Default A 90, B 80, C 70, D 60, F below 60. Use "plus_minus" for A+ 97 / A 93 / A- 90 ... D- 60, or a custom list like "A 93, B 85, C 75, D 65".
teacher_nameNoTeacher or tutor name for the reports, e.g. Ms. Rivera.
only_studentsNoOptional subset of student names to print, e.g. "Ana Diaz, Ben Ito". Default: every student.
ignore_columnsNoColumns that are not scores and must not be graded or copied, by header name: student IDs, student numbers, SIS/login/email, section, notes. Example: ["Student Number", "Email"] or "StudentID, Nr albumu". Always name ID and info columns here.
points_possibleNoPoints possible when the table does not say: one number for every assignment (e.g. 100), a list in column order (e.g. "20, 20, 10, 50"), or {"Quiz 1": 10}. A 'Points possible' row in the table or headers like "Quiz 1 (10)" also work. Default 100.
category_scoringNoHow a category score is built: points (default, total points earned / possible in the category) or average (each assignment counts equally).
round_for_letterNotrue to round the final percent to a whole number before picking the letter (89.5 -> 90 -> A). Default false: 89.5 is a B.
show_class_averageNoPrint the class average on each report. Default true.

Output Schema

NameRequiredDescriptionDefault
kindYes
notesYes
pagesNo
statsYes
gradingYes
privacyYes
studentsYes
warningsYes
downloadsYes
categoriesYes
class_nameYes
distributionYes
graded_countYes
letter_scaleYes
missing_workYes
missing_totalYes
students_countYes
students_shownYes
assignments_countYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnly/idempotent/non-destructive/closed-world, so the bar is lower, yet the description still adds real value: it enumerates what the PDF contains (current grade and letter, category scores, excused/missing/dropped marks, missing work, comment), states the Excel gradebook is also returned, and disclaims emailing/posting and data storage. Minor gap: no mention of size limits, failure modes (e.g. unparseable roster), or cost despite very large string caps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

It is front-loaded: trigger first, then the ignore_columns tip, examples, input lineage, output contract, and exclusions in a logical order. It is dense but a few clauses merely re-list parameters already in the schema, which is the only thing trimming would improve.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 22-parameter, nested-schema tool, the description still covers what it does, when to reach for it, the key pitfall (ID/info columns leaking into grades), the input source shared with calculate_class_grades, and the exact deliverable. An output schema exists, so its brief return summary is a bonus rather than a requirement.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3 and the schema already documents most parameters in detail. The description adds procedural meaning for a few of the 22 params (ignore_columns must list ID/info columns 'so they stay out of the grades', optional comments/class name/teacher/term/report date, and a student subset), but leaves the others (categories, drop_lowest, letter_scale, category_scoring, points_possible) to the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

It uses a specific verb+resource ('a progress report template filled in for students') and immediately scopes output ('one PDF with one page per student ... and the Excel gradebook'). It also positions itself against the sibling by saying it 'takes the same roster and grading settings as calculate_class_grades', so an agent can tell the two apart without opening schemas.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives an explicit trigger ('Use this when the user wants...'), three concrete example phrasings ('printable progress reports, grade reports for parents, ...'), and explicit exclusions ('Does not email or post reports'). It also names the sibling whose inputs it shares, which effectively routes agents between the two tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources