Participants use a range of software applications to analyse image, audio, video,
text and numeric data.
![Picture](/uploads/4/8/7/3/48736149/4132890.png?344)
Searching is the process of locating data and information. Most software applications have a ‘Find’ or ‘Search’ command. The user types in a string of text or numbers and the software examines the data to find a match. A query is a search of a database for records that meet a certain condition. There are three methods of entering a simple query: selecting a menu option, using query by example and using a query language.
![Picture](/uploads/4/8/7/3/48736149/1746523.png?362)
Sorting is the process of arranging data in a particular order. Sorts are performed in either ascending order (A to Z and 0 to 9) or descending order (Z to A and 9 to 0). In a database, sorting can be done on more than one field, so that records are arranged in precise order.
![Picture](/uploads/4/8/7/3/48736149/7560846.jpg?314)
Modelling and simulations are used to make predictions and examine decisions concerning real situations. A model is a representation of some aspect of the real world and a simulation is the use of that model. Computer simulations use a computer to model a real system. They have been developed for many different fields of business, industry and science.
![Picture](/uploads/4/8/7/3/48736149/7154311.jpg?374)
‘What-if’ predictions are a powerful feature of spreadsheet software. The software allows the user to make changes to one item of data and observing the effects on other items.