How do I add a Database activity?

You will learn how to add a Database activity to your course in TITANium. The Database activity module allows you to create a database where students can upload a variety of data, like a comma delimited file (CSV), images, web links, etc. That data set can then be exported to be manipulated in Excel or SPSS.

Follow these steps to create a Database which will allow students to input exercise data.

1. Enter your course.

course main page

2. Click on the Gear icon.

 Gear icon is selected.

3. Select Turn editing on.

Turn editing on link is selected.

4. Click on Add resource or activity.

Add resource or activity link is selected

5. Select Database.

Database is selected.

6. Click on Add.

Add button is selected.

7. Type a Name.

Name field is selected.

8. Type a Description.

Description is selected.
Learn about the Additional settings.

Expand each section you want to use.

Entries

Using the default values, students will not need their contributions approved by the instructor and they can make new their entries an unlimited number of times.

Entries settings
Availability.

If there is a deadline by which time you want to have the data read only or you want to export to Excel, you can set read only dates.

Availability settings
Grade.

A Grade category is created on the Gradebook setup page. If you have created any, they will be available in the Grade category dropdown selection.

Setting a Grade to pass (in addition to Completion tracking) will allow you to have more control over the activities or resources your students will see. Read this guide for a sample use of a Grade to pass.

Grade settings
Ratings.

The Ratings section allows you to grade your students' contribution within the Database tool.

Ratings settings

Aggregate type

Choose one of the following ratings methods:

No ratings = Use this setting if there are no points for this database.

Average of ratings = If you rate more than one entry in a database, then those ratings will report the average to the gradebook.

Count of ratings = This rating will count the number of times a student has added an entry, and that determines the points.

Maximum rating = The highest rating (points awarded) of all of the student's entries within a database is reported to the gradebook.

Minimum rating = The lowest rating (points awarded) of all of the student's entries within a database is reported to the gradebook.

Sum of ratings = The total points awarded in all of a student's entries are reported to the gradebook; however, the score will not go above the maximum points set in the Ratings section of the edit settings for this database.

Aggregate type is set to Sum of ratings.

Scale

Type a integer value for the Maximum grade field between 0 and 200.

Maximum grade is set to 5.
Restrict ratings

Enabling the Date range doesn't really do anything for you except give you a headache. It doesn't prevent students from posting outside of the date range, it only makes it so that you cannot rate any posts outside of the date range.

Restrict ratings settings
Competencies.

No competencies have been uploaded for our current version of TITANium.

Competencies settings

9. Click on Save and display.

Save and display button is selected.

10. Now, it is time to determine which fields to add.

Create a new field

11. Use the dropdown menu to create a new field.

Fields need to be added one at a time. Choose the type of data you want to collect.

Create a new field is set to Date.

12. Type a name and description for the new Date field.

Field name is set to 'Today's Date'

13. Click on Add.

Add button is selected.

Repeat these few steps to add all of the desired fields. For this example, we are adding [[Number of pushups]], [[Number of situps]], [[Time to run/jog/walk one mile]], etc.

14. Student view of the Add entry tab of the database.

To add an entry, the student will need to click on the Add entry tab.

Add entry tab is selected.

Once students make data entries, you can export to an Excel sheet to manipulate the data.

Article Summary

You have now learned how to create a Database activity in your course in TITANium.