Skip to main content
UNSW Sydney Logo
Teaching
Mobile search
mobile nav menu button
  • About
  • Teaching
    • New to teaching
    • Educational design
    • Assessment and feedback
    • Evaluating education
    • More...
  • Educational Technology
    • Support
    • Training
    • TELT Administrator
  • Events & News
    • Upcoming events
    • Recent news
    • Event recordings & resources
    • Subscribe to education news
  • Awards
    • Awards
    • Fellowships
    • Gathering evidence of your teaching practice
  • Professional Development
    • Beginning to Teach (BTT)
    • Teaching Accelerator Program
    • Foundations of L&T (FULT)
    • Course Design Institute (CDI)
    • Self-paced learning
    • Academic Mentoring
    • More...
  • Contact & Support
  • About
  • Teaching
      1. New to teaching
      2. Educational design
      3. Assessment and feedback
      4. Evaluating education
      5. More...
  • Educational Technology
      1. Support
      2. Training
      3. TELT Administrator
  • Events & News
      1. Upcoming events
      2. Recent news
      3. Event recordings & resources
      4. Subscribe to education news
  • Awards
      1. Awards
      2. Fellowships
      3. Gathering evidence of your teaching practice
  • Professional Development
      1. Beginning to Teach (BTT)
      2. Teaching Accelerator Program
      3. Foundations of L&T (FULT)
      4. Course Design Institute (CDI)
      5. Self-paced learning
      6. Academic Mentoring
      7. More...
  • Contact & Support

Breadcrumb

  1. Teaching
  2. Technologies
  3. Educational Technology
  4. Moodle
  5. Build Courses in Moodle
  6. Build Your Moodle Course
  7. Adding Course Content

Create a Database in Moodle

Overview

To create a database, first create the Database activity, then define the database fields and edit the database templates to display the information in a particular way.

This page provides instructions for all these actions, as well as help with course rollover and searchability.

 

When to use

A database can be a useful way to encourage students to contribute to the class's learning. For example, with no previous experience you can build a simple database in Moodle where:

  • Students can record the details of reference works they have found useful for your course, or where
  • Supervisors can advertise the research projects that they are prepared to supervise, providing information for students making their choices about research work.
  • Supervisors can also use the Database activity to allow students to share work—such as book reviews, personal reflections, collaborative activities where content builds on previous contributions—with other students.

Benefits

Once your database is created, you and your students can:

  • Begin adding entries in the Add entry page, either individually or by uploading a .csv file (In the Settings block, select Database activity administration, then Import entries.)
  • Comment on and rate submissions, if you've enabled this
  • View individual database entries or a list, and search and sort the database.

Guide

Step by step instructions

  • Create a Database activity
  • Define the database fields
  • Databases and course rollover
  • Make your database searchable

Create a Database activity

  1. On the course home page, click Turn editing on . In the relevant section click Add an activity or resource, and in the activity chooser select Database from the pop-up list and click Add.
  2. On the Adding a new Database page, click Expand all, then in the General section enter a Name for the database and some text in the Description field explaining how the database will be used.

image-20211117114728-1

  1. Under Entries, select:
    • Whether the supervisor's Approval is required before the entry will display to other students in the database, and
    • Whether you will Allow comments on entries
    • The number of Entries required for completion per student if the activity is to be considered complete, and
    • The number of Entries required before viewing other students’ entries. If you are requiring students to make entries before viewing, contact the system administrator to have the database’s auto-linking filter disabled.
    • The Maximum number of entries any student can contribute to the database.

image-20211117114740-2

  1. If necessary, under Availability, Enable the date fields and define the periods for which the database will be Available (i.e. open to contributions) and available in Read-only form.

image-20211117114750-3

  1. Under RSS, select how many Entries in the RSS feed you want to display.
  2. Set up the Ratings system, if you want students to be able to rate entries. (You must save the activity before the Roles with permission to rate will display.) You can:
    • Tell Moodle how to decide on a final rating (Aggregate type)
    • Indicate whether to apply a Scale to the ratings
    • Restrict ratings to items with dates in the given date range.
  3. Complete the remainder of the page and click Save and display. The database's home page displays. Define the database fields using the next set of instructions on this page.

Define the database fields

  1. On the database's home page (to access this page from the course home page, click the database's link), if necessary select the Fields tab.
  2. On the Fields page, do you want to:
    • Use a predefined set of fields (a preset)? If yes, continue to the next step.
    • Create your own fields? If yes, go to step 4.

You can also, on this page, choose to import a zipped file of a preset.

  1. To use a predefined set of fields:
    • Click the choose a predefined set link.
      image-20211117114905-7
    • In the Presets page, scroll down to the Use a preset section, select the preset and click Choose.
      image-20211117114918-11
    • On the Field mappings page select the Overwrite current settings check box and click Continue
      image-20211117114928-12
    • You will be invited to Add entries and populate the database
      image-20211117115034-13

 

  1. To create your own fields:
  • From the Choose drop-down list, select the field type you want to create.
    image-20211117115050-14
  • Enter the Field name, Field description and any other required information, and click Add.
    image-20211117115059-16
  • The fields added should now be displayed in the field tab
    image-20211117115105-17

 

  1. To make it possible for you to view created entries, once you’ve defined the fields do the following:
    • Click the Templates tab.
      image-20211117115141-19
    • On the template page, click Save template.
      image-20211117115146-20
    • Click the tab for the list template type.
      image-20211117115150-21
    • On the list template page, click Save template.
      image-20211117115146-20

 

  1. You may want to edit the database templates to make the database entries display the way you want them. Do this on the Templates pages. The Moodle Docs page "Database templates" provides useful instructions, tips and further information about creating database templates.

Databases and course rollover

When you roll a course over, the database content does not come across to the new course, because the content is counted as user data, contributed by students who will not be in the course the following semester.

To move the database into the new course, you must export it from the old course and import it into the new one.

Make your database searchable

Once you and your students have built the database beyond a certain size, you'll want it to be searchable.

You can make your database searchable in two ways. First, on the View list or Search page, deselect the Advanced search check box and click Save settings. Then do one of the following two things:

  • Use the fields that now display below the list to conduct a simple search. To search, enter a Search term and either click Save settings or press Enter.
  • Select the Templates tab, then on the Templates page select the Advanced search template tab, and define the template to suit your and your students' needs.

Advanced guide

This Moodle Docs page, "Database templates", provides useful instructions, tips and further information about creating database templates.

Additional information

Further assistance

If you experience technical or other issues, consult the Where to get help page.

  • Educational Technology
    • Moodle
      • Login
      • Dashboard
      • Build Courses in Moodle
        • Orientation to Moodle
        • Request Course through myUNSW
        • Build Your Moodle Course
          • Course Design
          • Course Home Page
          • Adding Course Content
            • Activities
            • Resources
            • Add a Book
            • Upload a File
            • Using Blocks
            • Attendance
            • Create a Folder
            • Atto Text Editor
            • Text Editor
            • Blog
            • Copy Text from Word
            • IMS content package
            • Chat
            • Tables
            • Choice
            • Create a Lightbox Gallery
            • Legacy Course Files
            • Create a Label
            • Database
            • Images
            • Create a Web Page
            • Dialogue
            • Video
            • Add a URL
            • Feedback
            • Forum
            • Hide Resource or Activity
            • Glossary
            • Restrict access
            • Activity Completion
            • Group
            • Group Selection
            • Lesson
            • SCORM Package
            • Create a Questionnaire
            • Use the Moodle Calendar
            • Add test students
            • Survey activities
            • Course menu block
            • Create Wiki Activity
            • Scheduler activity
            • Create media gallery
            • Dropbox files
            • Course overview
            • Create a Checklist Activity
            • StudentQuiz
            • VoiceThread Instruction
          • Assessment Tools
          • Blackboard Collaborate Ultra
          • Personalized Learning Designer
          • Team Builder
        • Bring Content into your Teaching Instance
        • Facilitate and Deliver Course
        • Uploading grades to SIMS using Astra
      • Course Administration
      • Moodle Releases
      • Moodle Upgrade Project
      • Feature Requests
      • Contacts
      • Index of all support pages
    • Lecture Recording+
    • Turnitin
    • theBox
    • Other eLearning Tools
    • Feature Requests
    • Book a Consultation
    • Digital Media Support & Equipment
    • Immersive Technologies
    • TELT Service Status
    • Known System Issues
    • System Maintenance Windows

Events & news

ChatGPT & AI in our teaching
CEP Lightning Workshops T1 2023
More
Back to top
  • Print
  • Share
    • Facebook
    • Twitter
    • Google
    • Email
  • Home
  • About
  • Educational Technology
  • Events & news
  • Awards
  • Contacts

Authorised by Pro Vice-Chancellor Education
UNSW CRICOS Provider Code: 00098G, TEQSA Provider ID: PRV12055, ABN: 57 195 873 179
Teaching at UNSW, Sydney NSW 2052, Australia Telephone 9385 5989

Footer menu

  • Privacy Policy
  • Copyright & Disclaimer
  • Accessibility
  • Report an incident
  • Complaints
  • Site Map
  • Site Feedback
Page last updated: Friday 17 December 2021