Forecast

(This page may not open correctly in Chrome. You may need to use Internet Explorer to see all of the directions.)

GRADE POINT EQUIVALENTS

A

A-

B+

B

B-

C+

C

4.0

3.7

3.3

3

2.7

2.3

2

 

 

 

 

 

 

 

 

C-

D+

D

D-

F

 

 

1.7

1.3

1

0.7

0

 

  1. Create a copy of the Estimated GPA worksheet. Rename the copy Forecast and change the font tab color to Red.
  2. Using the chart above, change the Grade Point Equivalent numbers to reflect the scale that might be used if plusses and minuses were included in the calculation of your GPA.
     
  3. In the space where you justified your previous chart choice, edit this text to reflect on the impact the above grade point equivalent chart would have on your estimated GPA. Do you think it would be advantages for MHS to use a scale like this? Why or why not?
     
  4. Delete the two blank sheets from the workbook, Sheet2 and Sheet3. 
  5. On the Estimated GPA worksheet, use the =TODAY() function to insert the date centered below the title with identical formatting as the title. 
  6. Save this spreadsheet and submit according to your teacher's instructions. 

 

  1. Add a footer to each worksheet of your Excel workbook that includes your name at the left, the date at the center, and "GPA" to the right.
  2. Print preview each page to make sure that no page is extending beyond one page! 
  3. Upload this assignment to Edmodo when complete.