CBSE report card format and marksheet template (free Excel)

Enter each student’s term marks once. The workbook adds them up, grades every subject on the CBSE 8-point scale, ranks the class and fills a printable report card for whichever roll number you pick.

The grading scale it uses

These are the marks ranges from CBSE circular Acad-14/2017. The bands are on a Settings sheet, so you can change them if your school uses its own scale.

MarksGrade
91 – 100A1
81 – 90A2
71 – 80B1
61 – 70B2
51 – 60C1
41 – 50C2
33 – 40D
32 & belowE (needs improvement in Classes 6 to 8, failed in Class 9)

Source: CBSE circular Acad-14/2017 (21 March 2017). CBSE withdrew this circular for Classes 6 to 8 in 2018, so those schools may set their own assessment. Many still use the same 8-point scale, which is why it is the default here.

What’s in the file

Settings

School name, session, class and section, subject names, the marks for each part of the term (periodic test, notebook, subject enrichment, exam) and the grade bands.

Students, Term 1 and Term 2

Student details, attendance and co-scholastic grades once, then each part of the term for every subject on the term sheets. Cells turn red when a mark is more than the maximum.

Class marksheet

Totals, percentage, grade per subject, overall grade and class rank, ready to print or share with the principal.

Report card

Type a roll number and the card fills itself: student details, both terms, grades, co-scholastic grades, attendance, remarks and signature lines.

How to use it

  1. Fill the Settings sheet first: school name, session, class, your subjects and the maximum marks for each part of the term.
  2. Add students on the Students sheet, then marks on the Term 1 and Term 2 sheets. Type AB or leave a cell blank if the student was absent.
  3. Check the Marksheet tab for totals, grades and rank.
  4. On the Report card tab, type a roll number and print. Repeat for each student, or save each one as PDF.

Questions

Is this the official CBSE report card format?

The layout follows the report card annexed to CBSE circular Acad-14/2017: two terms, a periodic test, notebook, subject enrichment and an exam, with grades on the 8-point scale. For Classes 6 to 8 that circular is no longer binding, so treat it as a sensible standard and adjust the Settings sheet to your school’s own scheme.

Does it work for Classes 1 to 5?

Not well. Primary classes are moving to the competency-based Holistic Progress Card under NEP 2020, which records much more than marks. This template is built for Classes 6 to 9.

Can I change the marks for each part of the term?

Yes. The default is 10 for the periodic test, 5 for notebook, 5 for subject enrichment and 80 for the exam, out of 100. Change any of them on the Settings sheet and every total and grade updates.

Will it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. All the formulas use standard functions.

What happens when a student is absent for an exam?

Type AB or leave the cell blank. If a student misses a whole term, the year percentage is worked out from the term they sat, so the missing term doesn’t pull the grade down. A missed part within a term, such as one periodic test, simply adds nothing to that term’s total.

When the spreadsheet stops being enough

School Vion does this for the whole school: teachers enter marks once, report cards follow your board’s format, and parents see them in the app.

See School Vion →