Can I weight the tests?

Yes — change the average formula to a weighted one, or ask the AI to do it.

Can I change the grade boundaries?

Yes — edit the thresholds in the grade formula.

Can I open it in Excel?

Yes — download it as Excel and it opens in Excel, Google Sheets and Numbers with its layout, styles and formulas intact.

How much does it cost?

You can open your file, convert it and check or change everything in the studio before you pay anything. Downloading the finished file is part of every MojoPDF plan — start with the 7-day trial for $1 and cancel any time.

Templates

Gradebook Template

A gradebook with averages and letter grades, ready to fill in — students and assessments; average per student; and more. Open it in Mega Excel Studio, make it yours, then download it.

Use this template

What's inside

Students and assessments
Average per student
Letter grade calculated
Class average per test
Chart of averages

Use this template Or start a blank workbook

Edit it as much as you like — downloading the finished file is part of every plan.

Private & secure· Every part editable· Download as Excel

A gradebook template you can edit online

Averaging scores and converting them to grades for a whole class takes hours by hand. This gradebook template gives you a gradebook with averages and letter grades: students and assessments; average per student; letter grade calculated; class average per test; and chart of averages. Press Use this template and it opens in Mega Excel Studio, ready to fill in — replace the example text, change colours and fonts, and ask the AI assistant to add formulas, rows or a chart. When it's ready, download it as Excel (.xlsx), PDF or CSV; it opens in Excel, Google Sheets and Numbers.

Ready-made

Students and assessments.

AI assistant

It can add formulas, rows or a chart.

Download as Excel

Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Press Use this template. It opens in Mega Excel Studio, where you replace the example text with yours, change anything you like, and download it when it's ready.