Database activity: Difference between revisions

From MoodleDocs
No edit summary
(updated videos for 4.3)
 
(79 intermediate revisions by 23 users not shown)
Line 1: Line 1:
{{Databases}}
{{Activities}}
{{Moodle 1.6}}
__NOTOC__
==What is the Database activity?==
The Database activity allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.  


The '''Database module''' allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things. You may be familiar with similar technology from building Microsoft Access or Filemaker databases.


* The first task is to [[Adding/editing_a_database|add the database]]. You will be asked to give it a name, provide some text explaining its intended purpose to users and set a few other options.
Watch this video to see how to set up a Database activity.
* Next you define the kind of [[Fields]] that define the information you wish to collect. For example a database of famous paintings may have a [[picture field]] called ''painting'', for uploading an image file showing the painting, and two [[text fields]] called ''artist'' and ''title'' for the name of the artist and the painting.
* It is then optional to edit the [[Templates|database templates]] to alter the way in which the database displays entries.
* Note that if you later edit the fields in the databases you must use the [[Reset template button]], or manually edit the template, to ensure the new fields are added to the display
* Finally the [[Teacher]] and/or [[Students]] can start entering data and (optionally) commenting on and grading other submissions. These entries can be [[viewed alone]], [[viewed as a list]] or [[searched and sorted]].


{{MediaPlayer | url = https://youtu.be/e53PNZOHTSU | desc = Setting up a Database activity}}


:'''''Note:''' Please don't confuse this [[Adding resources and activities | activity type]] with Moodle's underlying SQL database, which stores all of the information used in Moodle courses and is only of interest to Moodle [[Administrators]].''
==How is it set up?==
#In a course, with the editing turned on, choose 'Database' from the activity chooser.
#Give it a name and, if needed, a description.
#Expand the other sections to define the settings you want, in particular the Entries section.
#Click Save and Display
#From the next page, click to either create new fields, import a preset or use a preset.
#Once your fields are set up, click the Templates tab to edit and save templates. For more help, see [[Database templates]]


==How does it work?==
===Student view===
Students click on the Database icon in the course to access it and add an entry.


== See also ==
They can usually see entries individually (View single) and in a list (List view) and are able to search entries.
===Teacher view===
Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.
==More information==
* [[Database activity settings|Database settings]]
* [[Building Database]]
* [[Database templates]]
* [[Using Database]]
* [[Database activity FAQ]]


* [[Glossary module]], which performs a similar though more specialised, text-based role and is available for previous versions of Moodle.
[[Category:Database activity module]]


[[Category:Teacher]]
[[de:Datenbank]]
[[category:Modules]]
[[es:Base_de_datos_%28m%C3%B3dulo%29]]
[[eu:Datu-basea]]
[[fr:Base de données]]
[[ja:データベースモジュール]]

Latest revision as of 12:36, 29 November 2023


What is the Database activity?

The Database activity allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.


Watch this video to see how to set up a Database activity.

Setting up a Database activity

How is it set up?

  1. In a course, with the editing turned on, choose 'Database' from the activity chooser.
  2. Give it a name and, if needed, a description.
  3. Expand the other sections to define the settings you want, in particular the Entries section.
  4. Click Save and Display
  5. From the next page, click to either create new fields, import a preset or use a preset.
  6. Once your fields are set up, click the Templates tab to edit and save templates. For more help, see Database templates

How does it work?

Student view

Students click on the Database icon in the course to access it and add an entry.

They can usually see entries individually (View single) and in a list (List view) and are able to search entries.

Teacher view

Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.

More information