Difference between revisions of "Database activity"

Jump to: navigation, search
m
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Activities}}{{Improve}}
+
{{Activities}}
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.  
+
__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.  
 +
 
 +
{{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]]
 
* [[Database activity settings|Database settings]]
 
* [[Building Database]]
 
* [[Building Database]]
 +
* [[Database templates]]
 
* [[Using Database]]
 
* [[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]]
 
[[de:Datenbank]]
Line 15: Line 32:
 
[[eu:Datu-basea]]
 
[[eu:Datu-basea]]
 
[[fr:Base de données]]
 
[[fr:Base de données]]
[[cs:Modul Databáze]]
 
 
[[ja:データベースモジュール]]
 
[[ja:データベースモジュール]]
[[ru: База_данных]]
 

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?

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