Database activity: Difference between revisions

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?

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.

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.
-:(Technically, a single instance of the database activity module is more like a single ''data table'' than a whole ''relational database''.)
+Watch this video to see how to set up a Database activity.
-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.
+{{MediaPlayer | url = https://youtu.be/e53PNZOHTSU | desc = Setting up a Database activity}}
-[[Image:http://www.gliffy.com/pubdoc/1005015/M.jpg]]
+==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]]
-:'''''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.''
+==How does it work?==
+===Student view===
+Students click on the Database icon in the course to access it and add an entry.
-[[Category:Teacher]]
+They can usually see entries individually (View single) and in a list (List view) and are able to search entries.
-[[category:Modules]]
+===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]]
+[[Category:Database activity module]]
+[[de:Datenbank]]
+[[es:Base_de_datos_%28m%C3%B3dulo%29]]
+[[eu:Datu-basea]]
+[[fr:Base de données]]
+[[ja:データベースモジュール]]

Documentation