The Database activity allows students and/or instructors to populate, display, search, and comment on a bank of record entries. The format and structure of these entries is highly customizable, with the option to include images, files, URLs, numbers, check boxes, and text. The Database activity well suited for many different kinds of assignments, such as collecting and sharing information, giving students a data array to work with, and presenting content for students.

Add a Database Activity

1. On your Moodle course, click Turn editing on.

Turn editing on button

2. Click +Add an activity or resource in the section where you want to add the Database activity.

Add an activity or resource link

3. In the Add an activity or resource window, select Database. The Adding a new Database page will open.

Database activity

4. On the Adding a new Database page, enter a name in the Name filed,and provide instructions or background information for your students in the Description field (optional).

General Setting

5. Adjust the Database settings in the Entries section.

  • Approval required: If set to Yes, the entry will only be visible to everyone once the instructor has checked and approved it. 
  • Allow editing of approved entries: This option will be available if Approval required is set to Yes, which allows students who added their entries to edit or delete the approved entries.
  • Allow comments on entries: Determine if you want to allow students to comment on each other's entries entries.
  • Entries required before viewing: Determine the number of entries a student must add before they are allowed to see entries by other students.
  • Maximum number of entries: Select the maximum number of entries a student can submit.

Entries setting

6. Adjust the database Availability settings. 

  • Available from/to: The dates the database is visible to students and new entries can be added.
  • Read only from/to: The dates the database is available for viewing, but not open for data entry.

Availability setting

7. In Ratings section, determine how you will grade entries. 

Database entries can be rated using a scale. Any ratings given are recorded in the gradebook.

  • Roles with permission to rate: Identify users who have permission to rate items. This feature is not enabled until the activity is created. (Note: Once the Database activity is created, the list of roles may be changed via the permission link.)
  • Aggregate type: Choose aggregate type from the drop-down list. The options are No ratings, Average of ratings, Count of ratings, Maximum rating, Minimum rating, and Sum of ratings.
  • Scale: Sets the Scale type and maximum score for the activity.
  • Restrict ratings to items with dated in the range: Limits the time frame during which items are available for rating.

Ratings setting

8. Click Save and return to course button at the bottom of the page to return to your course main page.

Save and return to course button

Set up Entry Fields

1. On your Moodle page, click on the name of the Database activity.

2. Click the Fields tab.

Fields tab

3. From the Create a new field drop-down menu, select a field type. The types of fields possible are: Checkbox, Date, File, Latlong (latitude/longitude), Menu, Multimenu, Number, Picture, Radio button, Text area, Text input, and URL.

Create a new field option

4. Configure the data fields according to the options provided and then click Add.

5. Use the Default sort field drop-down menu to choose the order in which fields will display in the database, and then click Save.

Default sort field option

Log into Learning Spaces for more information on Adding Database Fields.

Define Database Templates

Templates for the Database activity allow you to control the visual layout of information when students are viewing, browsing, or editing database entries. To reduce setup complexity, we recommend creating all database fields before defining templates.

1. To set up your database template, click the Templates tab at the top of the page.

Templates tab

2. Click Save template button at the bottom of the page.

save template button

Log into Learning Spaces for more information on Customizing Database Template.

Update Database Templates

If you want to make changes to the template that you created, you will need to reset the templates before the field displays to students. To update your database templates, 

1. Open the Database page, and add and define new fields to use under the Fields tab.

Fields tab

2. Click Templates tab, then click the Add template tab.

click templates tab and click add template tab

3. Click Reset template button (located on the left) to update the template to include newly added fields.

Reset template button

4. Click Save template button at the bottom of the page. 

save template button

Note: You can repeat the steps above in the List template, Single template, and Advanced search template tabs. This will update the fields students see when browsing database entries, viewing one entry at a time, and searching within the database.

For details and instructions for your students on how to add entries to the database, see Add an Entry to a Database.

Export Database Entries

1. Once students have created entries, click the database activity on your Moodle page, then click the Export tab.

export tab

2. Choose the format your wish you export to: CSV or ODS

Note: The default settings of CSV text with selected delimiter are typically use with Excel and Google Sheets.

3. Select the fields you want to export. 

4. Select export options.

  • Check Include user details to include who submitted each entry.
  • Check Include time added/modified to include when each entry was made.

5. Click Export entries, then the file will download to your computer.

export options

Log into Learning Spaces for more information on Managing a Database.