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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Project L costs $65,000, its expected cash inflows are $14,000 per year for 8 years, and...

Finance
Q

A newborn girl appeared normal at birth, but within 24 hours she developed lethargy, hypothermia, and...

Biology
Q

Explain the importance of having understanding of the physics or chemistry of failure mechanisms when one is...

Physics
Q

T F 2x 4 5 C 1 E 6 Line Segments about Circles D Find...

Geometry
Q

Graph the following ellipse Give the domain range center vertices endpoints of the minor axis...

Geometry
Q

Determine the open intervals on which the function is increasing decreasing or constant Enter your...

Calculus
Q

Question ID 91 A house for sale has a huge deck on its west side...

Algebra
Q

14 14 6 x 1 A 7 C 7 7 B 2 2 D 3...

Algebra
Q

Find the standard form of the equation of the hyperbola satisfying the given conditions x...

Algebra
Q

E7.5 (LO 2), E The following control procedures are used in Keaton Company for over-the-counter...

Accounting
Q

A four-year project is expected to sell 12,000 units annually at $20.00 per unit. Estimated...

Finance
Q

I did most of the work and most of the correct parts of the question...

Accounting