CRITERIA A: 16/3/2017
Answer the
following questions
What is a spreadsheet? A spreadsheet is an electronic based document in which your data is arranged in rows and columns and can be used to in calculations.
What is a spreadsheet? A spreadsheet is an electronic based document in which your data is arranged in rows and columns and can be used to in calculations.
What are
the various types of spreadsheets? Google Sheets, iWork Numbers - .LibreOffice
Lotus 1-2-3Lotus Symphony - Microsoft Excel. OpenOffice and VisiCalc are some of the
type of spreadsheets.
Who would use
spreadsheets? Accountants, teachers, engineers, sales people, scientists,
supermarkets and market researchers are some people who would use
spreadsheets.
For example
accountants would need to use spreadsheets because they are the ones who will
manage the money that will go in and out of the bank and they are the ones who
look at how much wages each worker will get.
Another example
would be a Scientist. A scientist would need a spreadsheet when they are doing
an experiment. This helps them record the data to analyse what they did.
This is a
different example which is a supermarket. A supermarket would need a spreadsheet
the most because the need to see what products are been sold the most and what
are not and depending on that they can increase or decrease they amount of
money the product is sold for.
How is it
beneficial to students, adults and businesses? Spreadsheets are an electronic
based document in which your data is arranged in rows and columns and can be
used in calculations. This can be used for students when they are doing
statistics, for adults to keep the data of their company in and for buissness
to show statistics of the company or data which can be stored in many ways for
you or your company to use when you want.
What is the Global Context? Scientific and technical innovation is the global ontext which relates to this subject the most.
ATL skills you would require for this topic? In my opinion I think that research skills will be most needed for a spreadsheet.
FEATURES OF SPREADSHEETS:
1.
Excel formulas
2.
Cell
3.
Pivot tables
4.
Lookup formulas
5.
Excel charts
6.
Sorting and Filtering data
7.
Conditional formatting
8.
VBA and macros
9.
Excel Tables & structural
references
10.
Power Pivot, data
Excel formulas: A formula is
combination of operators, operands, and functions. It can be used for solving math.
Cell: A can be used to solve math and it can be
used to write data in.
Pivot tables: Pivot tables are the
perfect tools for managers & analysts.
Lookup formulas: By knowing
how to write lookup formulas, you can make various dashboards, interactive
charts and create effective models
Excel charts help you communicate information
very easily. By choosing your charts wisely and formatting them cleanly, you
can convey a lot.
If Microsoft ever needs few extra
billions of cash, they just have to turn sorting & filtering features in
Excel to pay-per-use. These ad-hoc analysis features are so powerful &
simple that any aspiring analyst must be fully aware of them.
Conditional formatting is a feature
in Excel that can make your work great. Just add something to highlight your
data and you will turn boring into interesting. With new features like data
bars, color scales & icon sets, conditional formatting is even more better.
Macros, little VBA programs are
what you write to achieve this. Learning VBA can be quite fun, challenging. Once
you learn VBA, thanks to all this you will save a lot of time.
Excel tables, a new feature added
in Excel 2007 is a very powerful way to structure, maintain & use data.
With tables, you can add or remove data as you like.
Although
Excel in itself is quite cool, it struggles to analyse some specific types of
data such as combining multiple tables and using them to create reports, processing
data from different sources.
