Page History

...

This refers to Moodle 3.10 11 from August 2021 2022 onwards

How to: create a database activity

...

1. Login to your module and click on the'Turn editing on button (top right). 
2. In the relevant section, click on the + Add an activity or resource hyperlink 
3. A window will open. Click on the word 'Database' and you will be taken directly to the 'Adding a new database' screen.

3. In General Settings, add the "Name" of the database (which will display on the main module page) and "Description", e.g., to include specific directions on how students might contribute if they are expected to.

...

4. (Optional) If you want to add a restriction, click on 'Add restriction' within the "Restrict Access" section. This will open a window, select the restriction you want to add or click on 'Cancel'.

5. Click on the 'Save and display' button to see the database and start setting it up as below  (or 'Save and return to module' to to go to module front page or 'Cancel'page)

6. Click on the 'Turn editing off' button  on your main Moodle page

...

• Entries - Set teacher approval for database entries to be viewable, allow comments, maximum entries, set entries required for completion of the activity or before students can view the entries of others.
• Availability - Similar to restrict access
• RSS - Add entries to RSS feed
• Grade - Controls the category in which this activity's grades are placed in the gradebook.
• Ratings - Allow users to rate items

...

Click Save templatefor each (normally  normally List Template, Single Template and Add Template are the only ones needed)

...

It's usually a good idea at this stage to add your first entry or a test entry. You will need to go to the Add Entry tab of your database to do this.

You can import multiple entries via a CSV file if you click the "Import entries" link in the Database activity administration block. The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries.

...

1. Click on the 'Cogwheel' within your database and select 'Import entries'.

2. Find your file to upload and click on 'Submit'.

3. It will then confirm that your entries have been imported. Click 'Continue'.

Further reading

Online collaboration with Moodle Databases and Wikis is a useful Xerte toolkit that will help you use both Wikis and Databases more effectively for student collaboration.

See also