Database activity: Difference between revisions

Latest revision as of 14:53, 13 August 2020

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.

Overview of the Database activity

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
Create a new field from the dropdown, repeating as necessary, or click the link choose a defined set to import an existing preset.
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

@@ 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.
-Moodle's '''Database Activity Module''' is an activity which allows the teacher to define a structured format for information - a set of fields. Teachers and/or students can then contribute to the "database" and build up a collection of structured records.
+{{MediaPlayer | url = https://youtu.be/HkKUojvm6Ag | desc = Overview of the Database activity}}
+==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
+#Create a new field from the dropdown, repeating as necessary, or click the link choose a defined set to import an existing preset.
+#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.
-:(Technically, a single instance of the database activity module is more like a single ''data table'' than a whole ''relational database''.)
+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]]
-For example, one activity might ask students to contribute pictures they have created. The activity would need a "picture" field but could also have a "title" field and a "description" field. The teacher could decide to allow participants to add comments to each others' contributions, or even to rate them.
+[[Category:Database activity module]]
-[[Image:http://www.gliffy.com/pubdoc/1005015/M.jpg]]
+[[de:Datenbank]]
+[[es:Base_de_datos_%28m%C3%B3dulo%29]]
-:'''''Note:''' Please don't confuse this [[Adding resources and activities | activity type]] with Moodle's underlying database, which stores all of the information used in Moodle courses.''
+[[eu:Datu-basea]]
+[[fr:Base de données]]
-[[Category:Teacher]]
+[[ja:データベースモジュール]]
-[[category:Modules]]

Documentation