This Excel spreadsheet with built-in code makes it possible to easily create a multi-choice quiz from your own lists and materials.
I made this as a pupil said it would help her sort out her KS2 spellings, and I have also used it to quiz others on fraction-decimal equivalences. I often have to work offline, and wanted something I could adapt on my own PC without searching through the web and downloading off the internet. The program simply runs on Excel: you do have to save your file as macro-enabled format though. Excel will alert you to this when you come to save.
When you open the file, click to enable macros and editing.
On Sheet1, simply copy your list of questions into the first column and add your choice of correct answer plus three incorrect answers.
On Sheet2, press the big grey button and the program runs, generating a colourful screen presenting your questions and answers in a random order, in large print ComicSans, while keeping score.
Note: This works best as a teacher-controlled quiz or whole-class whiteboard activity, as it's not too hard for a savvy pupil to switch away from the quiz onto the sheet containing the answers.
I made this as a pupil said it would help her sort out her KS2 spellings, and I have also used it to quiz others on fraction-decimal equivalences. I often have to work offline, and wanted something I could adapt on my own PC without searching through the web and downloading off the internet. The program simply runs on Excel: you do have to save your file as macro-enabled format though. Excel will alert you to this when you come to save.
When you open the file, click to enable macros and editing.
On Sheet1, simply copy your list of questions into the first column and add your choice of correct answer plus three incorrect answers.
On Sheet2, press the big grey button and the program runs, generating a colourful screen presenting your questions and answers in a random order, in large print ComicSans, while keeping score.
Note: This works best as a teacher-controlled quiz or whole-class whiteboard activity, as it's not too hard for a savvy pupil to switch away from the quiz onto the sheet containing the answers.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00