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

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
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Personal Finance
    • Other
      • Health & Fitness
  • Calendars
    • Calendar 2019
    • Calendar 2020
  • Functions
  • FAQ’s
    • Amazon Inventory Upload
    • Federal Income Tax
    • GST
    • Microsoft Excel
    • UAE VAT
  • Blog
  • About
    • Contact
You are here: Home / Excel Templates / Educational Templates / Download School Report Card And Mark Sheet Excel Template

Download School Report Card And Mark Sheet Excel Template

Download School Report Card And Mark Sheet Excel Template

School Report Card and Mark Sheet is an excel template which helps you prepare the mark sheet and the report card of the whole class in no more than 30-45 minutes.

Merely enter 9 basic details related to marks and attendance and student details. This sheet will automatically calculate the grand 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.

School Report Card And Mark Sheet Excel 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 really a very tedious job which is to be done 4 to 6 times a year.

School Report Card And Mark Sheet

To help these tutors save their time and effort we have created a ready-to-use School Report Card and Mark Sheet Excel Template with predefined formulas.

Click here to download the School Report Card and Mark Sheet Excel Template.

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

It helps you to generate report card of your class with a 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 sheet and report cards of their respective class. 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.

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

Contents of School Report Card And Mark Sheet Excel 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 institutions name and logo.

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

1. 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 is applicable to you.
  5. Exam Name: Unit – I / Unit – II / Semester Exam / Final Exam.
  6. Exam Month: Enter the name of the month in which examination is conducted.
  7. Total Working Days: Enter the number of working days till 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 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.

In addition to 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 in 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.

2. 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 student scorers of 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

3. 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 formula. Every time you want to view or print 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!!

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.

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

Filed Under: Educational Templates

About Fahim Lashkaria

I love working in Excel and I share functional excel templates at ExcelDataPro. Read more about me here or interact with me on twitter.

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

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
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2019. 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.
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.