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.
