Education for all

Spreadsheet   A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions Selection of a row In the image above row 3 is selected. This can be done by clicking on the number 3 in front of the row. Selection of a column In the image above column B is selected. This can be done by clicking on the letter B above the column. Selection of a cell In the image above cell B3 is selected. This can be done by clicking on the cell. Why?? The most common reason to use spreadsheets is to store and organize data, like revenue, payroll and accounting information. Spreadsheets allow the user to make calculations with this data and to produce graphs and charts. Formulas;

  What is Data? Data is a collection of facts, such as values or measurements. It can be numbers, words, measurements, observations or even just descriptions of things. There are two type of data. Qualitative and Quantitative Qualitative data is descriptive information (it describes something) Quantitative data, is numerical information (numbers). Qualitative : He is brown and black He has long hair He has lots of energy Quantitative: Discrete: He has 4 legs He has 2 brothers What Is Database? A Database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Fields, records, and files organize traditional databases. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number. Database is collection of data that is...