MoodleDocs - User contributions [en]

User:James Ballard

2009-04-10T09:19:29Z

Jib:

Database activity module

2008-01-23T10:47:51Z

Jib: /* How to use the database module */

[[ru: База_данных]]
{{Databases}}
{{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.

:'''''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 [[Administrator documentation | Administrators]].''

== How to use the database module ==
* 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.
* 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.
* It is then optional to edit the [[Database templates|database templates]] to alter the way in which the database displays entries.
* 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.
* Data can be uploaded into the database from a .csv file:
** Click the 'Add Entry' tab
** 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 and Roles==

Since Moodle 1.7 a number of options in Database have been migrated over to the Roles system. For example, preventing students (or any other role) submitting data must be done by overriding the role for that particular instance of the Database. However, do note that by default teachers are unable to override roles and this ability must first be granted by your Administrator for the course or site as appropriate.

== Example databases ==

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]

== See also ==

* Using Moodle [http://moodle.org/mod/forum/view.php?id=3505 Database module forum]
* [[Glossary module]], which performs a similar though more specialised, text-based role and is also available for previous versions of Moodle.
* [http://treadwell.cce.cornell.edu/moodle_doc/database_moodle/index.html a screencast introducing the Database Module and walking through creating a database]
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=72260 Database Module: Each learner Private DB?] forum discussion
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=84487 Database for Dummies please!] forum discussion

[[Category:Database]]
[[category:Modules]]

[[es:Base_de_datos_%28m%C3%B3dulo%29]]
[[eu:Datu-basea]]
[[fr:Base de données]]
[[cs:Modul Databáze]]
[[ja:データベースモジュール]]

Talk:Marking block

2006-04-25T07:47:57Z

Jib:

Hi, is this page aimed at teachers, administrators (developers) or both?

We would like to direct tutors to Moodle Docs as a user guide, and the installation details are likely to cause confusion. Should there be two pages, or would it just be easier to have something along the lines of "This is a non-standard block and which can be installed by an administrator as below" before the "technical" aspects of it. Standard block pages seemed to be split into different pages for different users (teacher/admin).

Any thoughts or is it just me ??
[[User:James Ballard|James Ballard]] 21:28, 24 April 2006 (WST)

:Most of the non-standard blocks are not categorised as either teacher or admin so it will be interesting to see what others think. As for not confusing teachers then perhaps a page for installing non-standard blocks and then the instructions don't need to be repeated for every block anyway? As for a user guide. Hmmmm. I think there is a fine line between explaining what something does (documentation) and showing how to use it. These pages should, IMHO, explain how what something does but I can see there would be overlap. --[[User:Darren Smith|Darren Smith]] 22:55, 24 April 2006 (WST)

::By User Guide, I was thinking in terms of the normal Manual that would come with any software, which is how I interpreted Moodle Docs, rather than a full how to tutorial. This has worked well on all the standard blocks and I wondered if non-standard blocks should follow a similar idea, as in general only administrators are distinguishing between the two. Once we decide to install a non-standard block, it becomes standard as far as our tutors and Moodle users are concerned, if that makes sense. [[User:James Ballard|James Ballard]] 15:47, 25 April 2006 (WST)

Jib:

{{Questionnaire}}

If you are creating a new survey or editing an existing template you will be able to define the overall settings via the Editing survey page.

==Name==

Give your questionnaire a filename (e.g. “Feedback”). The name entered here will be how this questionnaire is identified in future, especially if it is a template or public questionnaire.

==Owner==

This is determined in the [[Adding/editing a questionnaire|adding a questionnaire]] options.

==Title/Sub-title==

Give the questionnaire a title and optional sub-title. The title will appear on every page of the survey.

==Additional Info==

This will appear before the questions of your survey and should include any relevant details on the purpose of the questionnaire and instructions for completion.

==Confirmation Page==

If you have created a custom completion page you can enter the URL to it here, or you can type in the title and text you would like displayed as a confirmation page for users who complete the survey.

==Email==
If you want copies of each submission emailed to an address fill it out here.

==Theme==

Select a theme for your questionnaire. These appear to be stored -> mod\questionnaire\phpESP\public\css

[[Category:Teacher]]

2006-04-05T12:01:32Z

Jib:

How do I get the "adding a questionnaire" etc. link box that floats to the right in other pages.
[[User:James Ballard|James Ballard]] 20:01, 5 April 2006 (WST)

Talk:Questionnaire module

2006-04-05T12:01:13Z

Jib:

How do I get the "adding a questionnaire" etc. link box that floats to the right in other pages.