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.
{{New features}}
Watch the video to see the new features and improvements to the Database activity in Moodle 4.1.
Watch this video to see how to set up a Database activity.
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.
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.
{{MediaPlayer | url = https://youtu.be/cypkjvcveP8 | desc = Setting up a Database activity}}
The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).
==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.
== How to use the database activity module ==
They can usually see entries individually (View single) and in a list (List view) and are able to search entries.
* 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.
===Teacher view===
* Next you define the kind of [[Database fields|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.
Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.
* It is then optional to edit the [[Database templates|database templates]] to alter the way in which the database displays entries.
==More information==
* 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
* 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.
* [[Building Database]]
* Data can be uploaded into the database from a .csv file:
* [[Database templates]]
** Click the 'Add Entry' tab
* [[Using Database]]
** At the bottom of the page there is a link 'Upload entries from a file' which provides help in assigning data in a csv file to the relevant fields in your database.
* [[Database activity FAQ]]
== Example databases ==
[[Category:Database activity module]]
Moodle.org has three good examples of the database module in action:
* [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
* [http://moodle.org/mod/data/view.php?d=26 Themes], a database with screenshots, download links and user comments about Moodle [[Themes|themes]]
* [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.
== 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
* provide a [http://moodle.org/mod/forum/discuss.php?d=52699 student file storage area]
* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]
== See also ==
* [[Glossary module]], which performs a similar though more specialised, text-based role
* [[Using Moodle book]] Chapter 12: Databases
* [http://moodle.org/mod/data/view.php?id=7303 Database for Databases]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=3505 Database activity module forum]
* [http://treadwell.cce.cornell.edu/moodle_doc/database_moodle/index.html Screencast introducing the Database Module and walking through creating a database]
* [http://moodle.org/mod/data/view.php?rid=2424 Tracking Students' Reading with the Moodle Database Module] presentation
Using Moodle forum discussions:
* [http://moodle.org/mod/forum/discuss.php?d=72260 Database Module: Each learner Private DB?]
* [http://moodle.org/mod/forum/discuss.php?d=84487 Database for Dummies please!]
* [http://moodle.org/mod/forum/discuss.php?d=89117 Restricting access to database content by user?]
* [http://moodle.org/mod/forum/discuss.php?d=139137 How to use the database activity module?]
[[de:Datenbank]]
[[de:Datenbank]]
Line 55:
Line 39:
[[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 08:14, 5 December 2022
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.
New feature in Moodle 4.1!
Watch the video to see the new features and improvements to the Database activity in Moodle 4.1.
