UCL WIKI

UCL Logo
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Current »

With the kind permission of Tristan Robinson

Generate a Moodle question bank using the Maths Quiz GUI

    1. Step-by-step guide on how to use the GUI
  • Programme pre-requisites are: Microsoft office (excel) and Matlab
  • Unzip GUI.zip: Matlab files, Excel databases and additional files.
  • To run the program open and run maths_quizz.m in Matlab.



  • The interface will open. To browse click on the tab with the three dots and navigate to the folder with the Excel question sheets. Click on OK.



  • Upon recognising the directory, some of the drop down menus on the GUI will become active and display information.
  • The Database (.xls or.xlsx) dropdown shows all the Excel workbooks (.xls or .xlsx) present in the selected folder. The names of the workbooks take the form of function_Qalgebra, function_Qcalculus and etc. The programme will only run with pre-defined workbooks.
  • Click on one question bank workbook. The name will appear in the Selected database edit box and the worksheets will be shown in the Worksheet listbox.



  • Click one worksheet and then click on select. The list of questions will appear in the List of equations drop down.

 



  • Select the desired questions – you can use the ctrl or shift tab on your keyboard.
  • Select the type of question (multichoice, algebra or numerical) to generate. Not all options will be available – this is dependent on selected worksheet.
  • A default output name is given in Name of output file – an alternative name can be specified.
  • Click on xml to generate the question bank.
  • The output Moodle XML file is generated in the directory containing the Excel databases.

1.2 Description of how to import the Moodle XML file into Moodle

  • Once the Moodle XML file has been created it can then be imported onto Moodle https://moodle.ucl.ac.uk/
  • Turn editing on button below the UCL logo on the right hand side of the page.
  • Then on the left hand side of your Moodle click on the settings tab and scroll down to Question bank and then click on Import.


 

  • On the opened page select Moodle XML under file forma
  • Next under import questions from file click on the tab choose a file. On clicking on this tab a new window should open. Click on Upload a file, then click on the Choose file tab and then browse for the directory contain XML quiz file. Click on open and then click on upload this file to return back to the main screen.


 

  • You should now notice that the file has been attached with the name displaying under the choose a file tab. Finally click on import
  • All the question have now been imported into Moodle's question bank ready to be used in your Quiz. You will notice that Moodle has saved your quiz under with the same name as that of the Moodle XML file.

Appendix A: Description of workbook question database

  • Each worksheet follow a standard format.
  • Columns A, B, F, G, H,I J are generic and found in all worksheets.
  • Columns C, D and E change depending on the topic (worksheet) and question.
  • For any cell that is not used in the worksheet the user need to ensure a "nan" (not-a-number) string
  • Generic columns

A. Name: Name given to the particular type of question
B. Tex: Mathematical equation written in TEX syntax
F. dp: Decimal accuracy
G. Q: Links to the Qtext file (text for each question)
H. Hint1: Links to the Qtext file (hints for each question)
I. Hint2: Links to the Qtext file (hints for each question)
J. Level: Level of difficulty of the question: 0 = GCSE, 5 = A-level, 10 = 1st year and 20 = 2nd year
K. Source: Question reference

  • Non-generic columns

 

A. Function: Mathematical expressions or function (use Matlab maths syntax)
B. Sym: Symbols that are found in the algebraic expressions
C. Var: Variable that is to be solved in the algebraic expressions

D. Range: Range of the algebraic/trigonometric functions

A. Function, Function 1, Function 2: Mathematical expressions or function (use Matlab syntax)
B. w.r.t: Variable used to differentiation/integration
C. Limits: Limits of integration (can use symbol, pi and inf)
D. var: Variables used in series integration


A. Function: Mathematical expressions or function, written Matlab format.
B. Function 1, Function 2: Are used to separate the two mathematical expressions.
C. sym: Complex number symbol (either i or j)
D. Angle: Radians (rad) or degrees (deg)

E. R/I: Real (real) or imaginary (imag)

A. Numerator: Allows expressing the mathematical expression or functioning individually under different columns as numerator and denominator
B. Denominator: Allows expressing the mathematical expression or functioning individually under different columns as numerator and denominator
C. sym: specifies what symbol is being used in each fraction


A. Mat: specifies and defines the matrix array in Matlab syntax
B. Mat1, Mat2: specifies two matrices so that operations such as matrix addition, subtraction and multiplication can be carried out
C. Type: highlights the operation to be carried out whether addition subtraction or multiplication
D. NaN: Means not a number and is used to ignore the data in certain columns

Appendix B: Summary of worksheets

Question

Description

 

Type of Question

 

 

 

 

 

Comments

Algebra

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01expand

Expansion of algebraic expressions

 

 

 

 

 

02factorise

Factorisation of algebraic expressions

 

 

 

 

 

03simplify

Simplification of algebraic expressions

 

 

 

 

Solutions provided are numerically simplified and not what is necessarily taught in class:
  = x(x+2)-2/(x2+x-2

And not (x-2)/(x+2) as is normally taught .

04solve

Solving algebraic expressions (no variables)

 

 

 

 

 

05solvealge

Solving algebraic expression (with variables)

 

 

 

 

 

06solvetrig

Solving trigonometric expressions

 

 

 

 

 

07val

 

 

 

 

 

 

Calculus

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01diff-alg

Partial and normal differention of algebraic expressions

 

 

 

 

 

02diff-trig

Patial and normal differention of trigonometric expressions

 

 

 

 

 

03int-alg

Integration of algebraic expressiond

 

 

 

 

Matlab Error Message for Algebra

04int-trig

Integration of algebraic trigonometric expressions

 

 

 

 

 

05series

-

 

 

 

 

Does not work, Matlab errors

06parametric

Parametric differentiation of algebraic trigonometric expressions

 

 

 

 

Multichoice works, but algebra has matlab error

07lieibniz

-

 

 

 

 

Doesnt work, matlab error

Complex Number

 

Multi-choice

 

Algebra

 

Numerical

 

 

 

01iparts

Identifing imaginary and real parts

 

 

 

 

 

02isimplify

Simplify algebraic complex equations

 

 

 

 

When running multichoice, matlab freezes

03solve

Solving of algebraic equation which have complex solutions

 

 

 

 

 

04car2pol

Cartesian to polar coordinatates

 

 

 

 

Only works for multichoice, errors for both numerical and algebra

05pol2car

Polar to cartesian coordinatates

 

 

 

 

Error in matlab script, assoiciated with worksheet

06exp2car

Exponents to cartesian coordinatates

 

 

 

 

Doesn't work on matlab

07exp2pol

Exponents to polar coordinatates

 

 

 

 

Doesn't work on matlab

08arg

Argument of complex expressions

 

 

 

 

 

09conj

Conjugate of complex expressions

 

 

 

 

Doesn't work

10mod

Modulous of a complex expression

 

 

 

 

 

Partial Fractions

 

Multi-choice

 

Algebra

 

Numerical

 

 

 

01part_fraction

Simplification using partial fractions

 

 

 

 

 

Matrices

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01operation

Matrix addition and subtraction

 

 

 

 

 

02multiplication

Matrix multiplication

 

 

 

 

 

03inverse

Inverse of a square matrix

 

 

 

 

 

04solvedetz

Determinant of a matrix

 

 

 

 

 

05Solvedety

Determinants to give the value of x for simultaneous equations

 

 

 

 

 

06solvedetx

Determinants to give the value of y for simultaneous equations

 

 

 

 

 

07determinant

Determinants to give the value of z for simultaneous equations

 

 

 

 

 

Statistics

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01sets

 

 

 

 

 

 

02probevents

 

 

 

 

 

 

03normal

 

 

 

 

 

 

04poisson

 

 

 

 

 

 

05binomial

 

 

 

 

 

 

06crv

 

 

 

 

 

 

Methods

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01reduction

reduction

 

 

 

 

 

02solvered

Trapezium method

 

 

 

 

 

03simpsons

Simpsons method

 

 

 

 

 

04 trapezium

Trapezium method

 

 

 

 

 

05rectangle

Rectangle method

 

 

 

 

 

Differential

 

 

Multi-choice

 

Algebra

 

Numerical

 

 

01dy2hom

 

 

 

 

 

 

2gsol

 

 

 

 

 

 

2ivp

 

 

 

 

 

 

2bvp

 

 

 

 

 

 

1ode

 

 

 

 

 

 


  • No labels