1901EE36-GUI Marksheet Generator Solved

Input: You are given a .csv file that contains marks for each roll number and the individual options marked by each students(see sample input\responses.csv). The following first seven columns are fixed:

Timestamp: At what time student submitted their question paper.

Email address: Email address to which student login.

Score: Total calculated score.

Name: Name of the student.

IITP webmail: IITP webmail address. Phone number: Phone number of the student Roll Number: Roll number of the student.

Outputs

1.    Your aim is to make a GUI as shown in Figure 1. Here the first button is to upload a master roll.csv file. It contains the names and roll number of all the students of the class. (see sample input\master roll.csv)

2.    Next is the response sheet csv obtained from google (see sample input\responses.csv). You need to check that a row with roll number ANSWER should be present in this file. If not, pop and error saying that, “no roll number with ANSWER is present, Cannot Process!”. A user with select the browse button and select these two files.

3.    Next, the user will be asked to enter the number of +ve and -ve marks. In this case as shown in Fig. 1, +5 is for correct answer and -1 is for wrong ans. 0 is a valid input for -ve cases. Assume that correct numbers r being entered here, decimal being allowed. So +4.5, and -1.25 is a valid input.

4.    All the output files should be in the folder named “marksheets”

5.    Generate Roll Number wise marksheet. Here you need to generate a marksheet for every roll number present in the master roll. If a roll number is present in the master file but not in the response.csv that means that student was absent, so a blank marksheet file needs to be generated having all answers as blank. This option also will generate a marksheet of individual roll number and save as ”.xlsx”. A sample ”1401ME06.xlsx” is provided for your reference. Its self explainable. The number of right answers, number of wrong answers, not attempted questions and the marks associated with right, wrong answers are displayed after being calculated automatically. Please maintain the font colors. Master Key answers are in Blue, Student’s correct answer is in Green and wrong answer are in red. Refer ”1401ME06.xlsx” for color scheme. The file should also have the IITP logo.

1

 

Figure 1: GUI Options. On the right you are given the option for +ve and -ve marks. In this example, it depicts that 5 mk are for correct answer, and -1 is for wrong. This input should be dynamic, so calculations should be based on the input provided. 0 is also a valid input for -ve case.

6.    A generate concise marksheet option is given that contains all the marked options as well as marks before and after -ve computation. (see sample output\marksheet\concise marksheet.csv)

7.    So, for a class of k roll numbers, there will be k output xlsx files, and 1 summary file (concise marksheet.csv) that contains the concise info for marks before and after negative.

8.    Make sure all the roll number based are saved with uppercase roll numbers. So if the person has entered 1701cs45 in the response.csv, it should be always saved as 1701CS45.xlsx

9.    Add a button namely Send Email and when you click on send email button, it will send a marksheet to you email address with the marksheet of that roll number. Email should be done on both emails of response sheet.

10.        For frontend, any web technologies can be used. But backend csv processing needs to be Python Sample Input and Output are provided

2