Sorting+an+OIS+Exercise

Mr Smith, the head of Geography, has created a spreadsheet to log pupils who are going on a field trip.

Download the file **Pupil Field Trip** from: H:\Curricular\Int 2 Info Systems\Using Information\4 Functions of OIS

Now use the spreadsheet to answer the following questions:

> Which 2 pupils are at the top of the list alphabetically? > Who is the first boy on the list? > Who is the first girl on the list? > What is the order of tutor groups? > For each teacher, write down how many pupils they are responsible for.
 * 1) Sort all pupils into alphabetical order on their surname.
 * 1) Sort the spreadsheet into boys and girls.
 * 1) Sort the spreadsheet by Tutor group.
 * 1) Mr Smith wants to count how many pupils each teacher is responsible for. Sort the spreadsheet by Teacher Responsible.