mercredi 19 janvier 2011

Create a Database ressource in the course

View edit at the bottom of the page...
Suppose you have a course where the content and activities in Moodle is organise in weeks. We want to create a kind of form where the student can mark every activity when he’ve done it.
For that we can use the Database (DB) module to give to the student a place where he can mark all activities completed.

General setting

  1. From the main page of the course, create a simple DB activity.
  2. Insert a «Name»
  3. Write an «Introduction»
  4. Let the other setting just as it, so on «Disable», «No» or «None»
  5. Except for the «Require approval» setting that must be set to «Yes» (as describe in the section «More informations»)
  6. Click «Save and return to course»

Set entry field

  • Click on the new DB activity
  • You are direct to the «Fields» tab where you must create your field for the entries of the students
  • On «Create a new field», chose «Checkbox»
  • Create a first new Checkbox field
    • Insert a «Field name» ( «Week 1 activities»)
    • Insert a description in «Field description»
    • Insert the «Options (one per line)», e.g.:
      Activity 1
      Activity 2
      Activity 3
  • Create a new Checkbox for each week of your course. At the end, you should have for e.g. 15 checkbox field.

Play with Templates

You can define as you want the template («Template» tab) of the forms.
  • You can specify what a student see when he reach the «View list» (the default tab) by defining the «List template».
    • You can add the ##edit## tag on that page to give the possibility to the student to edit his entry
    • For example, I just put that infos on the «List template». That show the name of the student, the date and time of the last modification, and the edit button.
      ##user## Modified ##timemodified## ##edit##
  • You can also, and it’s one of the two most important modification, change the «View sigle» tab by defining the «Single template».
    • Important note : Be sure to have the tag ##edit## somewhere on that page to show the «Edit» button giving the possibility to the student to edit is entry.
    • Here I put all the fields for the form and organise it like in that example (note that the text in double square bracket are the code that insert the fields)

##user##
Modified ##timemodified##

Click on that file to edit your file - ##edit##
Week 1 - [[Week 1 activities]]
Week 2 - [[Week 2 activities]]
Week 3 - [[Week 3 activities]]
Week 4 - [[Week 4 activities]]
Week 5 - [[Week 5 activities]]
Week 6 - [[Week 2 activities]]
  • You can also, and it’s one of the two most important modification, change the «Add entry» tab by defining the «Add template». I simply copy and paste the same template as the «Single template» to make easyer for the student to find himself in the form.
Two last notes about the Template:
  1. I remove all the ##delete## action from the template to be sure nobody delete is entry.
  2. I also remove all the ##approve## action to be sure that no teacher will approve the student entry. As a reminder, the missing approval give to the student the right to edit his form many he want.

The end user...

  • The student: When the student click on the activity from the course main page, he is redirected to the «View list» page of the DB module. The first time, he will see the message «No entries in database». Here is what he must do.
    • Click on «Add entry» Tab
    • Tick the activities that have been done
    • Click on the «Save and view»
    • He will see only the activities done. The other ones are not shown.
    • He can then edit this entry (actually the form) by clicking the «Edit» button on the page
    • Then the form with checkbox appear and he can make is changes
    • He can’t look as the entry from other students
  • For the teacher, on the «View list» tab of the DB module, he see the name of all the students that have start completing the form. When he click on the edit button, he can see all the activities a student have mark as complete.

More informations

Allow student to only see it’s own entry in DB module

A first info on "how to prevent student to see an entry from other student" (point 2 in my fast look).
The answer came from the DB module FAQ (http://docs.moodle.org/en/Database_activity_module_FAQ#How_can_I_create_a_database_in_which_students_can_only_view_their_own_entries.3F)
We can read the following answer:
"Set up the database so that entries require approval. If the entries are never approved, then only the student that added a particular entry and the teachers can view it."
This setting is accessible from the DB module update link, Select «Yes» for the setting «Require approval».


Edit - 2011-05-09

Looking at Moodle 2.0, I found that Activity completion feature will do exactly that without having to make all this work I present here...

1 commentaire:

  1. new edit on 2011-05-09
    Moodle 2.0 do that with activity completion without working with DB module

    RépondreSupprimer