• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download School Report Card And Mark Sheet Excel Template

Download School Report Card And Mark Sheet Excel Template

Ready-to-use School Report Card and Mark Sheet template in Excel, Google Sheet, and OpenOffice Calc that simplifies the tedious task of preparing the mark sheet and the report card.

Merely enter 9 basic details related to marks and attendance and student details. It prepares the mark sheet and report of the whole class in less than an hour. This sheet will automatically calculate the total, percentage, grades, rank, etc.

Once you enter the required data you can directly print every student’s report card. This record helps a tutor to monitor the growth of each of their pupils and preserve it for future requirements.

Table of Contents

  • What is a Mark sheet?
    • Components of a Mark Sheet
  • What is a Report Card?
    • Components of a Repor Card
  • Purpose of a Report Card
  • School Report Card And Mark Sheet Template (Excel, Google Sheets, and OpenOffice Calc)
  • Contents of School Report Card And Mark Sheet Template
    • Basic Data Entry Sheet
    • Mark Sheet
    • Report Card Sheet
  • Benefits of Using School Report Card and Mark Sheet Template
  • Frequently Asked Questions

What is a Mark sheet?

A mark sheet is a document that displays the marks obtained by all students in each subject. In other words, schools use the mark sheet to enter and record marks, comments, etc academic assessments.

Some schools also insert student’s demographic information like their age, roll numbers, etc that they can use as a reference on the report card.

Components of a Mark Sheet

Usually, a mark sheet consists of 2 sections: Class Details and Subject-Wise Marks.

Class details consist of Class, Division, Academic year, Month, and Exam Type.

The subject-wise Marks details include the following:

Roll Number
Name of the Student
Marks Obtained

The marks obtained section consists of 3 different columns. The first displays the marks obtained, second the total marks for which the exam was taken, and the third one is the percentage.

Many educational institutions also add grades for each subject. But it is optional. This projects the subject performance and knowledge of the students.

All of the above details need to be added for all the subjects taught in the class and for which an exam is conducted.

Moreover, it consists of the total marks obtained by each student in all subjects. This helps in defining the class grades. It also consists of details such as student’s attendance and General Register Number for displaying them on the report card.

What is a Report Card?

A Report card is an individual summary of each student’s academic performance. In other words, it is the assessment report of each student that depicts his overall performance in any particular assessment exam.

Components of a Repor Card

It consists of student’s details, subject-wise marks, subject-wise grades, and class-wise grades. It displays the student’s overall percentage, Grade, and Rank.

Additionally, it consists of school reopening details, passing out details, attendance, and grading system. Usually, the report card is prepared based on the details entered in the mark sheet. Some educational institutions also include behavioral aspects of children in the report card.

Doing it manually makes it a time-consuming and tedious job. Moreover, the chances of error also increase.

Purpose of a Report Card

  • It provides the school, parents as well as the student to understand the academic achievements.
  • A report card helps the school management, teacher as well as parents to understand the student’s capabilities.
  • It helps the teachers and parents to take necessary actions to improve the performance of weak students.

School Report Card And Mark Sheet Template (Excel, Google Sheets, and OpenOffice Calc)

School Report Card And Mark Sheet

We have created a simple and easy School Report Card and Mark Sheet Template to help tutors save their time and effort with predefined formulas.

Define basic criteria in the basic and insert the marks obtained by each student to their respective roll numbers. That’s it. It will automatically do the rest of the task for you.

Excel Google Sheets Open Office Calc

Click here to Download All Educational Excel Templates for ₹299.

You can download other Educational Excel Templates like Student Monthly Attendance Sheet and Yearly School Attendance Sheet from our website.

Let us now discuss all the contents of this template in detail.

Contents of School Report Card And Mark Sheet Template

This template consists of 3 different sheets:

  1. Basic Data Entry Sheet
  2. Mark sheet (For view and printing purpose only)
  3. Report Card (This too is for view and printing purpose only)

Important Note: In the header section that is available on the Mark sheet and Report Card insert your schools or institution’s name and logo.

Mark Sheet Header
Mark Sheet Header
Report Card Header
Report Card Header

Basic Data Entry Sheet

This sheet is divided into 3 sections;

Section A

Section A is for the ‘Basic information’.

Enter the following details:

  1. Class: Enter in digit only. (Do not enter division here)
  2. Class & Div: Enter Class along with Division.
  3. A.Y.: Enter Academic Year detail.
  4. Total Marks of Exam: Either 50 Marks or 100 Marks whichever applies to you.
  5. Exam Name: Unit – I / Unit – II / Semester Exam / Final Exam.
  6. Exam Month: Enter the name of the month in which the examination is conducted.
  7. Total Working Days: Enter the number of working days till the examination date.
  8. Annual Result: If the result is being prepared for the Final Exam, write “Yes” or else write “No”.
  9. School Re-open Date: If the result is being prepared for the Final Exam, insert the school reopen date here or else leave it blank.

Note: In case you conducting the test of marks other than 50 or 100 marks, this template will not calculate the accurate percentage and ranks.  It is designed for 50 /100 marks exams only.

School Report Card And Mark Sheet

Section B

Section B consists of ‘Grading information’. This is for the tutor’s knowledge and reference. It is also displayed on the Report Card. It helps the parents and students to understand the grading system.

School Report Card And Mark Sheet
Grading System for 100 marks

 

School Report Card And Mark Sheet
Grading System for 50 Marks

Section C

Section C consists of ‘Marks Data Entry’. First, enter the student’s name against their respective roll number, G.R. Number of student and attendance till the date of examination.

Besides that enter the marks obtained in various subjects. 1 column is given for each subject.

School Report Card And Mark Sheet

Remember to replace the subject heading as per your need. This will be displayed on every sheet.

School Report Card And Mark Sheet

If you don’t have to take any approval from higher authority or need to get the things checked, you can directly print the Report Card of your class.

Mark Sheet

Mark sheet is only for viewing/checking, printing, and approval purpose. Please do not edit anything here.

In case you want to change any data, please make necessary changes in the Basic Data Entry Sheet only.

Mark Sheet

It will also highlight the top 5 scorers student for each subject. Additionally, it will also show the top 5 class toppers and the top 5 students with the highest attendance in yellow color in their respective columns.

Mark Sheet

Report Card Sheet

Immediately after finishing data entry in the Basic Data Entry Sheet and verification through the Mark Sheet, your Report cards are ready to print.

Important: Your report card is linked with a formula. Every time you want to view or print the report card of any student; just change the roll number in the cell on the top right corner of the report card.

All the data in the report card will automatically change by itself fetching data of that respective roll number from the Mark sheet. This has been programmed using the Vlookup function.

School Report Card

Start with the first roll number and just give the print command for each report card. Don’t forget to set your print area before taking the print.

Isn’t this so easy? Now you can prepare the Mark sheet and Report cards of the whole class in only 30 Minutes!!

Benefits of Using School Report Card and Mark Sheet Template

  • Not every school can afford the hi-tech software solutions for recording these data. Hence, tutors need to do these efforts manually. It is a very tedious job which is to be done 4 to 6 times a year.
  • It helps you to generate a report card of your class with minimal effort and eventually saving an educator’s precious time and energy.
  • This energy and time can be utilized in some productive and constructive work rather than performing some traditional and tedious job and most importantly it is a free solution.
  • The tutors can prepare mark sheets and report cards of their respective classes. They can use this same sheet for all the exams conducted during the whole academic year.
  • It also provides with a ready-to-view report of marks and the respective ranks obtained by each student.

We thank our readers for liking, sharing, and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

Frequently Asked Questions

What are some examples of Positive Feedback for Student’s Report Card?

Usually, teachers struggle to write constructive and insightful comments on student’s report cards. Here are a few examples that can be helpful:

  • is a conscientious, hard-working student.
  • works independently.
  • is a self-motivated student.
  • consistently completes homework assignments.
  • puts forth their best effort into homework assignments.

For more positive feedback ideas click on the link below:

125 Report Card Comments

How do I calculate the percentage of the total marks?

To calculate the overall percentage, you need to sum up the marks obtained by the students in all subjects. Divide the product by the sum total of marks of all subjects. Then, multiply the answer with 100.

For example, if a student obtained 80, 60, 70, 87, and 85 in 5 subjects. All the exam conducted was 100 marks each. Thus, to find the percentage do as following:

80 + 60 + 70 + 87 + 85 = 382

Sum total of marks 5 X 100 = 500

Percentage = (385/500) X 100 = 76.40 %

For a single subject, same formula will apply.

= (87/100) X 100 = 87 %.

How can we give the grade for different marks in a subject?

We can give grades to the marks using IF Statements.

How can we give ranks to students?

We can give ranks to students using the Rank Function.

« Download Yearly School Attendance Sheet Excel Template
Download CBSE School Attendance Sheet Excel Template »

Filed Under: Educational Templates

You are Here: Home / Excel Templates / General Templates / Download School Report Card And Mark Sheet Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Comments

  1. THAPELO MOKOKOANE says

    September 4, 2019 at 4:58 pm

    template is good for us as teachers but need to improve to allow more than one tests marks

    Reply
    • Fahim Lashkaria says

      September 4, 2019 at 5:01 pm

      You mean to say it should have multiple exams like unit exams/test, term exams and final exams all in one.

      Reply
  2. osama says

    September 17, 2019 at 10:25 pm

    Hi. Thanks for that. I have one question: Can I print all sheets by only a single click? Nor one by one? best regards…

    Reply
    • Fahim Lashkaria says

      September 18, 2019 at 11:38 am

      By setting the print area perfectly you can print all results together.

      Reply
  3. Waseem says

    November 21, 2019 at 7:32 pm

    template is good but i need two things more.
    1- i want to print all students result card with single click or command
    2- three terms or semester result on same result card

    Reply
    • Fahim Lashkaria says

      November 22, 2019 at 5:21 pm

      For this purpose, you need to make a customized format. Please contact at info@exceldatapro.com

      Reply
      • Emmanuel Ekponta says

        December 8, 2019 at 1:16 pm

        i have sent an email to you sir expecting your reply.
        thanks.

        Reply
        • Fahim Lashkaria says

          December 9, 2019 at 1:52 pm

          I have replied to you, dear. Please check at your end.

          Reply
  4. Hud says

    December 14, 2019 at 4:58 am

    Thanks Sir, I love excel very much. Your work just makes it a wonderful experience, May Allah reword you!!

    Reply
    • Fahim Lashkaria says

      December 14, 2019 at 11:46 am

      Thanks for the appreciation.

      Reply
  5. faiz says

    December 21, 2019 at 11:05 pm

    sir if a subject has 50 marks how can i change it in a colum or i want to enter 6 subject either than 10 subjects how can i do it

    Reply
    • Fahim Lashkaria says

      December 23, 2019 at 11:31 am

      The explanation of the marking system is already written in the Basic Data Entry Section. Please follow instructions to program your sheet.

      Reply
  6. Muhammad says

    January 12, 2020 at 2:43 am

    excellent!
    is it possible to design a system using exel,that when you login it will display columns to enter student details(names,class ,results and others). as you keep inserting it will be displaying the students result on a list,and then print?

    Reply
    • Fahim Lashkaria says

      January 12, 2020 at 12:17 pm

      Thanks. For student records, this template can be helpful:

      https://exceldatapro.com/general-register-and-bonafide-generator/

      Reply
  7. Akpati Nduka says

    January 14, 2020 at 5:26 pm

    This is a very nice work. How can we increase it to work for 20 subjects?

    Reply
    • Fahim Lashkaria says

      January 14, 2020 at 7:09 pm

      20 subjects are too many. Well if insert rows according to your need and then program the sheets accordingly. If you cannot do it you can contact us for making a customized sheet for you on a chargeable basis. thanks

      Reply
  8. fisseha says

    January 24, 2020 at 7:53 pm

    this is good job. 1st and 2sec semister to do in one report card please can you help me

    Reply
    • Fahim Lashkaria says

      January 25, 2020 at 11:55 am

      If you want to make 2 semesters you need to customize i. We can help you but it is chargeable and you can contact our developing team on info@exceldatapro.com

      Reply
  9. michael says

    January 29, 2020 at 11:41 pm

    the grades on your report card are not changing according to the marks recorded on the basic data entry sheet. whats wrong

    Reply
    • Fahim Lashkaria says

      January 30, 2020 at 1:43 pm

      Dear Micheal,
      Everything is working fine. I rechecked it. In the Basic Data Entry sheet, the grading system has been given. IF you have a different grading system you need to enter the data in that sheet according to your need.

      Reply
  10. MICHAEL BANDA says

    February 12, 2020 at 2:58 pm

    Please check properly if the grades on the marksheet will be the same as on the report card because if subject 1 on top is A then the rest of the subjects BELOW will be A as well instead of changing according to the specific mark scored.

    Reply
    • Fahim Lashkaria says

      February 12, 2020 at 5:20 pm

      Dear Micheal,
      Everything is working fine. I rechecked it. In the Basic Data Entry sheet, the grading system has been given. IF you have a different grading system you need to enter the data in that sheet according to your need.

      Reply
      • Abdulganiyy says

        July 26, 2020 at 5:35 am

        Thanks for this great template.
        I also observe that the grades are not updating in the report card
        It’s referring to vlookup(AH33, marksheet! A9:$AJ$69, 5) which I found no grade in it but ranking.

        Reply
  11. Shahid says

    March 7, 2020 at 9:09 pm

    Hi
    What if some subjects of 50 marks and some subjects are of 100 marks exam. Here in sheet we can only choose 100 or 50, what if we have some subjects of 100 marks and some of 50 marks

    Reply
    • Fahim Lashkaria says

      March 8, 2020 at 7:30 pm

      We haven’t made such a report card yet. We have noted it and will be soon published on website.

      Reply
  12. Ihsan says

    March 23, 2020 at 7:15 pm

    Hi. Thanks for that. I have one question: Can I print all sheets by only a single click? Nor one by one? best regards

    Reply
    • Fahim Lashkaria says

      March 24, 2020 at 12:14 pm

      No. Select each pupil name and you have to print individually. If you want to do it in one click you need to make the total number of results in just one sheet and link the cells accordingly.

      Reply
  13. EZEKIEL MARAURI says

    April 28, 2020 at 4:18 am

    Sir, Love this template but can you edit to allow more than 1 test marks.
    Example: Science with 10 test marks
    Science:
    Tes1 Test 2 Test3 test 4 etc…

    Reply
    • Fahim Lashkaria says

      April 29, 2020 at 12:45 pm

      You need to get it customized according to your need. You can contact info@exceldatapro.com

      Reply
  14. Abdulganiyy says

    July 26, 2020 at 6:15 am

    Thanks for this great template.
    I also observe that the grades are not updating in the report card
    It’s referring to vlookup(AH33, marksheet! A9:$AJ$69, 5) which I found no grade in it but ranking.

    Reply
    • Fahim Lashkaria says

      July 27, 2020 at 12:22 pm

      The auto-update will be disabled for formulas in your excel setting. It is working properly as it has been thoroughly checked again.

      Reply
  15. OLUWASEUN OBISESAN says

    July 29, 2020 at 3:30 am

    Thanks for this template.
    I also observe that the grades and school re-open are not updating in the report card
    Pls see screenshot below

    i.is.cc/1Harn8JS.png

    Reply
    • Fahim Lashkaria says

      July 29, 2020 at 12:48 pm

      Send the query to info@exceldatapro.com with the screenshot or recorded video.

      Reply
  16. Fh says

    December 24, 2020 at 12:57 am

    Can i download all these template s for free

    Reply
    • Fahim Lashkaria says

      December 29, 2020 at 12:03 pm

      All these templates are free to download. You can surely download them.

      Reply
  17. Enoch Kumbanaden says

    December 29, 2020 at 7:12 pm

    I am using your sheet for printing school report but when i want to print one students it is very small how to print one student report in one A4 sheet. please help. and we thank you for sharing your knowledge with us.

    Regards
    Enoch K

    Reply
    • Fahim Lashkaria says

      January 4, 2021 at 8:04 pm

      You need to manually set the print area.

      Reply
  18. Shadrach aderemi says

    December 3, 2022 at 5:25 pm

    Please i want to download the editable template for student marksheet and report card

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Educational Templates

  • Yearly School Attendance Sheet Excel Template
  • School Report Card And Mark Sheet Excel Template
  • CBSE School Attendance Sheet Excel Template
  • Multiple Choice Question – MCQ Test Checking Sheet Excel Template
  • Multiple Choice Questions – MCQ Test Sheet Excel Template
  • Multiplication Tables 1-30 Practice Sheet Excel Template
  • Multiplication Table Test Sheet Excel Template
  • Student Study Planner Excel Template
  • Basic Addition Practice Sheet Excel Template
  • Basic Subtraction Practice Sheet Excel Template
  • Basic Division Practice Sheet Excel Template
  • Basic Addition Test Sheet Excel Template
  • Basic Subtraction Test Sheet Excel Template
  • Basic Division Test Sheet Excel Template
  • Percentage Practice Sheet Excel Template
  • Squares Practice Sheet Excel Template
  • Square Root Practice Sheet Excel Template
  • Cube Root Practice Sheet Excel Template
  • LCM Practice Worksheet Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT