Before you start
You need the Excel export from each of the two Microsoft Forms quizzes.
In Microsoft Forms, open the quiz → **Responses** → **Open results in Excel**. Do that for both papers. If you already keep them in one workbook with several sheets, that is fine — use the whole file.
---
1. Load the responses
Drag the Excel file (or both files) onto the box at the top, or click it and choose them.
The tool reads only the sheets that hold actual Forms responses. If your workbook has a VStack, Dashboard or helper sheet, it ignores them **on purpose** and tells you it has — those sheets are built by formula from the others and reading them would put one paper's answers under the other paper's questions.
It works out which paper is which from the "MCQ #" column or the sheet name. If it cannot, pick Paper 1 or Paper 2 yourself from the dropdown on the right.
2. Read the checks
**Do this before you print or send anything.** Everything the tool could not make sense of is listed here in plain English rather than quietly guessed:
rows that are not real submissions (stray cells left below the data)
participants who left the course date blank
the same name submitted twice
employee numbers Excel has already damaged
how many correct answers it was able to recover, and whether anything disagreed
Green is fine. Orange is worth a look. Red needs fixing before you rely on the output.
3. Results
Pick the course date at the top to see just that course. The pass mark is 75% — the tool tells you exactly what that means in points and in questions.
Below the results table, everyone below the pass mark appears as **a single line** — name, paper, score, and how many they got wrong. Click a line to open it and see the questions they got wrong, what they answered and the right answer. Click again to close it. **Expand all** opens the lot.
Click **Print exceptions sheet** for the paper you walk the room with. It always prints in full — every person, every wrong answer — whether or not you have opened them on screen.
4. Certificates
Choose whether everyone gets one or only those at or above the pass mark. Check the date, centre and course director, then click the button. You get one PDF with a page per participant, on the real ARC template. Print and sign as required.
5. List for the provider
**Copy table** puts it on the clipboard ready to paste into Excel or an email.
**Download as Excel** if you would rather send a file.
6. Save the record — this is the important bit
The tool keeps nothing of its own. It holds a copy in this browser so you do not lose your place if the window closes by accident, but **that copy is not a record**. It disappears if the browser is cleared and it does not exist on any other computer.
Before you finish:
**Download record (.xlsx)** — the spreadsheet of who did what. Save it with your course files.
**Download backup** — an exact copy you can reopen here later, or on another computer, with **Restore backup**.
Next course, use **Add earlier record** to fold the last one in, so the record you download carries everything.
---
If something goes wrong
The tool is designed to stop and say what is wrong rather than produce a quietly incorrect answer. If it refuses a file, the message says which file and why — usually it is the wrong export, or a `.csv` instead of an `.xlsx`.
Nothing you do here changes your source files. If it looks wrong, reload the page and start again.
**Nothing leaves this browser.** No participant data is uploaded, sent or stored anywhere.
---