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

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.

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

 

Continue to Exercise 2: Complex Sorting

 


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