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.