Mario+and+Sonic+at+the+Olympic+Games

Mario and Sonic at the Olympic Games Everyone in the class will compete at 2 events in Mario and Sonic at the Olympic Games. You can choose as a class what the 2 events will be. Your teacher will split the class into 2 groups.

Task 1
Complete your own avatar, and share it with everyone in your group using Edmodo. You could use: [|DoppelMe] [|The Simpons Movie website] [|Game Edition avatar creator] [|27 avatar creators from Mashable]

You should also share your date of birth and hair colour with your group.

Task 2
Take part in the events in Mario and Sonic at the Olympic Games. Take a note of your position in each event. Share your position in the 2 events with everyone in your group.

Task 3
Draw a table in your jotter to represent the database. Along the top mark the field headings, and then fill in sample data for 3 students including yourselfOn your table mark out: 1. An example of a record 2. An example of a field

Underneath your table, write each of the field names and state their type eg Forename: Text

Task 4
Create a database to store the following information for each of the members in your group:
 * Forename (text)
 * Surname (text)
 * Avatar (Container)
 * Sex (text - this should be validated m or f only)
 * Date of birth (date)
 * Hair colour (text)
 * Event 1 position (number - this should be validated 1-8 only)
 * Event 2 position (number - this should be validated 1-8 only)

Task 5
Use your database's search function to answer the following queries:
 * 1) Show all those students who have blond hair
 * 2) Show all the males in your group who have brown hair
 * 3) Sort the database in order of females and then males. All the females should be sorted in alphabetical order by their surname. All the males should also be sorted in alphabetical order by their surname.

Task 5
You should create a new layout for your database.

Task 6
Investigate how to export your database as a Comma Separated Value (CSV) file. Now import your CSV file into a spreadsheet. What happens?