1. Simple Sorting
The ability to CHANGE the SORT ORDER is a big advantage computerised databases have over manual or paper based databases.
Changing the sort order on one field is known as a SIMPLE SORT.
How to Do Simple Sorts! Go Full Screen to see in greater detail?
|
Watch the Simple Sorting Movie and practice simple sorting by answering the following questions in your Progress Grids.
What you have to do!
| 1. | Sort the flights in order of cost (i.e. the price field) with the cheapest flight first in the list. Write down the flight number 20th on the list. |
| 2. | Sort the flights in order of cities alphabetically. Write down the flight number 82nd on the list. |
| 3. | Sort the flights in order of flight numbers alphabetically. Write down the flight number 37th on the list |
| 4. | Sort the flights in order of departure date. Write down the flight number 67th on the list. |
| 5. | Sort the flights with countries in reverse alphabetical order i.e. starting with the Z's. Write down the flight number 79th on the list. |
| 6. | Sort the flights in order of available seats, starting with the lowest number available. Write down the flight number 12th on the list. |
| 7. | Sort the flights in order of available seats, starting with the highest number available. Write down the flight number 15th in the list. |
Mark Off Exercise 1 in Your Progress Grids
What you should be able to do at the end!
