Part $2$:

On worksheet $2,$ create a GPA calculator spreadsheet using the example at the bottom of the instructions:

Classes

Grades $($actual $/$made$-$up$)$

Credits hours $($how many credits per course$)$

Grade Points $($use the data table$)**$

$**$Extra Credit for using a function for the Grade Points column referencing the lookup table $($remember absolute formulas$)$

Calculate answers using appropriate formulas $/$ functions for:

Total Credits hours

Total Points columns

Total of Total Points

Fall GPA, Spring GPA

CUMM GPA $($you may need to look this one up$)$

Design the spreadsheet with a simple professional format

Do not copy the example line$-$for$-$line. Make it specific for you.

Name the worksheet GPA Calculator

Use the rubric below for grading guidance.