Result is ‘PASS’ if the student has scored at least the “% Required to Pass” in each of the subjects in the test.Overall % is calculated as Total Marks/Maximum Marks in each test.Maximum Marks is the sum of maximum possible marks in all the subjects in a test.Total Marks is the sum of actual marks scored in all the subjects in a test.Please make sure that the subject names are unique. This would make sure that the final marks will not be displayed anywhere in the template. 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. 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. 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%. In such scenarios, weights are assigned to each test and final marks are calculated based on those weights. In many scenarios, students’ final marks are calculated based on assessments or tests throughout the academic year. 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 the screenshot above with the sample data, I have used 40% as % required to pass. Also, you would enter the ‘% Required to Pass’. This is where you would enter your school and class information. Step 5: Go to Student View to view and print Student Report Card (Choose a Student).Step 4: Go to Subject View to view and print Subject Report Card (Choose a Subject).Step 3: Go to Class View to view and print Class Report Card.Step 2: Enter information in Entry worksheet.Step 1: Enter information in cells underlined in the Settings worksheet.Calculates the result and class rank for each test.Calculates the final % for each subject.Calculates the final overall %, final class rank and final result.Calculates the average final % for each student.Highlights students failing to meet the % required to pass.Highlights the highest marks in each test.Presents the data for all the students in each test.Calculates the average final % for each subject.Presents the number of students failed in each subject in each test.Highlights Subject with the least average in each test.Option to calculate final marks based on custom weights assigned to each test.

Customizable maximum marks for each test for each subject.Up to 12 different subjects can be entered.Up to 12 different tests can be entered.

Microsoft excel templates online