Interview Reports

The goal of this task is to generate reports regarding applicants interview data required in admission process. list of students that are called for interview, present and absent on interview day, list of those who give interview on certain date and interview marks based list.

These are explained below:

  • List of Applicants that are called for Interview:

First the admin select in reports section from the menu, then he select the category Interview from the reports section, where he selects the List of all applicants that are called for Interview report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

ALL STUDENTS INTERVIEW LIST

  • Attendance of Applicants on Interview date:

First the admin select in reports section from the menu, then he select the category Interview from the reports section, where he selects the Attendance of Applicants on Interview day report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

INTERVIEW ATTENDANCE

  • Marks in Interview:

First the admin select in reports section from the menu, then he select the category Interview from the reports section, where he selects the List of marks in Interview report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

INTERVIEW MARKS

  • Date wise List of Applicants for Interview:

First the admin select in reports section from the menu, then he select the category Interview from the reports section, where he selects the Date wise list of students for Interview report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

DATEWISE LIST OF STUDENTS FOR INTERVIEW

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicant’s Interview Record.

sequence_interview

Here is the Database script of table that is required for these reports.

Interview and  Applicant database table