Starting from:

$30

Mid Sem Assignment CS384 - Marksheet Generator Solved

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

More products