How to Calculate GPA Using MS Excel
142.2 هزار بار بازدید -
4 سال پیش
-
In this video, we’ll be
In this video, we’ll be showing you how to calculate GPA using Microsoft Excel.
GPA stands for Grade Point Average and it is one of the most common stats a college will use to gauge a student. If you are wondering what your GPA is or what it might look like depending on your grades, it is very handy to make a GPA calculator. Let’s create a GPA calculator in Excel.
The chart on the right is a standard GPA chart. Not all curriculums are the same, so you may need to check in with your school to see what number each letter grade corresponds to.
1. Input your course data with course names, Grade Points corresponding to the letter grade you received, and the credit hours for each class.
2. Now we are going to multiply the GP with the Credits. Click the top cell in the Points column and write this formula: =C7*D7. Hover the mouse over the bottom-right of the cell until the cursor changes then click and drag it down the column.
3. Finally, we will calculate the GPA. We will take the sum of the Points and divide it by the sum of the Credits to get the GPA. Click in the Total GPA cell and type this formula: =(SUM(E7:E11)/SUM(D7:D11)).
And that’s how to calculate your GPA in Excel!
❓💬 What other handy calculations would you like to learn? Let us know in the comments below.
#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Instagram Instagram: howtechprojects
✅ Twitter Twitter: howtechprojects
GPA stands for Grade Point Average and it is one of the most common stats a college will use to gauge a student. If you are wondering what your GPA is or what it might look like depending on your grades, it is very handy to make a GPA calculator. Let’s create a GPA calculator in Excel.
The chart on the right is a standard GPA chart. Not all curriculums are the same, so you may need to check in with your school to see what number each letter grade corresponds to.
1. Input your course data with course names, Grade Points corresponding to the letter grade you received, and the credit hours for each class.
2. Now we are going to multiply the GP with the Credits. Click the top cell in the Points column and write this formula: =C7*D7. Hover the mouse over the bottom-right of the cell until the cursor changes then click and drag it down the column.
3. Finally, we will calculate the GPA. We will take the sum of the Points and divide it by the sum of the Credits to get the GPA. Click in the Total GPA cell and type this formula: =(SUM(E7:E11)/SUM(D7:D11)).
And that’s how to calculate your GPA in Excel!
❓💬 What other handy calculations would you like to learn? Let us know in the comments below.
#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Instagram Instagram: howtechprojects
✅ Twitter Twitter: howtechprojects
4 سال پیش
در تاریخ 1399/04/10 منتشر شده
است.
142,261
بـار بازدید شده