Google Sheets Sorting & Grading Demonstration Form

This is my pride and joy - a set of formulas into Google Sheets which allows for:

• Instant grading of submitted forms (against my answer key)
• Checking against an imported class roster to see who has submitted or not submitted
• Sorting of students who are below a certain grade threshold (which can be adjusted)
• Checking for duplicate entries
• Collecting of email addresses for students who have not submitted form (to send a batch-email to them)

This is also in the description of the YouTube video, but here are the links for the:
Sorting & Demonstration Sheet:
https://docs.google.com/spreadsheets/d/14-kF2T4Tb4uusAYdLtCPNPGwKhmCjTH55X31dnGNiNA/edit?usp=sharing

Fake Name Template for Testing:
https://docs.google.com/spreadsheets/d/17Hj3mLBKQlzKnuukIwp002hJSQKx2pWY8kBmZSIv9g8/edit?usp=sharing

Form that data is pulled from: (collecting username is disabled so anyone can view)
https://docs.google.com/a/isd622.org/forms/d/1PQQFECAYtDn0nSOk_KE8SduYxcJZ1cHyKNOhJ8PvYiU/edit