Marks Sheet & Report Card (Excel)
Enter each student's marks once and get the whole class result: totals, percentage, grade, class rank and pass or fail. Then pick a roll number on the Report Card sheet and print a neat report card for that student, with subject-wise marks, grades and remarks.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
Marks
| Roll | Name | English | Hindi | Mathematics | Science | Social Science | Punjabi | Total | Max | % | Grade | Rank | Result |
| 1 | Aarav Sharma | 57 | 79 | 76 | 50 | 65 | 80 | 407 | 600 | 67.8% | B2 | 6 | Pass |
| 2 | Ananya Singh | 72 | 82 | 79 | 46 | 80 | 42 | 401 | 600 | 66.8% | B2 | 7 | Pass |
| 3 | Ishaan Verma | 95 | 72 | 58 | 77 | 56 | 54 | 412 | 600 | 68.7% | B2 | 5 | Pass |
| 4 | Diya Kaur | 87 | 72 | 76 | 95 | 77 | 72 | 479 | 600 | 79.8% | B1 | 1 | Pass |
| 5 | Kabir Gupta | 67 | 82 | 97 | 51 | 56 | 82 | 435 | 600 | 72.5% | B1 | 3 | Pass |
| 6 | Meera Joshi | 51 | 97 | 24 | 66 | 89 | 42 | 369 | 600 | 61.5% | B2 | 8 | Fail |
| 7 | Rohan Das | 84 | 91 | 46 | 52 | 90 | 79 | 442 | 600 | 73.7% | B1 | 2 | Pass |
| 8 | Saanvi Patel | 44 | 61 | 91 | 43 | 94 | 97 | 430 | 600 | 71.7% | B1 | 4 | Pass |
What's inside
- Setup: school, class, exam name, up to 6 subjects with maximum and pass marks
- Editable grade scale (A1 to E, like the 9-point scale many boards use)
- Marks sheet for 60 students: total, percentage, grade, rank and result
- Report Card sheet: pick a roll number, print on A4, with teacher remarks and signature lines
How to use it
- On the Setup sheet type the school name, class, exam and your subject names with maximum and pass marks.
- Check the grade scale and change it if your school uses different cut-offs.
- On the Marks sheet type roll numbers, names and marks. Results calculate as you type.
- On the Report Card sheet pick a roll number from the list and type the remarks.
- Print the report card (File › Print). Pick the next roll number and print again.
Tips
- Leave a subject name empty on the Setup sheet if you have fewer than 6 subjects; it is ignored.
- Students with the same total get the same rank.
- Type AB for absent: it counts as zero and the student's result shows Fail for that exam.
Questions and answers
How is the grade decided?
From the overall percentage using the grade scale on the Setup sheet. Change the cut-offs there.
When does a student fail?
When the marks in any subject are below that subject's pass marks.
Can I print all report cards at once?
In this free version you print one at a time by changing the roll number; it takes a few seconds each.
More in the Teachers & Tutors toolkit
Student Attendance Register (Excel)Free monthly student attendance register for Excel: mark P, A or L for up to 60 students, Sundays shaded, totals and att…Excel templateTuition Fee Register (Excel)Free Excel fee register for tutors and coaching centres: students, fee payments, a month-by-month paid grid, total dues …Excel templateOnline Report Card MakerMake a student report card online: subjects, marks, percentage, grade and remarks. Print, save as PDF or download as Exc…Online tool
Also useful
GST Invoice Template (Excel)Free GST tax invoice template for Excel. Pick a customer and items; it fills HSN, rates, CGST+SGST or IGST and the amoun…Excel templateGST Monthly Summary (Excel)Free Excel workbook that totals a month's sales and purchases by GST rate: taxable value, IGST, CGST, SGST, B2B and B2C,…Excel templateClient Dues & Ageing (Excel)Free Excel receivables tracker: list bills and receipts, see each client's balance by age (not due, 1-30, 31-60, 61-90, …Excel template