How To Calculate Your Cgpa Or Gpa Using Ms-Excel - Step By Step

You can use Microsoft Excel to calculate your Cumulative Grade Point Average for a session or your Grade point Average (GPA) for a semester. Excel reduces the stress for you. All you need to do is to insert the insert the correct syntax in the correct column, then excel performs the calculations for you.

How To Calculate Your Cgpa Using Ms-Excel

This is the Part 4 of chapter 2 of Excel tutorial. You are advised to read the first two parts:

Part 1: PRACTICAL AND BUSINESS APPLICATIONS OF BUILT-IN FUNCTIONS IN MS-EXCEL 2016

In this part 4 of chapter to of Excel tutorial, I will explicitly explain how to calculate your academic CGPA with practical illustrations.

The illustration in this section is for a five-point grade system. But the procedure is the same for other grade systems. Also in the example below, I assumed you offered nine courses both in first and second semester. If the number of courses you offered is less or more than nine, don’t panic. All you need to do is to adjust the cell references in the syntax of the function used.

The two main functions needed to design a CGPA System are the IF and SUM functions.

Definitions of Some CGPA Terms Used in this Illustration

1. UNITS:

This can also be referred to as Credit Unit. It is the credit load given to a course by the university management. Different courses have different credit units.

2. GRADE SYSTEM:

There are different types of grade system. The two most popular grade systems are the Five-Point Grade System and the Three-Point Grade System.
In the Five-Point Grade System, there are 6 grade letters, but only five out of the six letters are valid. The grade letters A, B, C, D, E, F represent the values 5, 4, 3, 2, 1, 0 respectively. 

The letter F is not valid since zero which is its value is an invalid number.
In the Three-Point Grade System, there are 4 grade letters where only three out of the four grade letters are valid.

3. GRADE LETTER EQUIVQLENCE:

As the name implies, it is the numerical equivalence of the grade letter. For example, in a Five-Point Grade System, the equivalence of the letters A, B, C, D, E, F are 5, 4, 3, 2, 1, 0 .

4. GP:

This means Grade Point. It is the value of the Grade letter equivalence multiplied by the Credit Unit.

5. TNU:

This means Total Number of Units. It is the sum of the credit units of all the courses offered in a semester.

6. TGP:

This means Total Grade Point. It is the sum of the grade points you made in all the courses offered in a semester.

7. GPA:

This means Grade Point Average. It is the value of the TGP divided by the TNU.

8. CTNU:

This means Cumulative Total Number of Units. It is the sum of the TNU for first and second semester.

9. CTGP:

This means Cumulative Total Grade Point. It is the sum of the TGP for first and second semester.

10. CGPA:

This means Cumulative Grade Point Average. It is the value of the TGP divided by the TNU for the academic session.

See:

Designing the CGPA System in MS-Excel

It is now time to design the CGPA System.
Prepare the three tables - first semester, second semester and general tables on MS-Excel worksheet as shown in the figure below.
CGPA System

Syntaxes for the CGPA System

For the First Semester Table

Type in the following syntaxes in the specified cells:

1. For the GRADE EQUIVALENCE;
Position your cell pointer in cell E4 and type the syntax:
=IF(D4="A",5,IF(D4="B",4,IF(D4="C",3,IF(D4="D",2,IF(D4="E",1,IF(D4=F,0)))))) press Enter. Use the auto fill handle to generate the values for the subsequent cells in the column.

2. For the GP;
Position your cell pointer in cell F4 and type the syntax:
=C4*E4 press Enter. Use the auto fill handle to generate the values for the subsequent cells in the column.

3. For the TNU;
Position your cell pointer in cell G4 and type the syntax:
=SUM(C4:C12) press Enter.

4. For the TGP;
Position your cell pointer in cell H4 and type the syntax:
=SUM(F4:F12) press Enter.

5. For the GPA;
Position your cell pointer in cell I4 and type the syntax:
=H4/G4 press Enter.

For the Second Semester Table

Type in the following syntaxes in the specified cells:

1. For the GRADE EQUIVALENCE;
Position your cell pointer in cell E15 and type the syntax:
=IF(D15="A",5,IF(D15="B",4,IF(D15="C",3,IF(D15="D",2,IF(D15="E",1,IF(D15=F,0)))))) press Enter. Use the auto fill handle to generate the values for the subsequent cells in the column.

2. For the GP;
Position your cell pointer in cell F15 and type the syntax:
=C15*E15 press Enter. Use the auto fill handle to generate the values for the subsequent cells in the column.

3. For the TNU;
Position your cell pointer in cell G15 and type the syntax:
=SUM(C15:C23) press Enter.

4. For the TGP;
Position your cell pointer in cell H15 and type the syntax:
=SUM(F15:F23) press Enter.

5. For the GPA;
Position your cell pointer in cell I15 and type the syntax:
=H15/G15 press Enter.

For the General Table

Type in the following syntaxes in the specified cells:
1. For the CTNU;
Position your cell pointer in cell A26 and type the syntax:
=G4+G15 press Enter.

2. For the CTGP;
Position your cell pointer in cell B26 and type the syntax:
=H4+H15 press Enter.

3. For the CGPA;
Position your cell pointer in cell C26 and type the syntax:
=B26/A26 press Enter.

Your completed CGPA System should resemble the one shown in the figure below.
CGPA System output

Congratulations! You have built a system for calculating your CGPA for an academic session using Microsoft Excel.

This is the end of the part 4 of chapter 2.

Now go over to Part 5: REFERENCING CELLS, DATA AND FORMULAS IN OTHER WORKSHEETS OF AN EXCEL WORKBOOK


Was this tutorial helpful to you?

Inform your friends about this post by clicking the share button below. 

Comment below if you are hooked up along the installation process.

Also click Here to subscribe for free so that you will get our latest game updates in your email.

Recommended Entrepreneurship Books

the passionate entrepreneurs strategies book by buzzer joseph

The Passionate Entrepreneur’s Strategies: Learn how to discover business ideas that will be successful, grow multiple online income streams, make money from home, attract new and retain customers, applications of SWOT analysis in any business, skills that will help you succeed as an entrepreneur, self-discipline, etc. Lucrative Business Ideas Series Book 1. By Buzzer Joseph. Read more about the book.

how to make money from blogging and affiliate marketing book by buzzer joseph

How to Make Money from Blogging and Affiliate Marketing: Learn the Step by Step Guide of Creating, Growing and Optimizing your WordPress Blog from Scratch for Search Engines (SEO) and How to Make Money through Google AdSense, Affiliate Marketing and Other Strategies for Earning Passive Income Online. Lucrative Business Ideas Series Book 2. By Buzzer Joseph. Read more about the book.

how to make money self publishing kindle books by buzzer joseph

How to Make Money Self-Publishing Kindle Books for Beginners: Learn the Step by Step Guide to Self-Publish a Best Selling Book on Amazon KDP, How to Design Book Covers with Adobe Photoshop, Format, Edit and Proofread your Book Manuscript with Microsoft Word, Promote your Book on Various Online Platforms and Earn Monthly Passive Income Online. Lucrative Business Ideas Series Book 3. By Buzzer Joseph. Read more about the book.

diy grid and off-grid solar pv installation guide by buzzer joseph

Complete Solar PV System Installation Guide: DIY guide on how to install grid-connected and off-grid solar PV systems, how to build solar-powered electric cars, convert conventional cars to electric cars, online and offline ways to make money from solar energy sector (including stocks), electrical wiring and protection system installation guides, plus free resources for skill acquisition and personal development. Lucrative Business Ideas Series Book 4. By Buzzer Joseph. Read more about the book.

how to make money from cryptocurrency trading and investments by buzzer joseph

How to Make Money from Crypto Trading and Investing for Beginners: Step by step guide with screenshots on the basics of blockchain technology, bitcoin and altcoins, crypto security tips, cryptocurrency market analysis (FA and TA), long term and short term trading, how to calculate your profits in excel, legit ways to make money with cryptocurrencies, DeFi yield farming and staking, how to use any centralized and decentralized exchange platform and more, plus crypto investment bonus! Lucrative Business Ideas Series Book 5. By Buzzer Joseph. Read more about the book.

blockchain practical guide kindle book by buzzer joseph

Blockchain Practical Guide: Step by step guide with pictures, on how to monetize the latest blockchain technology trends: crypto trading and tools, especially Ethereum, DeFi, Staking, NFTs, Top 100 Play-to-Earn (P2E) and NFT games, Web 3.0, Metaverse, Virtual Reality (VR), Augmented Reality (AR), blockchain job opportunities, with crypto investment bonus! Lucrative Business Ideas Series Book 6. By Buzzer Joseph. Read more about the book.

how to make money with blockchain web3 apps kindle book by buzzer joseph and kelly joseph

How to Make Money with Blockchain Web3 Apps: Step by Step Guide with Screenshots and Videos on How to Make Money from Blockchain and Web3 Projects – NFTs, Play-to-Earn (P2E) Games, Move-to-Earn (M2E) Apps, Watch-to-Earn (W2E) Apps, SocialFi and GameFi Apps, with crypto investment bonus! Lucrative Business Ideas Series Book 7. By Buzzer Joseph and Kelly Joseph. Read more about the book.

1 comment:

  1. Thank you for the detailed explanation. Pls how can i add i to remark the carryover courses

    ReplyDelete

WHAT'S ON YOUR MIND?
WE LOVE TO HEAR FROM YOU!