KCC > Information Services > Employee Support > Web Applications > Moodle Support


The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.

Here are some ideas for the database module to:

  • allow collaboration on building a collection of web links/books/journal references related to a particular subject

  • display student created photos/posters/websites/poems for peer comment and review

  • gather comments and votes on a shortlist of potential logos/mascot names/project ideas

  • provide a student file storage area

  • maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves

Step 1 Editing

Login to course and Turn editing on, located in the Course administration.

Turn editing on

Step 2 Add

Click on the “Add an activity or resource” Add an activity or resource, there is a pop-up window that will have all the activities and resources listed.

Add an activity or Resource clickable link

Step 3 Name

The name that is typed here will form a link for the students to click on to enter the Database, Introduction Text – should be the directions for the activity.

Name and instructions for the Database

Step 4 Entries

Approval required?

If set to "yes", the entry will only be visible once a teacher has checked and approved it.

Allow comments on entries

If set to "yes", users will be able to comment on database entries.

Entries required for completion

Select here how many entries you wish the student to add before the activity can be considered "complete".

Entries required for viewing

Select here how many entries you wish the student to add before they are allowed to see entries by other people. Note: If entries are required before viewing, the database auto-linking filter should be disabled. This is because the database auto-linking filter can't determine whether a user has submitted the required number of entries.

Maximum number of entries

Select here the maximum number of entries you wish students to make.

Entries image

Step 5 Availability

The 'available from/to' settings override the 'read only from/to' settings. So if a database has 'read only' from 1st January, and "available from" 1st February, students will not be able to view its content during January

Available from/to

Select here the dates you want the database to be visible to students.

Read only from/to

If you wish, select here the dates you want students to be able to see entries in the database but not be able to add their own. For example you could make a database 'available from' January 1st until March 1st, but 'read only' from January 1st to February 1st. This means students can only view entries for a month before being able to add their own.

Availability image


Step 6 Grade

This setting controls the category in which this activity’s grades are placed in the Gradebook.

Grade Category

Step 7 Ratings

No Ratings (default)

No option for grading this database.

Average of ratings

This is the mean of all the ratings given to posts in that database. It is especially useful with peer grading when there are a lot of ratings being made.

Count of ratings

The counts the number of rated posts which becomes the final grade. This is useful when the number of posts is important. Note that the total can not exceed the maximum grade allowed for the forum. A count may be used if the teacher simply wants to acknowledge that a reply was given in the case students being required to make a certain number of posts in the discussion. Note: Count of ratings does not work for the “Separate or Connected Ways of Knowing” scale or custom scales due to the limitation imposed by the max grade.

Maximum rating

The highest rating is returned as the final grade. This method is useful for emphasizing the best work from participants, allowing them to post one high-quality post as well as a number of more casual responses to others.

Minimum rating

The smallest rating is returned as the final grade. This method promotes a culture of high quality for all posts.

Sum of ratings

All the ratings for a particular user are added together. Note that the total is not allowed to exceed the maximum grade for the forum.


Sum of ratings does not work for the “Separate or Connected Ways of Knowing” scale or custom scales due to the limitation imposed by the max grade.

Ratings image

Step 8 Common Module Settings

Group settings, Group Mode – When course group mode is turned on, the group mode can be one of three levels: No groups, Separate groups or Visible groups.

Common Module settings

Step 9 Restrict Access

Restrict access settings – The restrict access section asks for the conditions when the activity (or resource) should be visible. This can be based upon dates, and/or score ranges of other activities and/or if other activities are considered completed. Note that ALL access restrictions (date, grade condition, activity completion condition) have to be met in order for the activity to be made available. 

Restrict access setting image

Step 10 Save

Save or Cancel

Save and return to course-Allows to save and go back to main Moodle page.

Save and display button image- Allows to save and display new page/activity. Best Option to choose. Allows you to finish the set up for the Attendance

Cancel button image- will not save any changes, and send back to main Moodle page.


Follow on Facebook Follow on Twitter Subscribe on Youtube