MS Excel Exercise: GPA Calculator

You will be constructing a spreadsheet that you can use to calculate your current Grade

Point Average. $($GPA$)$

Open a New Worksheet in Microsoft Excel.

Copy the spreadsheet shown to the next page.

Under the heading Subject, list the classes that you currently are enrolled in$.$

In the column titled, Current Grade,

check the grades for your current

grades in each subject and enter them

in the appropriate cell.

Use an IF Function to create the

Grade Values. Use the NOTE:

Grade Values to help you.

Condition: IF Current Grade $="$A$",$ then

$4\mathrm{.}0,$ else IF Current Grade $="$B$",$ then $3\mathrm{.}0,$

else IF Current Grade $="C",$ then $2\mathrm{.}0,$ else

IF Current Grade $="$D$",$ then $1\mathrm{.}0,$ else IF

Current Grade $="F",$ then $0\mathrm{.}0,$ else $0\mathrm{.}0$

In the Total Values $=$ cell, insert a

formula that calculates the Total of all

individual letter grade values found in

the Grade Values Column. $($Add up

all the individual letter grade values$).$

In the MY GPA$=$ cell, insert a

formula that calculates the AVERAGE of all the individual Grade Values.

Round of the decimals to the nearest $100$th$.($Two decimal places$)$

Under the cell that calculates MY GPA, Insert an IF Statement for the following condition:

If a student's GPA is greater than or equal to a $3\mathrm{.}50,$ then have the cell display HONOR ROLL!

If the student's GPA is less than the $3\mathrm{.}50,$ have the cell display, Keep Trying!

Try out your GPA Calculator and make $3$ different Report Card Examples. Type in a

series of low grades $(1\text{'}$s & $2\text{'}$s$)$ and then high grades $(3\text{'}$s & $4\text{'}$s$)$ and see if the IF statement changes to Keep Trying or Honor Roll!

Answer the questions $1$ to $10.$