Note: You are currently viewing documentation for Moodle 3.11. Up-to-date documentation for the latest stable version of Moodle may be available here: Database activity settings.

Database activity settings: Difference between revisions

From MoodleDocs
(→‎See also: Adding MoodleBites YouTube video link)
mNo edit summary
 
(25 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{Database}}==Adding a database activity==
{{Database}}
 
This page explores in more detail the settings for the [[Database activity]] once you have added it to your course and also covers the Site administration settings.
To add a database activity:
#With the editing turned on,in the section you wish to add your database, click the "Add an activity or resource" link (or, if not present, the "Add an activity" drop down menu )and choose ''Database'' All settings may expanded by clicking the "Expand all" link top right.
# Give your new database a name and a description.
# Select your options (see below).
# Click the "Save and display" button at the bottom of the page.
# Define the [[Database fields|fields]] or use a [[Database presets|preset]].
# Define the [[Database templates|templates]].
# Add one or two same entries then edit the templates as appropriate.


==General==
==General==
{|
In the Description, provide instructions for students. Check the box if you want these instructions to display on the course page.
|[[File:database26general.png|General settings expanded by default]]
|}
 
===Name===
Choose a helpful name as this will form the link students will click on to access your database.
===Description===
Type the description of the database here. Click the icon on the left to expand the toolbar to three lines.
 
===Display description on course page===
If this box is ticked, the description will appear on the course page just below the name of the Database.


==Entries==
==Entries==
(These settings are collapsed by default.)
;Approval required?
{|
:If set to "yes", the entry will only be visible to everyone once a teacher has checked and approved it
|[[File:databasentries25.png|Entries settings expanded]]
:Entries waiting for approval can be shown as highlighted to the teacher and also to the user who added the entry (new in Moodle 3.0).
|}
:If approval required is set to "yes", the teacher can choose whether approved entries can still be edited or not.
 
:Allow comments on entries===
===Approval required?===
:If set to "yes", users will  be able to comment on database entries.
If set to "yes", the entry will only be visible once a teacher has checked and approved it.
;Entries required before viewing===
===Allow comments on entries===
:Select here how many entries you wish the student to add before they are allowed to see entries by other people. ''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.
If set to "yes", users will  be able to comment on database entries.
:Maximum number of entries===
===Entries required for completion===
:Select here the maximum number of entries you wish students to make.  
Select here how many entries you wish the student to add before the activity can be considered "complete".
===Entries required for viewing===
Select here how many entries you wish the student to add before they are allowed to see entries by other people. ''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.
===Maxiumum number of entries===
Select here the maximum number of entries you wish students to make.
 
==Availability==
==Availability==
(These settings are collapsed by default.)
As well as specifying when the database will be available for students to contribute to, the setting '''Read only from/to''' allows you to select dates you want students to be able to see entries but not add their own.
{|
==Ratings==
|[[File:datbaseavailability26.png|Availability settings expanded]]
If you enable [[Ratings]] then a Scale dropdown will appear, Grade category and Grade to pass. The Grade to pass may be connected with [[Activity completion]] and [[Restrict access]]  to prevent students accessing the next activity until they have reached the required grade in the database activity.
|}
 
===Available from/to===
Select here the dates you want the database to be visible to students.
 
===Read only from/to===
If you wish, select here the dates you want students to be able to see entries in the database but not be able to add their own.  
For example you could make a database 'available from' January 1st until March 1st, but 'read only' from January 1st to February 1st. This means students can only view entries for a month before being able to add their own.
 
The 'available from/to' settings override the 'read only from/to' settings. So if a database has 'read only' from 1st January, and "available from" 1st February, students will '''not''' be able to view its content during January.
 
==RSS==
==RSS==
(This setting is collapsed by default and only visible if RSS has been enabled on the site and for the database.)
This is disabled by default and only visible if RSS is enabled site wide.
 
==Other settings==
Select the number of entries you wish to appear in the RSS feed here.
Depending on what is enabled for your site and course, you may also need to explore [[Common  module settings]], [[Restrict access| Restrict access]], [[Activity completion]], [[Tags]] and [[Competencies]]
 
==Grade==
(This setting is collapsed by default)
Choose the category in which this database will appear if ratings are enabled.
 
==Ratings==
(These settings are collapsed by default)
 
{|
|[[File:databaseratings26.png|Ratings settings expanded]]
|}
 
===Roles with permissions to rate===
Database entries can be rated using a [[Scales|scale]]. By default, only teachers can rate database entries, though students can be given permission to do so if desired from ''Administration>Database administration''. This is a useful tool for giving students participation grades. Any ratings given are recorded in the [[Gradebook|gradebook]].


==Common module settings==
==Save and display==
 
Once you have specified the settings for your database, see [[Building Database]] for help configuring the fields.
(These settings are collapsed by default.)
 
See [[Common module settings]]
==Restrict access/Activity completion==
(These settings are collapsed by default)
 
These settings are visible if [[Conditional activities]] and [[Activity completion]] have been enabled in the site and the course.


==Site administration settings==
==Site administration settings==
Line 107: Line 51:
*[[Capabilities/mod/data:writeentry|Write entries]]
*[[Capabilities/mod/data:writeentry|Write entries]]
*[[Capabilities/mod/data:addinstance|Add a new database activity]]
*[[Capabilities/mod/data:addinstance|Add a new database activity]]
==See also==
*[http://youtu.be/sRxDg7tGyjw Moodle 2.0 Database - part 1]  MoodleBites video on YouTube
*[http://youtu.be/RRHy7vjCc7E Moodle 2.0 Database - part 2]  MoodleBites video on YouTube


[[de:Datenbank konfigurieren]]
[[de:Datenbank konfigurieren]]
[[fr:Créer une base de données]]
[[fr:Paramètres de la base de données]]
[[ja:データベースの追加/編集]]
[[ja:データベースの追加/編集]]
[[es:Configuraciones de actividad BasedeDatos]]
[[es:Configuraciones de actividad BasedeDatos]]

Latest revision as of 11:27, 28 August 2020

This page explores in more detail the settings for the Database activity once you have added it to your course and also covers the Site administration settings.

General

In the Description, provide instructions for students. Check the box if you want these instructions to display on the course page.

Entries

Approval required?
If set to "yes", the entry will only be visible to everyone once a teacher has checked and approved it
Entries waiting for approval can be shown as highlighted to the teacher and also to the user who added the entry (new in Moodle 3.0).
If approval required is set to "yes", the teacher can choose whether approved entries can still be edited or not.
Allow comments on entries===
If set to "yes", users will be able to comment on database entries.
Entries required before viewing===
Select here how many entries you wish the student to add before they are allowed to see entries by other people. 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===
Select here the maximum number of entries you wish students to make.

Availability

As well as specifying when the database will be available for students to contribute to, the setting Read only from/to allows you to select dates you want students to be able to see entries but not add their own.

Ratings

If you enable Ratings then a Scale dropdown will appear, Grade category and Grade to pass. The Grade to pass may be connected with Activity completion and Restrict access to prevent students accessing the next activity until they have reached the required grade in the database activity.

RSS

This is disabled by default and only visible if RSS is enabled site wide.

Other settings

Depending on what is enabled for your site and course, you may also need to explore Common module settings, Restrict access, Activity completion, Tags and Competencies

Save and display

Once you have specified the settings for your database, see Building Database for help configuring the fields.

Site administration settings

Database activity defaults and additional settings may changed by an administrator in Administration > Site administration > Plugins > Activity modules > Database.

Database activity capabilities