WEBVTT - generated by Mediathek

1
00:00:00.000 --> 00:00:05.000
Welcome to the video tutorial  Using Database
in Moodle.

2
00:00:06.000 --> 00:00:09.000
With the Database activity in moodle  you can
create individal forms,

3
00:00:09.030 --> 00:00:13.000
where your students can insert information
or files.

4
00:00:14.000 --> 00:00:17.000
These information can be gathered  according
to your criteria

5
00:00:17.020 --> 00:00:19.090
and are viewable for all course participants.

6
00:00:20.020 --> 00:00:24.000
In our example we will create a   database
for our students,

7
00:00:24.020 --> 00:00:28.000
in which they will upload their powerpoint
presentations.

8
00:00:29.000 --> 00:00:32.070
In order to do this, we first need  to turn
the editing on and add

9
00:00:33.000 --> 00:00:37.000
a new activity. We choose  Database from the
menu

10
00:00:37.020 --> 00:00:42.000
and click on Add. First we add a title of the
database

11
00:00:42.030 --> 00:00:45.000
as well as a short description.

12
00:00:45.050 --> 00:00:50.000
We also need to adjust the settings  regarding
the entries.

13
00:00:51.000 --> 00:00:55.000
In the first field you can activate  the approval,
in order to control

14
00:00:55.030 --> 00:00:57.000
the entries before making them public.

15
00:00:57.080 --> 00:01:01.000
If you choose to activate approvals,  you can
choose to disable the deleting

16
00:01:02.000 --> 00:01:04.000
of entries by students by changing this setting.

17
00:01:05.000 --> 00:01:09.000
With this setting you can allow students to
comment each others entries.

18
00:01:10.000 --> 00:01:14.000
In case you set a minimum number of  entries,
the activity will count

19
00:01:14.000 --> 00:01:18.000
as completed once this number has been reached.

20
00:01:19.000 --> 00:01:23.000
There is also the possibility to hide the entries
until a certain amount

21
00:01:23.000 --> 00:01:26.000
of entries by a user has been reached.

22
00:01:27.000 --> 00:01:31.000
The last setting allows you to limit the amount
of entries

23
00:01:31.000 --> 00:01:33.000
each user can upload.

24
00:01:34.000 --> 00:01:38.000
Once you've adjusted all settings  click on
Save ad return to course.

25
00:01:38.000 --> 00:01:42.000
Now you need to add the fields to the database.

26
00:01:43.000 --> 00:01:46.000
In the tab Fields choose one of  the options
in the dropdown menu.

27
00:01:46.000 --> 00:01:50.000
In this example we first choose  Text input,
where our students

28
00:01:50.000 --> 00:01:53.000
can enter the presentation's subject.

29
00:01:53.000 --> 00:01:57.000
We enter the title of the field  and write
a description. We check

30
00:01:57.000 --> 00:02:01.000
the box Required field.  We click on Add.

31
00:02:01.000 --> 00:02:05.000
The second field will be a text area.  Here
the students need to enter

32
00:02:06.000 --> 00:02:08.000
a short description about their presentation.

33
00:02:09.000 --> 00:02:14.000
Finally we create a File field  where the document
can be uploaded.

34
00:02:15.000 --> 00:02:19.000
If you want to edit or delete a field, you
can do this by

35
00:02:19.000 --> 00:02:22.000
clicking on the icons  on the right side.

36
00:02:23.000 --> 00:02:27.000
We are now finished with creating  the database.
Students can

37
00:02:27.000 --> 00:02:30.000
fill in the fields and upload  their presentations.

38
00:02:31.000 --> 00:02:34.000
All entries can be viewed as a list or as a
single entry.

39
00:02:34.000 --> 00:02:38.000
They can also be filtered  according to different
criteria.

40
00:02:38.000 --> 00:02:44.000
You can also use the search tab and look for
keywords.

41
00:02:45.000 --> 00:02:50.000
Exporting all the entries is also a possibility,
either as

42
00:02:50.000 --> 00:02:54.000
CSV or an ODS file.  You also have the option

43
00:02:54.000 --> 00:02:57.000
to choose and export only particular fields.

44
00:02:58.000 --> 00:03:01.000
For easier use of the form you   have the possibility
to adjust

45
00:03:01.000 --> 00:03:06.000
the template of your database and save it.

46
00:03:06.000 --> 00:03:10.000
In the presets tab you will be  able to save
and export the

47
00:03:10.000 --> 00:03:14.000
template for other database  activities in
moodle.

48
00:03:15.000 --> 00:03:18.000
You now know the basics of  using the database
in moodle.

49
00:03:19.000 --> 00:03:23.000
For further help, please take  a look at our
other tutorials.