How to make a self-marking quiz in Excel


Here is a quick way to set some basic tests/quizzes that mark themselves using Microsoft Excel. It’s a time-saver when using simple multiple-choice quizzes or easy-to-select responses. Although this is nowhere near the usability of Flubaroo, it’s great for teachers who might not have access to online resources.

I have made the Workbook available for website members to download below. Feel free to use and modify as you see fit. I have also uploaded this to the Resources section for Tech Teachers members as well.

Members can download the PowerPoint file (used in the movie above) and the Excel workbook using the link below.


The rest of this content is available to full members. Full membership of the site is available by either donating R100 on the Donation page, or uploading an activity or assessment that you yourself have created to share with others (on the Upload page).

Similar Posts: