Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

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

26/12/2020 Client: saad24vbs Deadline: 10 Days

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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

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!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Writer Writer Name Offer Chat

Writers are writing their proposals. Just wait here to get the offers for your project...

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What does the triangle mean in naplan - Module 01 Written Assignment - Managed Care Myths - Wireshark lab dns v7 0 solution - Wileyplus accounting homework answers chapter 3 - Eco 202 final project - Which of the following statements about buying centers is true - Bond university career development centre - Map of curtin university - Psychology - Puget sound skills center - Storage organs in humans - Engineering test plan example - Group project - Why should we study intercultural communication - Logit Assignement- Need ASAP - Should the us convert to a zero personal income tax - Liam o mahony auto repairs - As 3500 part 3 - Martial arts r us maru needs a database - Uhg yahoo finance - Essential Types of Essays In Academic Writing | A Crucial Guide - PPT on develop compensation and benefits package that you would like to be offered from your organization - Plagiarism Free - Para lavarse el pelo carlos usa crema de afeitar - Chapter 7 payroll project journal entries - Racq road side assistance - Imagery examples in the book thief - The second thinksafe step is: - Thermo fisher scientific revco service manual - The outcasts of poker flat characters - Informatics - Presenting problem case study example - De la salle institute napa - Newton's second law misconceptions - Cesc check in assessment - Assignment - Medallion club of marvel stadium - Zinc and vinegar chemical reaction - Sum of arithmetic sequence worksheet - Race - Matlab state space simulation - Analysing the Accounting Information - Rumelt's criteria for evaluating strategies example - Acara work samples year 3 writing - Aalberts dispense technologies san antonio tx - Triangular prism edges faces vertices - 6 2 discussion final project - Iphone 6 plus upgrade program - John invested the following amounts in three stocks - Alison games atlantic history - Capital in the Twenty-First Century (200 words or more) - Disconnect reconnect course tafe - Inherit the wind play characters - Swot analysis of an accounting firm - NEED AN A+! Summative Assignment: Critique of Research Article NEED AN A+! - Astrand cycle test protocol - Butan 1 ol ir spectrum - Shell model of human factors - Jb hifi returns policy - Eriochrome red b indicator - Dr vignesh raja joondalup wa - Barack obama leadership style ppt - Homework - Pink noise generator circuit - Knee voltage of led - According to kelly, fear is different from threat in that fear - Kindly give me answer for a case study - Chemistry matter and change chapter 9 study guide answers - Trade terms quiz module 7 - Higher italian past papers - Causes of being underweight - What you pawn i will redeem annotated bibliography - Are moon jellyfish pelagic or benthic organisms - Discussion: Networking Opportunities - Ucas personal statement worksheet - Shop Thursdays - Which of the following accounts is equity - Marketing and operations management at ikea - Efficiency of dc shunt motor - Budget assignment for students - SOCW 6361 Wk 11 Discussion 2: Becoming a Lifelong Advocate - Shear center thin walled open section - Building shared services at rr communications case study - Movie review - Week 4 application security - Humanities through the arts 9th edition pdf - A 27-year-old patient with - 5 PAGes ESSAY - Federalism - 2016 maps clip art by bruce jones design inc - F 16 roll rate - Key organizational enablers for effective demand management - Non functional pencil grasp - Board paper executive summary - Https course apexlearning com public cpop - Iron iii nitrate health hazard rating - Discussion Assignment 3 - Conformity is to obedience as - Chapter 10 arbitrage pricing theory - Sydney secondary college balmain - Derivation of coulomb's law from gauss law