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

History Data Reports

The goal of this task is to generate reports regarding History(previous year students that are applied for different programs). List of applicants who applied for specific year along with contact information, gender wise lists, their academic record, admission test and interview details, their status (the final status reports not eligible for admission based on 2nd year marks, those who are eligible but not come up to merit, the students who are eligible for enrollment in department but cannot submitted their dues, and the list of those students who submitted their dues and get enrolled in department).
These are explained below:

  • All Applicants list of Previous year:

First the admin select in reports section from the menu, then he select the category History from the reports section, where he selects the All Applicants list of Previous year 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.

STUDENT LIST OF YEAR....

  • Previous Applicants Academic Record:

First the admin select in reports section from the menu, then he select the category History from the reports section, where he selects the Academic Record list of Previous year 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.

ACADEMIC RECORD OF LAST YEAR

  • Gender wise List:

First the admin select in reports section from the menu, then he select the category History from the reports section, where he selects Gender wise list of Previous year 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.

GENDER WISE LIST OF YEAR

  • Admission Test and Interview Marks List:

First the admin select in reports section from the menu, then he select the category History from the reports section, where he selects the Admission Test and Interview Marks List of Previous year 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.

ADMISSION TEST AND INTERVIEW MARKS OF LAST YEAR

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

sequence_History

 

Test Venue Reports

The goal of this task is to generate reports regarding Test Venue’s data required for admission process. The number of rooms in each block, their capacity, and their availability.
These are explained below;

  • Test Venue Block’s Details:

First the admin select in reports section from the menu, then he select the category Test Venue from the reports section, where he selects the Test Venue Block’s Details 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.

VENUE REPORT

  • Room Details:

First the admin select in reports section from the menu, then he select the category Test Venue from the reports section, where he selects the Test Venue Room Details 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.

ROOM DETAILS

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Admission test venue.

sequence_test venue

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

Test Venue

Reports about Academic Record

The goal of this task is to generate reports regarding applicants Academic Record data required for admission process. The list of students based on matriculation marks, inter marks, intermediate, CGPA or marks on bachelor level, and there Subject combinations report.

These are explained below:

  • All Academic Record of Applicant:

First the admin select in reports section from the menu, then he select the category Applicant Academic Record from the reports section, where he selects the All Academic Record of Applicant 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.

ACADEMIC RECORD OF STUDENTS

  • Subject Combination:

First the admin select in reports section from the menu, then he select the category Applicant Academic Record from the reports section, where he selects the Subject Combination 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.

SUBJECT COMBINATION REPORT

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicant’s Academic Record of those that are enrolled for admission test.

sequence_academic record

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

Applicant database table and Academic Record

Payment Reports

The goal of this task is to generate reports regarding payments data required in admission process. The list of students who pay admission form fee, their sum and date-wise lists of payment.

These are explained below:

  • Payment Information of all Applicants for Admission Test Fee:

First the admin select in reports section from the menu, then he select the category Payment Information from the reports section, where he selects the Payment information of all applicants 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.

PAYMENT INFO OF ADMISSION TEST

  • Date wise Admission Test Fee Report:

First the admin select in reports section from the menu, then he select the category Payment Information from the reports section, where he selects the Date wise Admission Test Fee 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 ADMISSION TEST FEE

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicant’s Payment Record of those that are enrolled for admission test.

sequence_payment

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

Applicant database table and Payments

Applicant Reports

The goal of this task is to generate reports regarding applicants data required for admission process. The list of male and female students separately, list that contains the contact number, email, mailing address, the students date wise form submission, the list of verified students for admission test, list of students of each room regarding admission test seating plan, the final status reports not eligible for admission based on 2nd year marks, those who are eligible but not come up to merit, the students who are eligible for enrollment in department but cannot submitted their dues, and the list of those students who submitted their dues and get enrolled in department.
These are explained below:

  • All Students Enrolled for Admission Test:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the All Student Enrolled for Admission Test  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 OF ADMISSIN TEST

  •  List of Male/Female Applicants:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the List of Male and Female Applicants 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.

LIST OF MALE AND FEMALE STUDENTS

  • List of Verified students for Admission Test:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the List of verified Students for Admission Test 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.

LIST OF VERIFIED STUDENTS

  • Date wise Admission Form Submission:

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Date wise Submission of Admission Form 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.

DATE WISE FORM SUBMISSION REPORT

  • List of Students in Each Room(Seating Plan for Admission Test):

First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Room wise List of Students for Admission Test  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.

ROOM WISE LIST OF STUDENTS

  • Final Status Of Students:

The final status report contain four type of status, not eligible for admission based on 2nd year marks, those who are eligible but not come up to merit, the students who are eligible for enrollment in department but cannot submitted their dues, and the list of those students who submitted their dues and get enrolled in department. First the admin select in reports section from the menu, then he select the category Applicant record from the reports section, where he selects the Final Status of the Students 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.

FINAL STATUS REPORT OF STUDENTS

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicants that are enrolled for admission test.

sequence_applicant reports

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

Applicant and Test Venue