Activities - Database - Setting up a database

Choose "Database" from the "Add an activity or resource" menu.

database general

Name - Give your database a name

Description - Give your database a description. This will display at the top of your database.

Display description on course page - If enabled, the description above will be displayed on the course page just below the link to the activity or resource.

database entries

Approval required - If enabled, entries require approving by a teacher before they are viewable by everyone.

Allow comment on entries - This allows teachers and students to comment on database entries.

Entries required for completion - The number of entries a student is required to submit before the activity can be considered complete.

Entries required before viewing - The number of entries a student is required to submit before they can view entries from other students.

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 - The maximum number of entries a student is allowed to submit for this activity.

database availability

Available from and to is when the database may have entries added to it.

Read only from and to is when the database can still be viewed but can no longer have any entries added to it (or edited).

database RSS

If you are feeding the entries of this database out using an RSS feed (either into another course or an external site), here you can determine how many entries are included in the RSS feed.

database grade and ratings

Grade category - This setting controls the category in which this activity's grades are placed in the gradebook.

Roles with permission to rate - To submit ratings users require the moodle/rating:rate capability and any module specific capabilities. Users assigned the following roles should be able to rate items. The list of roles may be amended via the permissions link in the administration block.

Aggregate type - The aggregate type defines how ratings are combined to form the final grade in the gradebook.

  • Average of ratings - The mean of all ratings
  • Count of ratings - The number of rated items becomes the final grade. Note that the total cannot exceed the maximum grade for the activity.
  • Maximum - The highest rating becomes the final grade
  • Minimum - The smallest rating becomes the final grade
  • Sum - All ratings are added together. Note that the total cannot exceed the maximum grade for the activity.

If "No ratings" is selected, then the activity will not appear in the gradebook.

Scale - If ratings are enabled, choose which scale will be used.

Restrict ratings to items with dates in this range - If enabled, only entries made between the dates specified can be rated. If entries are made outside of those times, they cannot be rated.


» Guide to Moodle