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.

Enter your course.

2. Click on the Gear icon.

3. Select Turn editing on.

Turn editing on.

4. Click on Add resource or activity.

Click on Add resource or activity.

5. Select Database.

Select Database.

6. Click on Add.

Click on Add.

7. Type a Name.

Type a Name and a Description.

8. Type a Description.

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.

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.

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.

Ratings.

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

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.

Scale

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

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.

Competencies.

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

9. Click on Save and display.

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

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.

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

13. Click on Add.

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.

View the sample completed database from the student's view.

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.

0 Comments

Add your comment

E-Mail me when someone replies to this comment