I need help with this project

MTH 154 - Quantitative Reasoning - Gossmann - Spring 2024 Project 1: Gradebook (modified from Pearson Education, Inc.) Scored out of 100 points In this project you will create a spreadsheet which keeps track of your as-yet-theoretical grade in this Math 154 course. In addition to simply recording all of your grades for the course, it will provide you with a \"running tally\" of how you are doing in the course at any point in time during the semester. After the project is complete, you will be able to utilize it to keep track of your course grade throughout the rest of the term. Instructions: Create a workbook in Google Sheets or Excel. 1. (S points) What does \"running tally\" mean? To help you understand this, on the first spreadsheet, compute the grade of a student with an 82 MyLab HW average, 87 Spreadsheet/Activity HW average, 73 Quiz average, a 92 on Project 1 and a 93 on the midterm. Use the syllabus to determine the appropriate weights for each category and enter a formula in a spreadsheet to compute their grade. Re-compute their grade assuming they get a 95 on Project 2. Insert a textbox nto the spreadsheet and record both grades in the textbox. How did you account for the \"missing\" weights for categories that don't have a score yet, like the midterm? 2. (10 points) Create a new sheet in the workbook from part 1 which will allow you to enter all of