Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

← TemplatesSchools & churches

Free Student Report Card Generator (Excel) for Kenyan schools

Marking a whole class by hand, then copying totals, means and positions onto every card, is where a term's worth of teacher time disappears. This free generator does the arithmetic for you: enter each learner's mark per subject and it grades every subject, works out the mean, the points and the exact class position, then fills a tidy A4 report card you pick a learner for and print.

Download — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • Auto-grades every subject from an editable, sourced grading scale
  • Mean, points and exact class position worked out with RANK
  • Pick a learner and a clean A4 report card fills itself in
  • Attendance summary and space for class-teacher and head-teacher remarks
  • Class summary: class mean, pass count and average per subject
  • Formulas locked; only the yellow cells accept typing

The tabs

  • Start Here (guide)
  • Setup & Grading
  • Marks Entry
  • Report Card (A4)
  • Class Summary

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • A class dashboard: class mean, pass rate and the grade distribution, drawn as in-cell bars
  • A printable A4 report card in English and Kiswahili (Alama, Daraja, Nafasi)
  • A subject-by-subject analysis that names the strongest and weakest areas
  • Per-learner teacher remarks stored on the register, so you can print the whole class in one batch
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On the Setup tab you enter your school name, term, year and class once, and confirm the grading scale (it ships with a standard Kenyan band, and you can edit any band if your school differs). On Marks Entry you add each learner and type their mark out of 100 for each subject. Total, mean, grade, points and position all compute themselves, and a mean below your pass mark turns red so weak results stand out.

The Report Card tab is the payoff: pick a learner from the dropdown and a clean one-page card fills in with every subject mark, its grade and remark, the mean, the position out of the class and an attendance summary, with space for the class-teacher and head-teacher comments. Yellow cells are the only ones you type in; the rest are locked formulas. It opens in Excel, WPS Office or Google Sheets, so you can mark from a phone.

Do it online instead

Build a printable transcript free with the transcript tool

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Frequently asked questions

Is the basic version really free?

Yes. Download the basic Student Report Card Generator, keep it, and use it term after term at no cost. The premium upgrade, with a class dashboard, a subject analysis and a bilingual card, is an optional KES 500.

How is the class position worked out?

Every learner's mean is compared against the whole class with the RANK function, so the position is exact and updates the moment you change a mark. The report card shows it as position out of the number of learners entered.

Can I change the grading scale?

Yes. The grading bands live on the Setup tab as editable yellow cells. If your school uses different marks for each grade, edit the bands once and every learner and card follows. Nothing is hard-coded into a formula.