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
mNo edit summary
 
(64 intermediate revisions by 11 users not shown)
Line 1: Line 1:
{{Databases}}
{{Database}}
==Adding a database activity==
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.
[[Image:Database_1.gif|thumb|Give your database a name and a description]]
To add a database activity:
# Click the "Turn editing on" button at the top right of the course homepage.
# Select Databases from the "Add an activity" dropdown menu.
# On the Adding a new database page give your new database a name and a description.
# Select the general options (see below) and the common module settings.
# 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 options==
==General==
[[Image:Database 2 v19.png|thumb||General options for the database activity]]
In the Description, provide instructions for students. Check the box if you want these instructions to display on the course page.
===Available from/to===
The dates the database is both visible to students and open for data entry.


===Viewable from/to===
==Entries==
The dates the database is available for viewing, but not open for data entry.
;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| Restrict access]],  [[Activity completion]], [[Tags]] and [[Competencies]]


===Required entries===
==Save and display==
The number of entries each student is required to enter before the database activity can be considered complete. The student will see a reminder message if s/he has not submitted the required number of entries.
Once you have specified the settings for your database, see [[Building Database]] for help configuring the fields.


===Entries required before viewing===
==Site administration settings==
The number of entries the student needs to submit before s/he can see entries by other students. If the student has not submitted the required number of entries, s/he will only see the entry page and not the list or single view pages.


''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.
Database activity defaults and additional settings may changed by an administrator in ''Administration > Site administration > Plugins > Activity modules > Database''.


===Maximum entries===
==Database activity capabilities==
The maximum number of entries the student can submit before s/he is blocked. This prevents people from spamming the system, either in the hope that one entry is good enough or, on a public site, as a way of advertising.


===Comments===
*[[Capabilities/mod/data:approve|Approve unapproved entries]]
Enables commenting on entries. The comments field appears on the single view template when this is enabled.
*[[Capabilities/mod/data:comment|Write comments]]
*[[Capabilities/mod/data:exportallentries|Export all database entries]]
*[[Capabilities/mod/data:exportentry|Export a database entry]]
*[[Capabilities/mod/data:exportownentry|Export own database entry]]
*[[Capabilities/mod/data:managecomments|Manage database activity comments]]
*[[Capabilities/mod/data:manageentries|Manage database activity entries]]
*[[Capabilities/mod/data:managetemplates|Manage templates]]
*[[Capabilities/mod/data:manageuserpresets|Manage all template presets]]
*[[Capabilities/mod/data:rate|Rate entries]]
*[[Capabilities/mod/data:viewallratings|View all raw ratings given by individuals]]
*[[Capabilities/mod/data:viewalluserpresets|View presets from all users]]
*[[Capabilities/mod/data:viewanyrating|View total ratings that anyone received]]
*[[Capabilities/mod/data:viewentry|View entries]]
*[[Capabilities/mod/data:viewrating|View the total rating you received]]
*[[Capabilities/mod/data:writeentry|Write entries]]
*[[Capabilities/mod/data:addinstance|Add a new database activity]]


===Require approval?===
[[de:Datenbank konfigurieren]]
Allows you to require each entry to be approved by someone with the appropriate role before other users can view it.
[[fr:Paramètres de la base de données]]
 
===RSS articles===
Enables you to publish an RSS feed of entries in the database. The option here sets the number of entries available in the feed.
 
''Note'': RSS feeds need to be enabled by your system administrator.
 
===Allow posts to be rated?===
Lets you allow posts to be rated, which will enter a score in the gradebook for the student’s submissions in the database. The grade is set using the dropdown menu below this option.
 
==See also ==
* [[Database permissions]]
 
[[Category:Database]]
 
[[de:Datenbank anlegen]]
[[ru:Добавление/редактирование базы данных]]
[[fr:Créer une base de données]]
[[ja:データベースの追加/編集]]
[[ja:データベースの追加/編集]]
[[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