I am trying to create a spreadsheet to calculate GPA for a high school. If I have the type of course and a grade, example, honors with a grade of a A. What formula can I use to pinpoint where this falls in a grid.
If you need any additional information please let me know. I would like the quality points for this particular scenario to be displayed in K41. In this case the quality points that should be displayed is 6.0. Thank you. Here is my data:
<colgroup><col span="4"><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
If you need any additional information please let me know. I would like the quality points for this particular scenario to be displayed in K41. In this case the quality points that should be displayed is 6.0. Thank you. Here is my data:
Course Difficulty | Grade | Quality Points Earned | |||||||||
Final Avg | Letter Grade | Quality Points | Scale for | Honors | A | ||||||
AP | Honors | Academic | Elective | Unweighted GPA | AP | B | |||||
100-98 | A+ | 7.3 | 6.3 | 5.3 | 4.3 | 4.3 | Academic | A+ | |||
97-94 | A; O; P | 7.0 | 6.0 | 5.0 | 4.0 | 4.0 | Elective | B+ | |||
93-92 | A- | 6.7 | 5.7 | 4.7 | 3.7 | 3.7 | |||||
91-89 | B+ | 6.3 | 5.3 | 4.3 | 3.3 | 3.3 | |||||
88-85 | B; S | 6.0 | 5.0 | 4.0 | 3.0 | 3.0 | |||||
84-83 | B- | 5.7 | 4.7 | 3.7 | 2.7 | 2.7 | |||||
82-80 | C+ | 5.3 | 4.3 | 3.3 | 2.3 | 2.3 | |||||
79-76 | C | 5.0 | 4.0 | 3.0 | 2.0 | 2.0 | |||||
75-74 | C- | 4.7 | 3.7 | 2.7 | 1.7 | 1.7 | |||||
73-71 | D+ | 4.3 | 3.3 | 2.3 | 1.3 | 1.3 | |||||
70-67 | D | 4.0 | 3.0 | 2.0 | 1.0 | 1.0 | |||||
66-65 | D- | 3.7 | 2.7 | 1.7 | 0.7 | 0.7 | |||||
64-50 | F | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||||
49-0 | X; U | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
<colgroup><col span="4"><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>