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
