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 %

Solutions

Expert Solution

Below are the 2 screens of different scores

Grade = > A

Grade = > F

Colby Messinger answered 1 year ago

Next > < Previous

Related Solutions

How are the requirements for a design project developed?

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

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

Provide a carefully constructed narrative reply to each of the following requirements. You may consider using...

Provide a carefully constructed narrative reply to each of the following requirements. You may consider using internet resources beyond your textbook to gather supporting information. Identify several different career paths that one might consider as an accounting professional. Define accounting, and define generally accepted accounting principles (GAAP). Identify several different career paths that one might consider as an accounting professional. What is ethical behavior, and why is it very important to the accounting profession? What challenges might arise that cause...

Write any java programming to meet the following requirements. Your project must meet the following requirements:...

Write any java programming to meet the following requirements. Your project must meet the following requirements: 1. Specify input specification Design input 2. Specify Output Specification Design Output 3. The class must include set methods and get methods ( with or without parameters both) 4. Must include Array structure 5. Must include Input or Output Files or both 6. Demonstrate your knowledge of an Applet

Subjects