** I need to use the \"VLOOKUP\" Function in Excel. Can you provide me with a \"
ID: 2994256 • Letter: #
Question
** I need to use the "VLOOKUP" Function in Excel. Can you provide me with a "formula" to input in the excel spreadsheet to obtain the correct answer?
An engineering student took five courses last semester. The credit hours and the grades for these courses are listed in Table 1. Table 2 provides the grade point associated with each letter grade (per each credit hour).
Table1: Credit Hours and Grades
Course
1
2
3
4
5
Credit Hours (xi)
3
4
5
3
3
Grade
C
B+
A
C-
D
Table 2: Grade Points Per Credit Hour Associated with Letter Grades
Grade
A
A-
B+
B
B-
C+
C
C-
D+
D
D-
F
Points (yi)
4.0
3.7
3.3
3.0
2.7
2.3
2.0
1.7
1.3
1.0
0.7
0.0
Eq-1
where xi is the credit hours of course i and yi is the points associated with the grade for course i.
Calculate the student
Course
1
2
3
4
5
Credit Hours (xi)
3
4
5
3
3
Grade
C
B+
A
C-
D
An engineering student took five courses last semester. The credit hours and the grades for these courses are listed in Table 1. Table 2 provides the grade point associated with each letter grade (per each credit hour). Table1: Credit Hours and GradesExplanation / Answer
An engineering student took five courses last semester. The credit hours and the grades for these courses are listed in Table 1. Table 2 provides the grade point associated with each letter grade (per each credit hour).
Table1: Credit Hours and GradesGrade point average = Total Grade point / total credit hours
SGPA = (3C + 4(B+) + 5A + 3(C-) + 3D) / (3+4+5+3+3)
SGPA = (3*2 + 4*3.3 + 5*4 + 3*2 + 3*1) / (18) = 2.678
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.