GPA and CGPA concept is used to evaluate the performance of students in many institution across globe. Every country has is own methodology to gauging the performance. The process of calculating GPA and CGPA is easy.
What is GPA and CGPA
S-GPA - Semester Grade Point Average
C-GPA - Cumulative Grade Point Average
Mostly in every country technical education students performance is gauged under these concept.
GPA is calculated for each semester and so we can say as SGPA. Calculation is done by summing the product of each course grade points and Credit Hours scores. Finally dividing by total Credit Hours score. SGPA is the base of calculation of CGPA. To calculate SGPA, the institution awards Grade for each course and each grade holds Grade Points, also Credit Hour Points. Every universities or institutions have their own Credit Hour Points weighted on various points like internships, work experience, volunteering, extracurricular activities, course work and so on.
Grading system normally has 8 to 10 point Grading systems based on courses.
For each student to Pass there is examination/evaluation conducted having certain marks systems, like, Maximum Marks for each course 100, Minimum Passing 40 each course, below 40 is failure.
Percentage Classification/Division
70% and Above Distinction/Outstanding
60% - 66.99% First Class
50% - 59.99% Second Class
40% - 49.99% Pass Class
Below 40% Fail/Improvement
The classification varies universities to universities. Classification of students based on marks or percentages they secure.
CGPA - is a method to sum product of all semester GPA and Credit Hours Scores.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Grade | Marks in % | Grade Point | Description |
| 2 | O | 90 and above | 10 | Outstanding |
| 3 | A+ | 80--89 | 9 | Excellent |
| 4 | A | 70--79 | 8 | Very Good |
| 5 | B+ | 60--69 | 7 | Good |
| 6 | B | 50--59 | 6 | Above Average |
| 7 | F | 40--49 | 5 | Average |
| 8 | G | Below 40 | 0 | Incomplete/Fail |
| Course Code | Course Name | T1 | T2 | T3 | ESE | Total | Out of | Grade | Grade Points | Credits |
|---|---|---|---|---|---|---|---|---|---|---|
| EC2111 | DS | 17 | 14 | 0 | 38 | 69 | 100 | B+ | 7 | 3 |
| EC2113 | DE | 18 | 20 | 8 | 28 | 74 | 100 | A | 8 | 4 |
| EC2111 | EDC | 13 | 14 | 9 | 36 | 72 | 100 | A | 8 | 4 |
| BSEC2121 | EM-III | 15 | 8 | 8 | 34 | 65 | 100 | B+ | 7 | 4 |
| EC2111 | NT | 14 | 18 | 7 | 37 | 76 | 100 | A | 8 | 4 |
| EC2115 | EDCL | - | 20 | 25 | A+ | 9 | 4 | |||
| EC2117 | DSL | - | 43 | 50 | A+ | 9 | 4 | |||
| EC2116 | DEL | - | 20 | 25 | A+ | 9 | 4 |
With above table, now let us calculate SGPA
We have Grade Points and Credit Hours Points, using Excel function we will calculate the SGPA.
The perfect function is SUMPRODUCT because we have to find product of each course.
=SUMPRODUCT($J$3:$J$10*$K$3:$L$10)/SUM($K$3:$K$10)
Results: 8.16
=SUMPRODUCT(Grade Points * Credit Points)/SUM(Credit Points)
So simple calculating the SGPA
CGPA is calculated by Adding up SGPA for all Semester and divided by number of Semester
The simple method in excel to calculate SGPA and CGPA.
Related Articles:
1. Calculate Weighted Average
2. Calculate Percentile in Excel
3. Analyze Data in Excel with Conditional Formatting
No comments:
Post a Comment