User manual

Creating Question Batches with an Excel Spreadsheet

Download question template

From the slideshow question menu select to download a question template, click here

Save the Excel spreadsheet named template.xls to your computer and open with Excel.

Adding questions/slides to an Excel spreadsheet

The spreadsheet should have 4 work sheets - Settings, Slide Macros, Result Groups and Questions.

1. Settings work sheet

Work Sheets

Name of batch: Enter descriptive name of batch.

Title image: Enter the name of the image which will act as a title page (image must be 640 x 480 pixels and be

JPEG format). The title image will act as a button on the games menu screen.

Background image: Enter the name of the image which will act as a background image (image must be 640 x

480 pixels and be JPEG format).

Shared: Question batches can be shared. To make a question batch available to others, enter Yes , or enter

No to make it unavailable.

Random order: You are able to set the questions to be show in random order. If you choose not to, they will be

shown in the order you have uploaded them.

Questions per quiz: Enter the number of questions which the quiz will display by default. This number can be

changed once the quiz is on the system through the slideshow settings.

2. Slide Macros Work Sheet

Slide macros are useful if you have many questions which have the same slide specification. Rather than entering

the same slide details for each question, a macro can be defined which describes a group of slides. For each

question with the same pattern of slides, the same macro can be specified in the Slide macro column of the

Questions sheet , and then no slides need to be defined in the Questions sheet.

To define a slide macro, open the Slide macros

sheet. Start a new macro by filling in a name for the macro in the

leftmost column (under Macro name ); then fill in the other columns with the details of the first slide. If there are to

be other slides in the same macro, define them on the following rows, with the same macro name in the leftmost

column.

Within each slide definition for each macro, you can use parameters. These allow the same macro to be used by

multiple questions but with different images. To use a parameter, where you would normally put a filename in the

slide definition (e.g. under Image ), put PARAM1 for the first parameter, PARAM2 for the second, and so on.

Parameter values are filled in from the Questions sheet s Parameter 1 , Parameter 2 , and Parameter 3

columns.