Difference between revisions of "Database activity"

Jump to: navigation, search
m (See also)
m
 
(65 intermediate revisions by 22 users not shown)
Line 1: Line 1:
{{Databases}}
+
{{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.  
{{Moodle 1.6}}
 
  
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.
+
{{MediaPlayer | url = https://youtu.be/HkKUojvm6Ag | desc = Overview of the Database activity}}
  
== How to use the database module ==
+
* [[Database activity settings|Database settings]]
* 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.
+
* [[Building Database]]
* 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.
+
* [[Database templates]]
* It is then optional to edit the [[Templates|database templates]] to alter the way in which the database displays entries.
+
* [[Using Database]]
* 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
+
* [[Database activity FAQ]]
* 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]].
 
  
== Example databases ==
+
[[Category:Database activity module]]
  
Moodle.org has three good examples of the database module in action:
+
[[de:Datenbank]]
 
+
[[es:Base_de_datos_%28m%C3%B3dulo%29]]
* [http://moodle.org/mod/data/view.php?id=6140 Moodle Buzz], a database of the titles, authors and web links to news articles mentioning Moodle
+
[[eu:Datu-basea]]
* [http://moodle.org/mod/data/view.php?d=26 Themes], a database with screenshots, download links and user comments about Moodle [[Themes|themes]]
+
[[fr:Base de données]]
* [http://moodle.org/mod/data/view.php?d=13 Modules and plugins], a database containing a variety of web links (download, documentation, discussion) and info (maintainer, module type, requirements) about the modular components of Moodle, including those created by third parties.
+
[[it:Attività Database]]
 
+
[[ja:データベースモジュール]]
== Creative uses ==
 
 
 
You could use the database module to:
 
 
 
* allow collaboration on building a collection of web links/books/journal references related to a particular subject
 
* display student created photos/posters/websites/poems for peer comment and review
 
* gather comments and votes on a shortlist of potential logos/mascot names/project ideas
 
* ...
 
 
 
:'''''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]].''
 
 
 
== See also ==
 
 
 
* [[Glossary module]], which performs a similar though more specialised, text-based role and is also available for previous versions of Moodle.
 
 
 
[[Category:Teacher]]
 
[[category:Modules]]
 

Latest revision as of 14:52, 16 February 2019

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.

Overview of the Database activity