Databases (Moodle activity)

The database activity allows you and your students to develop and search a bank of records entries.

Suggestions on how to use this tool

  • Collate and share observations from field study
  • Create and comment on a shared collection of artefacts
  • Create and comment on lab results throughout semester
  • Create a list of key concepts and use comments for students to submit real life examples

Create a database

  1. In the topic section where you want to add a database activity, click on Add an activity or resource.
  2. Select Database and click Add.
  3. In the General section:
    1. Give your database activity a Name and Description. You can use the Description field to alert students to important information about the database activity or direct them to technical assistance.
    2. In the Availability section you can set Available from and Available to and / or Read only from and Read only to date fields to restrict student access to the database activity. Click on the Enable checkbox next to each field to set each date.
  4. Select other database setting options as required.
  5. Once complete, click Save and return to unit.

    Note: Beside each field, you can click on the help icon for a description of each option provided.

Database Fields

A field is a unit of information for your database activity.  The database can have just one field or multiple fields of varying types, depending on the kind of information you wish to collect.  An example of a field is a field called Monash University Australia Campus where the options are Berwick, Caulfield, Clayton, Gippsland, Parkville and Peninsula.

  1. Ensure editing is on.
  2. Next on database you want to edit.
  3. Select the Fields tab.

Database Templates

Once you have added all required fields for your database activity, you can change the visual layout of the database activity for each of the database views, whether it is in list, single, search or add form. You change the layout of each view by amending the respective database template.

  1. Select the Templates tab.
  2. For example, click the List Template, if you wish to amend the List Template.

  3. Enter a header and footer for the database's View list page.
  4. In the Repeated entry textbox use the editor to change the presentation layout.

    Note: In some cases, you may need to highlight to select the text before pressing the button; you may also add text and/or amend the table. You may also change the order of the fields, remove and or add from the Available tags field by double clicking on the tag.

  5. Click on Save template.

    Note: Click on Reset template to restore the template back to its default presentation layout.

View the database

You can view the database in lists or single entries with the View list or View single tab

Search

  1. Select the Search tab.
  2. Set your search criteria using the drop down menus and free text fields.

  3. Click on Save settings.

    Note: For Advanced search options, select the Advanced search checkbox. This will enable you to search additional fields.

Add database entry

  1. Select the Add entry tab.
  2. Create your new database entry.
  3. Click on Save and view.

Export database entries

  1. Select the Export tab.
  2. In the Choose the format you wish to export to section, choose your preferred exported file format.
  3. Choose the fields you wish to export by selecting the checkboxes next to the fields available.
  4. Click on Export entries.
  5. Click OK to save the file.