S1
Introduction Course
S2
Introduction course
Computing
Standard Grade
Information Systems
Intermediate II
Information Systems
Higher
Internet
Safety
Business Studies
Dept

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

Play this video
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. Using the Flights Database answer the following questions in your progress grids.
    • Make Sure you read each question carefully to see:
      • which fields you have to sort on; and
      • in which order.
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!

 

Continue to Exercise 3: Simple Searching

 


S1 Courses

 

 

 

Home | S1 Topics | S2 Topics
Computing Standard Grade | Info Systems Intermediate II | Info Systems Higher | Internet Safety
Log into Glow | School Website | Contact Us