## EXCEL EXERCISE #1: Grade Sheet PROJECT

1. Create a spreadsheet similar to the one below.

 A B C D E F G 1 BISI 3230: Information Syst 2 Fall 2016 3 4 STUDENT NAMES STUDENT ID EXAM #1 EXAM #2 EXAM #3 PART. AVERAGE 5 Thomas, Steven 999-25-5683 94 65 89 90 6 Alexander, Suzette 999-52-6938 93 91 97 80 7 Richards, Billy Joe 998-71-2838 55 62 65 40 8 Rasmussen, Betty 997-74-4447 95 94 90 90 9 Your name xxx-xx-xxxx Xx Xx Xx xx

a) In the last row, enter your name (Row 9) and make up values for STUDENT ID, EXAM #1, EXAM #2, EXAM #3, and PART. Highlight this row.

b) Calculate the AVERAGE in column G using the appropriate Excel Function. Assume that each EXAM and participation weights the same in calculating the average. Format the table to be visually appealing.

c) In a second worksheet of the workbook, reenter the same data.

d) This time, to calculate the AVERAGE score, assume that EXAM #1 weighs 20%, Exam # 2 weighs 25%, EXAM #3 is 30%, and PART is 25% of the average score.

Hint: Create Assumptions section of the different weights and use absolute references in the formula to calculate the AVERAGE.

e) In Column H of the second worksheet completed in c) above, create a label called GRADE (that is in Cell H4). Use and appropriate function to return the letter grade for each student based on the following Grade criteria: >=90.00: A, 80-89.99: B, 70-70.99: C, 60-60.99: D, and <60: D.