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.
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Blog
Archive
Contact
google+twitterfacebook
Copyright © 2019 HomeworkMarket.com