MyUCDavis Glossary Export
The export of glossary terms from MyUCDavis is being treated as a separate export since it is a separate feature within Website Builder (WB.)
Glossary Authoring
Instructors access the Glossary feature for a course site via the Website Builder sub-menu.
When Glossary is selected, the glossary and authoring functions are displayed in the left frame and the Glossary Introduction screen is displayed on the right frame.
Glossary functions include:
- Glossary is Active - the ability to activate or deactivate (make inaccessible to students)
- Exit Glossary Editor - returns user to Website Builder default screen
- Create New Glossary Term - enter a new term into the glossary
- Copy Glossary Term - allows the user to copy some or all glossary terms from another term and/or course
- Upload Glossary File - upload a tab-delimited Excel file containing term, definition, and category columns
Faculty can add or edit glossary terms using the Create New Glossary Term feature or by selecting the term; both actions bring up the glossary edit screen as shown here:
Glossary Term Editor
Faculty can also copy some or all glossary terms entered in another course offering into the current course offering using the Copy Glossary Term function.
Copy Glossary Term
Finally, the Upload Glossary File feature allow faculty to upload terms into the glossary as long as the upload is an Excel file and saved as Text (Tab Delimited) and each row of the spreadsheet consists of 3 columns: Term, Category, and Definition respectively.
Upload Glossary File
Glossary feature has no equivalent in Sakai/SmartSite at this time.
Database Table
In the course management system, the database table for glossary data contains the following fields:
glossary_id
glossary_term
glossary_definition
category
date_modified
hidden
associate_to_term
term_code
crn
The first five field describe glossary data - the glossary_id and date_modified fields are automatically populated, the glossary_term and glossary_definition fields are required, and category and hidden are optional fields. A category allows terms to be grouped for display. Hidden allows the instructor to work on terms before choosing to display them.
The associate_to_term is an optional field that is populated when a faculty user chooses to associate one glossary term with another, for example, to include plural form, past tense, or future tense of the term. This associated term does not seem to appear on the glossary list.
The glossary is associated with the course offering in which the faculty user accesses the Glossary tool, so the term_code and crn are automatically generated.