Middle School Math Class Gradebook Excel Education

Hello. I am teaching an accelerated math course for the summer to a mixed group of middle school and high school students. I currently have a gradebook on Excel made to keep track of their assignments and assessments, but I believe that it could be significantly improved and I'm also not sure I'm using the formulas correctly to reflect a fairness in their grading. I would like help in either taking my gradebook and improving it, or would be open to having a new one created if necessary. I can give further details once we connect, but different categories of work, such as classwork, homework, quizzes, exams, final, etc are weighed differently. I also have a total of about 32 students. Thank you!