Messages
Proposals
Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.
Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support
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.
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
ONLINE |
Instant Homework Helper |
$36 |
She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
Top Grade EssayI have read your project details. I can do this within your deadline. |
$45 | Chat With Writer |
ONLINE |
Chartered AccountantI have read and understood all your initial requirements, and I am very professional in this task. |
$46 | Chat With Writer |
ONLINE |
Smart Homework HelperHello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism |
$50 | Chat With Writer |
ONLINE |
Finance ProfessorYou can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you! |
$49 | Chat With Writer |
ONLINE |
Quick N QualityGive me a chance, i will do this with my best efforts |
$50 | Chat With Writer |
ONLINE |
Financial AnalystHello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism |
$20 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.