Report Card – Basic (Free Excel Template)
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 OF REPORT CARD EXCEL TEMPLATE
- 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)
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.
You can choose up to 12 subjects. Please make sure that the subject names are unique.
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.
- 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
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
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.
This excel result sheet download is simple and effective in managing the student report of a class of 50 students. I hope you find the result card format in excel template useful. Please share your feedback on whether the marksheet format in excel 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.
300 Comments
This is a great template for me to use with my students.
Is it possible to NOT PROPAGATE ALL SUBJECT NAMES FOR EVERY TEST NAME?
For example, I only require two “field work reports” for the entire course. I don’t do it for every subject.
If that is possible, it will be very helpful for me.
Sunny
Hi Sunny,
Thank you so much for your kind words, and we’re glad the template has been useful for your students!
Regarding your question — currently, the template is designed so that all subjects apply to every test/assessment name, so it doesn’t support having a different subset of subjects for specific assessments (like a “Field Work Report” that only applies to two subjects instead of all of them).
If your final scores/grades for each subject don’t depend on this specific assessment, one workaround would be to maintain two separate copies of the template — one for your regular subject-wise assessments, and a separate one just to track the “Field Work Report” scores for the two relevant subjects.
However, if the “Field Work Report” needs to feed into the overall subject scores and calculations within the same file, this would require a customization to the template’s structure and formulas.
If you’d like to explore a customized version tailored to your specific requirement, please feel free to raise a request here: https://support.indzara.com/support/tickets/new, and our team would be happy to assist further.
Thank you again for reaching out!
Best wishes,
Dennis R,
Indzara Support.
Want this template as it seems interesting
Thank you for your interest in our template! You can download it directly using the link below:
Click here to download
If you have any questions or need assistance, feel free to reach out.
update the template to allow more subjects like up to 20 subjects eg English,”Kiswahil, KSL(as dropdowns),”Essential Mathematics,Core mathematics”(as dropdowns),CSL, Literature, Fasihi,chemistry,Physics,biology,computer, agricuture,business,french,cre,history,geography,PE,ICT, etc
This template is a game-changer! I love how simple and effective it is for keeping track of grades and progress. Thank you for sharing such a useful resource!
Thank you so much for your kind words! We’re thrilled to hear that the Report Card template has been a game-changer for you.
It’s always our goal to create simple yet effective tools that make a real difference.
If you ever have any suggestions or need assistance, feel free to reach out—we’re here to help!
Best wishes.
Thanks for providing infomation
You are welcome. Thank you for showing interest in our template.
Best wishes.
I have tried this template on several occasions, but each time, it tells me the student name section is protected. Can I get assistance on that?
Thank you for showing interest in our template.
We regret the inconvenience caused.
I just tested the template and the student name input field is not protected. Only the fields containing password is protected to ensure the same is not modified/deleted accidentally. The password to unprotect the same is indzara.
Best wishes.
AOA-thanks for the free template. I am using it for the last 3 years in my school
Is there is any pro version? can we make some customization?
Regards
You are welcome.
Currently, we do not have a premium version of the template.
Yes, we take customization projects for a fee. Please write to us at the below link with your requirements on a excel sheet with sample data and sample required output for estimation.
https://support.indzara.com/support/tickets/new
Best wishes.
Please the worksheet is protected. What’s the password please
Thank you for showing interest in our template.
The password to unprotect the sheet is **indzara**.
If you have any further questions or need assistance, please feel free to reach out to us—we’ll be happy to help.
Good morning. I would like to know if it will be possible to add an email address so that the report can be emailed to parents instead of printed? Can you assist please.
Thank you for showing interest in our template.
Yes, it is possible. You will need add an email ID near employee name and then use HYPERLINK formula to create a dynamic link to mail to the parent on click of a link.
=HYPERLINK(“mailto:” & & “?subject=”& & “&body=” & , “Send Email”)
Best wishes.
Thank you for your response.
Would that be on the settings page? As I do not see anything about employee name
or is it on the entry page by the students name? Should I add a column?
I am truly grateful that at last I found your website. I will be buying your premiums and work along with in some of the projects if I come across them going forward. Most of the American version of the Excel projects that I normally look at didn’t work well for me, because my country was colonized by British, and some of the things we do here, especially education system is just not compatible with Americans version of education system. So from where you come from, I can see a lot of similarity in areas like education system and others. Therefore, learning from you, and getting simple projects from you, would truly be a gold for me.
Thanks so much.
Please send passwrd of unprotected sheet
Please some of the cells are protected how can I edit them?
Thank you for showing interest in our template.
You can unprotect the same using password indzara.
Best wishes.
Is it possible to customize the student view sheet in terms of marks, if so please help me to do that.
Thank you for using our template.
It is a complicated process, you will have to unhide and unprotect the HELP tab using password indzara. Then you will need to edit multiple formulas in the sheet appropriately to change the % to numbers. We take customization projects for a fee, requesting to contact support@indzara.com for estimation.
Best wishes.
May I know how much do you charge for it
please how do I download the template
Thank you for showing interest in our template.
Following is the link to download the template:
Empty template:
https://indzara.com/wp-content/uploads/2013/06/indzara_ReportCard_Basic_v1.xlsx
Sample template:
https://indzara.com/wp-content/uploads/2013/06/indzara_ReportCard_Basic_v1_withSampleData.xlsx
You can also click the two links below the Free Download Header to download the same.
Best wishes.
student view not displaying individual record by names
Thank you for using our template and we regret the inconvenience caused.
Requesting to check the sample sheet for any data entry errors and if there is no data entry errors, requesting to share the sheet to support@indzara.com to check further.
Best wishes.
Hi
thanks so much for the grade sheet template
I just have a question about the number of the subject, is it possible to increase them up to 15 subjects
because that is what our institute use to i appreciate you help
thanks very much
Thank you for using our template and you are welcome.
We can take it as a customization project for additional fee to add more subjects. Requesting to contact support@indzara.com for an estimation.
Best wishes.
Plz send password for unprotect file
Please use indzara as password.
Thanks & Best wishes.
Thanks for this template. But I need to add more subjects, how can I go about editing the subjects column?
I’ll like to know if the updated version is out.
How can I participate in the free course?
Thanks for using our template.
At present, this template can handle up to 12 subjects. We might increase the capacity in future releases.
Best wishes
Wow…I have a school project in computer to make a attendance register can you help me make one
Thanks for using our template.
Due to a heavy workload, we are not accepting any customized projects.
Best wishes
thnkx
Welcome!!!
Its very nice but it need password
download both sheet but cant change anything due to password base . pls may u share password for unprotect sheet
Hello
Please use “indzara” as a password.
Thanks
Pls, do u have school management excel sheets?
I also want a worksheet that will calculate my daily sales for my business.
Thanks for your message.
We have templates for small businesses and schools which handle the attendance and report cards. Please elaborate more on your requirements.
Best wishes
I want add more student details in report card like father name, Mother Name, SR no. Date of Birth
Thanks for your message.
These details are not available in the present template. You may add them, however, you have to edit the student view tab to reflect the details.
Best wishes
Thanks for the response. I tried adding more subjects and editing the student view but it was displaying error. Please what else can I do.
Hello
This template has limitations on the number of subjects. We will try to increase them in future releases.
Best wishes
Please do you have the Premium Excel Template for Report card. I need a template that can handle more than 12 subject
Thanks for your message.
We do not have a premium template for the report card yet.
Best wishes
This was really useful to the the work I am doing. Will the template work for more than 12 subjects.
Thanks for your message.
At present, this template can handle up to 12 subjects. We might have an enhanced version in the future.
Best wishes
I neet unproteced Excel Sheets where I can learn programming
Thanks for your message.
Please use the password “indzara”
Best wishes
pls send me (student result sheet or carde)thanks .
I am a teacher,
Thanks for your message.
Please share the complete name of the sheet. You can download the same from their respective web page.
Best wishes
what is password to unprotect the sheets
Hello
Please use “indzara” as a password.
Best wishes
Sir, your work is a well done job. How I wish if not of your tight schedule to make a tutorial on how to make this template.
Thanks for using our template.
We have tutorials for excel and we have share the functionality of the template in the video. However, as per our policy, we do not disclose the building blocks of any template.
Best wishes
This is a very nice template. How can I reduce the assessment to 4 and increase the subjects to 15 as obtainable in my country Nigeria?
Thanks.
Sorry, increasing the subjects would require making many modifications to the formulas and sheets.
Best wishes.
Just give me a clue on what to do. Please
Please unhide hidden sheets and follow the formulas. Once you understand that, you can add more or reduce subjects and tests.
Best wishes
Can the template be made to accommodate up to 15 subjects
Thanks for using our template.
This template can handle a maximum of 12 subjects. We might increase this limit in our future releases.
Best wishes
plz send daily homework templates for nursery – 7th standard.sending student parants from whatsapp
Thanks for your message.
We do not have a template for homework yet.
Best wish
hello sir
How to remove cell protection
Hello
Please use “indzara” as a password.
Thanks
REQUIRE EXAMINATION ADMIT CARD IN THIS SHEET{ IN CARD-ROLL NO, STUDENT NAME, FATHER NAME, DATE OF BIRTH]
Thanks for using our template.
We do not have this feature yet. We will try to incorporate it in the future release.
Best wishes
thank you for the template.
can anyone help me on how to programme the template to rank the students in positions instead of the the ‘NR’ if thats possible
my email is mtsabedze7@gmail.com
You are welcome.
The template ranks students in positions. But if the student’s score in any exam is less than the pass percentage set, then the rank is set to NR.
Best wishes.
This is a very good template really. Where are you found and how can some one join you.
Tell me how the payments are done because i want to promote your premium templates in Uganda.
ayebaresamuelhot@gmail.com
Excellent job,
I will like to get the advance tutorial and password to customize the report card setting.
for more info email me: Osmanabasskay@gmail.com
I Look forward to her from you.
Thanks for using the template.
The password is “indzara”
Please refer to https://indzara.com/2013/06/report-card-basic-excel-template/ for the video and the related text.
Best wishes
A Job Well-done,
Please can i get one with more subject, lets say 20 and grading system A – F.
Please i need its urgently. This is my email.
aleeyu2012@gmail.com
Thanks in advance.
Thanks for sharing your positive experience.
Due to a huge workload, we are not accepting any customized projects.
Best wishes
How can i get an automated broadsheet from students whose result sheet were generated with this please
Thanks for using our template.
Please share more details on what you require. We are not accepting any customized projects.
Best wishes
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!
Thanks for your feedback.
The password is ‘indzara’
Best wishes
please how do i change the headings to fit my
Hello
Please extend the column width.
Best wishes
Is there any option to add more students and some more others subjects. If possible please give me an options
Thank You!
MUana
Hello
The present version has some limitations. We might add these features in the next release.
Best wishes
can you please help me in getting number of failure in class_view sheet without counting blank from entry sheet.
thanking you so much…
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..
Hello
Please use “indzara” to unlock the sheets.
Best wishes
thank you very much sir /madam
marvelous work you have done .
it is very much helpful to all and simple superb.
Thanks for sharing the feedback. We hope to add value to your business
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
Hello
Please use the password “indzara” to unlock the sheets and access the formulas.
Thanks
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
Hello
Thanks for using the template.
Please share more details at contact@indzara.com
Best wishes
Hello can u send me one . email id generaljames615@gmail.com
Hello
We have sent you the template at the email id mentioned above.
Best wishes
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
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.
Thank You Sir.
Sir I need also student marks in each subject sir plz update it as soon as possible. plz
Thanks for your feedback.
We might have this feature in the next release.
Regards
Hi ..I need to show marks only not their percentages. could you let me know how to edit this template to meet my requirement
Hello
Thanks for using our template.
The marks are calculated in the hidden sheet. We need to update the formula in the report to point to that instead of the %.
Best wishes
Hello Indzara, honestly you have done a great job by putting all this up and also I have to appreciate your kind gesture for making the project a free one. You are a good man. Please I want to request one thing from you, and I will be glad if you can assist me. Kindly help increase in the Subjects roll, or give me the formula to use increase it please,you can reply to my email meggaabletech@gmail.com. Just 12 Subjects isn’t enough. Thanks and God bless you more.
Thank you.
Please note that increase subjects is not with one formula. 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.
can you send me the step by step to do that
can you send me the step by step to do that
Thanks a lot for your help
How we can do that
Please I need the password for the report card template. I will like to customize it. Thanks a million.
Hello
Please use “indzara” as the password.
Best wishes
Hi, you can contact me via abdulmuhaiminsulaiman@gmail.com
Hello
Please write to us with your queries at contact@indzara.com
Best wishes
Please sir can u you email me the procedure For designing the report card Template
Thanks for using our template.
Please review the video at https://indzara.com/2013/06/report-card-basic-excel-template/
Best wishes
Hello Sir,
I do not need % format. I require all marks as number without percentage.
Please help me
Mail umair.iqbal.qureshi1@gmail.com
will be happy if you respond please
Can it be possible for the marks for each test be total of the weight given instead of 100%? For instance the weight for class score is 30% and exams score is 70% so class score be total of 30%instead of 100%?
That would require changing the formulas. Sorry. I don’t have that feature.
Best wishes.
i want the template for 500+ students with 15 different subjects
Hello
The present version can handle up to 50 students and 12 subjects. Its designed for one class.
Best wishes
Hello Sir,
I do not need % format. I require all marks as number without percentage.
Please help me
Mail patrickenenche20@gmail.com
will be happy if you respond please
Hello
The total marks for each subject may vary. Hence, presenting the numbers as percentage overcomes this hurdle.
Best wishes
Hello
The total marks for each subject may vary. Hence, presenting the numbers as percentage overcomes this hurdle.
Best wishes
Hello Sir,
I do not need % format. I require all marks as number without percentage.
Please help me
Mail gsuresh2007@gmail.com
will be happy if you respond please
give me making video o f Report Card its needed to me
Thanks for sharing. Great template .
Sir really it’s great work.
Dear,
We are using the attendance report (paid version) and it is very useful. As a second step wthe would like to use this grade template.
We wonder if it is difficult to make a small change so the template does not take in account columns in the entry tab where the ‘max marks’ is blank or 0 (means that for a given subject there was no test or marks are not available. In the calculated sheets the #DIV/0 would not appear, as the given column would be excluded from the calculation.
Kind regards, and keep on the good work
Thanks. Glad to hear that the attendance register is useful.
Can you please explain whether you have certain subjects not needed for some tests but needed for some tests? is this why you need to put max as 0?
Please email contact@indzara.com with details and file if possible.
Best wishes.
Hi sir, great work how do I add the subjects to about 20 subjects?
Dear Sir,
I am currently utilizing your template named as Report Card and found it the best application ever i seen on this subject. It is further added here that i want to know that how i can increase number of assessments as already given number of assessments are 10 but i want to increase this number to 13 to 15 classwise.
It is further asked that i need some application for accounts of my institution named as FAME Foundation which is an educational institution having around 150 students of various classes from class 1 to 12.
Please update this post on priority basis and i will be obliged in this regard.
Thanks
Azeem Afrasiyab Adv from Lahore Pakistan.
azeemnazeems@gmail.com
Thanks for your interest.
I don’t have an upgraded version of this template with features you are asking for. Sorry.
Best wishes.
sir i try it but not show in student view. i want that is all detail i add in entry then i show in student view. because it is use in student report card. and i think it is most important in student report card like – father’s name, mother’s name, and Date of birth. how can i do that or send a file on my email – sarvodayaschoolchirawa@gmail.com
regards
deepak sharma
In order for the report to show the information, we have to add formulas to bring that info over. You can unlock the sheet using indzara as password and then see the formula used to bring the student name. Follow similar method to bring Date of birth or any other info for the student.
Best wishes.
sir i try it but not show in student view. i want that is all detail i add in entry then i show in student view. because it is use in student report card. and i think it is most important in student report card like – father’s name, mother’s name, and Date of birth.
regards
deepak sharma
In order for the report to show the information, we have to add formulas to bring that info over. You can unlock the sheet using indzara as password and then see the formula used to bring the student name. Follow similar method to bring Date of birth or any other info for the student.
Best wishes.
sir i want add more details of students like – father’s name, mother’s Name, Date of birth. how can i do that?
Please try inserting columns after Student name column.
Best wishes.
i try it but it is not show in student report card please tell me about it.
In order for the report to show the information, we have to add formulas to bring that info over. You can unlock the sheet using indzara as password and then see the formula used to bring the student name. Follow similar method to bring Date of birth or any other info for the student.
Best wishes.
Can we update if we have any additional marks ..
The marks have to be entered in the specific cell. So, if the mark is changing, we have to replace the old value with the new one. Thanks & Best wishes.
Hai,
If a student absents himself for a exam, what to enter?
because when i type anything apart from number, it calculates it as zero and taking that also into consideration for average calculation.
Please help.
Have you tried leaving it blank? Please let me know.
Thanks & Best wishes.
Can I edit a column and another grading system? It’s great, anyway. Thank you
Please feel free to edit using password indzara. Thanks. Best wishes.
Hello Sir,
I do not need % format. I require all marks as number without percentage.
Please help me
Mail gsuresh2007@gmail.com
will be happy if you respond please
I have emailed you a file. Please note that I have not tested fully and hence have not published it online yet.
Best wishes.
I have imported grades from exel. I am able to see grades in Class View, but I am getting #N/A in Student View.
Is there a fix? Thank you!
I am not sure what ‘imported grades’ refers to. Please explain. If there are further questions, please email file to support@indzara.com. Thanks. Best wishes.
Hi
This is Sarika Again. Actually we have started working on the result for PT-1. I know you might not like to share the password.Thats absolutely fine with me. But please can you provide me a file having 60 records instead of 50. it will be a great help and solve all my problems.
My email id is sarika.minocha@gmail.com
Please use indzara as password. Thanks.
Best wishes.
Hi
The file is really very good. Can you provide me the password to unprotect and pls guide if I want the records till 60.
My email id is sarika.minocha@gmail.com
Please use indzara as password. Thanks.
Best wishes.
Thank sir, your work helps a lot but
I still have challenges after entry the various marks in the entry.
The marks do not reflect in the class, subject and student views.
Please I need a help!
You are welcome.
Please email file with data to support@indzara.com and specify exactly which marks are not reflecting where. The more specific the information is, easier it will be for me to reply quickly. Thanks for your support.
Best wishes.
Thanks Indzara for the assistance, I just downloaded the template I will study and get back to you. But how can we get this template to handle more students so 300 students
You are welcome. We should make many modifications to the formulas to increase support for number of students. Sorry, I don’t have that built. Best wishes.
The administration at my school likes the template, however they which for the raw scores to be shown for each maximum weight and not the percentage. Could i get some assistance here. Thanks.
Thank you. I have only the % option and don’t have the raw scores. Sorry.
Best wishes.
Nice .I had gone through all the comments till now .and came to know that this INDZARA is a nice person ,because for each queries he had give reply.by which he had helped so many peoples .thanks for helping people.
Thanks for your feedback. Glad to help.
Best wishes.
Hi IndZara, do you do database development as well? like java, php, mysql….. if yes, please notify me, I want to propose a deal.
brandeazygh@gmail.com
Thank you very much. I tried the template & found ever best. I need to handle the data of at least 300 students. Please help me to increase the number of students in the sheet.
Its urgent. Please reply. I will remain thankful.
Please reply to rabarbhuyan@gmail.com
Thank you very much. I tried the template & found ever best. I need to handle the data of at least 300 students. Please help me to increase the number of students in the sheet.
Its urgent. Please reply. I will remain thankful.
Hii
I have a request can you please share some Health & Safety report formats.. like Monthly HSE Statistic Report in dashboard fully automated.
by the way I have prepared one but I am not satisfied with that so if you could help me out, I’ll be very thankful to you..
Your sharing are truly amazing..
Thanks
Regards,
Tarique Khan
Thanks for your interest. I am sorry that I don’t have such a template.
Best wishes.
PLEASE SIR.HOW CAN I GET INTO THE SITE.AS IN INTO THIS TEMPLATE THAT ENABLES ME MAKE MY OWN CHANGES? EMAIL ME PLEASE.benkroos72@gmail.com
You can download the template file and use Excel in your desktop to make changes. Best wishes.
AND more to add how to add school logo
You can right click on the logo and select Change Picture. Then, choose an image file from your computer to replace.
Best wishes.
Sir i must thank you very much am happy about the template. please how do i add student’s pictures to the final report card. thanks
You are welcome. You can insert pictures manually from the Insert ribbon. For the picture to automatically change in Student report card, it would require many steps. I am sorry that I don’t have that documented. Best wishes.
Use formula =IF(K17>=90%,”A1″,IF(K17>=80%,”A2″,IF(K17>=70%,”B1″,IF(K17>=60%,”B2″,IF(K17>=50%,”C”,IF(K17>=40%,”NEED IMPROVEMENT”)))))) to set grades based on the percentage of marks obtained.
Thanks.
Dear Indzara, This is really amazing. I have customized the sheet for my requirement and it looks awesome. It has saved lot of my time in keeping track of my students performance and now my PTA goes very smooth and accurate. I tried a lot to make the sheet take more than 50 students.. but did not succeed. I can understand you are busy. But my request is that help us getting this done when you are free. One more suggestion, if there was a drop down option to choose class as well then it would have been unbeatable.
Regards
Educoach
Thanks for the feedback. I will do my best to create an advanced version of this in the future. Best wishes.
Dear Sir,
we want to same format with grade wise marks inplace of % based
can you provide us grade based same format
Kindly confirm or send my e-mail address
sharmakr@rsinfratransmission.com
I have emailed you an example showing marks and implementing grades. I haven’t tested the entire file yet, but it should give you ideas to use.
Thanks & Best wishes.
Hi,
Can you help me, I want a report card generation excel program which give grade output. I am trying with V lookup but failed to do so. I know you are busy so can you guide me on this how can I change the marks into grade and then to CGPA.
I have emailed you an example of implementing grades. I haven’t tested the entire file yet, but it should give you ideas to use.
Thanks & Best wishes.
Hi Indzara,
Would you be in interested in doing a project for me on commercial basis. It is about report card only but different format.
Please let me know.
Mail id: singhalok099@gmail.com
Thank you. I have emailed you.
Best wishes.
when cell value is zero, I want hide entire row hide automatically. and it dosnt equal zero it should show off again. please advice me.
To make it automatically happen, I believe we have to write a macro. I am sorry that I haven’t done that so far. Best wishes.
Thank you sir, I’ll try and I like to say I already done 85% from my request project with referring your report card format.
Great to hear. Thanks for the update.
thank you so much for your kind wards sir. I’ll send soon.
i sent my requirement with excel file, please contact any concern. thank you again.
Dr sir, this is very useful and highly advanced data sheet I have seen ever. I wish you all the best for your further and would like to thank your kindness. thanks lot again.
Thank you so much for taking the time to provide feedback. Best wishes.
Dr sir, I want create this type report card with few changes. i still try to do it with referring your excel sheet. but I want your support complete it. can you help me. if you can I really grateful you.
Please email the file and changes needed. If it is simple, I can help. But if it requires effort and time, I take such projects for a fee. Thanks. Best wishes.
Can it handle more than 50 students.
I need it badly
Thanks in anticipation
Thanks. I am sorry that I don’t have a template that handles more than 50 students. Best wishes.
Very helpful. Believe me never seen such a comprehensive sheet.
You have helped more than millions of people.
Really you are professional.
Thanks
Thanks for the kind words. Best wishes.
Please Sir, in my country, Ghana our report card is quite different.
We have continuous assessment which consist of all the exercises for the term.
*The total exercises for each subject will be scaled to 50%
*the exams of 100% of each subject will also be scaled to 50 %
*then the respective subject is added to get the total score.
*we are offering 8 subjects
I would be grateful if you could assist me to develop a template for the class.
I can brief you more on whatsapp if you wish. +233200430921
Sir, Thanks for your comment. I am very sorry that I am unable to modify this right now, as I am tied up with other projects. I am truly sorry. I hope to get to work on this later this year.
Best wishes.
You made a real helpful content for all, I appreciate your work. Please resolve the following issues :
1. Provide the solution if the number of students in the class is 150 or even more.
2. How to remove the subject columns completely when we need only 7 subjects.
3. When I am trying to print the marksheet of any student the upper headings (STUDENT VIEW , Settings, Entry, Class View etc.) also being printed along with the marks and other necessary data. How to remove that heading row from being printed.
4. How to change the font style, size and colors of the data like names, subjects , marks etc.
Please provide me the solutions for above mentioned issues in my email (nolinkumarkundu@gmail.com) . It will be a great help for my institution.
Thanks.
1. I don’t have a template for 150 students
2. Please do not remove columns. The columns can be hidden if they are not needed.
3. You can select the cells you want to include in printing and then set that as Print area.
4. Select the cells and change format in the format menu in the Home ribbon.
Best wishes.
Great job Indzara! Thank you for the support!
You are very welcome. Thanks & Best wishes.
TOTAL SUB_PASS Result Marks % Remarks
390 7 Pass 55.71 Second Class
456 7 Pass 65.14 First Class
396 6 Fail 56.57 Second Class
478 7 Pass 68.29 First Class
sir
when i am using if condition to calculate the grade the third record has failed which formula should i apply to calculate the grades as more than 60% will be the first class less than 60 and greater than 40 will be the second class and if a student has passed less than 7 subject it will be a fail. Please help me by giving the formula
A formula with IF function can work. We can also set up a lookup table with the grade thresholds and then use MATCH function.
If you have attempted to do the formula and have any issues, please email at indzara @ gmail. the file along with very specific questions.
Thanks & Best wishes.
Hello Indzara, your template is awesome. Can the number of subjects covered be increased to 18 or 20? How can I do that?
Thank you. Sorry, it would require a lot of changes in multiple worksheets to increase subjects. You can begin from the hidden sheet where calculations are done. Then, make corresponding changes in the reports.
Best wishes.
Hello… I need the system to calculate the letter grade
Sorry, I don’t have that functionality yet in the template. Thanks.
A nice useful template.Can I expand it for 72 students?HOW?
I am sorry. I don’t have documentation on steps to increase students. You can unprotect the sheets with indzara as password and edit. Thanks. Best wishes.
Hi, pls hw can i add columns at the end of student view for DISCIPLINE and CLASS COUNCIL DECISION. THANKS
Please unprotect the sheet with indzara as password and then add columns without modifying any of the formulas. Thanks. Best wishes.
what is the password to unprotect the sheet
indzara is the password. Thanks & Best wishes.
Hi there, i am after an accounts system which has after entering student and class time will automatically transfer to the correct roll and correct class, and also has the ability to generate a report with attendance rate.
I have 18 classes in morning session and 18 classes in the evening with 15 students per class.
Can you do this for me? And how much would it cost me?
I am sorry that I am unable to take this project at this time. I am currently working on some small business projects this month. I am sorry.
Thanks & Best wishes.
hello sir i have one query regarding report card template,sir i want to add attendance information in student view for each student in that case where i can make changes.
We have to build the attendance tracking in a separate sheet. Then, in the Student view, we have to use index & match to pull attendance data (from Attendance sheet) into the Student view for the selected student. Best wishes.
how i can use your performance report card for more than 70 students i also use your report cards but its just only based and handle it only 50 students i will try to exceeding 50 to more than 93- students but the following errors are displayed in cells. like: =IF(OR(C$10=””,$B61=””),””,SUMIFS(INDEX(Tbl_Percentages,MATCH($B61,Tbl_Student_Names,0),), Help_Lookup_Tests,C$10,Help_Lookup_Subjects,$M$5)) #REF! how can i change your report card 50 to 93 students which they handle or record more than 93 students please reply urgent.
Thanks. I have replied to your email. Best wishes.
I need help to increase the number of students. Please help. The template is very very helpful but to increase the number of students.
Sorry I don’t have the documentation on how to increase students and update all the dependent formulas.
Best wishes.
sir how to convert percentage marks of individual subject in student view into actual marks entered in entry sheet. i want actual marks instead of percentage marks in student sheet view
I am sorry that I don’t have a published version that shows Marks. Please feel free to edit the formulas and display marks instead of %. Best wishes.
thankyou May allah Guide us.
Thank you. Best wishes.
any attempt to enter a number or letter, it asked for a password, can you please, help
The template will work without needing a password. But some cells are protected and if you need to edit those, please use the word indzara as password. Thanks & Best wishes.
Thank u Indzara for ur contribution in my work. And thanks Dinesh for ur kindness. I came across to this template last year while making reports, and it was really something what i was trying to create in excel, but due to lack of knowledge for Data relations, i couldn’t. But this site came in as a life saver.
thanks people.
Keep up the good work
You are welcome. Thanks for your kind words. Best wishes.
I manage a school in Manipur in the North-east of India. Our school is under the state board viz- BOARD OF SECONDARY EDUCATION, MANIPUR. The Report Card Generating Software available in the market are not to the needs of the school as we have a lot of minor subjects such as Reading, Handwriting, G.K., Moral Science, Dictation, etc. They all provide space for fewer number of subjects. I would like to be able to prepare the Report Cards myself as per our necessity. Please help.
This template handles up to 12 subjects. You can generate report cards using this. Please let me know if there are any questions. Thanks.
This is a very great template and has ben very useful. Please how do I add more than 12 subjects to have up to 15 subjects. Thanks.
Thank you. I am glad that it is useful. It’s hard to explain all the steps needed to expand subjects and I am currently tied up with other projects. Please unprotect the sheets using password indzara and review the formulas. You can edit as needed. Thanks & Best wishes.
Very nice and helpful template. But please how to I adjust the NR issue on final class rank.. Instead of showing NR, how can I make it to show the real final class rank. Please help.
Thank you. The class rank should appear as NR when the student has not achieved minimum % required to Pass in all the subjects. If the student has passed all, then the class rank will appear. Please let me know if I have not addressed your question. Thanks.
Alright, how do I remove the restriction so that it will calculate the final class rank even though the student didn’t meet the minimum % required to pass.
In the hidden ‘Help’ sheet, in columns AC to AN, there are formulas which set the subject total to “” if it is below % required. You can edit that and remove that criteria P3=”FAIL” in the formula. This has to be done for all the cells in columns AC to AN. This will let totals and rank calculated for students.
Thanks 4 ur response. I was able to fix it. I rate this program 8/10. I’ve not found any other like it. In the final result that usually shows PASS or FAIL, if my students final overall % is 80%, I think that’s a good performance. But the final result always shows FAIL in that situation, how can I workaround this?
You are welcome. I am glad to hear that you like it. Does the student have above 80% in each of the subjects? Thanks.
Yes the student have above 80%
please were is the hidden help sheet:? How can i access it
Please right click on any tab/sheet name and you will see option to ‘Unhide’. Then choose the hidden sheet to unhide. Best wishes.
If there are any further questions, please email the file to indzara @ gmail .com and I will have to look at it. Thanks & Best wishes.
Hi,,
wonderful work.. please help with ur email address / contact number to send queries for this.
At present the only query coming to me is that how can i modify this to spool reports in chart or bar formats.
Thnks for posting such beutiful and useful work.
Regds
You are welcome. You can email at indzara at gmail dot com. Thanks. Best wishes.
Thanks for the template is helpful .but sir how can I increase the number of student in sheet bsc I have 80 student in my class. thanks
I am very sorry. I have not had a chance to work on this. I am currently tied up with other projects. Sorry.
Best wishes.
Thanks .but can u help me and tell the procedures to use so that more than 50 student will be enroll .thanks. My email is mansurmaibeni4@gmail.com
It is a wonderful work and really helpful document….Thank you very much for sharing your effort…
Thank you for the feedback. I am glad that it is useful. Best wishes.
thnxs sir ,
how to show marks rather than percentage . please help me
it very good template .thnxs sir
You are welcome. I will be adding it to the next version. Thank you.
Useful tutorial, please can I get fees payment template for my school including students pictures.
Thank you. I don’t have a fees payment template. Sorry.
Is there a sample image for such a template? Please let me know. Thanks.
This is excellent Ind Zara. Its very helpful. Thank you for the good job. Please keep it up.
You are very welcome. Thanks for the feedback. I am very glad to hear. Best wishes.
Hi, This is very good template.. i required only Three Assessment & Three Subjects.. ?? not required more assessment & subjects.. plz do needful for this..
Thank you. Have you tried entering just the three? please let me know if there are any issues.
easy excel rank
very helpful article
thanks
You are welcome. Thanks for the feedback.
Hi,
I’d like to adapt the template slightly, change the colours, how can I unprotect the worksheet?
we do not use percentages at our school we use Levels (One, Two and Three).
We work with Unit and lesson titles under those units.
Please can you email me the password to unprotect the worksheet so that I can make the adjustments to suit our institution please.
Thanks,
Hannah
Sure. Please use the password indzara to unlock and make changes. Best wishes.
Sir,
Can You make a School Time Table Templet for us
Please let me know what you would like to see on the template.
Hello, would it be possible to send me the password so that I can make changes to the excel document?
Please use indzara as password. Thanks.
sorry sir the password you gave is not working
I tried just now and indzara (no caps) works fine. Please email me the file if there are further issues. Thank you.
thanks sir the password works, i need your help on how to remove the percentage and have actual marks
i also need you help to make the rank work
Glad to hear. I am very sorry that I don’t have a template with actual marks.
Sir, In the month of October 10, 2014 I post one requirement as per CBSE grading system. I need urgently….
I am sorry. I have not been able to find time to work on it yet.
Can someone extend this to 13 or more subjects. I tried this but looks complicated… very goo job.. I like it
You did not talk about this…. irrelevant?
THANKS VERY MUCH FOR THE HELP YOU OFFER TO US WHO ARE NEEDY OF THIS THING
Thank you very much for taking the time to provide feedback. I am glad that I can be of help.
Thank you very much Sir for your support. If you add the CBSE Grading System. I will be very happy. can you make changes in REPORT CARD system like After Marks column add Wattage and then after Grades (as per CBSE 9 point)
Once again thanks a lot.
Thanks for the idea. I hope that I can build one before the end of the year.
Sir I need in report card weightage & grades coloumn. Please help me.
I don’t have such a template yet. Sorry. I hope that I can build one before the end of the year.
Hi, This is a very special project that would definitely impact schools a great deal, thank you. Please can you add additional rows for up to 20 subjects. Alternative if you could send me an unprotected sheet I am sure that I can manage with the editing. Thanks.
Thank you. The password is indzara. You can edit as needed.
Thank you very much for your support. If you add the grade system. I will be very happy. Thank you so much Indzara…
very effective and useful file
but how i can change mark show in% to normal marks
how i can use your performance report card for more than 70 students i also use your report cards but its just only based and handle it only 50 students i will try to exceeding 50 to more than 70- students but the following errors are displayed in cells. like: #DIV/0! how can i change your report card 50 to 80 stidents which they handle or record more than 70 students please reply urgent
alwaystrysmiling@gmail.com i nee dyour help please
Unfortunately, that would require some modifications. I am working on several other projects now and am unable to work on this one. I am sorry that I cannot be of more help now.
Sir i want also give therecord space 70 students please send me to my mail id: yelisha007@gmail.com
Hi Sir This is Yelisha Sir please send the 70 students data capable please
email: yelisha007@gmail.com
Thank you sir
This best template I have seen. if you could add automatic grade system based on percentage of the student it will be a lifesaver for teachers.
Thanks for share!
Thank you. I agree that grading system would be a good addition. What grading system do you use?
perfect for me. how can I change % to marks in the students view. I need marks , % and grade. how can I do this ? Please help me.
Good for COlleges. i need a templates or software for our Colleges to record Academic performance , attendance and show result in report . for each student progress or attendance
Please clarify. Are you looking for tracking academic performance and attendance performance in one report?
Good for COlleges. i need a templates or software for our Colleges to record Academic performance , attendance and show result in report . for each student progress or attendance
Good one
Thank you. I am glad you like it.
hi indzara please can you give me the password for the report card template so that i can customize the template
Please use indzara as password. Thanks.