Build, display, and search a bank of entries about any topic with your students.
Create a database and set up fields to add entries.
The format and structure of the entries is almost unlimited. Entries can include images, files, URLs, numbers, text, and more.
A database creates one table per instance, but you may create as many instances you need. The entries can be linked to other tables and all resources in the course, if you allow auto-link in a name field.
Create a database
Steps in Snap: Create learning activity or resource > Database > Add
Steps in other themes: Turn editing on > Add an activity or resource > Database > Add
- Type a meaningful name and description. The description displays to students when they view the database. Check the Display description on course page box if you want the description to show there.
Optionally, make selections in the following areas to customize the certificate.
- Common Module Settings
- Restrict Access
- Activity completion
Click Save and display to show the new database and add fields.
After you create the database, you will see several tabs:
- View List or View Single: Click these tabs to see entries.
- Search: Allows you to search for a specific entry.
- Add Entry: Insert data into the database.
More on adding entries and viewing lists on the Moodle website (may be available in English only)
- Export: Allows you to export the entries.
- Templates: Templates control the visual layout of information when listing, viewing, or editing database entries. It is a similar to the technique used to mail merge letters in word processors such as Open Office Writer or Microsoft Word.
More on templates on the Moodle website (may be available in English only)
- Fields: After you have created a database and saved its settings, you need to designate fields that will be part of your database.
- Presets: Determine any presets for the database information.
Add database fields
A field is a named unit of information that can be displayed in different formats. The field definitions create the basic structure of the database and determine what kind of information students can enter into your database.
- Select the Fields tab.
- Use the Create a new field drop-down menu to select a field to create.
- Checkbox: Select options from a set and mark them in a check box.
- Date: Type a date by selecting day, month, and year from a drop-down list.
- File: Upload a file of any type from a computer. Tip: Use the Pictures field for images.
- Latlong: Specify a geographic location by specifying the location's latitude and longitude. Links are automatically generated to geographic data services such as Google Maps, Google Earth, or Multimap.
- Menu: Select an option from a drop-down menu. Type each option on a different line in the options text field.
- Multimenu: To select multiple options from a drop-down menu (by holding down the Control or Shift).
- Number: Type a number (positive, negative, or zero).
- Picture: Upload an image file from a computer.
- Radio button: Select just one option from a list.
- Text input: Type text up to 60 characters in length.
- Text area: Type text longer than 60 characters in length and/or include HTML formatting.
- URL: Type a web address. Selecting Autolink the URL makes the URL a clickable link. Typing a forced name for the link means that the name will be used for the hyperlink.
- Complete the required fields for the selected field.
- Select Save and view.
Add entries to fields
After the fields have been added, you and your students can add the information for the fields.
- Select the Add Entry tab.
- Fill in the information as required by the type of field.
- Select Save and view.
Edit a database
Steps in Snap: Database > Edit
Steps in other themes: Turn editing on > Database > Edit > Edit Settings
To edit a database, go to the database and select Edit.
If you accidentally delete the activity, you can restore it from the recycle bin.
Set database entry requirements
Steps in Snap: Database > Edit > Entries
Steps in other themes: Turn editing on > Database > Edit > Edit Settings > Entries
You can determine whether or not to entries to the database will require approvals. You can also determine the maximum number or entries allowed.
- Approval required: Determine whether or not the database entries require instructor approval before being available to other students.
- Allow editing of approved entries: Determine whether or not students can edit an entry after receiving approval.
- Allow comments on entries: Determine whether or not students can make comments on database entries.
- Entries required for completion: Select the number of entries a student must make before the activity is considered complete.
- Entries required before viewing: Select the number of entries a student must make before being able to view entries from another student.
- Maximum number of entries: Select the maximum number of entries a student must make before submitting the database to the instructor.
Set the availability of the database
Steps in Snap: Database > Edit > Availability
Steps in other themes: Turn editing on > Database> Edit > Edit Settings > Availability
You can determine when databases will be available to participants to update and to read.
- Available from / Available to: If selected, set the date and time when the database will be opened for participants to edit and when it will no longer be available.
- Read only from / Read only to: If selected, set the date and time when the database will be available to read.
Set the ratings for the database entries
Steps in Snap: Database > Edit > Ratings
Steps in other themes: Turn editing on > Database> Edit > Edit Settings > Ratings
You can who can rate the entries for the database grading.
- Roles with permissions to rate: Lists the roles that can rate the entries.
- Aggregate type: Select one of the following from the Type menu.
- No ratings - This activity will not be graded.
- Average of ratings - The mean of all ratings.
- Count of ratings - The number of rated items becomes the final grade. Note that the total cannot exceed the maximum grade for the activity.
- Maximum - The highest rating becomes the final grade.
- Minimum - The smallest rating becomes the final grade.
- Sum - All ratings are added together. Note that the total cannot exceed the maximum grade for the activity.
- Restrict rating to items with dates in this rate From/To: If selected, set the date and time of the database items to be rated.
Check out how Grading works!
Determine database completion
Steps in Snap: Database > Edit > Activity completion
Steps in other themes: Turn editing on > Database > Edit > Edit Settings > Activity completion
You can determine to mark the database activity as completed.
- Completion tracking: Options include Do not indicate activity completion, Students can manually mark the activity as completed, and Show activity as complete when conditions are met.
- Student must view this activity to complete it: When the Completion tracking is set to Show activity as complete when conditions are met, this option will be available. Determine if the activity will be marked as complete after the student views the database.
- Student must receive a grade to complete the activity: When the Completion tracking is set to Show activity as complete when conditions are met, this option will be available. Determine if the activity will be marked as complete after the student receives a grade.
- Expect completed on: Enable this feature and set a date for when it is expected participants will be marked as completed.