Grade papers and exams

I need to record and score this batch of midterm answer sheets from Professor Martinez's Intro to Anthropology. Open the spreadsheet with the student list, verify each student's ID and rubric mapping are present, enter each raw score in the Score column, calculate the weighted total per the syllabus (40% exams, 60% coursework), flag any totals below 60% in red, then lock the grade column and prepare a CSV for the registrar by Friday afternoon after I double-check three random rows.

Before I upload grades to the portal, make the sheet reviewable for Professor Martinez. Put the final course grade at the top next to each name, surface how many points came from exams versus coursework, highlight any manual adjustments and why, and create a one-line note at the top listing students with missing work that could change grades if turned in this week.

I was grading and after entering Ana Lopez's exam score the formulas for the weighted totals returned errors and three students show impossible totals. I checked the rubric mapping and student IDs and they look correct. I am worried I broke a range reference or someone else edited the sheet earlier. What likely went wrong, how should I restore the correct totals safely, and what immediate checks do I run before I resume grading?

I keep losing time because every grading spreadsheet gets edited by TAs and formulas break or ranges shift. I waste hours hunting errors before I can grade. Which habit change will prevent this recurring firefight: how should I structure the workbook, control edits, and run quick integrity checks so I stop rebuilding totals each grading session?