Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have uploaded the data. Project 1 Instructions Design a spreadsheet to calculate the class's grades. Consider the following requirements: 1. Each project will be
I have uploaded the data.
Project 1 Instructions Design a spreadsheet to calculate the class's grades. Consider the following requirements: 1. Each project will be graded from 0 to 10 points. 2. Each quiz will have a grade from 0 to 10 points. 3. Each team homework assignment (THA) will be graded 1 to 10 points 4. See your course syllabus to identify the contribution of each grade to the final grade. 5. The tests (midterm and final) will be graded from 0 to 100 points, but your solution should allow to set different values to grades (i.e 80 points, 90 , or 95 ,) This design will give me flexibility when preparing the tests. This flexibility is very important. 6. Program your solution to set a numeric final grade for the course. 7. Use a LOOKUP (or VLOOKUP) table to translate the numeric grade to the letter grade using the corresponding scale in the course syllabus. Functionality, usability, and proper design will be considered for grading the assignment. Read the questions and answers (Q&A) document for Project and the rubric before start working on your solution. Use the link for Project 1 to submit your solution to Canvas. nnn On a inN a aa ro \& lnN ^ lnN 8 d lnr inStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started