Design a spreadsheet to calculate the class’s grades. Consider the following requirements: Each project will be...

Design a spreadsheet to calculate the class’s grades. Consider the following requirements:

Each project will be graded from 0 to 10.
the contribution of each grade to the final grade are ( 7 team work assignments 10%, Project 1,2,3,4= 20%, mid term 35%, final 35%.)
The final test will be graded from 0 to 100, but your solution should allow different grades (i.e 80 points, 90, or 95). This flexibility is very important.
Program your solution to set a numeric final grade.
Program your solution to translate the numeric grade to the letter grade using the corresponding table

Please show steps by steps and explain the calculations.

Grading Evaluation

Deliverable	Final grade contribution
7 Team homework assignments	10%
Projects (1,2,3,and 4)	20 %
Midterm	35 %
Final test	35 %

Expert Solution

Below are the 2 screens of different scores

Grade = > A

Grade = > F

Colby Messinger answered 1 year ago

How are the requirements for a design project developed?

The systems requirements in a software project includes the categories of primary requirements, derived requirements, design...

The systems requirements in a software project includes the categories of primary requirements, derived requirements, design constraints, and design goals. Briefly explain each category and how it is different from the other categories.

PROJECT 4 : DESIGN A HYDRAULIC MOBILE CRANE REQUIREMENTS: •Design the system to carry load of...

PROJECT 4 : DESIGN A HYDRAULIC MOBILE CRANE REQUIREMENTS: •Design the system to carry load of up to 5000 lb •Use a hydraulic winch(rotary actuator)to move the pulleys up and down •Use fail-safe measures to support positive loads and run-away issues •The speed of the crane shouldbe changeable •Use dampeners to prevent vibration and maintain pressure and flow where necessar

Design a spreadsheet to compute the dollar amount in each of the next 10 years of...

Design a spreadsheet to compute the dollar amount in each of the next 10 years of an initial investment returning a constant annual interest rate. Interest is reinvested each year so that the amount returning interest grows. What is the dollar amount 10 years from now of $500 invested at 6% annual interest?

For each of the following scenarios, (a) state the study design, (b) calculate the risk of...

For each of the following scenarios, (a) state the study design, (b) calculate the risk of the outcome among the exposed relative to the unexposed being sure to use the appropriate measure of risk, and (c) interpret your findings in a full sentence in the context of the study. Hint: First, identify the exposure and outcome. Then, set up the 2x2 table and calculate the risk. The incidence rate of stomach cancer in a population of middle-aged men who smoke is...

Design a program that displays the following in Java: Enter the grades for an Essay: Grammer...

Design a program that displays the following in Java: Enter the grades for an Essay: Grammer (must be 30 or less): 40 Grammer (must be 30 or less): 26.3 Spelling (must be 20 or less): 17.4 Correct Length (must be 20 or less): 19 Content (must be 30 or less): 23.5 The recorded scores are: Grammer: 26.3 Spelling: 17.4 Correct Length: 19.0 Content: 23.5 Total score: 86.2 The grade for this essay is B

Consider requirements and technology for an analysis of an Automated Teller Machine (ATM) design. Type an...

Consider requirements and technology for an analysis of an Automated Teller Machine (ATM) design. Type an outline out for an ATM system design using the below HCI criteria. Use eye-tracker data to further analyze the product Consider accessibility (universal usability) issues such as lighting, physical placement of ATM, etc. Consider user profile issues, e.g. is this the first time a user is using an ATM? Requirement to perform beta and/or market tests? Are there other stress factors such as a...

Consider requirements gathering. Tell us 3 challenges of requirements engineering and project management. Why were they...

Consider requirements gathering. Tell us 3 challenges of requirements engineering and project management. Why were they challenging?

If your firm were to consider investing in the following project, calculate the NPV, IRR, and...

If your firm were to consider investing in the following project, calculate the NPV, IRR, and Payback values. Would this be a good investment for your company? PROJECT CASH FLOWS AND VALUES FOR A PROPOSED NEW PRODUCTION FACILITY: In year 0, invest $1,000,000 for a new production facility. The project will also require an investment of $50,000 into Net Working Capital. (Assume regular conditions of liquidation at project end.) The project is forecasted to last 4 years. Facility investment is...

Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should...

Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Project A Project B Project C Project D Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00) Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00 Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00 Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00 Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00 Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00 Rate 7% 10% 13% 18% Your company is considering three independent projects. Given...

Question