Difference between revisions of "Database activity settings"

Jump to: navigation, search
(Rating a database: added screenshot)
 
(44 intermediate revisions by 7 users not shown)
Line 1: Line 1:
{{Improve}}
+
{{Database}}==Adding a database activity==
  
{{Database}}==Adding a database activity==
 
[[Image:Adddatabase.png|thumb|Give your database a name and a description]]
 
 
To add a database activity:
 
To add a database activity:
# Click the "Turn editing on" button at the top right of the course homepage.
+
#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.
# Select Databases from the "Add an activity" dropdown menu.
+
# Give your new database a name and a description.
# On the Adding a new database page give your new database a name and a description.
+
# Select your options (see below).
# Select the general options (see below) and the common module settings.
 
 
# Click the "Save and display" button at the bottom of the page.  
 
# 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 fields|fields]] or use a [[Database presets|preset]].
Line 13: Line 10:
 
# Add one or two same entries then edit the templates as appropriate.
 
# Add one or two same entries then edit the templates as appropriate.
  
==General options==
+
==General==
[[Image:Databasesettings1.png|thumb||General options for the database activity]]
+
{|
 +
|[[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==
 +
(These settings are collapsed by default.)
 +
{|
 +
|[[File:databasentries25.png|Entries settings expanded]]
 +
|}
 +
 
 +
===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 for completion (old)===
 +
 
 +
In Moodle 3.3, the 'Entries required for completion' setting has been replaced by an Activity completion setting 'Require entries'. (In previous versions of Moodle, the setting had no effect on activity completion, but simply displayed a message on the view list page stating how many entries should be added to complete the activity.)
 +
 
 +
===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.
 +
 
 +
===Maximum number of entries===
 +
 
 +
Select here the maximum number of entries you wish students to make.
 +
 
 +
==Availability==
 +
(These settings are collapsed by default.)
 +
{|
 +
|[[File:databaseavailability.png|Availability settings expanded]]
 +
|}
 +
 
 
===Available from/to===
 
===Available from/to===
The dates the database is visible to students.
 
  
The database will also be open for data entry, '''provided''' we are not within the date range specified by the "read only from/to" settings.
+
Select here when you want the database to be visible to students.
  
 
===Read only from/to===
 
===Read only from/to===
The dates the database is available for viewing, but not open for data entry.
+
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" 1 January, and "available from" 1 February, students will '''not''' be able to view its content during January.
+
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.
  
===Required entries===
 
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.
 
  
===Entries required before viewing===
 
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.
+
Note that it's possible to select a precise time as well as date for these availability settings.
  
===Maximum entries===
+
===Grade to pass===
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.
+
Here you can set a passing grade for the database. This may be connected with [[Activity completion]] and [[Conditional activities]] such that a student will not be able to access a follow up activity until they have achieved the required grade in the database.
  
===Comments===
+
==RSS==
Enables commenting on entries. The comments field appears on the single view template when this is enabled.
+
(This setting is collapsed by default and only visible if RSS has been enabled on the site and for the database.)
  
===Require approval?===
+
Select the number of entries you wish to appear in the RSS feed here.
Allows you to require each entry to be approved by someone with the appropriate role before other users can view it.
 
  
===RSS articles===
+
==Grade==
Enables you to publish an RSS feed of entries in the database. The option here sets the number of entries available in the feed.
+
(This setting is collapsed by default)
 +
Choose the category in which this database will appear if ratings are enabled.
  
''Note'': RSS feeds need to be enabled by your system administrator.
+
==Ratings==
 +
(These settings are collapsed by default)
  
==Rating a database==
+
{|
[[Image:Databasesettings2.png|thumb||Rating a database]]
+
|[[File:databaseratings26.png|Ratings settings expanded]]
 +
|}
  
Lets you allow posts to be rated, which will enter a score in the gradebook for the students' submissions in the database. The grade is set using the dropdown menu below this option.
+
===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==
 
==Common module settings==
See [[Common module settings]] for more information.  Essentially you can set how different [[Groups]] in the course see or interact with each other and set an ID for grading purposes in this area.
+
 
 +
(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 [[Restrict access]] and [[Activity completion]] have been enabled in the site and the course.
 +
 
 +
Activity completion condition options are:
 +
 
 +
* Require view
 +
* Require grade
 +
* Require entries
 +
* Expect completed on
  
 
==Site administration settings==
 
==Site administration settings==
  
The database activity module has additional settings which may be changed by an administrator in ''Settings > Site administration > Plugins > Activity modules > Database''.
+
Database activity defaults and additional settings may changed by an administrator in ''Administration > Site administration > Plugins > Activity modules > Database''.
 
 
===Enabling RSS feeds===
 
  
RSS feeds must first be enabled in ''Settings > Site administration > Server > [[RSS]]''.
+
==Database activity capabilities==
  
==See also ==
+
*[[Capabilities/mod/data:approve|Approve unapproved entries]]
* [[Database permissions]]
+
*[[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]]
  
[[de:Datenbank anlegen]]
+
[[de:Datenbank konfigurieren]]
[[ru:Добавление/редактирование базы данных]]
+
[[fr:Activité base de données]]
[[fr:Créer une base de données]]
 
 
[[ja:データベースの追加/編集]]
 
[[ja:データベースの追加/編集]]
 +
[[es:Configuraciones de actividad BasedeDatos]]

Latest revision as of 13:45, 14 May 2019

Adding a database activity

To add a database activity:

  1. 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.
  2. Give your new database a name and a description.
  3. Select your options (see below).
  4. Click the "Save and display" button at the bottom of the page.
  5. Define the fields or use a preset.
  6. Define the templates.
  7. Add one or two same entries then edit the templates as appropriate.

General

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

(These settings are collapsed by default.)

Entries settings expanded

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 for completion (old)

In Moodle 3.3, the 'Entries required for completion' setting has been replaced by an Activity completion setting 'Require entries'. (In previous versions of Moodle, the setting had no effect on activity completion, but simply displayed a message on the view list page stating how many entries should be added to complete the activity.)

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.

Maximum number of entries

Select here the maximum number of entries you wish students to make.

Availability

(These settings are collapsed by default.)

Availability settings expanded

Available from/to

Select here when 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.


Note that it's possible to select a precise time as well as date for these availability settings.

Grade to pass

Here you can set a passing grade for the database. This may be connected with Activity completion and Conditional activities such that a student will not be able to access a follow up activity until they have achieved the required grade in the database.

RSS

(This setting is collapsed by default and only visible if RSS has been enabled on the site and for the database.)

Select the number of entries you wish to appear in the RSS feed here.

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)

Ratings settings expanded

Roles with permissions to rate

Database entries can be rated using a 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.

Common module settings

(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 Restrict access and Activity completion have been enabled in the site and the course.

Activity completion condition options are:

  • Require view
  • Require grade
  • Require entries
  • Expect completed on

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