Please enable JavaScript.
Coggle requires JavaScript to display documents.
databases and spreadsheets (data base editing (validation examples:…
databases and spreadsheets
data base definitions
structured set of data that is held on a computer and accesible in various ways
field: titles and collumns of information that go vertically
records: a row of information going horizontally accross the data base
validation: makes sure peole reply and type in the correct thing to the data base
data base editing
validation examples: number, yes/no , letters
a query is a question that you ask to fins out about data in a spreadsheet. and is like filtering on a spreadsheet as you can take out the unimportant fields and have just the ones you need
form is where you can create a clearer more official looking table of your information and can also only include the importaant facts if you filter it
data bases are used to capture and analyze data in a simple easy way
reports cut out useless information and give you a neater more organised report of your data
spreadsheets definitions
cell: a single box and an intersection of a collumn and row
row: a horizontal line of information going across a spreadsheet
column: vertical line of information going across a spreadsheet
formula: selection of numbers letters and operations to help fill in a spreadsheet
a document of information which is arranged in columns and rows
spreadsheet
used to lay out information clearly and categorize facts. easier way to interpret and analyse data
formulas are used to fill all the blank boxes in a spreadsheet quickly and easily without you having to work out sums
=sum (b5*f9) multiplies the two collumns/rows typed and presents the answer in box selected
charts are used to represent data because it is a much clearer easier way of showing and seeing differences and similarities in data and just represent it better
sorting and filtering helps you see what you want clearer and easier as they are on their own and it looks cleaner and clearer you do it by clicking next to the title and selecting the filter by option then you can choose how you want to sort it or filter it