User Account

All Pages

Calculate the average in column g using the appropriate

Assignment Help Management Information Sys
Reference no: EM132025074

EXCELEXERCISE : GradeSheet PROJECT

1. Create aspreadsheetsimilar to the one below.

 

A

B

C

D

E

F

G

1

BISI3230:Information Syst

 

 

 

 

 

 

2

Fall 2016

 

 

 

 

 

 

3

 

 

 

 

 

 

 

4

STUDENTNAMES

STUDENTID

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,BillyJoe

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 worksheetof 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.

Reference no: EM132025074

Questions Cloud

Difference between color blindness rates of men and women : Construct the 90% confidence interval for the difference between the color blindness rates of men and women.
Confidence interval for the population mean : The confidence interval for the population mean mµ is left parenthesis nothing comma nothing right parenthesis. ?(Round to one decimal place as? needed.)
The annual operating cash flow is projected : In other words, the annual operating cash flow is projected to be $60 × 6,600 = $396,000. What is the base-case NPV?
What is the best estimate of the current stock price : Orwell building supplies last dividend was $1.75. its dividend growth rate is expected to be constant at 48% for 2 years, after which dividends are expected.
Calculate the average in column g using the appropriate : Assume that each EXAM and participation weights the same in calculating the average. Format the table to be visually appealing.
What is the value of the project : What is the value of the project if OU Tech decides to issue $80,000 in bonds at an interest rate of 8% to finance the project?
Alternative hypothesis and null hypothesis : What is the alternative hypothesis (Ha) and null hypothesis?
What does the entrepreneur gain : What face value must the debt holders be promised? Which project will the entrepreneur select? What does the entrepreneur gain?
What is the capitalized worth : The original cost of a certain asset is $1,180. It has to be replaced (at this cost) every 4 years; the salvage value is negligible.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Explain bead bar management information systems

Bead Bar Management Information Systems - List and describe each of the seven phases of the systems development life cycle.

  Briefly describe the seven components of a strategic plan

Briefly describe the seven (7) components of a strategic plan. Discuss two (2) significant issues concerning information system management in the overall strategic plan.

  Identify and incorporate a variety of preventive controls

Identify and incorporate a variety of preventive controls into your BCP. Some of the listed controls are the following: Appropriately sized uninterruptible power supplies (UPS) to provide short-term backup power to all system components (including ..

  Identify components that you believe make press release

In an essay of 350-500 words, describe the role of press releases in public relations. Identify components that you believe make an effective press release.

  Research about the virtualization

Examine at least three (3) benefits and three (3) drawbacks that an organization or individual could experience using virtualization.

  What is the purpose of an in-circuit emulator

Cloud Computingis used as a means to provide off-site computing power to an organization. Describe the three main types of Cloud Computing platforms. What is the purpose of the control unit in a channel architecture? What type of computer generall..

  Describe the requirements for a recruit based on your state

Describe the requirements for a recruit based on your state police as well as your local law enforcement agency.

  What is meant by the term cyberethics and cyberlaw

What is meant by the term "Cyberethics and Cyberlaw" in relation to the Internet? Discuss the impact of the Internet on any one of the concepts discussed.

  Problems of cost estimates with information technology

The question related to Management Information System and it discuss about the problems of cost estimates with information technology. The problems have been discussed in the solution briefly

  Identify five properties for each entity

For this discussion forum, you will list three entities and then identify five properties for each entity

  How can buffer-overflow attacks be avoided

Research and discuss the principle of exploits based on buffer-overflow attacks. How can buffer-overflow attacks be avoided?

  Evaluate the existing infrastructure as it currently exists

An international law firm has asked you to engage in a risk and mitigation evaluation and plan for their organization.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd