Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Systems (Charts (Charts are created by highlighting data., They can…
Data Systems
Charts
-
-
You can choose from many different types, such as pie and bar charts.
-
Spreadsheets
Cells, rows and columns
-
-
Cells are the individual blocks - such as G3, D11, A7
Formula
-
You can use a formula to add, multiply, subtract or divide the numbers on a spreadsheet.
By using a formula, the answer will automatically update correctly if you change any singular piece of data
Filters
By filtering, you can organize data in the most helpful way.
For example, if you need to find all films rated 12, simply filter them in this way.
-
Databases
-
Fields
-
This includes Title, Genre, Age etc
-
Validation
-
If an age is written as a currency, then it isn't valid. You need to change it to a number. This is validating the data.
-
Operators
Operators are more than, less than and equal to.
If you use the less than operator, the you can write all data less then £4. This shows you any data that costs less than £4.
-