Report Card – Basic (Free Excel Template)

Posted on
PURPOSE
The purpose of this template is to automate creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort. I believe this would be useful for schools and other educational institutions, conducting tests or assessments for their students.


FREE DOWNLOAD




FEATURES

  • Handles up to 50 students
  • Up to 12 different tests can be entered
  • Up to 12 different subjects can be entered
  • Customizable % required to pass
  • Easy data entry of marks
  • Customizable maximum marks for each test for each subject
  • Marks presented as %
  • Option to calculate final marks based on custom weights assigned to each test
  • Class View
    • Highlights Subject with the least average in each test
    • Presents the number of students failed in each subject in each test
    • Calculates the average final % for each subject
  • Subject View (Choose one subject)
    • Presents the data for all the students in each test 
    • Highlights the highest marks in each test
    • Highlights students failing to meet the % required to pass
    • Calculates the average final % for each student
  • Student View (Choose one student) 
    • Presents all the data for one student 
    • Calculates the final overall %, final class rank and final result. 
    • Calculates the final % for each subject
    • Calculates the result and class rank for each test 
  • Ready for printing


HOW TO USE THE TEMPLATE

  • Step 1: Enter information in cells underlined in the Settings worksheet.
  • Step 2: Enter information in Entry worksheet.
    • Enter Maximum Marks for each test
    • Enter Student info and marks.
  • Step 3: Go to Class View to view and print Class Report Card
  • Step 4: Go to Subject View to view and print Subject Report Card (Choose a Subject)
  • Step 5: Go to Student View to view and print Student Report Card (Choose a Student)
 
SETTINGS

indzara_ReportCard_Settings

This is where you would enter your school and class information. Also, you would enter the ‘% Required to Pass’. In the screenshot above with the sample data, I have used 40% as % required to pass. This allows the template to automatically highlight any marks which are less than 40% with a red font so that it’s easy for the teacher to identify failures.

In many scenarios, students’ final marks are calculated based on assessments or tests throughout the academic year. In such scenarios, weights are assigned to each test and final marks are calculated based on those weights. This template accommodates that set-up. You can choose up to 12 tests and you can assign a weight to each test and the total of the weights should be 100%. The template is very flexible. For example, if your final marks are based only on the last test you conduct, you would assign 100% weight to the last test and 0% weight to all other tests. 

If you do not have the need to calculate final marks, please choose No in the drop down menu as shown in the image below. This would make sure that the final marks will not be displayed anywhere in the template. 
indzara_ReportCard_Settings_FinalMarks

You can choose up to 12 subjects. Please make sure that the subject names are unique. 

ENTRY
indzara_ReportCard_Entry

CLASS VIEW
This is where you enter the student names, their roll numbers and the marks they scored in each subject in each test. This sheet automatically adjusts based on the number of tests and subjects you have entered in the Settings worksheet. 

Enter Maximum Marks for each test. This is crucial for calculation. If you don’t enter this, you would see errors like the one shown in this image.
indzara_ReportCard_SubjectView_error

indzara_ReportCard_ClassView

This view presents the overall performance of the class and highlights areas of opportunities. Everything is automatically calculated and is ready to print. 
  • Subject with the least average in each test is highlighted with dark orange font. This allows easy identification of the (relatively) weakest subject for the class. 
  • Number of students failed in each subject in each test is also calculated and highlighted. 
  • If you have chosen to calculate final marks in the Settings worksheet, the average final % of the class for each subject is also calculated.
SUBJECT VIEW 
indzara_ReportCard_SubjectView

Choose a subject from the drop down menu and this view presents each student’s performance in that subject during the course of the academic year. This allows the teacher to understand how the class is performing in that subject.

  • Highest marks in each test is highlighted in dark green font.
  • Marks that have failed to meet the % required to pass are highlighted with dark red font.
  • If you have chosen to calculate final marks in the Settings worksheet, the final % of each student in that subject is also calculated.
STUDENT VIEW
indzara_ReportCard_StudentView
Choose a student from the drop down menu and this view presents the performance of that student in all subjects across all the tests. 
  • In addition to the %, this sheet calculates 
    • Result (Pass or Fail) whether the student has passed in each subject in a test. 
    • Class Rank of the student in each test
  • If you have chosen to calculate final marks in the Settings worksheet, the final % of the student in each subject is calculated. The Final Result, Final Class Rank and Final Overall % are also calculated. 
  • Placeholders are provided for signatures from school principal and class teacher. This sheet can be printed and handed to the students.
Calculation Logic
  • Total Marks is the sum of actual marks scored in all the subjects in a test.
  • Maximum Marks is the sum of maximum possible marks in all the subjects in a test.
  • Overall % is calculated as Total Marks/Maximum Marks in each test.
  • Result is ‘PASS’ if the student has scored at least the “% Required to Pass” in each of the subjects in the test. Otherwise the Result is ‘FAIL’.
  • Class Rank is calculated based on students whose result is ‘PASS’ in the test. For students with a ‘FAIL’ result, the class rank is NR (No Rank).
    • If there are five students and 2 of them score the highest total marks in a test, then both of them will get a class rank of 1 and there will not be class rank of 2. The next highest student will get a class rank of 3.  
  • Final % for each subject is calculated based on weights given to each test in the settings worksheet. 
  • Final Overall % is calculated as average of the Final % in all subjects. 
  • Final Result is PASS if the student’s Final % for each subject is at least the ‘% required to pass’. 
  • Final Class Rank is calculated based on students whose final Result is PASS. For students whose final Result is FAIL, the final class rank is NR.

I hope you find the template useful. Please share your feedback on whether the template captures the requirements of your scenario. I can make the necessary changes so that the template can be used by as many people as possible. 

220 thoughts on “Report Card – Basic (Free Excel Template)

  1. How can i get an automated broadsheet from students whose result sheet were generated with this please

  2. Thank you so much for the work that you have done in excel file. it is really helpful. i am just fascinated. Could you please send the password mail: bodrasanju@gmail.com. Thank you!

    1. Thanks for your feedback.

      The password is ‘indzara’

      Best wishes

  3. please how do i change the headings to fit my

    1. Hello

      Please extend the column width.

      Best wishes

  4. Is there any option to add more students and some more others subjects. If possible please give me an options
    Thank You!
    MUana

    1. Hello

      The present version has some limitations. We might add these features in the next release.

      Best wishes

  5. can you please help me in getting number of failure in class_view sheet without counting blank from entry sheet.
    thanking you so much…

  6. Hello Dear,
    I want to add Father’s Name, Date of Birth and remove Class Teacher’s Name.
    If you could share the password I could do that..

    1. Hello

      Please use “indzara” to unlock the sheets.

      Best wishes

  7. thank you very much sir /madam
    marvelous work you have done .
    it is very much helpful to all and simple superb.

    1. Thanks for sharing the feedback. We hope to add value to your business

  8. Hello Indzara,
    Good Job done. Please could you provide formulas used in the cells for personal modification. I understand cells were protected for any misuse or possible mistakes by the users, but I think providing formalas would help users to customise for their own schools

    1. Hello

      Please use the password “indzara” to unlock the sheets and access the formulas.

      Thanks

  9. Good job but addition
    1. marks and grade it is important
    2. Position for each subject of student
    let me provide example through email attachment

    1. Hello

      Thanks for using the template.
      Please share more details at contact@indzara.com

      Best wishes

      1. Hello can u send me one . email id generaljames615@gmail.com

        1. Hello

          We have sent you the template at the email id mentioned above.

          Best wishes

  10. REALLY THANK YOU VERY MUCH FOR THE GREAT WORK, BUT I NEED IT SHOWING MARKS INSTEAD OF PERCENTAGES IN STUDENT VIEW SHEET URGENTLY… Thanks again

    1. Thank you.
      It requires making several changes across the workbook including hidden sheets. I am sorry that I don’t have that documented yet to share.
      Best wishes.

Leave a Reply

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