## 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.