[SOLVED] Building the gradebook

Building the gradebook:Explain how you created the Excel worksheet you have used for this project (an overview as if writing to someone not in this course-explain what you did). Put in several details such as the category names, the percent weights used, etc.Make sure to explain (in general terms) what calculations you had to perform to get from the scores the student earned to the final course percentage they earned for the course. Be sure to include an explanation of each of the different functions/formulas you used, but avoid using specific cell references (B5, A3, G12, etc.) – so the reader can understand what was done without looking at the spreadsheet.
What final course percentage (rounded to the nearest whole percentage) did you calculate?
What letter grade in the course did this student earn based on the percentage calculated?Increasing homework scores:If this student would have earned 100 on every homework assignment, how would that affect their final percentage in the class at the end of the semester?
If this student would have earned 100 on every homework assignment, how would that affect their final letter grade in the class at the end of the semester?
State in your response if it is possible or not and explain how you came to your conclusion and why you think the result was what it ended up being.Test corrections on the midterm test:Go back to the grade book scores given in the original project description.
What is the best possible final class percentage and final class letter grade in the class the student could get if the instructor allowed the student to have 25% of the points they missed on the midterm test added to their current score if the student submits corrections for all the problems they missed on the midterm test?(…)