Glossary

Not sure if this might help

In summary this is simple to do

• In Excel copy and paste the glossary terms into a particular spreadsheet (this is attached) then follow the spreadsheet macro instructions to create an import file
• In Moodle create an empty glossary in the appropriate course/topic and upload the file of terms created via the spreadsheet

Step 1 – Create a Spreadsheet Glossary

Within the Moodle Training Course Glossary Topic is a spreadsheet attachment called Moodle Glossary Prep Sheet

• Click on this spreadsheet to open it.
• Click on the enable macros button in the message box that appears
• Use File and save as to create your glossary as your own spreadsheet and save it in your curriculum shared area appropriately named
• Open up the document or spreadsheet that holds your glossary terms
• Copy and paste the Glossary terms and definitions into the first 2 columns of your copy of the Glossary prep sheet
  Note – at this point you may need to tidy up the glossary spreadsheet content to ensure that each row has a term and a definition.

Step 2 - Run the spreadsheet macro to create an XML file

Select

• Tools
• Macro
• Macros

Click the Run button

Ensure there is a tick in each of the 3 tick boxes (if not then click in each to put a tick in)

Click the Assign Values button to update the spreadsheet prior to exporting it.

Click the Create XML file button

In the Save as window that opens

• Browse to find the appropriate folder in your curriculum shared area
• Amend the file name to describe your glossary contents
• Click on the save button
• Close the Moodle Glossary Preparation for Import dialogue box (shown above).

The XML file is now available to import into a Glossary.

Step 3 - Create a Glossary

Go to the required Boodle course and turn editing on.

In the required topic select the Glossary activity.

Name the Glossary

Enter a description

Scroll down the screen

Initially you can leave the system defaults as they are.

Note - If you want to know more about Glossaries in detail then see the ‘Fareham College Guide to Glossaries’ in the Boodle Training course, Glossary Topic.

Scroll down

Save the glossary by clicking on
Save changes

The Glossary is then generated

Step 4 – Populate the Glossary with your XML file

To import entries click on the Import entries link

The screen below will appear.

Click on the Browse button and find the XML file that you created in step 2.

Click on the Save changes button to import the glossary terms.

A report will then be generated telling you how many entries were imported or possibly list any that were rejected and why.

Glossary entries will be rejected if they are duplicates or if they contain special characters such as the degree symbol .

Review the Import and rejection report. If necessary correct the spreadsheet entries and re run the spreadsheet macro (follow step 2).

Click the continue button at the foot of the import report and you will be returned to the glossary.

You can now either review the glossary (see the Fareham College guide to glossaries) or import more glossary entries.

It is OK to re import a similar XML file (e.g. after correct errors as duplicate entries will be rejected and only new entries (not previous imported) will be brought in.

1. if the file is a freshly exported one, (from a glossary instance)
   
2. from the moodle exchange, or (like the FPP glossary I created in 2004 and uploaded to the moodle exchange)
   
3. one I prepared using my text editor (usually SCITE, but often generated using more complex means, and yes, the template was correct)