Business Software Excel Templates Accounting, Retail & POS HR Management Customer Relations Management Marketing & Sales School Projects Data & Statistics Financial Plans & Projections Education Quick Office Tools PHP SCRIPTS How to Get Our Resources Blog

Grade Point Average (GPA) Excel Template for Students, Lecturers, Exam Officers in Tertiary Institutions

1,535 122

1,500 | shub

Category: Education, Excel Templates

Overview GPA and CGPA

The Nigerian Tertiary Institution just like every other tertiatiary institution in the world uses the Grade Point Average (GPA) and the Cummulative Grade Point Average(CGPA) to award degrees to students who have fulfiled all requirements for graduation.

These awards are based on the grades obtained right from the first semester to the end of the program and it is in divisions or classes. For most undergraduate programs, the divisions are usually First Class, Second class Upper Division, Second Class Lower Division, Third Class Division and Pass. Most Masters Programs in the US and UK uses just three divisions-Distinction, Merit and Pass.

The Grade Point Average (GPA) takes into consideration the Total credit units apportioned to a course, the various grade levels and points earned by the student. This is usually computed to determine the cummulative considering a two semester system

Overview of Template

The Grading Point Average (GPA) excel template provides all tools needed for students and lecturers to calculate their GPA and CGPA in seconds! The template uses a real life scenario for calculating GPA and CGPA in Nigerian tertiary institutions and customisable for other tertiary institutions in the world.

This excel template will enable you to monitor your grades from the word GO! In essense, you will monitor and control your grades to get desired results and divisions on the convocation day.


  1. Semester By Semester Result Inputation
  2. Grade Scale can be modified.
  3. Computes all Semester Results
  4. Easy to use and highly customizable.
  5. User friendly interface.
  6. All formulas already calculated and automated.
  7. 24/7 Support with the developer.

Use Cases

This excel template is most suitable for the following:

  1. Students in tertiary institutions who wish to keep track of their Grade Points Average and Cummulative Grade Point Average.
  2. Lecturers and Exams/Transcript Departments in Tertiary institutions for multiple results and CGPA entry for a class(es).
  3. Examination Officers who wish to have a template to compile CGPA for Multiple students.
  4. Educational Administrators for Research Purposes.
  5. Other Excel Developers.

Excel Template

Version 2.0 (2022)

Widget is loading comments...