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: @@
-{{Activities}}{{Improve}}
+{{Activities}}
+__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 activity 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.
+{{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.
+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]
+* [[Database activity FAQ]]
-This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.
-The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).
+[[Category:Database activity module]]
 [[de:Datenbank]]
@@ Line 16: / Line 32: @@
 [[eu:Datu-basea]]
 [[fr:Base de données]]
-[[cs:Modul Databáze]]
 [[ja:データベースモジュール]]
-[[ru: База_данных]]

Documentation