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: 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 |
WRITING LANDAs per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget. |
$46 | Chat With Writer |
ONLINE |
Assignment SolverI find your project quite stimulating and related to my profession. I can surely contribute you with your project. |
$16 | Chat With Writer |
ONLINE |
Top Quality AssignmentsI am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message. |
$28 | Chat With Writer |
ONLINE |
Supreme Essay WriterI can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing. |
$46 | Chat With Writer |
|
ONLINE |
Instant Homework HelperAs an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients. |
$31 | Chat With Writer |
ONLINE |
A+GRADE HELPERI am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content. |
$38 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.