Interested In Using The Database Activity For Moodle?

--- Advertisement ---

Connected 2023
Connected Conference OpenLMS

A Database activity is a collection of structured information that chosen users can update. Each row of information is an “entry” or “record”, and each cell value is a field. The name of the field is on the top of its column. Depending on the type of information of the field, you can choose the type of input allowed.

As with most Moodle activities, the limit is your imagination. Data collection tends to be an important part of most professions. Those that involve research or evidence to make decisions will enjoy neat data. Students contributing to a robust dataset will make it easier to achieve statistical samples. A little statistics will be the icing on your class’s crowd-sourced field research activity!

A Database can have many visual customization options. The activity includes several templates.

This is a walkthrough on setting up a Database. It stems from a Moodlerooms video.

  1. On your course page, click on turn editing on. Some adding icons (plus signs) and other options will appear.
  2. On the topic of your choice, click on “Add an activity or resource”. A pop-up list of activities will appear.
  3. Select “Database” and click “Add”. This will take you to a database configuration form. Fill it out. This process is fairly straightforward.
  4. In “Entries”, you can set proofreading options. You can verify entries before they go into the database. Or allow yourself to edit permissions for data that already went in. Other notable options is the minimum (entries required) and maximum number of entries. How many entries are a significant sample in your assignment?
  5. Other options include availability schedules for the database, and grading for the additions. When you complete the database setup, click on “Save and display”. Clicking will take you to the database fields page, which will be empty.
  6. Select a type of entry on “Create a new field”. Each field needs a name, a type, a description, and whether it can be empty or not (required). Click on “Add” when you are done. Repeat for all the columns on your database.
  7. On the “Add entry” tab you can add the first entry. This is the form your students will see when they are adding their entries. To customize the look on this form, click on “Templates”.

This is it! Now you have a working database for all your data collection needs. The Database is a powerful activity with many more features than what I mentioned.

For more on Database, check out its Moodle page here.

Course Merchant

This Moodle Practice related post is made possible by: Course Merchant, the Moodle shopping cart for selling courses. Click here to learn more.


Know any cool applications of Moodle Database? Share it with us below, or on social media!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Dive Deeper On

The Latest

The eLearn Podcast

Connected Conference OpenLMS

--- Advertisement ---

Post Pages - Sidebar 4 - CourseMerchant

--- Advertisement ---

Post Pages - Sidebar 7 - Titus Learning

--- Advertisement ---

Post Pages - Sidebar 5 - Edwiser (RemUI)

Subscribe to our newsletter

Education technology has the power to change lives. 

To get the latest news, information and resources about online learning from around the world by clicking on the button below.