How to set up a database for image collection
To add a ‘database’ activity to your Moodle course, please follow the steps below:
- Sign in to your Moodle account and select the course where you would like to add a ‘Database’ activity.
- Click on the ‘Edit mode’ button and then select a section where you would like it to be located.
![Edit Mode - Moodle Screenshot](https://digi-ed.uk/dev-support/wp-content/uploads/2022/05/Edit-Mode.png)
- Click on the ‘Add an activity or resource’ button and then choose ‘Database’ from the popping-up window.
![Add an activity or resource - Moodle Screenshot](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Add-an-activity-or-resource.png)
![Screenshot of selecting the ‘Database’ activity (highlighted) in the activity picker of a DLE course.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Add-an-activity-or-resource_database.png)
- A new page will be shown where you can customise the settings of this particular activity.
How to set up a Database activity to your Moodle course
In terms of the setup of a Moodle ‘Database’ activity, please follow the steps below.
General
In the ‘General’ section, you can give a useful name and description to the activity. You can also choose whether you would like the description to be shown on the course page or not.
![Screenshot of the display of the settings (highlighted) under the ‘General’ section (highlighted) of a ‘Database’ tool in a DLE course.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/General_database-1.png)
Entries
In the entries section you can select whether approval is required, comments allowed on entries, that students are required submit entries before viewing rights and the maximum number of entries allowed. We recommend leaving all of the settings as default.
![Screenshot of the Entries of a 'Database' activity, including Approval, comments, entries required before viewing and maximum number of entries.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Entries.png)
Availability
Select availability if you want your database to be available for a limited time.
![Screenshot of the Availability of a 'Database' activity, including dates and time.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Availability_database.png)
Ratings
It is possible to rate database records within Moodle. These ratings are then aggregated to produce a grade for that activity for the student being rated. For example a student’s image posts may be rated by their fellow students with those ratings being averaged and that grade then contributing to the students overall course grade. You can choose whether ratings can be submitted by students and/or by teachers. Recommendations are to leave as default.
![Screenshot of the Rating section of a 'Database' activity.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Ratings.png)
Common Module Settings
In the ‘Common module settings’ section, you can decide whether you would like the activity to be shown or hidden from the students.
The ‘Link to UNIT-e’ setting refers to transferring the released grades to the student record system, therefore, this option should be left off as default as ‘Databases’ are not used for summative assessments.
By default, Moodle detects a user’s language from their browser setting. The ‘Force language’ can be used if you want to force a language instead.
The ‘Group mode’ can be useful for you if you would like to allocate the students to different groups, so you can send out group notifications.
![Screenshot of the listed option (‘Common Module Settings’) (highlighted) of a ‘Database’ activity in the DLE.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Choice_common-module-settings.png)
Restrict access
In the ‘Restrict Access’ section, you can add restrictions in terms of accessing the activity as a student which can be based on date, grade, group, grouping, or user profile, however, we recommend leaving this option on default.
![Screenshot of the listed option (‘Access restrictions’) (highlighted) of a ‘Database’ activity under the ‘Restrict access’ section (highlighted) in the DLE.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Restrict-Access_highlighted.png)
Click Save and display return to course
Start building the Image Collection
When opening up the Database Activity you can now set up the fields required for the image collection. You will be greeted with the following screen.
![Screenshot of the database activity](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/database-1024x443.png)
- In lower area, click on ‘Use a preset’ to get started.
![Screenshot of the database activity, 'Use a preset' highlighted](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/database_preset-1024x443.png)
- Then select ‘Image gallery’ from the preset choices and click ‘Use this preset’ in the bottom right hand corner.
![Screenshot of database presets, 'Image gallery' highlighted.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/presetchoices-2-1024x589.png)
- This will creates an image database with 3 fields: ‘image’, ‘title’ and ‘description’ and the default sort field.
![Screenshot of 'Managed fields' including image, title and description highlighted.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Manage-fields-1024x453.png)
Students: ‘how to add images’ to Collection
- Click on the Image Database activity
![Image database active image.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Image-database-activity.png)
To add image: Click on ‘Add entry’
![Screenshot database, 'Add entry' highlighted.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/Add-entry-1-1024x195.png)
- Provide a title and a description, alternative text will help those using a screen reader to view your image.
- You can either click on the image box to upload images or drag and drop images to the box itself.
- If on mobile, you will have to click the ‘add file’ icon and find/select image from your phones image gallery.
- Click ‘Save’ or ‘Save and add another’ if you have more images to add.
![Screenshot of 'New entry' when uploading an image into the database.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/student-entry-1024x827.png)
- To see all images, click on View List and choose how to filter images
- To view one image. click on view single and navigate through images as required.
![Screenshot of the image database. Include three pictures of horses and the viewing settings highlighted.](https://digi-ed.uk/dev-support/wp-content/uploads/2023/06/viewdatabase-1024x657.png)