Part – IV Sorting Filtering and Page setup . Advanced data analysis tools A spreadsheet is a “Flat file database”. Thus, database operations such as sorting, filtering can be done on spreadsheet. The “Data” menu of OpenOffice calc provides maximum data analysis tools such as sorting, filtering, validity etc., In this part, the sorting and filtering feature is to be learnt.
. . Database A database is a repository of collections of related data or facts. It arranges them in a specific structure.
The table given below contains details of students in a class. Sl. No Class Group Code Student Name Gender Comm Date of Birth Date of Birth Religion XII - F1 GANDHIMATHI N F SC H XII - H2 SANDHIYA D F SC H XII - H2 SUMATHI P F BC H XII - F1 JAYASREE J F BC H XII - H1 JOTHIKA A F SC H XII - H2 RAMYA T F MBC H XII - F1 KOWSALYA T F SC H XII - F1 ASHA A P F SCA H XII - A VENNILA T P F BC H XII - F2 SANGEETHA G F MBC H Table . .
Student Database The entire collection or related data in one table is referred to as a File or a Table. Each row in a table represents a Record, which is a set of data for each database entry. Each table column represents a Field, which groups each piece or item of data among the records into specific categories. (Refer Figure .
) . . Sorting: Sorting is the process of arranging data in ascending or descending order. There are two types of sorting in OpenOffice Calc.
They are, Chapter ( ) Simple Sorting ( ) Multi Sorting ( ) Sort by selection ( ) Simple Sorting Arranging data using single column is known as simple sorting. For sorting the data, calc provide two icons on the standard tool