I have to create a gradebook weighted project in excel and I have some confusion.

INSTRUCTIONS: each gradeable item needs a weight assigned to it. That weight needs to be in a separate cell in Excel so you can calculate final grades for students. For example, if the mid-term's is 50% and the final is 50% you'd need the mid-term's 50%(or 0.50) in one cell and the final's 50% in another cell. This way, for each student, you can reference his/her specific midterm grade, multiply it by the weight, and that his/her final grade, multiplied by the final's weight.

I have attached the gradebook that I have worked so far. I just need to be sure that I have done it right. Any suggestion, please.

Student Information Student ID D000-235852 D000-123541 D000-541541 D000-500011 D000-235235 D000-100011 D000-110020 D000-200205 D000-900103 D000-036666 D000-701055 D000-600122 D000-852400 D000-600155 D000-455500 D000-500011 D000-582000 D000-222000 D000-366066 D000-780200 Student First Name Stephanie Nathalie Carlos John Marie Jean Sebastian Emely Anne Alex Efrain Miguel Lea Alexandra Steven Victor Mike Adam Elizabeth Ashley Student Last Name Williams Harris Lee Jackson Hernandez Miller Wilson Thomas Perez White Sanchez Clark Johnson Brown Jones Anderson Smith Garcia Moore Davis Grades Assignments Max Points HomeWork 5 Class Participation Mid Term1 Mid Term2 Final Exam Total 5 25 25 40 100 80 88 95 80 90 90 80 85 81 93 90 100 95 90 93 80 77 70 75 80 70 70 75 80 85 100 90 92 85 90 95 93 90 100 95 88 90 80 93 89 70 80 77 82 75 95 100 91 85 89 77 85 52 89 80 80 83 85 87 88 99 96 89 98 100 70 80 90 89 88 92 89 87 81 86 89 89 90 95 97 89 97 96 100 100 90 82 83 81 83 83 87 86 85 89 79 89 90 91 90 Grades Weights % 100% Grade A HomeWork Class Participation MidTerm1 MidTerm2 Final Exam Total 5.00% 5.00% 25.00% 25.00% 40.00% 100.00%