The course-
Spreadsheets
are used to store, manipulate and analyse data and to present it in easy-to-understand
ways. They are invaluable for collecting and manipulating data of all types.
Spreadsheets can be formatted to create clear, concise reports and can be sorted,
filtered and updated with the touch of a button. Spreadsheets are used
extensively in many organisations to help people carry out their job roles. For
instance, accountants use spreadsheets to keep track of the money going into
and out from a business, and scientists use them to analyse the results of
their experiments and record the data for use in the future. In this unit you
will understand the many uses for spreadsheets and the tools and techniques
that are available and become skilled at using them. You will be able to apply
some of your findings to your own spreadsheet solutions. In this unit, you will
understand the many uses for spreadsheets. You will discover the many tools and
techniques that are available in spreadsheet software and will become skilled
at using them. You will investigate some of the ways spreadsheets used in
real-life. You will design a spreadsheet solution for a brief. You will then develop
and test your spreadsheet solution to store, manipulate and analyse a large amount
of data and present the output data in easy-to-understand way. Once completed,
you will review the finished spreadsheet solution having obtained feedback from
others, and evaluate possible improvements. In particular, this unit develops
skills from Unit 1: The Online World and Unit 2: Technology Systems. In addition,
it supports the content of Unit 10:
Database Development.