RANDOM QUIZ USER GUIDE
After opening a new workbook, select the Create quiz tab, in the drop-down list, click Refresh to completely refresh your workspace, with the aim of avoiding errors when running the program
After creating a new workbook, select the Create quiz tab, in the drop-down list, click Create sheets.
A spreadsheet is created with three sample sheets named title, listStudent and tests.
Then a form called Basic Form opens:
Don't add anything, and don't delete any part of the form. Go to settings:
then choose as shown below:
SET TITLE AND TIME
Back in the spreadsheet, select the sheet named title, a simple form as shown below:
STUDENT EMAIL LIST
ENTER THE QUESTION'S CONTENT
Select the sheet named test.
Select Add-ons/Random Quiz/Enter questions, a dialog box appears like this:
Question number: Where you enter the number of the question.
Content Question: This is where you can enter the text of the question, or you can also copy the question from another document and paste it here.
However, you need to pay attention:
The physical quantities in the problem are not represented by numbers, but replaced with a letter (the letters are not used: a, b, c, d, e, f) together with an index . For example, in the left illustration, velocity is denoted by v1, and mass is denoted by m1.
The physical quantities must be placed between the "" sign and the && ampersand. Example here: "&v1&" and "&m1&".
Insert symbol: Insert special characters or math operators.
Formula for calculation: This is where you enter the physical quantity calculation formula asked in the question. In this example, the quantity asked is the kinetic energy of an object, and the formula for the kinetic energy is 0.5 *m1*v^2.
Unit of measure: The unit of measure of the physical quantity has been calculated above. In this example, the kinetic energy has the unit J.
Theoretical options: This section is only for non-calculating questions, it is theoretical questions.
After entering the question, calculation formula and units of measure, choose Insert, followed by Next question to continue to enter other questions.
UPLOAD THE FIGURES
When you have prepared all the pictures for the test, select Add-ons/ Random Quiz/ Upload Pictures
CREATE TEST AND SEND STUDENT
Select Add-ons/ Random Quiz/ Create quiz
Wait for completion (The amount of time you spend depends on the number of students), a sidebar appears, Click Create Quiz to start creating quizzes. While the program is active, you can do something else, but don't quit the program or turn off the computer.
When enough tests have been created, the sidebar automatically closes. Now you just need to post to students with one more action: Select Add-ons / Random Quiz / Send:
The student scores will appear immediately in the Score column: