தேர்வு முடிவு பகுப்பாய்வு

Result Analysis Tool

மதிப்பெண்களை Excel-இலிருந்து ஒட்டி, பாடவாரி தேர்ச்சி விகிதம், மாணவர்/மாணவியர் பகுப்பாய்வு, தரவரிசை மற்றும் மதிப்பெண் வரம்பு அறிக்கைகளை உடனே பெறுங்கள்.

மதிப்பெண்கள் பதிவேற்றப்படுவதில்லை

கருவி ஏற்றப்படுகிறது…

பயன்படுத்துவது எப்படி? · How to use the result analysis tool

  1. Copy your marks. In Excel or Google Sheets, select the table from the header row down to the last student: Roll No., Student Name, Gender (B/G) and one column per subject. Extra columns such as Total, Rank or helper formulas are ignored automatically.
  2. Paste. Click in the box and press Ctrl+V. Enter AB for absent students. The tool shows how many students and subjects it found.
  3. Check the settings. Tick the subjects that count in Total, and confirm the pass marks: government norm (35%) and management norm (50%).
  4. Print or download. Print the report or save it as PDF, or download CSV files to open in Excel.

What the report includes

  • Subject-wise students appeared, passed, failed and pass percentage for boys, girls and total, under both government and management norms.
  • Mark range distribution: 100, 95–99, 90–94 … 50–54, below 50, absent and malpractice.
  • FA, SA and overall grades on the A1–E2 scale for the FA + SA format.
  • Subject average, highest, lowest, centum count and the top three students in each subject.
  • Mark list with total, average, result and rank.
  • Lists of students who failed in one, two, or three or more subjects, for remedial classes.

Frequently asked questions

Are my students’ marks uploaded anywhere?

No. All calculations run inside your browser. Marks are not sent to TN Kalvi or any server, and they are gone when you close the page.

Which sheet formats work?

Two formats are detected automatically: (1) one mark column per subject, used for Classes 9–12 and monthly tests, and (2) the FA + SA format for Classes 1–8, where each subject has 40 | 60 | 100 | FA | SA | FA+SA columns. Merged header cells are fine.

How is a student marked Absent, Fail or Pass?

If a student is absent (AB) in any counted subject, the result is Absent and no rank is given. Otherwise a student who scores below the chosen pass mark in any counted subject fails. You choose whether the result follows the government norm (default 35%) or the management norm (default 50%).

How are ranks calculated?

Only students who passed get a rank, ordered by total. Students with equal totals share a rank and the next rank is skipped (1, 2, 2, 4), the same as Excel’s RANK function.

Why should Total and Average use the same subjects?

If Total adds one set of subjects and Average divides a different set, grades and ranks become inconsistent. This tool always calculates both from the subjects you tick.

Can I open the report in Excel?

Yes. Use the Analysis or Mark list download buttons to get CSV files that open in Excel or Google Sheets with Tamil text intact, or use Print to save a PDF.