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

Start learning with our library of video tutorials taught by experts. Get started

Moodle 1.9 Essential Training for Teachers
Illustration by

Customizing a database template


From:

Moodle 1.9 Essential Training for Teachers

with Chris Mattia

Video: Customizing a database template

Now that we have created our database and added our data fields, the next step is to set up the templates that will display the data inside of our database. To do this, make sure you are inside of your database and click on the tab for Templates. A default template is created for you automatically that will have all of the data types and the data fields that have been created as part of your database. This is laid out in a table format and if we click inside of this table, we'll notice that we have seen the controls for table before back when we learned about using tables inside of HTML.
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

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Moodle 1.9 Essential Training for Teachers
8h 34m Beginner May 28, 2009

Viewers: in countries Watching now:

Moodle is an online tool that allows educators to interact with students outside the classroom and manage a course from anywhere. In Moodle Essential Training for Teachers, Chris Mattia shows how this program works for teachers on three levels: disseminating information, creating a forum where ideas are exchanged, and assessing the progress of students. Chris shows how to build course materials with Moodle's HTML editor, post assignments, and save time by using Moodle's grade book to evaluate tests automatically and organize scores. Exercise files accompany the course.

Topics include:
  • Installing and configuring Moodle
  • Preparing media files for distribution inside a Moodle course
  • Posting instructions on the course home page
  • Setting up course-specific glossaries and databases
  • Building assignments students can complete online
  • Using Moodle's built-in email and discussion boards
  • Creating a wiki inside Moodle for students to build and contribute content
  • Developing multimedia exams to assess course comprehension
Subjects:
Elearning Teacher Tools Education Educational Technology Higher Education Student Tools
Software:
Moodle
Author:
Chris Mattia

Customizing a database template

Now that we have created our database and added our data fields, the next step is to set up the templates that will display the data inside of our database. To do this, make sure you are inside of your database and click on the tab for Templates. A default template is created for you automatically that will have all of the data types and the data fields that have been created as part of your database. This is laid out in a table format and if we click inside of this table, we'll notice that we have seen the controls for table before back when we learned about using tables inside of HTML.

A couple of changes that we want to make here. First of all, is that anytime a scientific name is displayed anywhere, it should be italicized. So we'll go ahead and select the field here inside of the brackets that says Species_Name and simply come up and click the Italicize button. This will make anytime a scientific name is entered, it will be italicized properly. We also want to change the descriptor for this field. Currently, it's set to Species_Name. It would be more descriptive, if we wrote Scientific Name. It's fine to have the common name simply listed without being italicized, but let's go ahead and get rid of the underscore in Common Name. The template is good enough first to get the information that we need out of it. So go ahead and click the button at the bottom that says Save template.

Once the template has been saved, we are able to go over to the list view and see a listing of all of the entries inside of our database. Currently our database doesn't have any data in it. So in the next movie we'll go ahead and add some data into our database.

There are currently no FAQs about Moodle 1.9 Essential Training for Teachers.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Moodle 1.9 Essential Training for Teachers.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

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.