Give Brightpath's teachers letter grades, averages and a class ranking, instead of a spreadsheet full of formulas.
Letter grades
Map a score from 0 to 100 to a letter, and reject scores outside that range.
Averages and ranking
Store scores per student, compute averages and rank the class.
Drop the lowest score
Let teachers ignore each student's worst test when computing averages.
Stuck watching tutorials but unable to build anything alone? Why it happens, and a step-by-step way out using small projects with tests and a clear definition of done.