Quiz Results & Question Analysis – Excel Template

Mark a 10-question quiz right or wrong per student and see each student's score and which questions the class found hardest.

• Automatic summary: Students, Class average, Pass rate, Q1 – % correct, Q2 – % correct, Q3 – % correct, Q4 – % correct, Q5 – % correct, Q6 – % correct, Q7 – % correct, Q8 – % correct, Q9 – % correct, Q10 – % correct
• Calculated for you: Score, Score %, Result
• Drop-down menus for quick, consistent entry
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.