The database activity in Moodle allows teachers to create embedded database directly in their Moodle site. These databases can be populated with information by the teacher, or populated by the students themselves. In this example, I have created a database that has been designed to provide a tool for students to anonymously reflect on their learning. These reflections are shared amongst all students in the Moodle course and each student has the ability to comment on all individual student reflections. In addition, the teacher has the ability to rate individual anonymous record posts submitted by the student and an average score can be recorded in the Moodle gradebook at the completion of the database activity.
Video Tutorial One
- How this particular database activity appears to a student.
- All students can contribute comments to each student’s record in the database.
- Moodle 2.0 comments appear much more “Web 2.0” like and been integrated into many of the activities and resources in Moodle version 2.0.
Video Tutorial Two
- The initial database activities settings configuration.
- Providing students with the ability to comment on each other’s contributions is vital for improving writing, holding them accountable, and generating discussion regarding what they are learning.
- The “Require approval” setting if used, will provide the teacher with a button to approve any new record added by a student before it visible to other students. This can also be used as a way to provide a system to collect and store information from students without making it public to other students. For example, let’s say a student has posted some content in a new database record but there are some grammatical errors in the post. The teacher could add a comment to that students post regarding fixing the grammatical errors. That original post and the teacher’s comments would only be available to the specific student and the teacher. Once the student has corrected the errors, the teacher could delete their comment and then approve the students record so that it is visible to the rest of the class.
Video Tutorial Three
- Creating fields for your database and adding those fields to the list view, single record view, and Add (record) view templates.