Note: You are currently viewing documentation for Moodle 2.6. 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
(change image to 1.9 and add more 1.9 settings)
 
(44 intermediate revisions by 9 users not shown)
Line 1: Line 1:
{{Databases}}
{{Database}}==Adding a database activity==


Creating or editing a Database activity module is straight forward.
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.


# Turn on course editing, select Databases from the "Add an activity" pull down menu
==General==
# Set the name, description and other settings ([[Adding/editing a database#Database_settings|see below]]
{|
# Define the [[Database fields|fields]]
|[[File:database26general.png|General settings expanded by default]]
# Define the [[Database templates|templates]]
|}
# [[Viewing a database|View the lists]] and results of data entry.


*TIP: Consider using a [[Database presets]] via an import.
===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.


[[Image:Database_1.gif|center|thumb|550 px|Give your database a name and a description]]
==Entries==
(These settings are collapsed by default.)
{|
|[[File:databasentries25.png|Entries settings expanded]]
|}


[[Image:Database 2 v19.png|center|thumb|550 px||Set additional parameters]]
===Approval required?===
==Database settings==
If set to "yes", the entry will only be visible once a teacher has checked and approved it.
*Title
===Allow comments on entries===
*Description
If set to "yes", users will  be able to comment on database entries.
*Available from and to - default is disabled
===Entries required for completion===
*Viewable from and to - default is disabled
Select here how many entries you wish the student to add before the activity can be considered "complete".
*Required entries - how many entries must a student make
===Entries required for viewing===
*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 entries  
===Maxiumum number of entries===
*Comments - allow student comments
Select here the maximum number of entries you wish students to make.
*Require approval
*Allow posts to be rated?
**Grade - scale used on ratings
*Common Module settings
**Group mode
**Grouping
**Available for group members only(Advanced element)
**Visible
**ID number  


==Availability==
(These settings are collapsed by default.)
{|
|[[File:datbaseavailability26.png|Availability settings expanded]]
|}


==See also ==
===Available from/to===
* [[Database permissions]]
Select here the dates you want the database to be visible to students.


[[Category:Database]]
===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.


[[ru:Добавление/редактирование базы данных]]
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==
(This setting is collapsed by default and only visible if RSS has been enabled on the site in ''Site administration > Advanced features > Enable RSS feeds'' and for the database activity defaults in ''Site administration > Plugins > Activity modules > Manage activities > Database > Settings > Enable RSS feeds''.)
 
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)
 
{|
|[[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==
 
(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==
 
Database activity defaults and additional settings may changed by an administrator in ''Administration > Site administration > Plugins > Activity modules > Database''.
 
==Database activity capabilities==
 
*[[Capabilities/mod/data:approve|Approve unapproved entries]]
*[[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]]
 
==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]]
[[fr:Créer une base de données]]
[[fr:Créer une base de données]]
[[ja:データベースの追加/編集]]
[[ja:データベースの追加/編集]]
[[es:Configuraciones de actividad BasedeDatos]]

Latest revision as of 23:13, 17 May 2014

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 once a teacher has checked and approved it.

Allow comments on entries

If set to "yes", users will be able to comment on database entries.

Entries required for completion

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

(These settings are collapsed by default.)

Availability settings expanded

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

(This setting is collapsed by default and only visible if RSS has been enabled on the site in Site administration > Advanced features > Enable RSS feeds and for the database activity defaults in Site administration > Plugins > Activity modules > Manage activities > Database > Settings > Enable RSS feeds.)

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 Conditional activities and Activity completion have been enabled in the site and the course.

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

See also