7. Many colleges will convert marks to a grade point average (GPA). Most use the scale shown in the table. Letter Grade Scale |Scale of Marks (%) Grade Point Value A+ 90-100 4.0 A 85-89 4.0 A- 80-84 3.7 B+ 77-79 3.3 B 73-76 3.0 B- 70-72 2.7 67-69 2.3 C 63-66 2.0 C- 60-62 1.7 D+ 57-59 1.3 D 53-56 1.0 D- 50-52 0.7 F 0-49 0.0 Courses are worth between 2 to 4 credits depending on the number of hours of class per week. To calculate the GPA for a set of marks, use the formula GPA = [sum of (credits x grade point value)] + total credits Consider these students' marks. a) Convert each mark to its grade point value. b ) Calculate each student's percent mark without weightings. C) Calculate each student's GPA using the formula d) Compare the rankings of the three students using the two methods. e) Describe how a student's GPA could be calculated using a formula in a spreadsheet. Introduction to Computer English Mathematics Business Science Student Accounting (3 h/week) (4 h/week) (4 h/week) (2 h/week) (3 h/week) Fannie 89 78 72 82 66 Khadija 65 76 92 71 80 Trent 75 75 75 75 75