Questions must be in an XLSX (Excel) file in order to be able to upload them as a Carousel Question Bank
If you're an Excel user, you can do this by clicking this link to download a question bank Excel template, and then adding in your questions to the file.
If you're a Google Sheets user, simply create the file in the format described below, and then select File >> Download >> Microsoft Excel to export the file in a format that can be uploaded to Carousel.
The file format should be as follows:
- A single tab
- Four columns on the worksheet with these column headings:
- Make sure your questions are numbered in sequential order, starting from 1.
- Use identical topic names where you want the system to recognise questions within the same topic. The system will create a new topic for every discrete topic name found, so if you have "Number, shape and space" and "Number, shape & space", the system will consider those to be separate topics.
- Follow these naming conventions if you're numbering topics. We've created a handy support guide to help you get your numbering to work as intended.
- Only use supported characters. Question banks most commonly get rejected by the system because of the use of unsupported characters – especially when it comes to subscript and superscript. We support most unicode characters, but this does mean a few characters are excluded - particularly in superscript/subscript, and their use will result in the Question Bank getting rejected. When using subscript, superscript and notations in particular (such as in vector equations) we strongly recommend using the Excel "Insert >> Symbol" function. This list shows which superscript/subscripts characters are and are not available as unicode, but as a rule of thumb if it is available as a symbol in Excel then it should be supported.
- Questions and answers must be a maximum of 700 characters in length. If they are longer, the file will be rejected.
- Make sure that "Number" is in cell A1 and "Question" is in cell B1 and so on - it won't work if the table is somewhere else on the sheet.
Here's an example file for a Chemistry question bank: