New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Setting up a simple database

From: Moodle 1.9 Essential Training for Teachers

Video: Setting up a simple database

One of the activities that we are going to do with our students while we are on the field trip in Belize is a field identification quiz. And the organisms that are going to be on the quiz are ones that the students have identified and seen both in laboratory and then identified in the field. So we need a mechanism for collecting a list of all the organisms that the students have identified thus far throughout the course of the semester. And in the second week of the semester when we begin talking about Coral reef structure and diversity is a great place to add this activity for the students to begin building this list.

Setting up a simple database

One of the activities that we are going to do with our students while we are on the field trip in Belize is a field identification quiz. And the organisms that are going to be on the quiz are ones that the students have identified and seen both in laboratory and then identified in the field. So we need a mechanism for collecting a list of all the organisms that the students have identified thus far throughout the course of the semester. And in the second week of the semester when we begin talking about Coral reef structure and diversity is a great place to add this activity for the students to begin building this list.

To create the list we are going to use a database. So let's scroll down to the second week in the semester, under the Assignments section and click the dropdown menu for Add an activity, and let's select a database. Now building a database inside of Moodle is a multi-step process and over the course of this chapter we are going to step through each of those different steps, so you can build your own custom database inside of your Moodle course. To begin, let's give the database a name of Identified Organisms. For the Introduction, let's simply note that we want the students to, List the Scientific and Common Names of all organisms identified in the Laboratory and in the Field.

We will scroll down in the list and we can set when we want the Availability of this database to be. We want the database to be available to the students all the time, so we'll leave all of these options set to Disabled. Next, we can set the number of required entries that each student is required to add into the database. So say for instance we wanted each student to identify five organisms. We could set that here and then every time the student added an entry into the database, the database would continue to remind them that they had 4 more, 3 more, 2 more, and so forth entries to make before they were finished with the assignment.

We want to leave this set to None, so that the students can add entries to this database as long as they need to. You have the ability to require a certain number of entries to be made before the learner can view the rest of the database. We want to leave this set to None as well, so that once an organism has been identified and added to the list, they don't get duplicated by another student. You can set the Maximum number of entries that a student can make. We want students to be able to add as many entries to this database as they need to, so we'll leave this set to None.

Comments, now it's a great idea to have comments added to every single entry. That way once an entry has been made, other students can come in and make additional notes on that entry. So for instance, in the example of the field or laboratory identification of organisms, additional students could come in and they could add comments about where they saw the animal, how many were there, and so forth. Require approval, if you want to control as the teacher whether or not you need to verify the entry before it's seen by the other students in the class, you can set this to Yes. We are going to go ahead and leave our set to No.

If you want to allow ratings to be made on the post, you can check the box here and select the grade rating scale that you want to have available for each rating. We are not going to grade this assignment and we don't want to have any rating set, so we'll go ahead and uncheck the Use ratings. The next section shows whether or not we want to have this available for separate groups or for all groups. And we want it available for everyone, so we'll go ahead and leave this set to No groups. We want the database available all the time, so we'll leave this set to Show. We are not going to use an ID number for this and the Grade category, since we are not going to be grading this assignment. We are going to leave that Uncategorized.

We will go ahead and click the button for Save and return to course. And if we scroll back down in the list, we can see that a database has been created for us. Go ahead and click on the link for that Identified Organisms database. And in the next movie, we'll begin setting up the database fields for this database.

Show transcript

This video is part of

Image for Moodle 1.9 Essential Training for Teachers
Moodle 1.9 Essential Training for Teachers

108 video lessons · 9780 viewers

Chris Mattia
Author

 
Expand all | Collapse all
  1. 8m 21s
    1. Welcome
      2m 8s
    2. Course overview
      5m 22s
    3. Using the exercise files
      51s
  2. 34m 55s
    1. Getting started
      2m 59s
    2. Installing Moodle on a Mac
      8m 45s
    3. Installing Moodle on a Windows computer
      14m 24s
    4. Creating user accounts
      3m 55s
    5. Creating a new course
      3m 0s
    6. Just enough site administration to get you going
      1m 52s
  3. 41m 16s
    1. Logging in and getting oriented with Moodle
      5m 8s
    2. Customizing your profile
      4m 7s
    3. Customizing course settings
      3m 49s
    4. Editing the header block
      1m 33s
    5. Posting a course syllabus
      3m 55s
    6. Communicating news to students
      3m 5s
    7. Managing files and folders
      3m 41s
    8. Posting lecture slides
      3m 11s
    9. Setting up the gradebook
      5m 35s
    10. Sending email to the class
      2m 54s
    11. Creating a simple assignment
      4m 18s
  4. 51m 28s
    1. HTML editor overview
      10m 11s
    2. Formatting text
      8m 42s
    3. Creating tables
      9m 36s
    4. Creating internal links
      7m 27s
    5. Creating external links
      7m 2s
    6. Inserting local pictures with HTML
      3m 55s
    7. Inserting pictures from Flickr
      4m 35s
  5. 49m 22s
    1. Preparing images
      6m 53s
    2. Batch-uploading files
      5m 58s
    3. Posting image files
      2m 33s
    4. Posting a photo gallery
      3m 45s
    5. Preparing audio files
      10m 14s
    6. Posting audio
      3m 50s
    7. Preparing video files
      7m 45s
    8. Posting video
      3m 48s
    9. Inserting video from YouTube
      4m 36s
  6. 37m 11s
    1. Creating a text label
      6m 14s
    2. Linking to a web site
      6m 2s
    3. Creating a text page
      4m 45s
    4. Creating a web page
      10m 56s
    5. Linking to a folder of documents
      4m 18s
    6. Inserting an IMS content package
      4m 56s
  7. 27m 23s
    1. Assignments overview
      2m 13s
    2. Advanced uploading of files
      10m 32s
    3. Online text
      4m 26s
    4. Uploading a single file
      5m 1s
    5. Offline activity
      5m 11s
  8. 11m 39s
    1. Creating a live chat room
      5m 13s
    2. Creating a choice
      6m 26s
  9. 15m 45s
    1. Setting up a simple database
      4m 14s
    2. Creating database fields
      2m 49s
    3. Customizing a database template
      1m 33s
    4. Entering data into a database
      1m 43s
    5. Enabling database auto-linking
      3m 23s
    6. Enhancing a database with file uploads
      2m 3s
  10. 17m 16s
    1. Creating a main glossary
      4m 45s
    2. Adding concepts to the glossary
      3m 16s
    3. Enabling glossary auto-linking
      3m 38s
    4. Enabling students to edit a glossary
      2m 5s
    5. Creating a secondary glossary
      3m 32s
  11. 9m 58s
    1. Creating a forum
      5m 21s
    2. Using a discussion forum
      4m 37s
  12. 32m 17s
    1. Creating a wiki
      7m 3s
    2. Wiki editing basics
      4m 26s
    3. Creating lists
      6m 1s
    4. Subdividing a class wiki
      3m 43s
    5. Adding attachments and images
      2m 54s
    6. Creating external links
      2m 27s
    7. Creating a table
      5m 43s
  13. 1h 9m
    1. Online assessment overview
      1m 38s
    2. Creating question pool categories
      1m 58s
    3. Creating a first question
      6m 24s
    4. Creating true/false questions
      4m 39s
    5. Creating multiple choice questions
      7m 23s
    6. Creating short answer questions
      6m 59s
    7. Creating essay questions
      6m 22s
    8. Creating match questions
      6m 38s
    9. Creating numerical questions
      4m 56s
    10. Importing question pools from Blackboard
      6m 24s
    11. Creating a quiz
      9m 9s
    12. Adding questions to a quiz
      6m 50s
  14. 39m 16s
    1. Gradebook overview
      2m 6s
    2. Completing assignments as a student
      9m 34s
    3. Grading an assignment
      4m 52s
    4. Quick grading
      2m 25s
    5. Grading assignments with uploaded files
      2m 18s
    6. Grading offline assignments
      1m 16s
    7. Grading an online quiz
      3m 30s
    8. Quiz data analysis
      3m 4s
    9. Adding assignments
      2m 3s
    10. Exporting grades
      3m 55s
    11. Importing grades
      4m 13s
  15. 20m 4s
    1. Calendars and events overview
      3m 51s
    2. Creating a new event
      3m 21s
    3. Creating a repeating event
      3m 15s
    4. Exporting a calendar to iCal
      4m 5s
    5. Exporting a calendar to Outlook
      5m 32s
  16. 44m 40s
    1. Course administration overview
      3m 3s
    2. Managing course settings
      12m 48s
    3. Managing user roles
      2m 59s
    4. Managing groups
      4m 51s
    5. Backing up your course
      4m 34s
    6. Restoring data from a backup
      3m 14s
    7. Importing content to another course
      4m 53s
    8. Resetting a course
      3m 24s
    9. Running reports
      4m 54s
  17. 4m 14s
    1. Additional resources
      2m 58s
    2. Goodbye
      1m 16s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.