Please enable JavaScript.
Coggle requires JavaScript to display documents.
6.1 Selection and justification of the appropriate software tools +…
6.1 Selection and justification of the appropriate software tools + techniques to process data.
Spreadsheets
Functions + Formulas can be used to calculate/ recalculate results
Modelling can be carried out
Format of data can be set to meet the defined objectives . e.g.Currency
Worksheets
can be used within a
Workbook.
Graphs can be created to show the results of the processing numerical data
Absolute + Relative cell referencing can be used
Spreadsheets are designed to store text + numerical data
Database
Database stored in a table/tables
Table is a file made up of
records
Record
is a collection of fields
Field
holds one item of data
.
Item
of data is made up of characters.
Query
can be used to find specific records.
They a
llow entry, storage,editing + processing of data
Validation
can be set to different fields.
Used to store + process data + text
Spreadsheets
If a model is created the
results aren't realistic
Take a
long time
to create a spreadsheet.
Inexperienced users may struggle to use functions + formulas needed.
If data is entered manually errors can be introduced.
Error in the formulas can affect results.
Not easy to manipulate text
Formulas are used to recalculate totals
*Modelling + What -If investigations
can be carried out.*
*Worksheets in Workbooks
can
separate different sets of data.*
Data can be s
et into a graph to see patterns + trends easily.
Columns +rows can be locked to maintain data integrity
Can be
imported to other documents
e.g.Presentations/reports.
Can
include Absolute + relative referencing
.
*Data is formatted to meet the needs of audiences.
Currency.*
Can be saved + backed up to prevent loss or damage.
Can be shared electronically
Database
Knowledge + skill is needed to set up a database*
Relationships need to be created if more than one table is needed.
Queries can be
difficult to formulate if data from across many tables are required.
*Security procedures need to be implemented
if the database
contain personal data
.*
If data is entered manually errors maybe introduced
An error in validation + data entry + queries can
affect results produced.
*Lots of data
,in records can be stored*
Data can be
added/ edited if changes are needed
.
Data can be
filtered/queried to find relevant results
.*
Data can be
sorted in a specific field
.*
Password can be set for security
Can be
used with other softwares
, e.g. to send personalised letters.
*Validation can be set on fields
to
minimise input errors.*
*Input forms created can help with data entry
.*
Reports can be generated to show results of the queries
.*
Can be imported into other documents
Can be shared electronically
Can be saved + backed up to prevent data loss or damage.