EXCEL EXERCISE #1

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.