Report Card Maker & Marks Register

Setting up a class

Type the school, the class and division, your name and the academic year once; they print at the top of every card and mark list. If you already keep the class in the Class Attendance Register on this device, Copy a class from the Attendance Register brings the details and the names across, and later fills in attendance on the report cards. The register itself is never changed. Then, on the Setup tab:

1. Students — paste the names one on each line. A roll number in front is kept (12 Arjun K or 12. Arjun K); a line without one gets the next number.
2. Subjects — type them, or tap + The usual six subjects and rename any to suit the class. A subject set to Grade is marked with a letter instead of marks: art, work education, health and physical education or discipline. Grade subjects print in their own box on the card and never count in the total.
3. Exams — tap a name such as + First Term or type your own. Each exam keeps its own maximum marks for every subject, so a unit test can be out of 25 and the term exam out of 100, or Mathematics out of 80 while English is out of 100. Same for every subject sets them all at once. Leave a box empty for a subject that is not in that exam.
4. Grades and pass mark — choose the grading scale and the pass mark in each subject.

Up to 40 classes can be kept, each with up to 200 students, 20 subjects and 12 exams.

Entering marks

The Marks tab shows one subject at a time, with a box beside every student, which is how marks usually arrive — one corrected bundle of papers at a time. The grade appears beside each mark as you type it, in red when it is below the pass mark, and the count on each subject button shows how many are done. Enter moves to the next student. Besides a number, a box takes:

• AB — absent from the exam. It counts as 0 out of the maximum and as below the pass mark.
• – (a dash) — the student does not take this subject, such as the other second language. The subject is left out of that student's total and maximum, so their percentage is fair.
• Half marks such as 45.5. A mark above the subject's maximum is refused, with the reason under the box.

If the marks are already in a spreadsheet, copy the column and use Paste a column of marks from Excel: the marks fill the boxes top to bottom in the same order as the students, and an empty line leaves a box empty.

How totals, grades and ranks are worked out

Each subject's percentage is its mark out of that subject's maximum, and its grade comes from that percentage. The total adds every subject marked with numbers, and the student's percentage is the total out of the maximums of the subjects they took. The scales:

A grade starts at its lowest figure, so with the CBSE scale 91% and above is A1 and 90.5% is A2. For example, Meera's First Term marks, each subject out of 50, are English 46, Hindi 41, Mathematics 45.5, Science 38 and Social Science 44. Mathematics is 91%, an A1; Science is 76%, a B1. Her total is 214.5 out of 250, which is 85.8% — an A2 overall.

A student passes when every subject reaches the pass mark. Ranks go by percentage, which is the same as by total when everyone takes the same subjects. Students with the same percentage share a rank and the next rank is skipped — two students on 85.8% are both 2nd, and the next is 4th. A student with any box still empty gets no overall grade or rank until it is filled in, so a missing paper never quietly pulls a rank down.

The mark list and the result analysis

The Results tab shows the whole class for an exam: every mark, the total, percentage, grade, rank and Pass or Fail, in roll order or by rank. Share mark list PDF makes an A4 sideways mark list with the subject averages, highest marks and pass counts along the bottom; Download for Excel saves the same figures as a CSV file.

The result analysis is one A4 page for the head teacher: the number on roll, how many passed, the pass percentage and the class average; for each subject the number who wrote it, the absentees, the average, highest and lowest marks and the pass percentage; how many got each grade; the top three; and the students below the pass mark with the subjects they need help in.

Report cards

On the Report cards tab, tick the exams the card should show — up to four, such as First Term and Annual Exam. Each exam gets a column of marks and grades, and with two or more an Overall column adds them up: if First Term is 214.5 out of 250 and the Annual Exam 432 out of 500, the overall is 646.5 out of 750, which is 86.2%. With several exams the result line and the overall rank follow the Overall column. Rank is left off the card unless you tick it, because many schools no longer print one.

Under the card, each student has boxes for days present, working days and the class teacher's remarks. Remark ideas offers ready sentences to tap — including one naming the subjects the student is below the pass mark in — and you can change every word. For a class copied from the Attendance Register, Fill in counts each student's attendance between two dates the way the register does: late counts as present and a half day as ½. A student with 17 days present, 1 late, 1 half day and 1 absent shows 18.5 of 20 working days (93%). Attendance and remarks are saved with the last exam on the card, so next term's cards start fresh.

All cards — PDF makes one A4 page for every student, with the grading key and lines for the class teacher, the parent and the principal to sign. Share this card sends a single student's card, for example to the parent on WhatsApp.

Keeping the data safe

Everything is saved in this browser on this device and nothing is uploaded; the PDFs and the Excel file are made on the device. When names are typed in an Indian script, the page fetches a matching font from Google Fonts the first time, so the cards print them correctly. Clearing the browser's data or changing devices loses what is saved, so use Save backup file now and then and keep the file in Drive or email. Open backup file on another device puts everything back — it replaces what is there.