Calculation
When to use visual spreadsheet?
When you want to create a calculation application
Useful in cases of communication to the public
When you want other people to understand a phenomenon or a problem using calculation.
When you want to explain calculation.
When you want to show how to solve a problem.
When you want to show how to make a decision in certain circumstances.
Examples of using the visual spreadsheet
Economics
Value of a share and purchase decision
Car loan calculator
Physics
Speed; Distance; Time
Aviation
Decision making
Usefulness of a spreadsheet.
It has different features:
- Gather data
- Put the data in grids in a certain order using rows and columns
- Calculate a number using one or more other numbers using formulas
Usefulness of a visual spreadsheet
All the features of a spreadsheet
+
It is auto-explaining
Each cell may contain images, documents
Advantages
It allows to easily sort the data
It allows to put a lot of data in a small space
Disadvantages
Aesthetically unconvincing
A cell can not contain explanations
No pictures
Little visual
Advantages
Allows to integrate images
Allows you to integrate explanations into cells
Show links between cells (lines and arrows)
It becomes self-explanatory
Disadvantages
Takes more space compared to the data presented.
Sorting is done manually. It is therefore very flexible, but takes longer.
Functions must be written manually.
Application areas
Whenever there is a multitude of data.
When the communication factor (public explanation) does not play.
Application areas
Whenever you want others to understand and use the calculation of a table.
As the table is self-explanatory, you can publish it (internet) or send it to the public (mail). He will appreciate the explanations that the table contains.
Examples:
Management of personal data
Enterprise data management
Examples:
Communication from statistical institutions, international, governmental.
Problems solving.
Pedagogy.
