2. Complex Sorting
Computerised databases can also be sorted on more than one field at the same time.
Changing the sort order on more than one field is known as a COMPLEX SORT.
Press the Tab key to move easily from field to field 
How to Do Complex Sorts! Go Full Screen to see in greater detail?
|
Watch the Complex Sorting Movie and practice complex sorting by answering the following questions in your Progress Grids.
What you have to do!
| 1. | Sort the flights in order of country and then city in ascending order. Look at the list carefully to see sort order. Write down the flight number 37th on the list. |
| 2. | Sort the flights in order of city and then country in ascending order. Look carefully at the sort order. Do you see any difference compared to your previous sort. Write down the flight number 28th on the list. |
| 3. | Sort the countries followed by the price, both in ascending order. Write down the flight number 67th on the list. |
| 4. | Sort the available seats followed by the ticket price, both in ascending order. Write down the flight number 71st on the list. |
| 5. | Sort the flight dates followed by the flight times, both in ascending order. Write down the flight number 56th on the list. |
| 6. | Sort the cities in ascending order followed by available seats in descending order. Write down the flight number 37th on the list. |
| 7. | Sort the flight times in descending order followed by the cities, both in ascending order. Write down the flight number 44th on the list. |
| 8. | Sort the flight number followed by flight date, both in ascending order. Write down the number 1st on the list. |
| 9. | Sort the flight number followed by country in ascending order. Write down the flight number 1st on the list. |
| 10. | Why is there no point in doing a double sort, when the first sort item is flight number. |
Mark Off Exercise 2 in Your Progress Grids
What you should be able to do at the end!
