Jordan Svien's Excel Tools

Click the Excel icon to download a code generator for creating simple Moodle compatible embedded answer (cloze) question strings and GIFT formatted import strings in Excel.

​​

• Recommended for those with limited Moodle or Excel knowledge or experience!

​​

• Includes user instructions and FAQ.

​​

• This generator was the subject of presentations given at the Moodle Moot Japan conferences in 2017, 2019, and 2023. Click the following to preview and download:

  • ​2017: Streaming Moodle's Question Creation Process with Excel (Versions 1&2).

  • 2019: Improvements to the Moodle Cloze & GIFT Code Generator (Version 3).

  • 2023: Further Improvements to the Moodle Cloze & GIFT Code Generator (Version 4).​

​

Macros are highly recommended, but macro-free functionality is available.

​

Workbook protection is set to off to allow full functionality. For formula safety, the generator sheet protection is set to on but can be disabled as desired.

​​

Last Updated: July 5, 2023 (V4.01): Fixed character limit in answer choices bug.  

Previous versions: V4.00, V3.31

Click the Moodle icon to download an Excel tool which turns Quizlet sets into custom Moodle quizzes!

​

• This tool converts a vocabulary set on Quizlet into ready-to-use Moodle quiz questions, based on your students' actual study data!

​

• The quizzes are automatically generated based on your students' real Quizlet study data (accessible with a Quizlet Teacher account), meaning you can accurately test words that are easy, medium, or difficult for your students rather than making the quiz yourself. The quiz difficulty and amount of questions are fully customizable. 

​

• No Quizlet teacher account and thus no study data? No problem - there is also an option to select and test words manually from the Quizlet set.

​​​

• Quizzes are automatically converted to Moodle's GIFT formatting for easy importing. No Excel knowledge and minimal Moodle knowledge required!

​

• This generator was the subject of a presentation at the 2018 Moodle Moot Japan Conference in Tokyo, Japan. Click here to download the 2018 proceedings paper.

​

Please note that macros must be enabled within the Excel document. Please set Excel calculations to "Manual" within Excel Options for proper quiz functionality. 

​

Last Updated: May 7, 2020.  Previous version: V1.21

Click the Quizlet icon to download a data capture tool for Quizlet term mastery data, available through a Quizlet Plus account. Quickly record a single set of mastery data, or build an entire database differentiated by class and new/review content.

​

• Excellent for teachers looking to record individual sets of Quizlet mastery data and for administrators looking to track and analyze an entire course's vocabulary list study data for revision and scaling.

​

• Includes detailed user instructions.

​

• This capture tool was the subject of a presentation given at the 2017 Hiroshima JALT Mini-Conference & Book Fair in Hiroshima, Japan. Click here to download the 2018 proceedings paper and tutorial.

​

Please note that macros must be enabled within the Excel document.

​

Last Updated: July 11, 2023 (V1.22)

Update notes: Fixed a bug that was cutting off the first Quizlet term

Previous Version: V1.21