Database

The database activity module enables students to create, maintain and search a collection of entries or records. You define the structure of the entries by a number of fields. 

Adding a Database and Settings

  1. On your course homepage, Turn editing onturn editing on
  2. Click 'Add an activity or resource' in the section of your course where you want the database to be displayed.
    Add an activity or resource

  3. Select the Database option from the activities list.
    database_add

  4. Click Add which is located at the bottom of the 'Add an activity or resource' box.
    Add

  5. If your database is intended to be a summative assessment, choose the relevant assessment from the list populated through Course Outline. Otherwise check the 'Formative or non-assessed activity' box. number 1 grey
  6. Click Proceed to settingsnumber 2 grey
    assignment_formative

  7. Database - General

    • Name the Database activity. number 1 grey
    • Provide a Description for students if needed, this can include instructions on how to use the tool. number 2 grey
    • Choose whether this description should be displayed on your course homepage by clicking the checkbox. number 3 grey
      general settings

  8. Database - Entries

    • If enabled, entries require approving by yourself or a colleague before they can be viewed by everyone. number 1 grey
    • If disabled, approved entries can no longer be edited or deleted by the student who added them. This setting has no effect unless Approval required is enabled. number 2 grey
    • The Allow comments on entries option allows students to comment on other database entries. number 3 grey
    • This option restricts students from viewing other entries until they have posted a preset number of entries themselves. number 4 grey
    • This option places a cap on the number of entries students can post. number 5 grey
      database_entries

  9. The Availability settings gives you the option to to set time frames for when the database is open, either to view or to edit:
    database_availability

  10. The RSS settings allows feeds to be added to the database and to limit how many:
    database_RSS

  11. The Grade option is only available if the database is a formative activity and if you have allocated an Aggregate type in the Ratings section. It allows you to set a minimum grade to pass.
  12. Database - Ratings

    • This option is not editable and tells you what role is able to allocate ratings.number 1 grey
    • The Aggregate type defines how ratings are combined to form the final grade in the gradebook. number 2 grey
    • The Scale of the rating is how the rating is displayed to students. If you have chosen to have ratings through the Aggregate type, you have to chose the only option available - 'Mark'. You can then enter the maximum grade available for this activity. number 3 grey
    • If this checkbox is clicked, ratings will only be applied to items within the date range that you allocate. number 4 grey
      database_ratings

  13. Other settings

    The other settings you can change on the Database page are shown below:
  14. Click either Save and return to course Save and return to course or Save and display if you want to preview the activity and begin entering the requirements. Save and display
Last modified: Tuesday, 10 December 2019, 4:29 PM