Excel - Entering marks - Validation, Conditional formatting and Vlookup

I used Camtasia to create the following clips relating to working with marks in Excel: the first is about checking that (slow) and (fast...