Complex Excel Sheet

This excel sheet is for a testing assessment. Each assessment has 75 questions different questions address multiple standards that the test is for. There are 10 separate standards. This sheet should include in whatever structure, what the percentage of questions for a specific standard a student got right. The ability to enter a right or wrong status for all 75 questions, and be able to have all of these diveded among 40 separate student entries. I do have a spreadsheet I have compiled that shows the gist of what I need to do, but am unsure how to make if functional. This would also need a clean and neat appearance and also be functional for a teacher to use. I know it sounds a bit confusing but there is no other way to explain it, you would also need to see the test sheet.