Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. design a spreadsheet to calculate the class�

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

90.2K

Verified Solution

Question

Advance Math

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

  1. Each project will be graded from 0 to 10.
  2. the contribution of each grade to the final grade are ( 7 teamwork assignments 10%, Project 1,2,3,4= 20%, mid term 35%, final35%.)
  3. The final test will be graded from 0 to 100, but your solutionshould allow different grades (i.e 80 points, 90, or 95). Thisflexibility is very important.
  4. Program your solution to set a numeric final grade.
  5. Program your solution to translate the numeric grade to theletter 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 %

Answer & Explanation Solved by verified expert
4.2 Ratings (618 Votes)
Below are    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Civil Engineering
1.2K views

Results obtained from a tension test on a bar of uniform cross section 10 mm x...

Accounting
1.2K views

Deliberate Speed Corporation (DSC) was incorporated as a private company. The company’s accounts included the following at...

Accounting
1.2K views

Chaz Corporation has taxable income in 2018 of $312,000 for purposes of computing the §179 expense...

Accounting
1.2K views

The following transactions relate to Sunlight Mountain Inc. Prepare journal entries for each transaction. Prepare the...

Biology
1.2K views

Select the term or terms that make each statement correct Having covered the structures and...

Biology
1.2K views

Which of the following pellets at the slowest speeds during differential centrifugation Microsomes Ribosomes Nuclei...

Geometry
1.2K views

Use the figure below to find the exact values of the half angles 5 Find...

Basic Math
1.2K views

Solve the exponential equation. Write the exact solution and the approximation to the 4 decimal...

Accounting
1.2K views

Exercise 5-2(Algo) Future value; single amount (LO 5-2)Exercise 5-2(Algo) Future value;...

Accounting
1.2K views

Compute overhead applied to production. Is the account over/under applied? Show...

Accounting
1.2K views

Using up to 300 words but not to exceed 400 words. Identify and describe the...

Accounting
1.2K views

Worldwide Inc., is a multinational company with divisions around the world. Division A in the...