- 05 Jul 2023
- 2 minutes to read
Database activity settings
- Updated on 05 Jul 2023
- 2 minutes to read
When creating or editing a database activity you can configure the following settings.
Setting | Description | Notes |
---|---|---|
Approval required | If enabled, entries require approving by a teacher before they are viewable by everyone. | - |
Allow editing of approved entries | If disabled, approved entries are no longer editable or deletable by the user who added them. This setting has no effect unless Approval required is enabled. | - |
Allow comments on entries | Enables commenting on entries. The comments field appears on the single view template when this is enabled. | - |
Entries required for completion | The total number of entries a learner has to to enter before the database activity is complete. A reminder is displayed if the number of entries is not met. | - |
Entries required before viewing | The number of entries submitted before the learner can see entries by others. If this is not met, they will see the entry page only. | The database auto-linking filter should be disabled if entries are required before viewing, because the database auto-linking filter can't tell if a user has submitted the number of entries required. |
Maximum number of entries | The maximum number of entries the learner can submit before being blocked. This prevents people from spamming the system. | - |
Available from/to | The dates between which the database is both visible to learners and open for data entry. | - |
Read only from/to | The dates the database is available for viewing, but not open for data entry. | - |
Grade category | This setting controls the category in which this activity's grades are placed in the gradebook. | - |
Grade to pass | This setting determines the minimum grade required to pass. The value is used in activity and course completion, as well as in the gradebook, where pass grades are highlighted in green and fail grades in red. | - |
Ratings Aggregate type | The aggregate type defines how ratings are combined to form the final grade in the gradebook.
| If No ratings is selected, then the activity will not appear in the gradebook. |
Scale | Select the type of grading used for this activity. If scale is chosen, you can then choose the scale from the scale dropdown. If point is chosen, you can then enter the maximum grade available for this activity. | - |
Restrict ratings to items with dates in this range | Select the dates From and/or To that you want to restrict ratings to be entered. | - |
Tags | See the tags documentation to learn more. | - |
The Database activity course in the Totara Academy contains more resources and learning materials, including best practice and the chance to give it a go yourself.