To add a Database activity to your LEO unit you will need to:

1. Add the Database activity to your unit, and edit the settings as appropriate
2. Create the 'fields' for your database
3. Start to add entries, and approve the entries of your students (depending on what kind of database you are trying to create)

Adding a Database to your unit

NOTE: We will explore the settings in more detail under the ‘Other settings’ section of this LEO Guide

To add a Database to your LEO unit you will need to:

1. Navigate to your unit from within LEO.
2. Click 'Turn editing on'.
3. Scroll down to the section in your LEO site you would like to add the Database to, then click on ‘Add an activity or resource’. From the options given under the ‘ACTIVITIES’ heading select ‘Database'. In the new page that opens up you will be able to edit the settings for your Database.
4. You will need to give your Database a name. However it is also useful to enter text in the ‘Description’ text box, so that your students know what the Database is about, or the reason they are being asked to complete it. Click on the box next to ‘Display description on unit page’ if you would like the description to be visible from the main page of your LEO unit.
5. Once you have selected your settings as appropriate, click on ‘Save and display'.

Adding 'fields' to your Database activity

After you have added the Database activity to your LEO unit, you need to add the 'fields'. The fields you add will dictate the kind of content you want to collect in your Database. For example a Database of student information may hve a picture field called 'image' where the student can upload an image of themselves, and two text fields 'name' and 'bio' for their name an biographical information. Some of the fileds you can add to your Database will limit the options of your students. For a example you can add a radio button or dropdown from which your students can select from predefined options selected by you. You can combine multiple fields, and make them compulsory, in order to capture all of the information that you require.

To add a field to your Database activity:

1. Click on the 'Fields' tab.
2. Click on the 'Choose' drop-down menu, and select from one of the following options:
   • Checkbox - The checkbox options allows you to set up a series of checkboxes your students can select from.
   • Date - This option allows a user to enter a date by picking a day, month and year from a dropdown menu.
   • File - This option will allow a user to upload a file from their computer.
   • Latlong - Latlong stands for 'Latitude and Longitude'. This option will allow the user to select a geographical location.
   • Menu - This option allows you to set up a dropdown menu for students to choose from.
   • Multimenu - The text entered in the options area will be presented as a list for the user to choose from and each line become a different option. By holding down control or shift as they click, users will be able to select multiple options. This is a fairly advanced computer skill so it may be wise to use multiple checkboxes instead.
   • Number - This option allows the user to enter any number, including negative numbers.
   • Picture - This option will allow the user to upload an image.
   • Radio button - This option allows you to set up some predefined values. The student can select one via a radio button interface.
   • Text input - users can enter up to 60 characters worth of text.
   • Text area - You can allow students to enter longer amounts of text. This field also has HTML functionality, allowing the student to embed multimedia and upload additional content.
   • URL - This option allows a student to copy and paste a URL (web address) into the field.
3. Give your newly added Field both a meaningful name, and a description (what information do you want the student to provide in this space). Select the 'Required field' checkbox if you want to make this field compulsory. Select the 'Allow autolink' checkbox if you want content from this entry linked to throughout your LEO unit.
4. Repeat these steps until you have added all of the appropriate Fields.
5. Click on the 'Add entry' tab at the top of the page. From here you can preview your Database Fields, and Add Database entries.