[Solved] CS384 Tutorial 5-CPI SPI Generator

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 = (C₁ G₁ + C₂ G₂ + C₃ G₃ + C₄ G₄)/(C₁ + C₂ + C₃ + C₄) (1)

CPI = (SPI1 Credits in semester₁ + SPI2 Credits in semester₂ + )/(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