Create a GPA calculator in Excel using these instructions below:
Problem 3: GPA Calculator
Many of you will have things in the university that you'll want to do or take advantage of which is GPA-dependent. For instance, if you want to enroll in an accelerated master's program, you will need to have a minimum GPA of 3.25 overall and 3.5 in all of the courses in your major.
Create a program that will calculate your overall GPA and GPA in major based on a list of your classes and your grades. This GPA should be calculated by semester and overall. This data should be presented in a way that includes the class, the name of your class, the grade that you received in your class, your GPA (overall and in-major) for this semester, and your cumulative GPA (overall and in-major). However, note that this may not be a sufficient amount of data to calculate your GPA (overall, in major, or both). This data may be provided by the user, calculated by you, or both.
Implementation:
Please go to the third tab, labeled Prob 3-GPA Calc, in the associated Excel Spreadsheet and implement your solution. You have broad leeway to implement this solution in a way that you see fit and can format your chart/calculator as you wish. However, it should be:
1. Obvious where your chart/calculator is;
2. Your chart/calculator should be clearly labeled so that all information presented is easily understood; and
3. If provided with the missing data, the chart/calculator will automatically and correctly calculate your GPA.
It is strongly recommended that you show and label intermediate calculations in the spreadsheet. You may store these calculations anywhere in the sheet but, remember, a solution that is not understandable isn't usable so make sure that your calculations and labels are logical, understandable, and organized.