You are given a grades.csv file that contains data for the grades for IIT Antartica. The content of the file are:
Roll: Roll of the student
Sem: Semester in which that sub is studied
SubCode: Course Code
Credit: Sub Credits
Grade: Obtained Grade
Sub Type: Whether Core or Elective etc names-roll.csv - This contains the mapping of names and roll numbers.
subjects master.csv - This contains mapping of course codes and the name of the subject.
Your task is to generate a marksheet of every roll number and save as ”.xlsx” file in the output folder. A sample “0401CS02.xlsx” is provided for your reference. Its self explainable. The names of each sheet should be like the ones mentioned “0401CS02.xlsx”. Names: Overall, Sem1,...,SemN
Calculation of SPI and CPI: Suppose in a given semester a student has taken four courses having credits C1, C2, C3 and C4 and grade points in those courses are G1, G2, G3 and G4 respectively. Then,
SPI = (C1 ∗ G1 + C2 ∗ G2 + C3 ∗ G3 + C4 ∗ G4)/(C1 + C2 + C3 + C4) (1)
CPI = (SPI1 ∗ Credits in semester1 + SPI2 ∗ Credits in semester2 + ...)/(Total credits) (2)
For example, if in a given semester a student has taken four courses having credits 6, 6, 6, and 8 and grade points in those courses are 10, 9, 8, 6 respectively. Then,
SPI = (6 ∗ 10 + 6 ∗ 9 + 6 ∗ 8 + 6 ∗ 6)/(6 + 6 + 6 + 8) = 7.62 (3)
If the student has an SPI of 7.62 in the 1st semester worth (say) 32 credits and 8.2 in the next semester worth 36 credits,
CPI(at the end of 2nd semester) = (7.62 ∗ 32 + 8.2 ∗ 36)/(32 + 36) = 7.93 (4)
Grade Numeric Equivalent:
1
• AA - 10
• AB - 9
• BB - 8
• BC - 7
• CC - 6
• CD - 5
• DD - 4
• F - 0 • I - 0
2
